Campaign Load In Progress State Due To Calendar REI BusComp not having SRC_ID
Last updated on APRIL 10, 2017
Applies to:Siebel Email Marketing Server - Version 16.4 [IP2016] and later
Information in this document applies to any platform.
On : 16.0 [IP2016] version, Siebel Marketing
When trying to run a Campaign Load in IP16, Campaign Load remains In Progress state due to Calendar REI BusComp.
Then, the following error occurs:
ObjMgrSqlCursorLog Trace 5 0000000257b7362c:0 2016-08-19 09:09:39 SQL Cursor with ID 1AF292B8 Buscomp: Calendar REI, Forward Only: 0, Fetch Rows: 10000, Fetch All Time: 2.038 seconds.
ObjMgrSqlCursorLog Close 5 0000000257b7362c:0 2016-08-19 09:09:39 End: Close Sql Cursor at 1af292b8
ObjMgrBusCompLog Error 1 0000000257b7362c:0 2016-08-19 09:09:39 There were more rows than could be returned. Please refine your query to bring back fewer rows".
The issue can be reproduced at will with the following steps:
1. Configure a Campaign in IP16
2. Schedule the Campaign
3. Load it
In the log you will see that the query generated does not have SRC_ID in the WHERE clause causing all records within a certain date to be selected from S_EVT_ACT and not only the ones related to the executed Campaign.
T5.PARENT_ACTIVITY_ID = T2.PAR_REPTEVT_MST_ID (+) AND
T5.PAR_REPTEVT_MST_ID = T3.ROW_ID (+) AND
T3.OPTY_ID = T4.ROW_ID (+) AND
T3.OPTY_ID = T1.ROW_ID (+) AND
((T3.TEMPLATE_FLG != 'Y' AND T3.TEMPLATE_FLG != 'P' OR T3.TEMPLATE_FLG IS NULL) AND (T3.OPTY_ID IS NULL OR T4.SECURE_FLG = 'N' OR T1.OPTY_ID IS NOT NULL)) AND
(T5.REI_TS < TO_DATE(:2,'MM/DD/YYYY HH24:MI:SS') AND T5.REI_END_TS >= TO_DATE(:3,'MM/DD/YYYY HH24:MI:SS') AND T5.PAR_REPTEVT_MST_ID IN (
FROM SLICCCO.S_ACT_EMP SQ1_T1
WHERE (SQ1_T1.EMP_ID = :4)))
Please do note that this does NOT occur in IP16.1 Patchset 1.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms