Last updated on AUGUST 08, 2017
Applies to:Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.
On : 15.0 [IP2015] version, EIM
Unable to Apply activate EIM_ACCOUNT after running EIM Mapping wizard for S_ORG_EXT with more that 1000 mappings
The following steps have been performed:
1. Ran EIM Mapping wizard on S_ORG_EXT for EIM_ACCOUNT.
2. At the time of apply/ activate EIM_ACCOUNT it is giving below error.
B. pOperCallback UTLDbDdlOperMultiColAdd
C. SQL Error Adding multiple column in one batch ... 608
D. S1000 (1792): [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
Bellow is the select statement for EIM_ACCOUNT:
select * from siebel.S_TABLE where NAME = 'EIM_ACCOUNT'
select count (*) from siebel.S_COLUMN where TBL_ID = '1-1-NIQY' and repository_id = '1-1-1'
S1000 (1792): [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
The issue can be reproduced at will with the following steps:
1. Add more that 1000 mapped columns to an EIM table
2. Apply DDL
The customer has added more that 1000 active mappings to EIM_ACCOUNT.
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