IBM Support

A report throws the error below when it's run for a
specific time frame

Troubleshooting


Problem

For example, if the report is run for June 23rd - Oct1, it will give an error. However, if the time frame get increased and include that time frame the report runs without error.

Symptom

Audit.RTUsage.RSVP PromptForward Report ReportService /content/folder
[@name='Report Studio Reports']/folder[@name='Promotion']/folder
[@name='Promotion Product Movement Reports']/report[@name='Promotion
Performance by PID by Store'] Failure RQP-DEF-0177 An error occurred
while performing operation 'sqlScrollBulkFetch' status='-9'.UDA-SQL-
0107 A general exception has occurred during the operation "fetch".
[Sybase][ODBC Driver][Sybase IQ]Secondary error noted <parameters><item
name="model"><![CDATA[/content/folder[@name='Report Studio Packages']
/package[@name='RS Promotion Reports']/model[@name='model']]]
></item></parameters>
10.11.11.49:9300 20440 2017-10-03 12:46:23.511 -5 http-9300-59 caf
2047 1 Audit.dispatcher.caf Request Failure SecureErrorId: 2017-10-
03-12:46:23.511-#3272 Original Error: RQP-DEF-0177 An error occurred
while performing operation 'sqlScrollBulkFetch' status='-9'. UDA-SQL-
0107 A general exception has occurred during the operation "fetch".
[Sybase][ODBC Driver][Sybase IQ]Secondary error noted RSV-SRV-0042
Trace back: RSReportService.cpp(726): QFException: CCL_CAUGHT:
RSReportService::processImpl() RSReportServiceMethod.cpp(259):
QFException: CCL_RETHROW: RSReportServiceMethod::process():
promptPagingForward_Request RSASyncExecutionThread.cpp(854):
QFException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT:
RSASyncExecutionThread::runImpl(): promptPagingForward_Request
RSASyncExecutionThread.cpp(910): QFException: CCL_RETHROW:
RSASyncExecutionThread::processCommand(): promptPagingForward_Request
Execution/RSRenderExecution.cpp(585): QFException: CCL_RETHROW:
RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(325):
QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW:
RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(419):
QFException: CCL_RETHROW: RSDocAssemblyDispatch::
dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp
(178): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(369): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp
(314): QFException: CCL_RETHROW: RSPageAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(369): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp
(177): QFException: CCL_RETHROW: RSTableRowAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(369): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.
cpp(151): QFException: CCL_RETHROW: RSTableCellAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(419): QFException: CCL_RETHROW:
RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
RSResultSetIterator.cpp(1475): QFException: CCL_RETHROW:
RSResultSetIterator::retrieveData QFSPartialDataset.cpp(80):
QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIterator
Source/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE
10.11.11.49:9300 6880 2017-10-03 12:46:23.464 -5
200519BD683B3C442D34B17B0F86DD52995BEE3939E72EB19883D8CC97DF961B
C4824qlj2Gys9q4qGMjv8dl4wwhvMq4sjdy82v2h
MdywCMjqGwMl49w4jv29llsG8s28Cy9w894l2hhw 8548 RSVP 5008 3

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.9;11.0.8;11.0.7;11.0.6;11.0.5;11.0.4;11.0.3;11.0.2;11.0.1;11.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
13 January 2026

UID

swg22012286

Page Feedback