My Oracle Support Banner

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

Last updated on SEPTEMBER 10, 2021

Applies to:

Oracle Managed File Transfer - Version and later
Information in this document applies to any platform.


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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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