Intermittently transfers mayreceive a QUERYHISTORYFAILED message in the Gateway Control Center log.
This problem was encountered when a new more controlled network was created. There is a Windows server within this network that has XCOM and the Gateway. The REALM is local to this server. The XCOM XCOMHIST and Gateway databases are on a separate server outside this controlled network.
It was thought that the problem had been resolved when they did the following changes, but that was not the case:
The actual cause of the problem was due to sharing the same IBM DB2/MySQL database with multiple XCOM Gateway servers.
Release : 12.0
Component : CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS
It is not recommended that the XCOM Gateway database be shared with multiple Gateway servers. Sharing the database can cause multiple problems such as:
1. Message "XCOMN1301E SCHEDULE REQUEST FAILED: ERROR SETTING LOCAL USERID" and the transfer is not scheduled
2. QUERYHISTORYFAILED messages in the Gateway Control Center log for the Transfer Status.
3. Policy File Watcher stopped when multiple Gateway Servers are sharing the database.
Each XCOM Gateway server requires its unique IBM DB2/MySQL database to prevent any type of contention when a file is received into the Gateway and needs to be onward transferred.