It's all about the answers!

Ask a question

Missing tables in RICALM schema


Kevin Ramer (4.5k8183200) | asked Jun 11 '12, 12:17 p.m.
In attempting to connect Insight to QM 3.0.1.3 and running ETL jobs at least two steps in the RQM_ODS3.0.1.3 jobs
fail reporting:

[PROGRESS   - 11:23:30] Build Node 73 'RQM3_KeyWord'; executing (pid 3272)
[PROGRESS   - 11:23:40] pid 3272 Build Node 73 'RQM3_KeyWord'; reported the following:
 
DM-DBM-0400 UDA driver reported the following on connection Rational Data Warehouse:1:
 
UDA-SQL-0353 An error was detected while processing the SQL request.
 
[IBM][CLI Driver][DB2/LINUXX8664] SQL0204N  "RICALM.KEYWORD_CLASSIFICATION" is an undefined name.  SQLSTATE=42704 

And a similar message for RICALM.OBJECTIVE_CLASSIFICATION

As far as I'm aware I've done the steps for configuring Insight, the Connection Manager and Data Warehouse database.  I.e. _some_ data is being moved across, but there is also much that is not.

Setup:

DB2 v9.7 and Insight Reporting server v1.1 on RHEL 5.3.
DataManager setup on Windows 7 where I run the ETL by hand once in a while trying to move another step or
two forward.  There is also a cron that does a rundsjob, but it produces different "results" than when the ETL is executed from my windows platform.



One answer



permanent link
Peter Haumer (2.2k12019) | answered Jun 11 '12, 12:23 p.m.
JAZZ DEVELOPER
Did you run the jts/setup and configured the warehouse there? This will run a schema check and add the missing RICALM schema and tables. In other words, you cannot use the Insight warehouse as is, but you must configure it during jts/setup. If you received errors during this step then please contact tech support with your logs.

The other step that should be done outside of the jts/setup is changing authentication of the report server over to use the JTS. This is explained in the Insight online help.

Hope this helps,
Peter.

Comments
Kevin Ramer commented Jun 11 '12, 12:25 p.m.

The JTS warehouse has been configured for a good long while. I've been at this insight thing for weeks now -- help a body out and show chapter and verse?


Peter Haumer commented Jun 11 '12, 12:35 p.m. | edited Jun 11 '12, 12:59 p.m.
JAZZ DEVELOPER

Are you saying that it worked before, but these errors just started happening? Could someone have changed your "Rational Data Warehouse" connection perhaps in Data Manager, or did you import a newer version of pkg files and overwrote that connection?


Kevin Ramer commented Jun 12 '12, 8:17 a.m.

No, I'm saying that I'm trying to get this launched with only some success. I looked at the xdc files that I have loaded and none mention a connection to the JTS data warehouse database.


Jun Wang commented Jun 14 '12, 12:28 a.m.

In Data Manager tool of Rational Insight, you can see a connection called "Rational Data Warehouse" that is connecting to your JTS data warehouse database, please check that connection and your Data Manager ETL is matching with the version of your CLM server (Importing the pkg files downloaded from the CLM server to the catalog of Data Manager).

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.