RIODS.PROJECT table not populating with Insight ETLs
Hello,
The Rational Insight ETL does not appear to populate a table it uses in the data warehouse, RIODS.PROJECT. This table is referenced by the db-incrementing PROJECT_ID value from tables such as RIODS.REQUEST, but REQUEST just uses -1 as the Project ID for any new project's work items. The RIODS.PROJECT table binds that to project name "Others" and has no other data.
The JKE Banking projects show up just fine, but any new projects are not being put into this table. We're digging into the ELTs now to see why this is, but if anyone could enlighten us that would be great.
Thank you,
June Boston
|
2 answers
Our OOTBE2E top level job was not calling the JFS jobs; we failed to re-add them when creating the Delta OOTB job.
We have added the JFS job first in the job queue for the OOTBE2E job and our table is populating correctly.
Comments
Francesco Chiossi
commented Jul 18 '14, 5:39 a.m.
Glad to hear that it's fixed.
|
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.