Should I be concerned QM projects aren't enumerated in DW Quality Manager jobs ?
The differences for the QM in question:
- Application Server is WAS
- Full CLM environment (JTS, CCM, QM, RM, ADMIN)
Thanks.
One answer
Hi Kevin,
It would be better to check the logs in more detail. You could open a defect and attach the qm-etl.log file so we can investigate.
Thank you,
Clara
Comments
[ I just relocated this item ]
I have configured the etl-drivers to log for tonight's run. One project area in the repository has '&' character in the name, I don't think that's the issue as other QM we manage have project area names with '&' in the name and all the QM projects are scanned.
Ok. I'm officially Card Carrying Insane. After updating the logging, and then checking the job status page for QM, I now see all the project areas back to March 20, 2014 ( the maximum 1000 results )
Is there a way to obtain a longer list than this with a REST or OSLC query ?
Hi Kevin,
I assume you are talking about the job status page for the ETL's in QM. That information comes from the DW. You may want to use an SQL statement like the following to get the information of the project areas and when they were ETL'd:
SELECT A.*, B.NAME FROM CONFIG.ETL_INFO A JOIN RIODS.PROJECT B ON A.DATASOURCE_ID = EXTERNAL_KEY2;
If you used a prefix when you set up the DW, the schema names (CONFIG and RIODS) may be different.
Thanks,
Clara