Clarity

  • 1.  Project not displaying in DWH database

    Posted Mar 17, 2017 09:53 AM

    We have an issue which was recently reported to us. The project manager is making some updates in CA PPM to the projects during the Load Data-warehouse Full load run . Because of these updates the projects didn't come up in the DWH database after the full load run completed and again displayed after the next day full load DWH job complete.

     

    So what kind of updates to the project in CA PPM can make the load datawarehouse job not picking up these projects.



  • 2.  Re: Project not displaying in DWH database

    Broadcom Employee
    Posted Mar 17, 2017 10:57 AM

    Hi Puneeth,

     

    When DWH runs it starts updating tables one by one and if the update was done when it completed reading the last updated_date and time and moved to next table it won't pick up and hence its recommended to run the delta load also as these these will be picked up again.

     

    Regards

    Suman Pramanik  



  • 3.  Re: Project not displaying in DWH database

    Posted Apr 13, 2017 06:54 AM

    Hi Suman,

     

    We also see that project manager of that project has not picked up by load datawarehouse full load run. Is the same scenario applicable for project manager field also?



  • 4.  Re: Project not displaying in DWH database

    Broadcom Employee
    Posted Apr 13, 2017 11:42 AM

    HI Puneeth,

     

     

    All the fields in Data Warehouse are brought in based on last_updated_date.

     

    When the Load Data Warehouse job starts running, it gets the current date and will pick up everything that was updated before this date.

     

    This is valid for all the fields/data. If the project manager just updated the field he must wait until the next run picks the data up.

     

    You should also be aware that Data Warehouse is not meant to be a real time reference, it's a reporting tool. So users should not be expecting an immediate update to DWH. We have customers who run it once per day only.

     

     

    Hope this helps -Nika