Skip to main content

JDBC_54 - Column: 'COLUMN' does not exist in table: 'Schema = 'SCHEMA', Table = 'TABLE''. This is likely due to a DDL being performed on this table.

  • November 26, 2021
  • 0 replies
  • 63 views

AkshayJadhav
StreamSets Employee
Forum|alt.badge.img

We have two Dictionary Sources for Oracle CDC clients.

  1. Online Catalogue
  2. Redo Logs

Online Catalogue shall be used when table structure(Schema) change are not expected. 

We hit above error when  Dictionary Source is set to Online Catalogue and table structure(Schema) changes.

Redo Logs shall be used when table structure(Schema) can change while Oracle CDC pipeline is running.

 

Follow below steps to change Dictionary Source to Redo Logs:-

Oracle CDC stage --> Configuration --> Oracle CDC --> Dictionary Source --> Redo Logs

Did this topic help you find an answer to your question?
This topic has been closed for comments