CA PPM Jasper JDBC Connection "null" data error

book

Article ID: 102457

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction



The following error was returned when trying to retrieve data from Jasper Studio 6.2.1 and 6.4, via Jasper JDBC URL:

"Query execution error
The following problem occurred:
null
Do you want to proceed anyway?
<Yes> <No>"


<Please see attached file for image>

User-added image

This has happened since around May 2018, and was working normally before.

This is even though the Database JDBC Connection "Test" was returned as "Successful."

<Please see attached file for image>

User-added image

And the Data Source was able to find tables, such as "INV_INVESTMENTS" and its fields.

<Please see attached file for image>

User-added image
 

Environment

CA PPM and Jaspersoft Studio.
Note that Jaspersoft Studio is different to the Jaspersoft Advanced Reporting within CA PPM.
 

Resolution

The database has been upgraded for CA PPM SAAS (On-Demand) users at around this time.

It is necessary to be running:
  • Jaspersoft Studio 6.4 (or later). This download is available from support.ca.com.
  • Matching JDBC drivers
You cannot point to the upgraded database using old drivers and Jaspersoft 6.2.

EXAMPLE
These screenshots were taken from a client system. Your system will have different database detail which will require updating.

The Database JDBC Connection should "Test" as "Successful."

<Please see attached file for image>

User-added image

The version of Jaspersoft Studio should be 6.4.2.

<Please see attached file for image>

User-added image

The old Database JDBC Connections should be cleaned out of the old connections, from this:

<Please see attached file for image>

User-added image

To this:

<Please see attached file for image>

User-added image

The red flag that your configuration will NOT work is if the word "CURRENT" (in green) is missing from against the Data Source.
The following screen is prior to upgrading to the latest Jaspersoft and trimming the list of connectors (above).

<Please see attached file for image>

User-added image

After cleaning up, this should be successful:

<Please see attached file for image>

User-added image

A successful test will allow you to enter a query such as the following, and then click "Next" without receiving the "null" error:
 
select name from inv_investments

From this next screen, you may continue as normal with your report design.

<Please see attached file for image>

User-added image





 

Additional Information

Jaspersoft Studio Professional CA JDBC Adapter - CA PPM 15.4.1

 

Attachments

1558700957948000102457_sktwi1f5rjvs16kbk.png get_app
1558700956285000102457_sktwi1f5rjvs16kbj.png get_app
1558700954703000102457_sktwi1f5rjvs16kbi.png get_app
1558700952929000102457_sktwi1f5rjvs16kbh.png get_app
1558700951138000102457_sktwi1f5rjvs16kbg.png get_app
1558700949318000102457_sktwi1f5rjvs16kbf.png get_app
1558700947499000102457_sktwi1f5rjvs16kbe.png get_app
1558700945675000102457_sktwi1f5rjvs16kbd.png get_app
1558700943849000102457_sktwi1f5rjvs16kbc.png get_app
1558700941931000102457_sktwi1f5rjvs16kbb.png get_app