Siebel Marketing Trigger Issue In 8.1

(Doc ID 1267204.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1.1.2 SIA[21215] to 8.1.1.4 SIA [21225] [Release V8]
Information in this document applies to any platform.

Symptoms

When attempting to use new Siebel 8.1.1 Marketing Trigger functionality, there are problems when trying to run a trigger event on the same contact two times or more.
A unique key violation on table S_MKTEVTRG_HST is encountered as the sequence number does not increase above 2.


ERROR
-----------------------
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.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  In Marketing Application:


1) Go to Programs screen and Programs List view and create a new program with:
a. Name=Test

2) Go to Administration - Marketing > Triggers and create a new record with:
a. Name =Test

b. Trigger Category = Cross Sell (any category will do)

c. Associated Program -> open MVG applet and select the program created in step 1

d. Trigger status = Active

3) Go to Program screen > Program list view and drill down on the Test program created in step 1
a. Application will navigate to Program > Design > Program Flow

b. From the Objects Pane select Trigger object and move it to the flow area
c. A popup is displayed, you should select “Select a specific event trigger” option and hit > OK
d. From the PickTrigger pickapplet select the Trigger created in step 2

e. From the Object Pane select Campaign object and move it to flow area
f. In Pick Campaign pickapplet that is automatically displayed select New button

g. Specify Name of the campaign to Test and hit Save
h. Hit OK to select the new created campaign.

i. From the Object Pane select Connector object and make sure you connect the trigger to the campaign.


4) In Administration – Web Services > Inbound Web Service query for “Marketing Event Trigger Execution”. Select Generate WSDL and save it.

5) Make sure that EAI OM and WfProcMgr server components are enabled on the envt

II) Using SOAP UI, test the “Marketing Event Trigger Execution” web service

1) The following request has been tested:

<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:exec="<a href="http://www.siebel.com/Marketing/Evttrig/Exec">" name="contextTextUrl_1282048170618" onclick="try{if(document.designMode && document.designMode == 'on') return false;}catch(e){} window.open('http://www.siebel.com/Marketing/Evttrig/Exec">');" target="_blank" title="Click (or CTRL+Click if using Firefox) to view"><span id="3-XJUWVB1282048170618">http://www.siebel.com/Marketing/Evttrig/Exec"></span></a>
 <soapenv:Header>
 </soapenv:Header>
 <soapenv:Body>
    <exec:MarketingEventTriggerExecutionExecuteEvent_1_Input>
       <exec:Event_spcCode>1-258786</exec:Event_spcCode>
       <exec:RealTime_spcFlag>Y</exec:RealTime_spcFlag>
       <exec:Customer_spcId>0-3FTZ9</exec:Customer_spcId>
       <exec:Event_spcName>test</exec:Event_spcName>
    </exec:MarketingEventTriggerExecutionExecuteEvent_1_Input>
 </soapenv:Body>
</soapenv:Envelope>

---//---
Using the URL:  http://localhost/eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute&UserName=SADMIN&Password=SADMIN

2) Run the above request 3 times. The first 2 times it will insert new records in S_MKTEVTRG_HST  table (Event Trigger History BC): one with SEQ_NUM = 1 and the other with SEQ_NUM =2
But the 3rd insert will come also with SEQ_NUM = 2. This will generate the following error:
ObjMgrBusCompLog Error 1 000005b24c6817f4:0 2010-08-17 02:39:06 (sqlobj.cpp (43736)) 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.

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