SBL-DAT-00381 And SBL-DAT-00382 During EndConfigurationOrder. (Doc ID 2253757.1)

Last updated on APRIL 10, 2017

Applies to:

Siebel CRM - Version 8.1.1.11.16 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.16 [IP2013] version, Order Management

SBL-DAT-00381 and SBL-DAT-00382 during EndConfigurationOrder web service calls in a high volume environment.

ERROR
-----------------------
SQLParseAndExecute Execute 5 0000160358c635bd:0 2017-03-14 12:00:34 ORA-00001: unique constraint (SIEBEL.S_ORDER_ITEM_U1) violated
ORA-06512: at line 6
ObjMgrBusCompLog Error 1 0000160358c635bd:0 2017-03-14 12:00:34 (oracon.cpp (896)) SBL-DAT-00381: A record that contains identical values to the record you have created already exists.
If you would like to enter a new record, please ensure that the field values are unique.
ObjMgrBusCompLog Error 1 0000160358c635bd:0 2017-03-14 12:00:34 (oracon.cpp (2301)) SBL-DAT-00382: The same values for 'Line Number, Line Number 2' already exist.

If you would like to enter a new record, please ensure that the field values are unique.

ObjMgrSqlObjLog WriteRecord 5 0000160358c635bd:0 2017-03-14 12:00:34 End: WriteRecord for SqlObj at 7dbefdd8
ObjMgrLog Error 1 0000160358c635bd:0 2017-03-14 12:00:34 (adptutils.cpp (7082)) SBL-EAI-04381: For instance of Integration Component 'Line Item', using user key '[Integration Id] = "1-3W5EC5"', a record with identical values already exists in the Siebel database.


STEPS
-----------------------
To reproduce, call eConfigurator through web service calls in a high volume environment. The issue usually occurs at web service step EndConfigurationOrder which syncs back to the database.

BUSINESS IMPACT
-----------------------
This causes certain Orders to fail

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms