XCOM22006E Error CA XCOM GATEWAY retrieving onward records
book
Article ID: 191580
calendar_today
Updated On:
Products
XCOM Data TransportXCOM Data Transport - WindowsXCOM Data Transport - Linux PCXCOM - SUPPORT
Issue/Introduction
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
Environment
Release : 12.0
Component : CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS
MySQL Server: 8.0.18 MySQL Community Server
Resolution
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.