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.
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 |
|
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! |
Felipe,
I have the same error. Please, could you send me the steps to solve that error? Thanks in advance Regards, Gerardo |
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. |
|
SQL Server...
Thanks! Hi, 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. |
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. |
Hi,,,
you said: "So I tried to setup it again. I follow the instructions and I now everything is working fine. " Can you please clearly specify which instructions you followed to solve this problem? Thanks a lot, --Claudia Callegari |
I have the same problem. Hoping someone has the solution. . .
Thanks a bunch! Faith |
Does anyone have any experience using this with a sqlserver database? My company runs sqlserver, but I'm not sure if the software is designed for sqlserver. We've been having A LOT of problems with our custom reports.
|
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. Hi pfreire, Can you give me detailed steps to setup custom reports in RQM 2.0 MY EMAIL id is rajakonda@gmail.com |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.