Reports not populating data when 'Update Report Tables' job is not run

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Jaspersoft Reports do not populate data even though the below jobs run successfully:

• Load Data Warehouse
• Time slicing
• Datamart Extraction

Steps to Reproduce:

1. Login to Clarity
2. Navigate to the Advanced Reporting Link 
3. Run a report such as the Missing Time report

Expected Result: The report should return the expected data

Actual Result: The report runs successfully without any data

Environment

Release: All 

Cause

The Update Report Tables job may also need to be run

Resolution

Run the Update Report Tables Job

Additional Information

The 'Updated Business Objects Report Tables' job is renamed to Update Report Tables Job in Clarity14.3 

This job populates the below tables:

• RPT_CALENDAR
• RPT_RES_SKILLS_FLAT
• RPT_RES_SKILLS_INDEX
• RPT_PROGRAM_HIERARCHY
• RPT_INV_HIERARCHY

Reference CA PPM Tech Tip: Updating Report Tables