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
Cause
Since the issue only happens after choosing a specific company in a prompt, SQL paremeter should be set to "literal"
Resolving The Problem
Here are the instructions to set the SQL Paremeter to literal :
If you want to change all the reports from the same package:
- In Framework Manager, set the SQL Parameter Syntax governor to
Literal to globally affect all reports based on the package.
- The setting is found under the Project menu > Edit Governors.
If you want to change just one specific report:
- In Report Studio, in the Query Explorer, select the query in
question and then change the Use SQL Parameter property in the
Properties pane to Literal.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22012286