Skip to main content
P
psingh-81-Visitor
1-Visitor
February 11, 2016
Solved

Cognos Error when trying to run a report: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.

  • February 11, 2016
  • 1 reply
  • 10130 views

Hello Friends,

I have a qml report, which when run through Windchill works fine but I am not able to export it since it is a huge report with more than 200k records.

When I try to run it using Cognos, it fails with following error:

RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0528 The XML parser returned the following message: "An exception occurred! Type:NetAccessorException, Message:Could not open file: http://xxx-ltd.com/Windchill/servlet/XML4Cognos?table=Site%23_SINGHP_latestStdpart&uid=wtadmin&locale=en-in".RSV-SRV-0042 Trace back:RSReportService.cpp(729): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(848): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(563): QFException: CCL_CAUGHT: RSASyncExecutionThread::handlePromptExceptionRSASyncExecutionThread.cpp(904): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(591): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(323): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(417): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(178): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(417): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(417): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSResultSetIterator.cpp(1472): QFException: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE

What could be the reason for this? Is it because the output is too large?

If yes, is there a way to increase that. If not, what could it be. Other reports, whether QML or Info*Engine are running fine on Cognos.

On another note, how do I increase the number of records for export in Windchill which is currently around 65k.

Thanks

Pardeep

Best answer by BineshKumar1

I see that. Reading through the stack trace, I think your report needs tuning from a Cognos front. The error code is thrown on Report Query Processor. How is the memory usage of BIBusTKServer on the Cognos server? 

See whether you can tune and increase the throughput following the steps mentioned in https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS144925

Thanks,

Binesh Kumar

Medtronic - MITG

1 reply

B
BineshKumar11-Visitor
1-Visitor
February 11, 2016

There is a similar discussion in this Cognos error - RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'

P
psingh-81-VisitorAuthor
1-Visitor
February 12, 2016

Hi Binesh,

That is similar but don't think it is related. status=232 is when Cognos is not working at all. Here it is not working for a particular report.

Thanks

Pardeep

B
BineshKumar11-VisitorAnswer
1-Visitor
February 14, 2016

I see that. Reading through the stack trace, I think your report needs tuning from a Cognos front. The error code is thrown on Report Query Processor. How is the memory usage of BIBusTKServer on the Cognos server? 

See whether you can tune and increase the throughput following the steps mentioned in https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS144925

Thanks,

Binesh Kumar

Medtronic - MITG

Terms & ConditionsAccessibility statement