Jaspersoft Install fails with Oracle RAC as Database

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

Problem:

Jaspersoft Install fails with Oracle RAC as Database

Steps to Reproduce:

1. Set up an ORACLE RAC Database for Jaspersoft
2. Download the Jaspersoft ISO
3. Extract the content
4. Execute the install.bat/install.sh 

Expected Result:

Jaspersoft install should complete 

Actual Result:

Install fail with the following error in the Jasersoft install log:

BUILD FAILED 

/apps/niku/jasperinstall61/buildomatic/bin/db-common.xml:104: The following error occurred while executing this line: 

/apps/niku/jasperinstall61/buildomatic/bin/app-server.xml:44: The following error occurred while executing this line: 

/apps/niku/jasperinstall61/buildomatic/bin/validation.xml:118: WARNING: STOP EXECUTION: no JDBC driver jar found (see above) 

Environment:

Applies to all supported PAS environments for PPM 14.2, 14.3, 14.4 

Cause:

Caused by CLRT-80638

Workaround:

1. Go to the Jaspersoft install directory

2. Edit the install.xml file 

3. Go to line number 274 

4. Replace the below lines with correct code 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Current code: 

<if property="oracleType" value="cluster"> 

          <setuputil file="${master.properties}" interactive="${interactive}" overwrite="true" confirm="false" singleUse="true"> 

            <query message="Enter Oracle Service Name" name="serviceName" checkType="Text" errorMessage="Please enter a valid Service Name" checkWarn="false" /> 

          </setuputil> 

          <property name="oConnectionType" value="SERVICENAME" /> 

          <property name="oConnectionValue" value="${serviceName}" /> 

        </if> 

 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Modified code:

 <if property="oracleType" value="cluster"> 

          <setuputil file="${master.properties}" interactive="${interactive}" overwrite="true" confirm="false" singleUse="true"> 

           <query if="query.props" message="Oracle Version" name="maven.jdbc.version" defaultValue="11.2.0.4" errorMessage="Please enter a valid Oracle Version" checkWarn="false"> 

              <option name="11.2.0.4 or Higher" value="11.2.0.4" /> 

              <option name="12.1.0.2 or Higher" value="12.1.0.1" /> 

            </query> 

          </setuputil> 

          <property name="oConnectionType" value="SERVICENAME" /> 

          <property name="oConnectionValue" value="${serviceName}" /> 

        </if>  

4. Run the install.bat/install.sh command from the extraction directory

 

Resolution: 

CLRT-80638 has been targeted to be fixed in the next available release after 14.4.