Our load datawarehouse jobs are running daily without any issue. But there is no rows created for the table 'dwh_inv_status_report' in the DWH schema. But in 'DWH_CFG_AUDIT', it is showing as this was last updated by today.
Could anyone please let us know, why there is no rows for this table?
Do you have Status reports in projects?
Yes Suman. We have values for overall status in schedule page.
But those values are not coming in the dwh_inv_status_report table.
Any errors when you run Load Data Warehouse - Full you can see in bg-dwh log? Does the job complete successfully?
If yes, can you check if the Status Report object is enabled for Data Warehouse? You can see that in Administration - Objects - Status Report properties page. If the object is not included in DWH (valid for versions 14.2 and 14.3) then please include it and run a Full Load.
Am apologizing for the late response. I was not available for last 2 days. Thanks for the quick response
Load Data Warehouse - Full job is running successful and Status Report object is enabled for Data Warehouse, but no data in this table.
How this status report is getting populated normally.
Could you please let me know, the niku to dwh schema mappings?
I have written a post about an issue in which DWH tables come with no data, please could you follow the steps and let me know if it worked for you:
It involves setting the app server clock to match the database server clock. This worked well for other customers previously. It's a required PPM configuration to make the clock to match for the job to be able to detect the records to fetch.
Hope this helps -Nika
We do have the similar issue on DWH_INV_HIERARCHY table. I have a case with support.
For the record, we worked with Ramana and were able to resolve the issue by resetting the app server clock as described above. Thank you! -Nika