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

Oracle Community | Ujjwal Deshpande | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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