Clarity : Installation/Upgrade of Jasper Server 7.8 using an Oracle (RAC) Cluster Fails

book

Article ID: 211189

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Installation/Upgrade of Jasper Server 7.8 using an Oracle (RAC) Cluster Fails with the below error.

C:\Temp\install.xml:490: The following error occurred while executing this line:
C:\Temp\install.xml:1113: Unable to get Jasper Database version 
  ERROR: The following error occurred while executing this line:
C:\Temp\install.xml:1324: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12504, TNS:listener was not given the SID in CONNECT_DATA 

Cause

This is Caused by Defect DE60196

Environment

Release : 15.9.1

Component : CA PPM JASPERSOFT

Resolution

This is being tracked as Defect DE60196 and is under engineering review. Customers can use the below workaround to address the issue.

  1. Navigate to the directory where you've extracted clarity_jaspersoft_7.8.0_6.4.0.35.zip.
  2. Edit install.xml file and modify "oConnectionType" from "SERVICENAME" to "SERVICE_NAME" on line 937

    Before


    After


  3. Edit file setup.xml under buildomatic/bin folder. Modify "dbSidOrServiceNameProp" from "ServiceName=${serviceName}" to "SERVICE_NAME=${serviceName}" on Line 914

    Before


    After

 

Additional Information

 

 

Attachments