ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Reports not populating data when 'Update Report Tables' job is not 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 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

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 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