Transfer is successful but received error QUERYHISTORYFAILED

Products

• XCOM Data Transport - Windows
• XCOM Data Transport

Issue/Introduction

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

 

 

Environment

Release : 12.0

Component : CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS

Cause

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.

Resolution

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:

[XCOMHIST]
CLISchema=svc_dbxc
Database=XCOMHIST
Port=60000
Hostname=xxxxxxx.cc.bbb.net
SchemaList='svc_dbxc','xcomhist'
UID=domain\svc_dbxc
DESCRIPTION=DB2XCOM