Logging in with the user EiamAdmin, tests have been carried out for downloading and uploading files. the result was OK. but when checking the Transfer Diagnostics /Onboard status tab it reports the following:
XCOM22006E Error occurred while retrieving onward records. Please contact your administrator
Release : 12.0
Component : CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS
MySQL Server: 8.0.18 MySQL Community Server
Based on logs, there seems to be a problem when connecting to the MySQL server from Tomcat.
To disable SSL connections between Tomcat and MySQL, modify the two XML files at C:\Program Files\CA\XCOMWebv12\apache-tomcat-8.0.24\conf\Catalina\localhost location as suggested below:
Open each of the XML files in notepad and modify the JDBC URL to append "?useSSL=false" after the database name.
After the change, JDBC URL looks like below:
Modify both XML files and restart Gateway using the Batch file or using Windows Service "xcomgcs".