It's all about the answers!

Ask a question

RQM- Insight Reports appear blank


preetam kulkarni (139298) | asked May 20 '11, 8:10 a.m.
Hi ,

I have integrated RQM2.0.1.1 with Insight1.0.1 running on standalone server having windows 2003 server. As required for integration, i have created data sources, Xml configurations and the catalog in data manager, where i have restored the insight catalog to run RQM jobs. i have also created connections with RIDW and ODBC in the connections.
when i run the ETL job it completes in a couple of seconds. when i try to run a report in sample data defnition it appears blank.

Can any body help me in this as to where its going wrong?

please let me know if any more details is needed.
Thanks in Advance

10 answers



permanent link
Jeff McRae (2711) | answered May 24 '11, 9:05 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Hi ,

I have integrated RQM2.0.1.1 with Insight1.0.1 running on standalone server having windows 2003 server. As required for integration, i have created data sources, Xml configurations and the catalog in data manager, where i have restored the insight catalog to run RQM jobs. i have also created connections with RIDW and ODBC in the connections.
when i run the ETL job it completes in a couple of seconds. when i try to run a report in sample data defnition it appears blank.

Can any body help me in this as to where its going wrong?

please let me know if any more details is needed.
Thanks in Advance


If your ETL is finishing in a few seconds, it probably isn't working. Have you checked the ETL logs to look for any error message?

permanent link
Jackie Albert (1.6k14947) | answered May 26 '11, 9:20 a.m.
Preetam,
See this link about turning on extra levels of Data Manager logging that may help you get more debug information in your output: https://www-304.ibm.com/support/docview.wss?uid=swg27017415

Hope this helps!

permanent link
preetam kulkarni (139298) | answered Jun 02 '11, 8:19 a.m.
Hi Jackie,

Thanks for the response. I have set the trace flags in the Logs of the Data Manager. After running ETl jobs also there dont appear any errors.
Even the log files do not show out any failed job in it.

permanent link
preetam kulkarni (139298) | answered Jun 02 '11, 8:22 a.m.
Hi Jeff,

Thanks for your response and very sorry for late reply. I have set the Trace values in ds.ini file to captture extra details for the job run.
The logs do not show out any failure in it.
Please suggest.

permanent link
Petroula Pantazopoulos (36612) | answered Jun 02 '11, 10:13 a.m.
JAZZ DEVELOPER
Hi Jeff,

Thanks for your response and very sorry for late reply. I have set the Trace values in ds.ini file to captture extra details for the job run.
The logs do not show out any failure in it.
Please suggest.


How about the windows cmd window, is it showing any error? Can you attach the log files?

permanent link
Petroula Pantazopoulos (36612) | answered Jun 03 '11, 8:51 a.m.
JAZZ DEVELOPER
Hi Jeff,

Thanks for your response and very sorry for late reply. I have set the Trace values in ds.ini file to captture extra details for the job run.
The logs do not show out any failure in it.
Please suggest.


How about the windows cmd window, is it showing any error? Can you attach the log files?

According to the log file you attached, the result of the "hasMore" conditional branching returns a false in which case it sees it as having no RQM datasources to process. In the log file I see 'hasMore'; succeeded (FALSE). The resource category it expects to find in the XDC file is called ResourceCategory = 'RationalQualityManager' which it probably does not exist, maybe you renamed it or have created a new xdc file. Inspect your xdc file for RQM and make sure that the value for the resource category is set to RationalQualityManager.

permanent link
preetam kulkarni (139298) | answered Jun 09 '11, 8:33 a.m.
Hi Petroula,

I have checked with the xdc connections which shows Test connection is successful.

permanent link
Petroula Pantazopoulos (36612) | answered Jun 09 '11, 8:55 a.m.
JAZZ DEVELOPER
Hi Petroula,

I have checked with the xdc connections which shows Test connection is successful.

The problem is not the connection but the name of the resource category in the xdc file. What is the name? Also is the ODBC driver configured to point to the right RQM xdc file?

permanent link
preetam kulkarni (139298) | answered Jun 10 '11, 6:20 a.m.
Hi Petroula,

The resource group category is Rational Quality Manager, also can you let me know how to configure this odbc to configure for RQM ? the machine is windows 2003 server edition

permanent link
Petroula Pantazopoulos (36612) | answered Jun 10 '11, 8:36 a.m.
JAZZ DEVELOPER
Hi Petroula,

The resource group category is Rational Quality Manager, also can you let me know how to configure this odbc to configure for RQM ? the machine is windows 2003 server edition


If what you are saying is correct, that is the name is "Rational Quality Manager" remove the spaces in the name so that the name may match what the ETL is expecting which is "RationalQualityManager"

Configuration of the XML ODBC data source is done through Windows ODBC Data Source Administrator. You should already have a datasource entry called RQM with driver "IBM Rational XML ODBC Driver" and when you click on Configure the configuration information there should be the full path to the RQM xdc file you have modified and configured to use for the ETL

Your answer


Register or to post 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.