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

Document ID : KB000008089
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

File Attachments:
TEC1855453.zip