Attunity Task - Oracle to SQL error

[poojask123]

I am creating a task to replicate data from Oracle to SQL server (1 table now, for testing). I get the below error. Can someone plz help me resolve this error.

Stream component 'st_0_Oracle' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_Oracle'.

Qlik Replicate

[lyka · Accepted solution]

Good day!

If using Oracle as a source, you need to enable supplemental logging:

SELECT supplemental_log_data_min FROM v$database;
The returned result should be YES or IMPLICIT.
Enable supplemental logging by executing the following query:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

Please refer to the Replicat eUser Guide for a complete steps on Setting up supplemental logging

Thanks,

Lyka

[poojask123]

Thanks @lyka . I got rid of the error for supplemental logging. Can you confirm if Archivelog too must be enabled? coz i get that as a warning.

I am also still not able to get through the task execution because of the following error.

[lyka]

Hello,

You need to specify in the oracle source endpoint in "Archived redo logs destination ID:" . If you are using more than 1 desyination id, then you define it in "Alternate archived redo logs destination ID:" (starting Replicate 7) or add an internal parameter called additionalArchivedLogDestId  and set the value

Thanks,

Lyka

[poojask123]

Thank you @lyka . i set up both the logs as per your instructions and my tasks are executing fine.