Initial loading of a segment tree for multiple segments fails at the first time with Errors such as "The same values for 'Person UId' already exist" or "Some records failed to load properly due to bad data" (Doc ID 810894.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing Server - Version 8.0 [20405] to 8.0.0.8 SIA[20430] [Release V8]
Siebel Marketing Server - Version 8.1.1 SIA [21111] to 8.1.1.3 SIA[21219] [Release V8]
Information in this document applies to any platform.
***Checked for relevance on 03-Out-2013***

Symptoms

With a campaign that is configured to load:

(1) a segment tree with the same nodes allocated to multiple treatments

OR

(2) the same segment allocated to multiple treatments

The initial load fails to load all of the data and the following kinds of errors are observed:

ObjMgrLog Error 1 0000000c49673f8a:0 2009-01-09 12:29:10 (adptutils.cpp (5614)) SBL-EAI-04451: Method 'WriteRecord' of business component 'Marketing Contact' (integration component 'Contact') for record with search specification '[Person UId] = "1046960007853723"' returned the following error:"The same values for 'Person UId' already exist.

OR

MktgGenericEvent Error 1 000001fb535c1320:0 2014-05-01 15:46:54 Some records failed to load properly due to bad data. The records that did not load properly are identified in log file '\\<Siebel File System>\Marketing\EAI\<Row ID>_Marketing Person.XML'. Please check the log file to see which records failed. You can either enter them manually into the Siebel UI, or correct them and load them in a new EAI job.

Subsequent loads of the same campaign complete successfully and all of the data is loaded in S_CAMP_CON. Issue only occurs on the first 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