My Oracle Support Banner

'[Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression' Signalled When Reverse Engineering Excel File Using ODI 12c (Doc ID 1637905.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 to 12.1.2.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

When reverse engineering a Microsoft Excel file over an ODI 12c Agent, the following message in observed in the log file :

ODI-1217: Session FirstExcel_DS_SESS (4613) fails with return code ODI-1298.
ODI-1226: Step FirstExcel_DS_STEP fails after 1 attempt(s).
ODI-1298: Serial task "null (50)" failed because child task "null (90)" is in error.
ODI-1298: Serial task "Försystem_Indikatorplansrapport_UNIT (60)" failed because child task "null (90)" is in error.
ODI-1227: Task LKM SQL to Oracle (Load data) fails on the source <Empty Value> connection Försystem Indikatorplansrapp UTV.
Caused By: java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'HUVUD.[Enhet]    ENHET'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6964)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7121)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3117)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:197)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:205)
at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:100)
at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:38)
at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:73)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:214)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:135)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:856)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2004)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:544)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:709)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:624)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:789)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:330)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$2700(StartSessRequestProcessor.java:80)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:957)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:177)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:110)
at java.lang.Thread.run(Thread.java:744)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.