Identity Governance Client Tools 14.X SOAP and Database Connection issue

Products

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

Issue/Introduction

We installed Identity Governance Client Tools 14.X for our Identity Virtual Appliance 14.X which is using embedded Oracle database.
We get SOAP Connector error and Database Connection error when we try to connect to the Identity Governance server and database.

Environment

Identity Virtual Appliance 14.X
Identity Governance Client Tools 14.X running on Windows 2016

Resolution

Procedure for versions 14.2 and above.

1. Bring up a Command Prompt as Administrator, and use the regasm.exe to register the 2 dlls: 

cd C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319

    regasm.exe "C:\Program Files\CA\Identity Governance\Client Tools\Software\Microsoft.Web.Services3.dll" 

2.0 Please make sure Ooacle Client Tools are installed on windows server, so that tnsnames.ora is avalable (under C:\app\client\Administrator\product\12.2.0\client_1\network\admin or similar path)
2.1 Confirm the content in C:\app\{user name}\product\1x.x.x\client_x\NETWORK\ADMIN\tnsnames.ora 
    XE =
    (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = database_srv)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = XE)
     )
   )

   Notice the host name is database_srv 

3. Copy the entries in /etc/hosts on vApp server to the c:\windows\system32\drivers\etc\hosts files on Windows machine running the IdentityGovernance-Client-Tools-14.X
    This allows the windows machine to resolve the ip address of database_srv 

4. Start IdentityGovernance-Client-Tools-14.X, go to General Settings, select "Use Static SQL Credentials" 
    SQL Server Type: ORACLE 
    Server: database_srv 
    Username: EUREKIFY_SDB 
    Password: EUREKIFY_SDB password 

    Apply the change and ensure it works. This verifies that the password of EUREKIFY_SDB is correct

5. Restart IdentityGovernance-Client-Tools-14.X, go to General Settings, select "Request SQL Credentials from a Server": 
      http://{ip address of the vApp server}:8082/eurekify/services/sageDNAService 

    Apply the change, on the prompt of "Enter Server Credentials", enter 

    SQL Server User Name: EUREKIFY_SDB 
    Password: EUREKIFY_SDB password 
    Web Server User Name: AD1\EAdmin 
    Password: AD1\EAdmin password 

    Click Ok, and we can see the message: 
    SQL Server Successfully connected (Version 14.X) 

Additional Information

Please be aware of the procedure is only applicable to IdentityGovernance-Client-Tools-14.1.0 which does come with Microsoft.Web.Services3.dll

The follow is a summary about how we fixed this issue on  IdentityGovernance-Client-Tools-14.1

1. Bring up a Command Prompt as Administrator, and use the regasm.exe to register the 2 dlls: 

    cd C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\
    regasm.exe "C:\Program Files\CA\Identity Governance\Client Tools\Software\Microsoft.Web.Services3.dll" 
    regasm.exe "C:\Program Files\CA\Identity Governance\Client Tools\Software\SageSOAP.dll" 

2.0. Please make sure Ooacle Client Tools are installed on windows server, so that tnsnames.ora is avalable (under C:\app\client\Administrator\product\12.2.0\client_1\network\admin or similar path)
2.1. Confirm the content in C:\app\{user name}\product\1x.x.x\client_x\NETWORK\ADMIN\tnsnames.ora 
    XE =
    (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = database_srv)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = XE)
     )
   )

   Notice the host name is database_srv 

3. Copy the entries in /etc/hosts on vApp server to the c:\windows\system32\drivers\etc\hosts files on Windows machine running the IdentityGovernance-Client-Tools-14.X
    This allows the windows machine to resolve the ip address of database_srv 

4. Start IdentityGovernance-Client-Tools-14.X, go to General Settings, select "Use Static SQL Credentials" 
    SQL Server Type: ORACLE 
    Server: database_srv 
    Username: EUREKIFY_SDB 
    Password: EUREKIFY_SDB password 

    Apply the change and ensure it works. This verifies that the password of EUREKIFY_SDB is correct

5. Restart IdentityGovernance-Client-Tools-14.X, go to General Settings, select "Request SQL Credentials from a Server": 
      http://{ip address of the vApp server}:8082/eurekify/services/sageDNAService 

    Apply the change, on the prompt of "Enter Server Credentials", enter 

    SQL Server User Name: EUREKIFY_SDB 
    Password: EUREKIFY_SDB password 
    Web Server User Name: AD1\EAdmin 
    Password: AD1\EAdmin password 

    Click Ok, and we can see the message: 
    SQL Server Successfully connected (Version 14.01.01.04)