Siebel 18.x Upgrade failed with Error "SQLSTATE=57016"
(Doc ID 2445480.1)
Last updated on OCTOBER 19, 2021
Applies to:
Siebel CRM - Version 18.8 and laterInformation in this document applies to any platform.
Symptoms
Siebel upgrade started on 18.8 where it upgrep failed at Item 23 which is seed import step with below error
ERROR
-----------------------
SQLSTATE=2350
seedupg0.log
Importing table 199: S_ETL_TIME_DAY ... imported 1440 rows 0.875s
2018-09-04 18:00:12 SQL Warning, SQL State 57016, -668, [IBM][CLI Driver][DB2/NT64] SQL0668N Operation not allowed for reason code "7" on table "SIEBELDBA.S_EVT_ACT". SQLSTATE=57016
2018-09-04 18:00:12 SQL Statement:
DELETE FROM SIEBELDBA.S_EVT_ACT where ROW_ID like '0%' AND ROW_ID NOT LIKE '0L%' AND LAST_UPD=TIMESTAMP('1980-01-01-00.00.00')
2018-09-04 18:00:12 [IBM][CLI Driver][DB2/NT64] SQL0668N Operation not allowed for reason code "7" on table "SIEBELDBA.S_EVT_ACT". SQLSTATE=57016
2018-09-04 18:00:12
2018-09-04 18:00:12 57016: [IBM][CLI Driver][DB2/NT64] SQL0668N Operation not allowed for reason code "7" on table "SIEBELDBA.S_EVT_ACT". SQLSTATE=57016
2018-09-04 18:00:12
2018-09-04 18:00:12 Error in importFileCb (UTLOdbcExecDirect delete).
2018-09-04 18:00:12 Error calling table pre callback table: S_EVT_ACT, tblIdx: 200.
2018-09-04 18:00:12 DATAIMP-ERR-1124: Unable to import table "S_EVT_ACT" (process table pre callback).
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 |