topic Re: Attunity Task - Oracle to SQL error in Qlik Replicate

Attunity Task - Oracle to SQL error

poojask123 — Fri, 15 Nov 2024 23:31:43 GMT

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'.

Re: Attunity Task - Oracle to SQL error

lyka — Fri, 04 Dec 2020 16:33:18 GMT

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

Re: Attunity Task - Oracle to SQL error

poojask123 — Tue, 08 Dec 2020 05:49:46 GMT

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.

Re: Attunity Task - Oracle to SQL error

lyka — Tue, 08 Dec 2020 19:13:58 GMT

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

Re: Attunity Task - Oracle to SQL error

poojask123 — Thu, 17 Dec 2020 11:25:04 GMT

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