topic Re: Task failed to resume with access is denied error in Qlik Replicate

Task failed to resume with access is denied error

desmondchew — Fri, 16 Jun 2023 02:28:16 GMT

We are encountering this error for the third or fourth time. We have log streaming setup. So I have stop the child task and then we we try to reload the child task, we got the following error.

There's no file opened at the QDI server.

Stream component 'st_0_Oracle ALL with Log Stream' terminated
Stream component failed at subtask 0, component st_0_Oracle ALL with Log Stream
Error executing command
Audit file open for read failed
failed to open file <D:\Attunity\Staging\ODS_ALL\LOG_STREAM\audit_service\20230527043942576911\181>
Access is denied. (apr status = 720005)

I login into QDI server and noted the file is there. However when checking on the permission I noticed that i do not have the read permission. However I do have permission with other files inside the folder. There's something that has changed the permission to cause this error.

Re: Task failed to resume with access is denied error

OritA — Fri, 16 Jun 2023 07:55:57 GMT

Hi,

In general, the use that is used to access the files is the Replicate user. Which use did you use to start the Replicate server? Was anything changed in the environment. We suggest that you check the windows event viewere to see if it contains any errors around the time of the manifestation of the permission issue (sometime due to hard disk full or other hardware issue the file may get corrupted). If no clue is found, I suggeste that you open a case and provide the log with the error and the task diagnsotic package so we can troubleshoot the cause of the problem.

Thanks & regards,

Orit

Re: Task failed to resume with access is denied error

shashi_holla — Tue, 20 Jun 2023 23:00:29 GMT

@desmondchew

Could you please let me know the target endpoint? Is it Google Big Query?

We have seen an instance where the python sessions created by GBQ endpoint tries to lock the Logstream audit files for processing and doesn't release it causing this issue.

Re: Task failed to resume with access is denied error

desmondchew — Thu, 22 Jun 2023 00:58:53 GMT

Hi,

We are writing from Oracle into Snowflake as target endpoints. I see there were several kernel crashed in QDI replicate server. I believe this could be the cause of locking the file resulting permission denied error.

Desmond

Re: Task failed to resume with access is denied error

Dana_Baldwin — Wed, 28 Jun 2023 22:01:57 GMT

Hi @desmondchew

If you are seeing Replicate task stop abnormally you should open a support case so we can help troubleshoot and resolve that.

Thanks,

Dana