Resource Time Review by Manager Report not displaying some resources in CA PPM Advanced Reporting
Article ID: 104087
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
The Resource Time Review by Manager report in CA PPM Advanced Reporting is not displaying some resources even though the resources show correctly in other time reports. One resource who is not showing has time posted prior to the Load Data Warehouse job being run so the data is expected to display for this user.
When this issue happens, you may see Data Warehouse (DWH) slices in Administration > Data Administration > Time Slices with blank Last Run Dates.
Environment
Release:
Component: ODTSL
Component: ODTSL
Resolution
Solution 1: Check to make sure the prerequisites are met as referenced in the Resource Time Review by Manager documentation
Solution 2: Check to make sure the Time Slicing job is completing successfully. If not, check the bg-ca.logs to see if the time slicing failure is related to KB000023178.
Solution 3: Reslice the DWH slices and then run the Load DWH job in full mode. Below are the steps on how to do this:
1. Pause the Time Slicing job (and wait for any processing time slicing jobs to complete)
2. Go to Administration -> System Options -> Data Warehouse Options
a. Clear out the field: 'Entity for Fiscal Periods' and click Save
b. Reset the 'Entity for Fiscal Periods field back to the previous Entity value and click Save again.
3. Unpause the Time Slicing Job (Check the check box next to the Paused Time Slicing job and click 'Resume') and wait for the job to complete successfully.
Notes:
Solution 2: Check to make sure the Time Slicing job is completing successfully. If not, check the bg-ca.logs to see if the time slicing failure is related to KB000023178.
Solution 3: Reslice the DWH slices and then run the Load DWH job in full mode. Below are the steps on how to do this:
1. Pause the Time Slicing job (and wait for any processing time slicing jobs to complete)
2. Go to Administration -> System Options -> Data Warehouse Options
a. Clear out the field: 'Entity for Fiscal Periods' and click Save
b. Reset the 'Entity for Fiscal Periods field back to the previous Entity value and click Save again.
3. Unpause the Time Slicing Job (Check the check box next to the Paused Time Slicing job and click 'Resume') and wait for the job to complete successfully.
Notes:
- If you go to Administration > Data Administration > Time Slices page, you will see that the DWH time slices "Last Run Date" have cleared out indicating they will now be reprocessed by the next Time Slicing job.
- It may take longer for the Time Slicing job to complete the first time after the reslice.
Additional Information
Reference the Resource Time Review by Manager documentation for more details on this report.
Reference KB000005312 - Resource Time Review by Manager report shows actuals in the wrong day due to a defect fixed in CA PPM 15.3.
Reference KB000005312 - Resource Time Review by Manager report shows actuals in the wrong day due to a defect fixed in CA PPM 15.3.
Feedback
Yes
No
Powered by
