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

The version of Jaspersoft Studio should be 6.4.2.
<Please see attached file for image>

The old Database JDBC Connections should be cleaned out of the old connections, from this:
<Please see attached file for image>

To this:
<Please see attached file for 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>

After cleaning up, this should be successful:
<Please see attached file for 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>