Unable To Apply Activate EIM_ACCOUNT After Running EIM Mapping Wizard For S_ORG_EXT
(Doc ID 2073266.1)
Last updated on NOVEMBER 22, 2019
Applies to:
Siebel CRM - Version 15.0 [IP2015] and laterInformation in this document applies to any platform.
Symptoms
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.
A. UTLDbDdlDbMerge
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'
Output= 1-1-NIQY
select count (*) from siebel.S_COLUMN where TBL_ID = '1-1-NIQY' and repository_id = '1-1-1'
Output= 1124
ERROR
-----------------------
S1000 (1792): [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
STEPS
-----------------------
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
Changes
The customer has added more that 1000 active mappings to EIM_ACCOUNT.
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 |
Changes |
Cause |
Solution |
References |