[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)

[sureshkumar]

Hello @haiderpasha 

From the logs it appears replicate system is not able to open the replicate file for the IO operation, Kindly check for the file existence at task level and also check you have enough permission to open this.

I would suggest starting the task from a previous timestamp or reloading the task if possible.

Regards,

Suresh

[RajyaLakshmi]

Hi @haiderpasha ,

Thanks for contacting in Qlik community

Can you check the location to see if the file exists in this directory?

It appears to be its unable to read the exact path from local to the target endpoint, " The system cannot find the file specified"

Double-check the file path mentioned in the error message. Make sure the file you're trying to access or reference exists at that location. Ensure that the file path is correctly formatted, including the use of correct slashes or backslashes depending on the operating system (e.g., \ for Windows, )

Best Regards,
Rajya Lakshmi

[Nicolae_Alecu]

Hello,

If it's an ad hoc issue, you could try to restart services.

Best Regards,

[haiderpasha]

The file path exists but there are no files exist in it. Not sure what is going on here.

[haiderpasha]

I have restarted the services but the issue hasn't resolved.

[RajyaLakshmi · Accepted solution]

Hi @haiderpasha ,

Thanks for your response.

Can you please try to start the task with previous timestamp or if possible reload the task.

Best Regards,

Rajya Lakshmi

[john_wang]

Hello @haiderpasha ,

Please check if the drive C:\ has free space or not. Or you may set IO to Verbose to get more detailed information.

Hope this helps.

John.

[SushilKumar]

Hello @haiderpasha 

Request you to please check that you are started the Qlik process with the Administrative user. 

Does Qlik user have sufficent privlages to access the mentioned folder . check is there any process is accessing the file via task manager . 

Regards,

Sushil Kumar