Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1721

io.debezium.text.ParsingException: no viable alternative at input 'IDNUMBER(4)GENERATEDBY'

XMLWordPrintable

      io.debezium.text.ParsingException: no viable alternative at input 'IDNUMBER(4)GENERATEDBY'
      
      CREATE TABLE products (
        id NUMBER(4) GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 101) NOT NULL PRIMARY KEY,
        name VARCHAR2(255) NOT NULL,
        description VARCHAR2(512),
        weight FLOAT
      );
      
      
      [2020-01-16 10:21:48,040] INFO [Consumer clientId=server1-dbhistory, groupId=server1-dbhistory] Successfully joined group with generation 1 (org.apache.kafka.clients.consumer.internals.AbstractCoordinator:484)
      [2020-01-16 10:21:48,041] INFO [Consumer clientId=server1-dbhistory, groupId=server1-dbhistory] Adding newly assigned partitions: schema-changes.inventory-0 (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:267)
      [2020-01-16 10:21:48,043] INFO [Consumer clientId=server1-dbhistory, groupId=server1-dbhistory] Found no committed offset for partition schema-changes.inventory-0 (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:1241)
      [2020-01-16 10:21:48,044] INFO [Consumer clientId=server1-dbhistory, groupId=server1-dbhistory] Resetting offset for partition schema-changes.inventory-0 to offset 0. (org.apache.kafka.clients.consumer.internals.SubscriptionState:385)
      [2020-01-16 10:21:48,096] INFO [Consumer clientId=server1-dbhistory, groupId=server1-dbhistory] Revoke previously assigned partitions schema-changes.inventory-0 (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:286)
      [2020-01-16 10:21:48,096] INFO [Consumer clientId=server1-dbhistory, groupId=server1-dbhistory] Member server1-dbhistory-05c46f44-f528-4be8-8f79-831ad14a7135 sending LeaveGroup request to coordinator kafka1:9092 (id: 2147483645 rack: null) due to the consumer is being closed (org.apache.kafka.clients.consumer.internals.AbstractCoordinator:916)
      [2020-01-16 10:21:48,102] INFO Requested thread factory for connector OracleConnector, id = server1 named = error-handler (io.debezium.util.Threads:250)
      [2020-01-16 10:21:48,102] INFO Requested thread factory for connector OracleConnector, id = server1 named = change-event-source-coordinator (io.debezium.util.Threads:250)
      [2020-01-16 10:21:48,102] INFO Creating thread debezium-oracleconnector-server1-change-event-source-coordinator (io.debezium.util.Threads:267)
      [2020-01-16 10:21:48,103] INFO WorkerSourceTask{id=inventory-connector-0} Source task finished initialization and start (org.apache.kafka.connect.runtime.WorkerSourceTask:209)
      [2020-01-16 10:21:48,245] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:36)
      io.debezium.text.ParsingException: no viable alternative at input 'IDNUMBER(4)GENERATEDBY'
              at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:40)
              at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
              at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
              at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:282)
              at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:121)
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.relational_properties(PlSqlParser.java:48099)
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.relational_table(PlSqlParser.java:47794)
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.create_table(PlSqlParser.java:46171)
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.unit_statement(PlSqlParser.java:2337)
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:54)
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parseTree(OracleDdlParser.java:29)
              at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)
              at io.debezium.connector.oracle.antlr.OracleDdlParser.parse(OracleDdlParser.java:49)
              at io.debezium.connector.oracle.OracleSchemaChangeEventEmitter.emitSchemaChangeEvent(OracleSchemaChangeEventEmitter.java:53)
              at io.debezium.pipeline.EventDispatcher.dispatchSchemaChangeEvent(EventDispatcher.java:174)
              at io.debezium.connector.oracle.LcrEventHandler.dispatchSchemaChangeEvent(LcrEventHandler.java:114)
              at io.debezium.connector.oracle.LcrEventHandler.processLCR(LcrEventHandler.java:78)
              at oracle.streams.XStreamOut.XStreamOutReceiveLCRCallbackNative(Native Method)
              at oracle.streams.XStreamOut.receiveLCRCallback(XStreamOut.java:465)
              at io.debezium.connector.oracle.OracleStreamingChangeEventSource.execute(OracleStreamingChangeEventSource.java:71)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:91)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
              at java.util.concurrent.FutureTask.run(FutureTask.java:266)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: org.antlr.v4.runtime.NoViableAltException
              at org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2023)
              at org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)
              at org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)
              at io.debezium.ddl.parser.oracle.generated.PlSqlParser.relational_properties(PlSqlParser.java:48057)
              ... 20 more
      

              ccranfor@redhat.com Chris Cranford
              pshussain Mohamed Pudukulathan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: