I knew about that (, said Doug, sheepishly) because I have used it before.

You know, at my age the hearing is the second thing to go.  I can't remember what the first thing was.

So that we don't post things you have already tried...
What have you already tried to troubleshoot or resolve this?

Hi

I have been facing this error please help


Quote
RSV-SRV-0040   The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.   DetailsCCLThreadResourceError:-1:Fatal: RSV-SRV-0042 Trace back:RSReportService.cpp(774): CCLThreadResourceError: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(254): CCLThreadResourceError: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(887): CCLThreadResourceError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(331): CCLThreadResourceError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(932): CCLThreadResourceError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(585): CCLThreadResourceError: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(339): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): CCLThreadResourceError: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): CCLThreadResourceError: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): CCLThreadResourceError: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSSingletonAssembly.cpp(126): CCLThreadResourceError: CCL_RETHROW: RSSingletonAssembly::assembleAssembly/RSAssembly.cpp(699): CCLThreadResourceError: CCL_RETHROW: RSAssembly::createListIteratorRSResultSetIterator.cpp(1513): CCLThreadResourceError: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): CCLThreadResourceError: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmSqlResultSet.cpp(1942): CCLThreadResourceError: CCL_RETHROW: QESource/QEDMSqlCursorScroll.cpp(449): CCLThreadResourceError: CCL_RETHROW: Source/AQE_UDAFacade.cpp(980): CCLThreadResourceError: CCL_RETHROW: AQE_UDAFacade::sqlOpenResult CCLErrorapicursr.cpp(552): CCLThreadResourceError: CCL_RETHROW: sqlOpenResult CCLErrorapigbl.cpp(3927): CCLThreadResourceError: APICursorOpenThread::joinsgiWrapper.cpp(989): CCLThreadResourceError: CCL_RETHROW: sgiAOpen CCLThrowablesgiCursor.cpp(275): CCLThreadResourceError: CCL_RETHROW: SgiCursor::asyncOpen CCLThrowablecommon/sgiOdbcCursor.cpp(330): CCLThreadResourceError: CCL_RETHROW: SgiOdbcCursor::doOpen CCLThrowablecommon/sgiOdbcCursor.cpp(1050): CCLThreadResourceError: CCL_RETHROW: SgiOdbcCursor::openForNonMetaRqst CCLThrowableThreads/CCLThread.cpp(176): CCLThreadResourceError: CCL_THROW: CogThread interface or unknown error

Hi Gollapudi

Have you cracked this error facing same here please help on this ASAP

So you may want to investigate that, but... You probably shouldn't be trying to using Cognos Analytics to produce that specific output format.

Quotesomething like this PowerShell script would work.

Code Select Expand

$fileIn = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book1.csv"
$fileOut = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book2.csv"

Import-Csv -LiteralPath $fileIn | Export-Csv -LiteralPath $fileOut -UseQuotes Always
But if you're going that route, you should also have PowerShell (or your script runtime of choice) run the query to get the data to begin with.

I just tried this in my test environment after setting
RSVP.CSV.DELIMITER = ,
RSVP.CSV.TERMINATOR = CRLF

All of my values, including the first one, are quoted the same way.

Maybe reproduce the problem using the GO Sales (query) package and post the report spec here?

Hello!  I am new to this website.  I am getting an error and I googled it and found a post with the same error, but I do not see how to view the answer(s) that were given....?????

QuoteCan you create joins off of calculations?

Yes and in one of the sample FM models there's an example of one.  It will be awfully inefficient but needs must I imagine.

QuoteI keep getting an error with really no error message.

Have you tried clicking on view details?  In some places, such as the relationship editor preview UI and the data grid, when something goes wrong there is a message to that affect with a link which says 'view details'.  If you click it you get the error message details.

here is the calculations:

SUBSTRING(i_ORGS,9,4) join to substring(i_ORGANIZATION_ID,9,4)

when on the grid tab, each return the correct data.  Just don't know why I can't use this as a join

Hello all, new to all this.  When creating relationships between tables.  Can you create joins off of calculations?  I have an org number and I need to substring the field to be substring(org,9,4) on each table that needs to be joined.  I keep getting an error with really no error message.

So is it even possible to do this?  Or do I need to add fields in the database to do this? Or even in FM to do this.