My Oracle Support Banner

Siebel Production Upgrade Failing at ddlctl_tab step with Error "ORA-04088: error during execution of trigger" (Doc ID 2830261.1)

Last updated on JANUARY 19, 2024

Applies to:

Siebel CRM - Version 21.5 and later
Information in this document applies to any platform.

Symptoms



Upgrade is failing while running Siebel Production Upgrade at ddlctl_tab step in UPGREP process. Below error messages can be found from ddlctl_tab.log file

 

2021-12-13 14:48:41 [tp][ODBC Oracle driver][Oracle]ORA-04088: error during execution of trigger 'SYS.SYS_VIT004'
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 14


writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
writeExecDDL error (pOperCallback UTLDbDdlOperTblCreate).
Error in MainFunction (UTLDbDdlDbMerge).
Error in Main function...
(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. Performing Siebel Production Upgrade from Siebel CRM 16.19 to Siebel CRM 21.5
2. Run Siebel Database configuration wizard from start programs
3. Select Production Mode upgrade and execute UPGREP process
4. UPGREP is failing at ddlctl_tab step 


Changes

 Upgrading from 16.19 to 21.5 version

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


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