My Oracle Support Banner

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:

Error invoking service 'SWI Product Class Import', method 'Upsert' at step 'Release Service Offering'.(SBL-BPR-00162)\n--\nMethod 'WriteRecord' of business component 'SWI ISS Class Definition BusComp' (integration component 'SWI ISS Class Definition BusComp') for record with search specification '[VOD Id] = \"1-2ZYJP4GB\"' returned the following error:\"An error has occurred writing to a record.\n\nPlease continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)\"(SBL-EAI-04451)"

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


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