Help with Oracle to MSSQL

[Xantor]

Good day,

My apologies if I posted this under the wrong thread.

We currently have an issue when replicating data from Oracle to MSSQL.

A quick overview from our setup. Qlik Replicate reads from our standby (Read-Only) database Oracle, it does an initial full load and then activates the CDC. No problems there. But after a while randomly, let's say after a couple of days. It errors with the following errors:

Stream component 'st_0_FIN_READ' terminated
Stream component failed at subtask 0, component st_0_FIN_READ
Error executing source loop

Oracle CDC stopped

Cannot create Oracle directory name 'ATTUREP_0208B04002FIN_READ' with path '/u03/app/oracle/fast_recovery_area/FIN_READ/archivelog/2026_06_09'
OCI error 'ORA-01031: insufficient privileges'

As far as I understand, it's not supposed to create directories in this case - it's only supposed to read.

Can someone help with some ideas please?

[Rahul_Kale]

Hello Xantor,

Thank you for reaching out to the Qlik community.

This is expected behaviour in Qlik Replicate, even in read-only scenarios.

Qlik Replicate must use Oracle DIRECTORY objects to read archive logs (even in read-only CDC). 

When it sees a new archive log path, it tries to create ATTUREP_* directory. 

Your error = missing privilege:

ORA-01031: insufficient privileges ``` 【2-aa816e】

To fix this issue, either you have to grant:- 

GRANT CREATE ANY DIRECTORY TO <user>;
 

Or 2. Pre-create directories + grant:

GRANT READ ON DIRECTORY <dir_name> TO <user>;

ensure OS path read access.