Webservices Call Fails

Document ID:  TEC1753887
Last Modified Date:  06/19/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Workload Automation AE

Releases

  • CA Workload Automation AE:Release:11.3.5
  • CA Workload Automation AE:Release:11.3.6

Components

  • CA Workload Automation AE (AutoSys):ATSYS
Problem:

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.

 

 

 

 

 

 

 

 

 

Workaround:

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.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >