My Oracle Support Banner

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 DECEMBER 20, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.