RCR 2.0GA fails in ETL BuildRecord job
Anyone else seeing this? We're running RCR on Windows / SQL Server 2005, with the DB server separate from the report/ETL server, against RQM 2.0. Upon kicking off the RQMAll dataMovementTask, the job fails. Browsing on the server into <installdir>\Rational Insight\cognos\datamanager\log shows the failure in the BuildRecord job:
Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved. We've tried rebuilding the data warehouse metrics from RQM, creating new project areas, trying project areas with data converted from RQM 1.0.1.1, all to no avail -- every job crashes at this point. Is anyone successfully using RCR on Windows / SQL Server? |
2 answers
One thing you can do is look at the source data in RQM and see if you can make it compliant, since that looks to be the problem.
In RQM, go to Builds -> View Build Records. Try to go through you Build Records, checking that the "State" is set on each, and that it is a value available in the drop-down. Hope that helps. Regards, John Anyone else seeing this? We're running RCR on Windows / SQL Server 2005, with the DB server separate from the report/ETL server, against RQM 2.0. Upon kicking off the RQMAll dataMovementTask, the job fails. Browsing on the server into <installdir>\Rational Insight\cognos\datamanager\log shows the failure in the BuildRecord job: Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved. We've tried rebuilding the data warehouse metrics from RQM, creating new project areas, trying project areas with data converted from RQM 1.0.1.1, all to no avail -- every job crashes at this point. Is anyone successfully using RCR on Windows / SQL Server? |
Hi John,
Actually, at the time the report was run, there were no build records in the candidate project. I tried creating one, and setting its state to a valid state, but no success - still get the same error. ri_jdbc and ri_odbc logs both show no error so I'm indeed quite puzzled. I now have a Jazz work item open on this and an IBM PMR, and will update back here if/when the problem is resolved. |
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.