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)
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 15.5 [IP2015] and later
Information in this document applies to any platform.
On : 184.108.40.206  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.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms