Resolve SOAP and Database Connection Errors for Identity Governance Client Tools

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

This article provides the configuration procedures to resolve SOAP Connector and Database Connection errors when connecting the Identity Governance Client Tools to an Identity Virtual Appliance (vApp) using an embedded Oracle database.

Environment

Identity Governance 14.5 & 15

Cause

Connection errors typically result from improperly registered DLL components or missing Oracle TNS client configuration on the local machine running the Client Tools.

Resolution

1. Register DLL Components Open an Administrator Command Prompt and register the required DLLs based on your installed version.

   • For 14.5: Ensure that you run the 64 bit assembly registration utility (regasm.exe) of .NET 4.6.1 on SageSOAP.dll that is available in Client Tools/Software folder after you install Client Tools.

2. Configure TNSNAMES.ORA Ensure Oracle Client Tools are installed on the Windows server. Locate and verify the tnsnames.ora file (e.g., C:\app\client\Administrator\product\12.2.0\client_1\network\admin\tnsnames.ora). Confirm the host entry matches the database server:

   XE =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = database_srv)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = XE)    )  )

3. Update Local Hosts File Copy the entries from the /etc/hosts file on the vApp server to the C:\windows\system32\drivers\etc\hosts file on the Windows machine. This allows the machine to resolve the database_srv hostname.

4. Configure Static SQL Credentials Launch the Identity Governance Client Tools and navigate to General Settings:

   1. Select Use Static SQL Credentials.
   2. Set SQL Server Type to ORACLE.
   3. Set Server to database_srv.
   4. Enter the EUREKIFY_SDB username and password.
   5. Apply settings to verify the database connection.

5. Configure Server-Requested Credentials Restart the Client Tools and return to General Settings:

   1. Select Request SQL Credentials from a Server.
   2. Enter the URL: http://{vApp_IP_Address}:8082/eurekify/services/sageDNAService.
   3. At the prompt, enter your SQL Server and Web Server credentials.
   4. Confirm the status message: "SQL Server Successfully connected."

Additional Information

For further information about Client Tools installation, see documentation Client Tools Server Hardware Requirements - 14.5 or Install Client Tools - v15

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.