ODI 12c Executions Fail with Various Error Messages when the Column Names in the Source Datastore of a Mapping Start with a Numeric Value

Last updated on MARCH 13, 2018

Applies to:

Symptoms

When using a Datastore (on any technology) which has column names starting with a digit / numeric value (For example, Datastore TABLE_SRC, with columns 1COLUMN, 2COLUMN and COLUMN3) as a source in an Oracle Data Integrator (ODI) 12c Mapping, the execution of the Mapping fails, and the following alternative errors are reported on various Session Loading Knowledge Module (LKM) tasks:

• On Oracle technology + "Execute on Hint" = No Hint, the following error is received on the LKM "Insert new rows" task:
  

  ORA-00928: missing SELECT keyword

  The SQL code executed in this case:
  

  INSERT
  /*+ APPEND PARALLEL */
  INTO TEST_TRG.TABLE_TRG
  (
    1COLUMN ,
    2COLUMN ,
    COLUMN3
  )
  SELECT
    SRC_A.1COLUMN ,
    SRC_A.2COLUMN ,
    SRC_A.COLUMN3
  FROM
  TEST_TRG.C$_0SRC SRC_A

• On Oracle technology + "Execute on Hint" = Source, the following error is received on the LKM "Insert new rows" task:
  

  ORA-00923: FROM keyword not found where expected

  The SQL code executed in this case:
  

  SELECT
    SRC.COLUMN3 AS COLUMN3 ,
    SRC.1COLUMN AS ACOLUMN ,
    SRC.2COLUMN AS ACOLUMN_1
  FROM
  TEST_SRC.TABLE_SRC SRC

• On Microsoft Access + undetermined "Execute on Hint" value, the following error is received on the LKM "Insert new rows" task:
  

  Syntax error (missing operator) in query expression 'SRC.1COLUMN

  The SQL code executed in this case:

  SELECT
    SRC.COLUMN3 AS COLUMN3 ,
    SRC.1COLUMN AS ACOLUMN ,
    SRC.2COLUMN AS ACOLUMN_1
  FROM
  TEST_SRC.TABLE_SRC SRC

• Etc.

Changes

Cause