com.jdedwards.jdbc.jdb.parser.ParseException

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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web2

  • via Oracle Community by Ujjwal Deshpande, 1 year ago
    Encountered "(" at line 1, column 23. Was expecting one of: <AS> ... <FROM> ... "." ... "," ...
  • Encountered "(" at line 1, column 23. Was expecting one of: <AS> ... <FROM> ... "." ... "," ...
  • Stack trace

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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.