Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilsh1
Contributor III
Contributor III

Error subscription has not been activated Talend CDC:Talend MDM 5.6.2

Hi All,
We are using Talend MDM 5.6 varsion with Bigdata platform and while implementing CDC we are getting the following error:Exception in 
component tOracleCDC_2
java.sql.SQLException: ORA-31429: subscription has not been activated
ORA-06512: at "SYS.DBMS_CDC_SUBSCRIBE", line 53
ORA-06512: at line 1
When we check for changed rows in the repository for CDC component , we are getting the changed rows but when we are using that component in designer and attaching tlogrow we are getting above error.We ahve used redo approach instead of trigger approch.
Any help appreciated.
Thanks in advance. 
Labels (4)
3 Replies
Anonymous
Not applicable

Hi,
Have you already checked document about: TalendHelpCenter:How to set up CDC in Oracle Redo/Archive log mode?
Redo/Archive log mode is used with Oracle v11 and previous versions.
Best regards
Sabrina
nikhilsh1
Contributor III
Contributor III
Author

Hi Xdshi,
We are using Oralce 11g version and we are connecting it through service name.
Anonymous
Not applicable

Hi nikhilsh,
Would you mind reporting a ticket on Talend Support Portal so that we can give you a remote assistance to address your issue through support cycle with priority.
https://support.talend.com/otrs/customer.pl
Best regards
Sabrina