"ORA-00933: SQL command not properly ended" Error Received when Upgrading ODI using the Upgrade Assistant

(Doc ID 2362954.1)

Last updated on FEBRUARY 27, 2018

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When upgrading Oracle Data Integrator (ODI) to version 12c, the Upgrade Assistant (UA) throws an "ORA-00933: SQL command not properly ended" error message. The log shows the following sequence of messages:

[2018-02-08T16:22:26.195+00:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting to upgrade components.
[2018-02-08T16:22:26.200+00:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Schema ODIM-ABCD will be upgraded from version 11.1.1.9.0 to 12.2.1.0.0
[2018-02-08T16:22:26.217+00:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Preparing concurrent plugin: ODI.ODI1
[2018-02-08T16:22:26.218+00:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting concurrent plugin: ODI.ODI1
[2018-02-08T16:22:26.292+00:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Running enabled plugin: ODI.ODI1
[2018-02-08T16:22:26.292+00:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Starting to upgrade ODI.ODI1.
[2018-02-08T16:22:26.309+00:00] [ODI] [NOTIFICATION] [upgrade.ODI.ODI1]  
--------- ODIPlugin.upgrade called
]]
[2018-02-08T16:22:26.309+00:00] [ODI] [NOTIFICATION] [upgrade.ODI.ODI1]  
--------- ODIPlugin.examine called
]]
[2018-02-08T16:22:26.332+00:00] [ODI] [NOTIFICATION] [upgrade.ODI.ODI1]  
--------- ODIPlugin.examine finished

]]
[2018-02-08T16:22:26.482+00:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]  ORA-00933: SQL command not properly ended

]]
[2018-02-08T16:22:26.482+00:00] [ODI] [INCIDENT_ERROR] [upgrade.ODI.ODI1]  java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
   at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
   at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
   ...
]]

Changes

 Upgrade from ODI 11g to 12c.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms