CA PPM Jaspersoft Server Cumulative Patch 6.2.1_5.2.1.4 Fails on Oracle RAC

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Jaspersoft Server Cumulative Patch 6.2.1_5.2.1.4 Fails to install on Oracle RAC Servers 

 

Steps to Reproduce:

1. Exact the Cumulative Patch 6.2.1_5.2.1.4 ISO

2. Start the Install 

Actual Result: The build fails with error ORA-12514, TNS:listener does not currently know of service requested

Expected Result: The install should be successful 

Below errors are shown in install logs 

[echo] Found jar file: assuming OK 

[echo] Jar or Jars found: ojdbc7-12.1.0.1.jar
[select-sql] Failed to connect: Listener refused the connection with the followi
ng error:
[select-sql] ORA-12514, TNS:listener does not currently know of service requeste
d in connect descriptor
[select-sql]
[echo] Connection failed:
[echo] SQLState: 08006
[echo] Vendor specific error code: 12514
[echo] Message: [Listener refused the connection with the following error
:
[echo] ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
[echo] ] 

Environment

Jaspersoft 6.2.1 database is configured on a Oracle RAC server.

Cause

This is a bug DE36561 and workaround is mentioned below

Resolution

This issue only will occur when JSFT is installed on Oracle RAC. To solve the problem, there is small config change in install.xml. To apply the changes do the following:

 

1. Unzip the patch zip - ca_ppm_jaspersoft_patch_6.2.1_5.2.1.4.33.zip to a folder - ca_ppm_jaspersoft_patch_6.2.1_5.2.1.4.33.
2. Navigate to bin folder in the patch and find the file - 'install.xml' script file.
3. Replace the existing 'install.xml' with the one attached to install.xml .
4. Then, run patch installation command.

Additional Information

Note: above changes need to be done only if JSFT 6.2.1 database is configured on a Oracle RAC server.