Message XCOMA5317E Error occurred in EndFileInsertion With the CA XCOM Gateway

Products

• XCOM Data Transport
• XCOM Data Transport - Windows
• XCOM Data Transport - Linux PC
• XCOM Data Transport - z/OS

Issue/Introduction

Message XCOMA5317E Error occurred in EndFileInsertion occurs when uploading a file using XCOM to the Gateway.  The message is found in the Gateway log. Message "XCOMN0525E CA XCOM Gateway file insertion failed: CA XCOM Gateway returned an error." is received in the XCOM base log.


Environment

Release:
Component: XCGWIN

Cause

This happens when there is a value of 9999 on the "UnExtracted Retention" of the policy.

Resolution

To fix the problem you will need to issue a MySQL ALTER command to change the DataType for the FILE_EXPIRY column of the xcom_gateway_file table from TIMESTAMP to DATETIME.

Here is the syntax of the command:

ALTER TABLE gatewayDatabase. XCOM_GATEWAY_FILE CHANGE COLUMN `FILE_EXPIRY`

'FILE_EXPIRY' DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ;