Webservices Call Fails

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

Webservice calls fails with below error.

24-MAY-2017 09:57:59 * (CONNECT_DATA=(SID=XXXXX)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=XXXXX))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.
XX.XX.XX)(PORT=XXXX)) * establish * XXXXX* 12505 

 

Below error occurs in waae_webservices_wrapper.log

 

INFO   | jvm 1    | 2017/05/24 10:00:27 | Error Code: 12505
INFO   | jvm 1    | 2017/05/24 10:00:27 | [EL Severe]: ejb: 2017-05-24 10:00:27.745--ServerSession(1553225196)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
INFO   | jvm 1    | 2017/05/24 10:00:27 | Internal Exception: java.sql.SQLException: Listener refused the connection with the following error:
INFO   | jvm 1    | 2017/05/24 10:00:27 | ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

 

Environment:
Issue May Occur in Oracle RAC with r11.3+ WAAE versions.
Cause:

This issue occurs when $TNS_ADMIN variable is not setup in the AutoSys environment, because when the TNS_ADMIN variable is set, the compliance app or WAAE Web Server uses the “oracle.tns.connection.string” parameter and skips the “oracle.connection.string=” setting in the $AUTOSYS/config/cmplapp/connection.properties file.

 

Note # And, by default the $TNS_ADMIN is set in the autosys environment profiles.

 

 

 

 

 

 

 

 

 

Resolution:

1) Let’s change this line in connection.properties file.

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

to 

oracle.connection.string=jdbc:oracle:thin:@//<hostname>:<port>:<SID>

 

2) To get WAAE Web Server to use the Oracle Servicename instead of SID, you need to ensure the $AUTOUSER/config.$AUTOSERV (EventServer_1) contains the servicename, and update the $AUTOSYS/config/cmplapp/connection.properties file with the following:  

 oracle.connection.string=jdbc:oracle:thin:@${servername}:${port}/${dbname}

 instead of: oracle.connection.string=jdbc:oracle:thin:@${servername}:${port}:${dbname}

 

 

Additional Information:

By default you can find this connection.properties file under /opt/CA/WorkloadAutomationAE/autosys/config/cmplapp. Once these changes are done please restart the services of web services.