cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Cognos reports issue on Windchill cluster.

ptcharshad
1-Newbie

Cognos reports issue on Windchill cluster.

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


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(771): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(787): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRun_RequestRSASyncExecutionThread.cpp(837): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSAssembly.cpp(639): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSResultSetIterator.cpp(1665): QFException: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(81): QFException: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmResultSet.cpp(75): QFException: CCL_THROW: QE


I believe this is related to Windchill cognos - communication.


Please respond in case you have encountered this or have some idea of the issue.


Thanks.

4 REPLIES 4
acoash1
5-Regular Member
(To:ptcharshad)

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.

acoash1
5-Regular Member
(To:acoash1)

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.

Top Tags