XCOM22006E Error CA XCOM GATEWAY retrieving onward records
search cancel

XCOM22006E Error CA XCOM GATEWAY retrieving onward records

book

Article ID: 191580

calendar_today

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".