My Oracle Support Banner

While Applying Patch 30399999 / Patch 31856789 Error 'Table EGO_BULKLOAD_INTF Is Missing The Column C_INTF_ATTR9#1' / 'ORA-01792: maximum number of columns in a table or view is 1000' (Doc ID 2761449.1)

Last updated on MAY 04, 2022

Applies to:

Oracle Product Hub - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

When upgrading to release 12.2.10, File egot047.odf  failed while applying <patch 30399999>.  This was also seen in case of upgrading to 12.2.11 by applying <patch 31856789>.

Error  
-----
adworker logs show below errors:

FAILED: file egot047.odf  on worker  8 for product ego username EGO.

Time is: Thu Jan 06 2022 23:58:04

Worker log shows
ALTER TABLE EGO.EGO_BULKLOAD_INTF ADD ( C_INTF_ATTR1#1 VARCHAR2(4000)  )

AD Worker error:
The following ORACLE error:

ORA-01792: maximum number of columns in a table or view is 1000

Following steps can cause issue:
 
1. Apply patch (Ex: 12.2.10 patch 30399999, 12.2.11 patch 31856789 ) having file egot047.odf version higher than 120.4.12020000.4.
2. Abort patch without completing patching cycle.
3. Perform full cleanup
4. Perform fs clone
5. Re apply patch again (Ex: 12.2.10 patch 30399999) having file egot047.odf version higher than 120.4.12020000.4.
6. See error "ORA-01792: maximum number of columns in a table or view is 1000"  in the adworker logs.
7. Skip and continue patch
8. See another error shown is "ORA-20001: Could not apply invalid crossedition trigger. "APPS"."EGO_BULKLOAD_INTF_F1": PLS-00049: bad bind variable"  
 

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.