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 laterInformation 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 |