Today the daily files were sent correctly to the remote system, but in one case it reported a failure. Below are the messages received:
The message in the Gateway Control Center log:
[policyName=IIII, fileName=FFFFFFFF, arrivalTime=Wed Jul 07 06:30:24 GMT-03:00 2021, originator=XXXXXX, deliveryStatus=FAILED, transferTime=Wed Jul 07 06:30:47 GMT-03:00 2021, xmlItemNumber=1, remoteDestination=xxxxxxxxxxxxx, transferStatus=QUERYHISTORYFAILED, lastMessage=Number of History Items is zero, fileGuid=abcdefghijkslakjfasj, fileSize=303264000, deliveryStartTime=Wed Jul 07 06:30:26 GMT-03:00 2021, lastActivityTime=Wed Jul 07 07:26:04 GMT-03:00 2021, transferNumber=2319, transferMicr=C3F3C9D5F8C7F0C6, localLogonUser=XXXXXX, localXcomHost=127.0.0.1 8044, localXcomSsl=NO], OnwardRescheduleDataBean
but the xcom.log shows that the file was sent successfully:
2021/07/07 06:30:47 TID=002319 [/IIIII/PPPPPP --> /input/directory/filename at xxx.xxx.xxxx.xx]
XCOMN0035I Starting Gateway SFTP export
2021/07/07 07:17:58 TID=002319
XCOMN0018I Transfer ended; File successfully exported to external server
Release : 12.0
Component : CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS
The system had IPV4 and IPV6 enabled. IPV6 was using the hostname in the config files and when the hostname is used, it can resolve it to IPV4 or IPV6 causing the intermittent problem.
In this case you can resolve by:
1. Disable IPV6.
2. Make sure that the user identification for the history database is not specified in the xcom.glb with a Domain included:
in addition to adding the domain to the ODBC UID parameter: