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

Cognos reports issue on Windchill cluster.

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:Smiley Tonguerocess()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod:Smiley Tonguerocess(): asynchRun_RequestRSASyncExecutionThread.cpp(787): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRun_RequestRSASyncExecutionThread.cpp(837): QFException: CCL_RETHROW: RSASyncExecutionThread:Smiley TonguerocessCommand(): 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

Re: Cognos reports issue on Windchill cluster.

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.

Re: Cognos reports issue on Windchill cluster.

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. 

Re: Cognos reports issue on Windchill cluster.

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

Re: Cognos reports issue on Windchill cluster.

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:Smiley TonguerocessImpl()  RSReportServiceMethod.cpp(258): QFException: CCL_RETHROW: RSReportServiceMethod:Smiley Tonguerocess(): 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:Smiley TonguerocessCommand(): 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.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________ Check out the Windchill Tips Board! We're talking about Whirlpool's use of digital twin, augmented reality, and data-driven design!

The NAVIGATE WORKING GROUP is here! Come innovate with PTC!

Sign up for a Working Group