Reports not populating data - additional job needs to run

book

Article ID: 33280

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Jaspersoft Reports do not populate data even though Load Data warehouse, Time slicing, Datamart Extraction jobs run successfully

Steps to Reproduce:

  1. Login to Clarity
  2. Navigate to Advance Reporting Link 
  3. Run reports like Missing Time and data is not populated

Expected Result: The report should return the expected data

Actual Result: The report runs successfully without any data

Cause

The Update Report Tables job may also need to be run

Environment

Release: All 

Resolution

Run the Update Report Tables Job

Additional Information

The 'Updated Business Objects Report Tables' job is renamed to Update Report Tables Job in CA PPM 14.3 

This job populates the RPT_CALENDAR, RPT_RES_SKILLS_FLAT, RPT_RES_SKILLS_INDEX, RPT_PROGRAM_HIERARCHY, RPT_INV_HIERARCHY  tables

Reference CA PPM Tech Tip: Updating Report Tables