EIM JOBS FAIL WITH ORA-00911 INVALID CHARACTER, IF EIM SQL USES COLUMNS THAT START WITH A NUMBER (THE EIM TABLE MAPPING WIZARD CREATED NEW COLUMNS ON EIM_PRDINT_DTL THAT START WITH A NUMBER 1 OR 2) (Doc ID 2084882.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 15.5 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.6 [21233] version, EIM

We have run  the eim table mapping wizard on S_PROD_INT for the EIM table EIM_PRDINT_DTL table.
Although EIM_PRDINT_DTL already has a mapping into S_PROD_INT, we wanted to add more mappings. 

We applied the EIM table changes and compiled into Server siebel_sia.srf file.

Since then any EIM ifb file uses EIM_PRDINT_DTL now fails with an oracle error.  

ORA-00911 Invalid Character

This Oracle error happens if Oracle sql is trying to use a column that starts with a number. 

The EIM Table Mapping wizard created new EIM_PRDINT_DTL columns that start with a 1 or a 2. 


ERROR
-----------------------
customer experiencing error:
SBL error SBL-EIM-00107 - ODBC error 37000 - ORA-00911: invalid character.

EIMError EIMErrorSubEvent 0 00000006563825ec:0 2015-11-03 11:23:23 Error SBL-EIM-00107: ODBC error 37000:

EIMError EIMErrorSubEvent 0 00000006563825ec:0 2015-11-03 11:23:23 [tp][ODBC Oracle driver][Oracle]ORA-00911: invalid character

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
We run an eim job tha uses the EIM_PRDINT_DTL table.
We have run the EIM Table Mapping Wizard on the S_PROD_INT table and chose the EIM_PRDINT_DTL table.
The EIM Table Mapping Wizard completed.
We applied, activated the physical changes..
Compiled EIM_PRDINT_DTL table into Siebel_sia.srf.
Restarted the Siebel Server.
Since then any eim job that uses this table fails with this Oracle error..
ORA-00911: invalid character

My investigation points to the new columns on the EIM_PRDINT_DTL that start with a number 1 or number 2 as causing this error.

The Oracle error reproduces if we test doing a select on that column in sql*plus.
select 1_OPT_BI from EIM_PRDINT_DTL errors with the same ORA-00911 invalid character error.

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