Upgrade 10.2.1 to 10.2.2 : Issue with crosstab XQE-GEN-0005

[TEVAMANA]

Hi Folks,

After an upgrade from 10.2.1 to 10.2.2, with reports with complex crosstabs when we run them we get this error message:

XQE-GEN-0005
Found an internal error:
java.lang.StringIndexOutOfBoundsException
(see details error message in attachment)

The report validation in Report Studio is fine.  After checking in the knowledge base, we decided to upgrade to Fix Pack 3 but this did not solve our problem. 

We also decided to re-develop from scratch the report but at the end we still face the same error message. 

We upgrade to 10.2.2 to get functionalities like "Dynamically named worksheet tabs in Excel 2007 output" but if we can't run reports with complex crosstabs

this is not a great move! 

Did someone face the same issue ?,

did someone find a workaround ??

Thanks a lot anyway

[MFGF]

Hi Folks,

After an upgrade from 10.2.1 to 10.2.2, with reports with complex crosstabs when we run them we get this error message:

XQE-GEN-0005
Found an internal error:
java.lang.StringIndexOutOfBoundsException
(see details error message in attachment)

The report validation in Report Studio is fine.  After checking in the knowledge base, we decided to upgrade to Fix Pack 3 but this did not solve our problem. 

We also decided to re-develop from scratch the report but at the end we still face the same error message. 

We upgrade to 10.2.2 to get functionalities like "Dynamically named worksheet tabs in Excel 2007 output" but if we can't run reports with complex crosstabs

this is not a great move! 

Did someone face the same issue ?,

did someone find a workaround ??

Thanks a lot anyway

Hi,

I'm using 10.2.2 and I have not encountered this issue. It's unclear what "complex crosstabs" actually means, though. Are you able to provide any details on what is needed to replicate the error? Can you reproduce the issue using any of the sample data that ships with Cognos? Have you checked with IBM support to see if it's a known issue?

Cheers!

MF.

[TEVAMANA]

Hello MFGF,

I am still working on this issue and I should have said the entire story: after migrating from 10.2.1 to 10.2.2 FP2, I did face this issue with DQM reports with crosstabs and Oracle datasource:

XQE-PLN-0001
Internal error. The query could not be planned by the Query Service:
Index: 0, Size: 0

RSV-SRV-0042 Trace back:RSReportService.cpp(754): XQEException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(859): XQEException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(314): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(904): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSQueryMgrBasic.cpp(289): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandQFSSession.cpp(1163): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1161): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1118): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(943): XQEException: CCL_RETHROW: QFSConnection::GetParametersQFSQuery.cpp(488): XQEException: CCL_RETHROW: QFSQuery::GetParametersXQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send

So we decided to upgrade to Fix pack 3 but this did not solve our issue as expected but the error message is now:

XQE-GEN-0005
Found an internal error:
java.lang.StringIndexOutOfBoundsException

I will try to reproduce this issue with samples as soons as I got time time to install it.

Thanks a lot for your reply and your answer.

[TEVAMANA]

Post to close

There are no bugs with crosstabs... this issue was not linked with crosstab...

The sql source query had comments and with CQM and IBM Cognos 10.2.1 it was not a problem. 

After the upgrade in IBM Cognos 10.2.2 and DQM, the report has generated this issue:

XQE-PLN-0001
Internal error. The query could not be planned by the Query Service:
Index: 0, Size: 0

So it may be a change with the parser between CQM and DQM... or 10.2.1 and 10.2.2

Thanks for your help anyway !!!

The comments have been removed from the sql query and the report runs fine