ODI 12.1.3 Mapping generates Inline view name _13 causes ORA-00911: invalid character error

ODI 12.1.3 Mapping generates Inline view name _13 causes ORA-00911: invalid character error

INLINE_VIEW_N is being generated incorrectly which is causing ORA-00911: invalid character errrors.

Ex:

Pattern like:

INLINE_VIEW_11
INL_12
_13

The _13 causes the error below

ODI-1228: Task Load xxx Oracle Insert- fails on the target
connection xx_xxxxxxxxxxxx.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

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)


This issue fixed in ODI 12.2.1. For ODI 12.1.3, download and apply Patch 20206720


Related Posts:

ODI 12.1.3 - Applying Patch 20206720: 12.1.3 Generates Inline view name _13 which causes ORA-00911: invalid character

ODI 12.1.3 - Installing a collocated agent from the ODI Enterprise Installation

ODI 12.1.3 - Applying Patch 20206720: 12.1.3 Generates Inline view name _13 which causes ORA-00911: invalid character

ODI 12.1.3 - Applying Patch 20206720: 12.1.3 Generates Inline view name _13 which causes ORA-00911: invalid character

Download p20206720_121300_Generic.zip

Patch Pre-requisites

- Download the latest version of OPatch 13.2.x via My Oracle Support Patch 6880880. (Choose 13.2.0.0.0 or "OUI NextGen 13.2") p6880880_132000_Generic.zip

- Ensure access to valid OUI Inventory by running $ opatch lsinventory -jre $ORACLE_HOME/jdk/jre 

- Validate the executables in system PATH after setting $ORACLE_HOME by running 'which opatch', 'which unzip'

- Download the patch to staging directory eg PATCH_TOP with appropriate permissions

Applying the patch

- Set ORACLE_HOME to directory where ODI is installed eg: MW_HOME/Oracle_ODI

- Stop ODI Studio, Standalone Agent, Admin and all Managed servers

- $ unzip -d PATCH_TOP p20206720_121300_Generic.zip

- $ cd PATCH_TOP/20206720

- $ opatch apply (Cold backup recommended)

- While applying the patch, if any conflicts with existing patches detected or a merge patch for conflicting and new patch is required, stop the patch and contact Support.

- Verify if patch successfully applied

$ opatch lsinventory | grep 20206720

- If any issues after applying the patch and you would like to roll back the patch, kindly run

$ opatch rollback -id 20206720

- Restart ODI Studio, Standalone Agent, Admin and all Managed Servers

Related Posts:

ODI 12.1.3 Mapping generates Inline view name _13 causes ORA-00911: invalid character error

ODI 12.1.3 - Installing a collocated agent from the ODI Enterprise Installation

Error starting the Oracle Data Integrator 11g Studio at ODI_HOME/oracledi/client/odi.sh

Error starting the Oracle Data Integrator 11g Studio at ODI_HOME/oracledi/client/odi.sh


When trying to start the Oracle Data Integrator Studio to create the agent definition for Oracle Data Integrator Agent, you may hit errors as below and ODI studio fails to load.

When you do echo $JAVA_HOME, it may be set correctly but the issue still persists.

Verify if odi.conf under $ODI_HOME/oracledi/client/odi/bin has Set JAVA Home parameter defined correctly. 

You end up seeing errors as below and ODI Studio fails to load if Java home parameter is set incorrectly.

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.ide.boot.PCLMain.callMain(PCLMain.java:63)
        at oracle.ide.boot.PCLMain.main(PCLMain.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.classloader.util.MainClass.invoke(MainClass.java:128)
        at oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain(IdeLauncher.java:190)
        at oracle.ide.boot.IdeLauncher.launchImpl(IdeLauncher.java:90)
        at oracle.ide.boot.IdeLauncher.launch(IdeLauncher.java:65)
        at oracle.ide.boot.IdeLauncher.main(IdeLauncher.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at oracle.ide.boot.Launcher.invokeMain(Launcher.java:714)
        at oracle.ide.boot.Launcher.launchImpl(Launcher.java:117)
        at oracle.ide.boot.Launcher.launch(Launcher.java:69)
        at oracle.ide.boot.Launcher.main(Launcher.java:59)