MFT Files Not Processed Consistently ORA-00001: Unique Constraint FILEADAPTER_IN_PK Violated (Doc ID 2806117.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

When the MFT transfer job tries to pick files from the source system, it processes few files and then it gives the error message below and stops polling from the source. Checking the table FILEADAPTER_IN, it shows that the entries for FULL_PATH have the same values as the filenames on the source. Therefore, when the job tries to fetch and process the same files again, the following error occurs. After redeployment of the interface, it works for a little while and stops again.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.