AE Web Server errors related to Oracle.

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

Problem:

The Workload Automation AE Web Service is reporting errors in the waae_webservices.log.

2016-06-04 20:57:37,087 [AEConnMgr Monitor] ERROR com.ca.waae.dbaccess.dao.AEConnection - createEntityManager [EventServer_1] -> IllegalStateException encountered. Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@CAA1D

Error Code: 0...Throwing AEConnFatalException.

 

We can contact the database

$ tnsping CAA1D

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 28-JUN-2016 08:44:49

 

Copyright (c) 1997, 2014, Oracle. All rights reserved.

 

Used parameter files:

/oracle/client_CAA01/network/admin/sqlnet.ora

 

Used LDAP adapter to resolve the alias

Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=odacbk3-scan)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CAA1D)))

OK (0 msec)

 

 

Environment:

Workload Automation AE 11.3.6.x

Oracle 

Platform - UNIX/LINUX

 

 

Resolution:

The tsnping results suggest LDAP is involved.

 Used parameter files:

 /oracle/client_CAA01/network/admin/sqlnet.ora

 Used LDAP adapter to resolve the alias...

 

The error in the waae_webservices.log log suggest the connection.properties has an incorrect format for the oracle.tns.connection.string and/or possible issues exist with the jar file:

ERROR com.ca.waae.dbaccess.dao.AEConnection - createEntityManager [EventServer_1] -> IllegalStateException encountered. [ExceptionHeader]4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

[InternalExceptionHeader]java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@CAA1D

[ErrorCodeHeader]0...Throwing AEConnFatalException.

 

Please make sure to follow the steps as outlined in the documentation.

See the section titled:

Configure the Java Database Connectivity Driver to Use Oracle Call Interface

The information can be found at the following link:

https://docops.ca.com/ca-wla-ae-wcc/11-4-2/en/installing/ae-implementation/environment-and-database-connection#EnvironmentandDatabaseConnection-ConfiguretheJavaDatabaseConnectivityDrivertoUseOracleCallInterface

 

 

Extracts from the documentation :

 

Stop the CA Workload Automation AE web server.

(Compliance application) Configure the application to use the OCI JDBC driver as follows:

Open the following file:

(UNIX) $AUTOSYS/config/cmplapp/connection.properties

(Windows) %AUTOSYS%\config\cmplapp\connection.properties

Locate the following parameter:

 

oracle.tns.connection.string=jdbc:oracle:thin:@${dbname}

Edit the parameter as follows:

oracle.tns.connection.string=jdbc:oracle:oci:@${dbname}

Save and close the file.

(RESTful web services) Configure the application to use the 64-bit Oracle client libraries as follows:

Open the following file:

(UNIX) $AUTOUSER/webserver/conf/wrapper.conf

(Windows) %AUTOUSER%\webserver\conf\wrapper.conf

Locate the following parameter:

wrapper.java.library.path.1=../lib

Edit the file to include an additional parameter as follows:

wrapper.java.library.path.1=../lib

wrapper.java.library.path.2=Oracle 64-bit client library path

Important! Ensure that 64-bit Oracle client is installed and that the client and the JDBC driver are the same version.

Save and close the file.

(Oracle 11g and above) Replace the Oracle 10 JDBC driver file with the Oracle 11 JDBC driver file as follows:

Delete the ojdbc14.jar file from the following directories:

(UNIX) $AUTOSYS/lib and $AUTOUSER/webserver/webapps/AEWS/WEB-INF/lib

(Windows) %AUTOSYS%\lib and %AUTOUSER%\webserver\webapps\AEWS\WEB-INF\lib

Open the following directory:

(UNIX) $ORACLE_HOME/jdbc/lib

(Windows) %ORACLE_HOME%\jdbc\lib

Locate the ojdbc6.jar file and copy it to the directories that previously contained the ojdbc14.jar file.

 

Important! The ojdbc6.jar is located in the Oracle home directory only if you use the full Oracle installer to install the database. If you use the instant installer, the file is saved to the location that you specify when you unzip the Oracle installation files.

The Oracle 11 JDBC driver files are saved to the specified locations.

 

Start the CA Workload Automation AE web server.

The JDBC driver is configured to use OCI and the Java components can connect to the database using TNS names that are stored in LDAP.