My Oracle Support Banner

Siebel 18.x Upgrade failed with Error "SQLSTATE=57016" (Doc ID 2445480.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Siebel CRM - Version 18.8 and later
Information 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


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