SBL-DBC-00111 Error When Releasing Product Class Structure Using SWI Product Class Import Business Service
(Doc ID 2998870.1)
Last updated on JANUARY 18, 2024
Applies to:
Siebel CRM - Version 21.7 to 21.11 [Release V17]Information in this document applies to any platform.
Symptoms
When releasing Product Class structure using 'SWI Procudt Class Import' business service, it fails with the following error:
The object manager log file shows that UPDATE statement tries to set LOCKED_BY twice as below:
UPDATE SIEBEL.S_VOD SET
DB_LAST_UPD_SRC = :1,
DB_LAST_UPD = current_date,
LAST_UPD = :2,
LAST_UPD_BY = :3,
MODIFICATION_NUM = :4,
LOCKED_BY = :5,
LOCKED_DT = :6,
LOCKED_FLG = :7,
LOCKED_BY = :8
WHERE
ROW_ID = :9 AND MODIFICATION_NUM = :10
...
SQLParseAndExecute Bind Vars 4 00002c8d65693fb9:0 2023-12-22 07:42:29 5: 503268568
...
SQLParseAndExecute Bind Vars 4 00002c8d65693fb9:0 2023-12-22 07:42:29 8: 503268568
...
This leads to the following 2 errors:
SBL-DBC-00111: An error has occurred writing to a record.
ORA-00957: duplicate column name
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 |
Cause |
Solution |