Problem:
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.
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' ;