Campaign Load In Progress State Due To Calendar REI BusComp not having SRC_ID
(Doc ID 2215678.1)
Last updated on JULY 07, 2020
Applies to:
Siebel Email Marketing Server - Version 16.4 [IP2016] and laterInformation in this document applies to any platform.
Symptoms
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:
ERROR
-----------------------
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".
STEPS
-----------------------
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.
...
WHERE
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 (
SELECT SQ1_T1.ACTIVITY_ID
FROM SLICCCO.S_ACT_EMP SQ1_T1
WHERE (SQ1_T1.EMP_ID = :4)))
ORDER BY
T3.TODO_PLAN_START_DT
Changes
Please do note that this does NOT occur in IP16.1 Patchset 1.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |