Seven Stars RAJ
Seven Stars

CDC component showing error

Hi Talend folks,

 

I am trying CDC concept in talend 6.5 data integration using Microsoft sql server 2014 database 

When I try to write the data using CDC component to tlogrow.

I am getting error from CDC component.

how to solve this error. kindly share your information. 

 

ERROR:

Starting job CDC at 19:12 23/04/2018.

[statistics] connecting to socket on port 3649
[statistics] connected
Exception in component tMSSqlCDC_3 (CDC)
[FATAL]: local_project.cdc_0_1.CDC - tMSSqlCDC_3 Invalid object name 'dbo.TCDC_stocks'.
java.sql.SQLException: Invalid object name 'dbo.TCDC_stocks'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:677)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)
at local_project.cdc_0_1.CDC.tMSSqlCDC_3Process(CDC.java:1060)
at local_project.cdc_0_1.CDC.runJobInTOS(CDC.java:1679)
at local_project.cdc_0_1.CDC.main(CDC.java:1505)
java.sql.SQLException: Invalid object name 'dbo.TCDC_stocks'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:677)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)
at local_project.cdc_0_1.CDC.tMSSqlCDC_3Process(CDC.java:1060)
at local_project.cdc_0_1.CDC.runJobInTOS(CDC.java:1679)
at local_project.cdc_0_1.CDC.main(CDC.java:1505)
[statistics] disconnected

 

 

 

Screenshot (64).pngScreenshot (65).png

Thanks
RAJ
1 REPLY
Moderator

Re: CDC component showing error

Hello,

Are you trying to create two mssql connections – different database, same schema? What does your generated SQL look like?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.