CDC component showing error

RAJ6 — Mon, 23 Apr 2018 14:45:27 GMT

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

Re: CDC component showing error

Anonymous — Tue, 22 May 2018 10:49:45 GMT

Hello,

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

Best regards

Sabrina

topic Re: CDC component showing error in Talend Studio

CDC component showing error

Re: CDC component showing error