Trace back Error for Value Prompts

[rajeurokz]

Hi,

I'm customizing a complex report with 20+ columns and 10+ prompts, report is based on relational package.
As per the requirement, i added 3 new prompts and 3 Columns(same as prompts) to the reports. Initially, when there was no value selected for all these prompts, report threw an similar error i.e. Trace back. As a work around, i selected the list and selected all the columns in the list properties tab. This resolved the problem with the list, but now I'm facing the same issue when I select a value for 2 of the prompts(together as well as individually), but the 3rd column has no issue at all.

Could someone throw some light on this throw back error and also help me get rid of this problem.

Error Message:

RSReportService.cpp(747): RSQFCommandException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): RSQFCommandException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(854): RSQFCommandException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): RSQFCommandException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(910): RSQFCommandException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(585): RSQFCommandException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(325): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): RSQFCommandException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(178): RSQFCommandException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): RSQFCommandException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): RSQFCommandException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): RSQFCommandException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): RSQFCommandException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): RSQFCommandException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): RSQFCommandException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): RSQFCommandException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): RSQFCommandException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(369): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): RSQFCommandException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(419): RSQFCommandException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSSingletonAssembly.cpp(126): RSQFCommandException: CCL_RETHROW: RSSingletonAssembly::assembleAssembly/RSAssembly.cpp(682): RSQFCommandException: CCL_THROW: RSAssembly::createListIterator.


thanks in advance!
RM

[bdbits]

The 747 is kind of a catch-all, and that's basically a stack dump from an error catch in Cognos code.

Was there an error message just before/above this one? Anything in the cognos log files?

Generically, the 747 seems to be related to either connection the columns in the query with those in the data source, a data type issue, or perhaps an error generated when it tries to evaluate the expression. Those are pretty broad, so if possible more information might help.

You could also try isolating it by removing items from the report until the error goes away. Tedious but might help narrow down the troubleshooting.