Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
poojask123
Partner - Creator
Partner - Creator

Attunity Task - Oracle to SQL error

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

poojask123_0-1606909195500.png

 

Labels (2)
1 Solution

Accepted Solutions
lyka
Support
Support

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

View solution in original post

4 Replies
lyka
Support
Support

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
Partner - Creator
Partner - Creator
Author

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.

poojask123_0-1607406549854.png

 

 

lyka
Support
Support

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
Partner - Creator
Partner - Creator
Author

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