"[ODBC Oracle Driver][Oracle]ORA-01792: Maximum Number Of Columns In A Table Or View Is 1000" Error When Executing Upgrep Step During Siebel Database Upgrade
(Doc ID 2765181.1)
Last updated on APRIL 01, 2021
Applies to:Siebel Financial Services CRM - Version 18.104.22.168 [IP2013] and later
Information in this document applies to any platform.
When attempting to run an upgrade, the upgrade repository (upgrep) step fails during importing repository and follow error occurs in ddlctl_tab.log:
2021-01-28 12:09:01 [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
2021-01-28 12:09:01 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
2021-01-28 12:09:01 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2021-01-28 12:09:01 writeExecDDL error (pOperCallback UTLDbDdlOperMultiColAdd).
2021-01-28 12:09:01 Error in MainFunction (UTLDbDdlDbMerge).
2021-01-28 12:09:01 Error in Main function...
2021-01-28 12:09:01 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)
The issue can be reproduced at will with the following steps:
1. Perform upgrade from 22.214.171.124 to any latest version of Siebel
2. Check to see if upgrep completes
3. Check the logs to see what errors are seen
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