Campaign Load with 'Allow Repeated Contacts' Fails with Errors SBL-DAT-00381 or SBL-DAT-00382 or SBL-DBC-00111 or ORA-00001 (Doc ID 2049808.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1.1 [21112] to 8.1.1.10 [23021] [Release V8]
Information in this document applies to any platform.

Symptoms

When attempting to run a Campaign Load using the option 'Add to Existing Wave' and 'Allow Repeated Contacts' = TRUE the expectation is that the same Contact can participate more than once in the same Load and Wave Number, however, the following error occurs:

ERROR
-----------------------
ObjMgrBusCompLog Error 1 00000b1c557c34d4:0 2015-06-16 17:53:45 (oracon.cpp (373)) 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 00000b1c557c34d4:0 2015-06-16 17:53:45 (oracon.cpp (1746)) SBL-DAT-00382: The same values for 'Token Number, Load Number' already exist.
If you would like to enter a new record, please ensure that the field values are unique.
ObjMgrLog Error 1 00000b1c557c34d4:0 2015-06-16 17:53:45 (adptutils.cpp (6046)) SBL-EAI-04381: For instance of Integration Component 'Campaign Contact', using user key '[Campaign Id] = "11-12MOKLO" AND [Contact Id] = "1-2Q9P-3194" AND [Prospect Id] IS NULL AND [Token Number] = "211" AND [Load Number] = "1" AND [Treatment Id] = "11-10471U3" AND [Scalability Batch Number] = "112387"', a record with identical values already exists in the Siebel database
ObjMgrLog Error 1 00000b1c557c34d4:0 2015-06-16 17:53:45 (adptutils.cpp (6046)) SBL-EAI-04381: For instance of Integration Component 'Campaign Contact', using user key '[Campaign Id] = "11-12MOKLO" AND [Contact Id] = "1-2Q9P-3194" AND [Prospect Id] IS NULL AND [Token Number] = "311" AND [Load Number] = "1" AND [Treatment Id] = "11-10471U3" AND [Scalability Batch Number] = "112387"', a record with identical values already exists in the Siebel database.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Campaign, Offer, Treatment and Segment Tree
2. Allocate the Segment Tree to the Email Treatment
3. Run a Campaign Load

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