Transfer Status not shown CA XCOM GATEWAY

Products

• XCOM Data Transport
• XCOM Data Transport - Windows
• XCOM - SUPPORT

Issue/Introduction

Transfer status is not shown if the Gateway is started via a Windows service. 

Environment

Release: 12.0

Component: CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS

Cause

By default, MySQL discourages login to the database with root user and password. It is recommended to use a non-root user that has sufficient privileges to create/alter databases while installing Gateway. 

Resolution

In reviewing the logs provided the following was noticed:

Exceptions while connecting to MySQL
 org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))

This is a common restriction on MySQL servers to allow connections only from the localhost. You can run the below SQL queries on the MySQL server to widen the restriction on the Gateway database. 

USE mysql;

GRANT ALL PRIVILEGES ON 'gatewaydb'.* to root@'%' identified by '%PASSWORD%' WITH GRANT OPTION;

Here, replace 'gatewaydb' with the gateway database name and %PASSWORD% with the root password. 

Additional Information

Typically when XCOM gateway is started with service, the output and any errors go to the below three files.

• C:\Program Files\CA\XCOMWebv12\apache-tomcat-8.0.24\logs\commons-daemon.yyyy-mm-dd.log
• C:\Program Files\CA\XCOMWebv12\apache-tomcat-8.0.24\logs\xcomgcs-stderr.yyyy-mm-dd.log
• C:\Program Files\CA\XCOMWebv12\apache-tomcat-8.0.24\logs\xcomgcs-stdout.yyyy-mm-dd.log