Jaspersoft DB Connection Check Error after move of Clarity DB

book

Article ID: 131719

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

We have recently moved our Clarity production database to a new server (new hostname). 
We have updated the jdbc connection string for the application in the properties.xml file with the new hostname.
Since then the out of the box report "Database Connection Check: CA PPM" does not work anymore.

We receive the error: 

The server has encountered an error. Please excuse the inconvenience.
Error Message:
An error occurred while creating the connection. Try again.

Impacted reports include:

  • PPM Schema
  • Portfolio Plan Changes
  • Portfolio Plan Changes – Waterline and Rank
  • Portfolio Plan Comparison
  • Project Change Request Register
  • Project Planning Schedule
  • User Access Rights
  • User Access Rights Detail
  • User License and Activity
  • User License and Activity Detail
  • Database Connection Check: CA PPM
  • Project Earned Value
  • Project Issue Register
  • Project Risk Register

Cause

This issue can happen after changes are made to the Database. The reason why only certain reports are impacted is because reports use two different data sources. Those impacted by this issue are those using the Data Source: CA PPM Bean Data Source. 

Environment

Release: All Supported Releases
Component: PPMJSP

Resolution

Run the following commands:

admin update jasperParameters

admin jaspersoft syncPPMContext -userName superuser -password superuser

Additional Information

Reference Advanced Reporting with Jaspersoft

See the following docops link for reports that use the PPM Bean Data Source

See the following docops link for reports that use the PPM Data Warehouse Bean Data Source