In CA Asset Portfolio Manager (APM), when selecting the asset viewer - owned information link, it errors with: TCPIP connection to the host failed.

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

In CA Asset Portfolio Manager (APM), when selecting the asset viewer - owned information, or the asset viewer - discovered information link,  it errors with: TCPIP connection to the host failed. 

Environment:
CA Asset Portfolio Management 14.1, any patch level
Cause:

AMS.properties file is missing the connection information

Resolution:

1. On the APM application server, stop the Apache Tomcat AMS service

2. Edit the AMS.properties file, typically, located on the APM application server, in this path: 
    C:\Program Files (x86)\CA\SharedComponents\AMS\Tomcat\webapps\AMS\WEB-INF\classes

3. Locate and update the following entries with your specific SQL Server database and APM web server connection information: 

   sql2005.port=1433 
   sql2005.password=rpVTWUXCBNM 
   sql2005.host=MySQLServerHostName 
   dbtype=sql2005 
   sql2005.loginid=mdbadmin 
   sql2005.databaseName=mdb

   itamwebserviceurl=http\://APMWEB\:80/ITAMService/Service.asmx   <-- this is the correct syntax

4. Close the APM web browser, start the Apache Tomcat AMS service and retest the 'asset viewer - owned information' link. 

Additional Information:

The passwords in the AMS.properties file are encrypted.  To verify an encrypted password, download the APM password encryption tool from this URL:  CA Asset Portfolio Solutions and Patches

 

Note: The AMS.properties file requires a backslash character (\) before any colon (:) or equals (=) symbols in the file. 

Examples:  the URL http:// should read http\://

an encrypted password, like rpD55YtuVxx9OPL== should read rpD55YtuVxx9OPL\=\=