DBMaint Issue: CAUAJM_E_85002 Compliance Application terminated with error [100]

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation AE

Issue/Introduction

DBMaint is failing during the execution of the compliance application with

DBMaint: Starting at: 05/16/18 03:31 ------------------------------------------------------------------------
CAUAJM_I_85000 Compliance Application running
CAUAJM_E_85100 Unable to open database connection. Error details: * IO Error: could not resolve the connect identifier "cawladb"
CAUAJM_E_85002 Compliance Application terminated with error [100]
 

Environment

CA WAAE 11.3.6 SP7 on Linux with Oracle 11G.
But it can happen with any other CA WAAE Service Packs and Oracle versions

Cause

JDBC driver did not support the syntax of the tnsnames.ora file

Resolution

Modify the tnsnames.ora file

From:
====

SID01 = 
(DESCRIPTION = 
    (ADDRESS_LIST =
          (ADDRESS = 
        (PROTOCOL = tcp)
        (HOST = SERVER1)
        (PORT = 1528))
          )
     (CONNECT_DATA =
        (SERVICE_NAME = SID01)
        
          )
)

To:
==
SID01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT = 1528))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID01)
)
)