Hi,
We have a Windchill cluster set up - WC 10.1 M010 with a master and 2 slave nodes.
Cognos host components are installed on master where as gateway servers are installed on two slaves.
https is configured for pdmlink as well as cognos.
With cognos, Update model and loadreports are successful.
But all the cognos reports fail with below error -
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RQP-DEF-0177
An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'.
Details
Please respond in case you have encountered this or have some idea of the issue.
Thanks.
I know this is a very old thread, but we are experiencing this right now.
Let me know if you remember how this was resolved.
The issue we had dealt with our SSL.
PTC says that in order to fix this, you have to enable SSL on both the cognos side and the Windchill side. We initially only had enabled SSL on the Windchill server.
That does not sound so right, the error clearly says Cognos has issues in get an authenticated trusted session to get data pulled out of Windchill. If it is an SSL issue, all you have to do is import the Windchill certificate in to Cognos JVM so that it would trust the connection. This should fix your issue.
From a security perspective, it is good to have cognos running in SSL mode.
Thank you
Binesh Kumar
Hi Harshad,
I have a strange Cognos error that PTC is having a hard time diagnosing. I have Cognos installed correctly and double checked all of the db.properties. We have Windchill cluster environment 10.2 M030 CPS 09. Cognos is installed in other node which is not a part of Windchill cluster.
I can also successfully login to Cognos's web UI and update the model/load reports. Authentication works fine as well.
1. All QML reports are working fine.
2. Infoengine reports with less data is working fine but when we are trying to run report with (50k rows), it's working for 200 rows, it's failing with below error:-
Original Error: RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'. UDA-SQL-0528 The XML parser returned the following message: "General XMLParser Error!". UDA-CUR-0000 Unable to fetch the row. RSV-SRV-0042 Trace back: RSReportService.cpp(729): QFException: CCL_CAUGHT: RSReportService::processImpl() RSReportServiceMethod.cpp(258): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(848): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(305): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_Request RSASyncExecutionThread.cpp(904): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_Request Execution/RSRenderExecution.cpp(591): QFException: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(323): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(417): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(178): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(314): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(177): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(151): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(417): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSDocAssemblyDispatch.cpp(367): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly RSResultSetIterator.cpp(1472): QFException: CCL_RETHROW: RSResultSetIterator::retrieveData QFSPartialDataset.cpp(80): QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIterator Source/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE
Appreciate If anyone can provide any suggestion/inputs on this.