Custom Reports - cannot make it work...
I've been trying for two days to make the custom reports works, and I haven't got any lucky.
Any help would be very appreciated!
Has anyone tried the new custom reports feature on RQM 2.0?
I followed all the installation instructions - and after some minor problems such as port conflicts between RQM tomcat server and Custom Reports (Insight) WAS server - I got it apparentely working (the server is up, I can access the Cognos/Insight web interface, the connections to the databases are working...).
But I simply can't create or run any report. It seems some problem with the data model or datasource, but I can't figure out what is wrong.
The symptom of htis problem is: when I try to create a new report using the Rational Quality Manager Data Model the first step is to define a Project (that should match the XML configuration, in my case RQM). It doesn't work and the error message is like this:
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
the detailed message is:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".CRREE9000E: Internal Java error, check ri_jdbc.log for detailsRSV-SRV-0042 Trace back:RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(239): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(287): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(160): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(122): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(626): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(667): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(978): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1051): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1211): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1511): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1498): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(243): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(603): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(601): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(558): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4174): QFException: CCL_THROW: CoordinationPlanner
Has anyone tried the new custom reports feature on RQM 2.0?
I followed all the installation instructions - and after some minor problems such as port conflicts between RQM tomcat server and Custom Reports (Insight) WAS server - I got it apparentely working (the server is up, I can access the Cognos/Insight web interface, the connections to the databases are working...).
But I simply can't create or run any report. It seems some problem with the data model or datasource, but I can't figure out what is wrong.
The symptom of htis problem is: when I try to create a new report using the Rational Quality Manager Data Model the first step is to define a Project (that should match the XML configuration, in my case RQM). It doesn't work and the error message is like this:
An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
the detailed message is:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".CRREE9000E: Internal Java error, check ri_jdbc.log for detailsRSV-SRV-0042 Trace back:RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(239): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(287): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(160): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(122): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSAssembly.cpp(626): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(667): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(978): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1051): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1211): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1511): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1498): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(243): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(603): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(601): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(558): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4174): QFException: CCL_THROW: CoordinationPlanner
11 answers
So a quick pointer: It looks like you're using the live data model (the one labeled IBM Rational Quality Manager) and not the data warehouse data model (the one labeled DW). We recommend using the DW model because the live model uses the RQM REST interface instead of a database, so there is a large performance price you pay.
Now about that error, It looks like the report is having problems connecting to RQM, Did you configure both XDC files to point to your RQM server (live and DW)? Does the user you put in the XDC file have the correct permissions/licensing to access RQM? also that error is common if you typo in the XDC file, so double check you're on the right port and you have the correct domain name/IP address .
Also search for the ri_jdbc.log file it mentions in your file system and see if there is an error logged there
Now about that error, It looks like the report is having problems connecting to RQM, Did you configure both XDC files to point to your RQM server (live and DW)? Does the user you put in the XDC file have the correct permissions/licensing to access RQM? also that error is common if you typo in the XDC file, so double check you're on the right port and you have the correct domain name/IP address .
Also search for the ri_jdbc.log file it mentions in your file system and see if there is an error logged there
I've ran the XDC and got the live reports working. And I found out that I also had some problems with the DW, because the XML ODBC was not working the first time the DW was configured.
So I tried to setup it again. I follow the instructions and I now everything is working fine. Thanks for the tip!
So I tried to setup it again. I follow the instructions and I now everything is working fine. Thanks for the tip!
Hi,
Which database are you using? SQLSERVER? DB2?
Thanks,
-Walter
Which database are you using? SQLSERVER? DB2?
Thanks,
-Walter
I've ran the XDC and got the live reports working. And I found out that I also had some problems with the DW, because the XML ODBC was not working the first time the DW was configured.
So I tried to setup it again. I follow the instructions and I now everything is working fine. Thanks for the tip!
SQL Server...
Thanks!
Thanks!
Hi,
Which database are you using? SQLSERVER? DB2?
Thanks,
-Walter
I've ran the XDC and got the live reports working. And I found out that I also had some problems with the DW, because the XML ODBC was not working the first time the DW was configured.
So I tried to setup it again. I follow the instructions and I now everything is working fine. Thanks for the tip!
HI. Now I am running into the same error.
pid 7880 Build Node 32 'Category_stg'; reported the following:
DM-DBM-0400 UDA driver reported the following on connection Rational Quality Manager:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
CRREE9000E: Internal Java error, check ri_jdbc.log for details
(for details, see Build_Category_stg_0005.log)
Can you please share the steps that you have followed.
Thanks for help in Advance.
Thanks,
Om.
pid 7880 Build Node 32 'Category_stg'; reported the following:
DM-DBM-0400 UDA driver reported the following on connection Rational Quality Manager:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
CRREE9000E: Internal Java error, check ri_jdbc.log for details
(for details, see Build_Category_stg_0005.log)
Can you please share the steps that you have followed.
Thanks for help in Advance.
Thanks,
Om.
I've ran the XDC and got the live reports working. And I found out that I also had some problems with the DW, because the XML ODBC was not working the first time the DW was configured.
So I tried to setup it again. I follow the instructions and I now everything is working fine. Thanks for the tip!
Hi pfreire,
Can you give me detailed steps to setup custom reports in RQM 2.0
MY EMAIL id is rajakonda@gmail.com
page 1of 1 pagesof 2 pages