topic Re: Replicate Task Using Log Stream in Qlik Replicate

Replicate Task Using Log Stream

NewbieQlik — Tue, 09 Aug 2022 16:09:48 GMT

I am trying to create a replicate task which uses oracle as the source and log stream as my target and I am getting this error.

Stream component 'st_0_ELH_LogStream' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_ELH_LogStream'.
Permission denied (apr status = 13, location = at_dir.c(768))

From the error it looks to me that it has something to do with the log stream Storage path permission. This is what I have given in my target endpoint as the Storage path /opt/attunity/replicate/data.

Any help on this issue is greatly appreciated.

Re: Replicate Task Using Log Stream

narendersarva — Tue, 09 Aug 2022 16:24:08 GMT

Hi,

Please check if the user that Replicate runs as have access to /opt/attunity/replicate/data

Also, please try to reload the task or run the task by timestamp from Advance setting.

Thanks

Naren

Re: Replicate Task Using Log Stream

Dana_Baldwin — Tue, 09 Aug 2022 16:25:43 GMT

Hi @NewbieQlik

Is there an entry in your task log like:

00723291: 2022-XX-XXT14:59:34 [SOURCE_CAPTURE ]I: Create permission check failed for Oracle directory objects (oracle_endpoint_conn.c:513)

If so, and you want Replicate to create and manage the Oracle directories, you need to grant the CREATE ANY DIRECTORY privilege.

Here are the required permissions for Oracle source:

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDBSource_Security.htm

Thanks,

Dana