XCOM22006E Error CA XCOM GATEWAY retrieving onward records
Article ID: 191580
Updated On:
Products
XCOM Data Transport
XCOM Data Transport - Windows
XCOM Data Transport - Linux PC
XCOM - 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.
After the change, JDBC URL looks like below:
url="jdbc:mysql://testserver:3306/databasename?useSSL=false"
Modify both XML files and restart Gateway using the Batch file or using Windows Service "xcomgcs".
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:
url="jdbc:mysql://testserver:3306/databasename?useSSL=false"
Modify both XML files and restart Gateway using the Batch file or using Windows Service "xcomgcs".
Feedback
Yes
No
Powered by
