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

book

Article ID: 4266

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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. 

Cause

AMS.properties file is missing the connection information

Environment

CA Asset Portfolio Management 14.1, any patch level

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\=\=