My Oracle Support Banner

ODI Generate SQL Include Keyword "SET" As Query Alias - "ORA-01747: invalid user.table.column, table.column or column specification" (Doc ID 2451811.1)

Last updated on JUNE 07, 2019

Applies to:

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

Symptoms

When attempting to run an Oracle Data Integrator (ODI) 12c Mapping that contains SET components, the following error occurs:

ODI-1217: session <SESSION_ID> failed with return code ODI - 1298.
...
Caused By: java.sql.SQLSyntaxErrorException: ORA - 01747: invalid user.table.column, table.column or column specification at oracle.jdbc.driver.T4CTTIoer11.processError (T4CTTIoer11.java: 495)
  at oracle.jdbc.driver.T4CTTIoer11.processError (T4CTTIoer11.java: 447)
  at ...
  at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute (SQLCommand.java: 205)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute (SQLExecutor.java: 142)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute (SQLExecutor.java: 28)
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask (TaskExecutionHandler.java: 52)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask (SessionTask.java: 206)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask (SessionTask.java: 117)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute (AbstractSessionTask.java: 886)
  at oracle.odi.runtime.agent.execution.SessionExecutor $ SerialTrain.runTasks (SessionExecutor.java: 2225)
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession (SessionExecutor.java: 610)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor $ 1.doAction (TaskExecutorAgentRequestProcessor.java: 718)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor $ 1.doAction (TaskExecutorAgentRequestProcessor.java: 611)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute (DwgObjectTemplate.java: 203)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask (TaskExecutorAgentRequestProcessor.java: 800)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access $ 1400 (StartSessRequestProcessor.java: 74)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor $ StartSessTask.doExecute (StartSessRequestProcessor.java: 702)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute (AgentTask.java: 180)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor $ 2.run (DefaultAgentTaskExecutor.java: 108)
  at java.util.concurrent.Executors $ RunnableAdapter.call (Executors.java: 511)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call (OdiJob.java: 73)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call (OdiJob.java: 73)
  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: Error: 1747, Position: 15377, Sql = ------------------------------------------------------------
Error Msg = ORA - 01747: invalid user.table.column, table.column or column specification
  at oracle.jdbc.driver.T4CTTIoer11.processError (T4CTTIoer11.java: 499)
... 36 more

 

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.