RQM- Insight Reports appear blank
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
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
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?
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?
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.
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