Transfer status is not shown if the Gateway is started via a Windows service.
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.
Component: CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS
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.
GRANT ALL PRIVILEGES ON 'gatewaydb'.* to [email protected]'%' identified by '%PASSWORD%' WITH GRANT OPTION;
Here, replace 'gatewaydb' with the gateway database name and %PASSWORD% with the root password.
Typically when XCOM gateway is started with service, the output and any errors go to the below three files.