com.jdedwards.jdbc.jdb.parser.ParseException: Encountered "(" at line 1, column 23. Was expecting one of: <AS> ... <FROM> ... "." ... "," ...

Oracle Community | Pratik02 | 2 years ago
  1. 0

    ERROR while Reverse Engineering using RKM JDE Enterprise One Oracle

    Oracle Community | 2 years ago | Pratik02
    com.jdedwards.jdbc.jdb.parser.ParseException: Encountered "(" at line 1, column 23. Was expecting one of: <AS> ... <FROM> ... "." ... "," ...
  2. 0

    ERROR while Reverse Engg using RKM JDE Enterprise One Oracle

    Oracle Community | 2 years ago | Ujjwal Deshpande
    com.jdedwards.jdbc.jdb.parser.ParseException: Encountered "(" at line 1, column 23. Was expecting one of: <AS> ... <FROM> ... "." ... "," ...

    Root Cause Analysis

    1. com.jdedwards.jdbc.jdb.parser.ParseException

      Encountered "(" at line 1, column 23. Was expecting one of: <AS> ... <FROM> ... "." ... "," ...

      at com.jdedwards.jdbc.jdb.parser.GeneratedSQLParser.generateParseException()
    2. com.jdedwards.jdbc
      JDBConnection.prepareStatement
      1. com.jdedwards.jdbc.jdb.parser.GeneratedSQLParser.generateParseException(Unknown Source)
      2. com.jdedwards.jdbc.jdb.parser.GeneratedSQLParser.jj_consume_token(Unknown Source)
      3. com.jdedwards.jdbc.jdb.parser.GeneratedSQLParser.selectStatement(Unknown Source)
      4. com.jdedwards.jdbc.jdb.parser.GeneratedSQLParser.overallStatement(Unknown Source)
      5. com.jdedwards.jdbc.jdb.operation.JDBOperationFactory.prepare(Unknown Source)
      6. com.jdedwards.jdbc.jdb.adapter.JDBConnection.prepareStatement(Unknown Source)
      7. com.jdedwards.jdbc.jdb.adapter.JDBConnection.prepareStatement(Unknown Source)
      7 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    4. oracle.odi.core
      OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke
      1. oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:200)
      1 frame
    5. Unknown
      $Proxy35.prepareStatement
      1. $Proxy35.prepareStatement(Unknown Source)
      1 frame
    6. oracle.odi.runtime
      DataMovementTaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:83)
      2. oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:117)
      3. oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:111)
      4. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:81)
      5. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
      6. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
      6 frames
    7. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      5 frames
    8. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
      1 frame
    9. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    10. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      5 frames
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame