[S3 Target] Failed to rename file

[haiderpasha]

Hello Team

     Our tasks are failing with below error. The full load data has been written to S3 but change records are not going through.

00003332: 2024-05-24T11:17:39 [IO ]E: The system cannot find the file specified. (apr status = 720002) [1000121] (at_file.c:447)
00003332: 2024-05-24T11:17:39 [IO ]E: Failed to rename file <C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\CDC00000000.tmp> to <C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\20240524-111737918.csv> [1000121] (at_file.c:456)
00003332: 2024-05-24T11:17:39 [IO ]E: Failed to rename file from <\\?\C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\CDC00000000.tmp> to <\\?\C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\20240524-111737918.csv>: The system cannot find the file specified. [1000121] (at_file.c:3036)
00003332: 2024-05-24T11:17:39 [IO ]E: Failed to copy file from <\\?\C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\CDC00000000.tmp> to <\\?\C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\20240524-111737918.csv>: The system cannot find the file specified. [1000121] (at_file.c:2945)
00003332: 2024-05-24T11:17:39 [TARGET_APPLY ]E: Failed to rename file from 'C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\CDC00000000.tmp' to 'C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\20240524-111737918.csv'. [1000121] (file_utils.c:491)
00003332: 2024-05-24T11:17:39 [TARGET_APPLY ]E: Failed to rename file 'C:\Program Files\Attunity\Replicate\data\tasks\ODS_ProdCopy_S3_RGA Table\data_files\public.sales_order__ct\CDC00000000.tmp'. [1000121] (file_imp.c:2545)
00003332: 2024-05-24T11:17:39 [TARGET_APPLY ]E: Failed to handle an unfinished file processing. [1000121] (file_apply.c:792)

[DesmondWOO]

Hi @nisarmohamed ,

I've seen similar reports before, but haven’t yet gathered enough details to confirm the root cause. As a first step, please check if any antivirus software might be scanning the path, and also verify whether two sources are mapping to the same target table name. If the issue persists after these checks, I recommend creating a support ticket so our team can investigate further with you directly.

Regards,
Desmond