· 8 years ago · Jan 04, 2018, 08:12 PM
1Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {mktSmartList} cloneSmartList: created "temp - cmpgn run Run Action Change Score 2011-10-03 06:29:33 pm" (id 1432) from "Run Action Change Score 2011-10-03 06:29:33 pm" (id 1431)
2Oct 03 18:29:36 (1261456822825385985) <23955> [info] {mktCacheManager} registering 'PplDbAttributePeer::clearCache' as cleanup function for 'DB attribute' cache
3Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {smlistComp} attrib filters for smart list ID 1432: compiled 1 of 1
4Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {smlistComp} member filters for smart list ID 1432: compiled 1 of 1
5Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {smlistComp} checking rules for smart list ID 1432
6Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {smlistComp} rule ID 563 fully compiled
7Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {smlistComp} rule ID 564 fully compiled
8Oct 03 18:29:36 (1261456822825385985) <23955> [debug] {smlistComp} 2 rules compiled (2 expected), fullyCompiled = 1
9Oct 03 18:29:37 (1261456822825385985) <23955> [info] {mktCacheManager} registering 'mktLeadPartition::clearPtnMap' as cleanup function for 'Partition Map' cache
10Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} before SQL: CREATE TABLE IF NOT EXISTS staging_campaign_member (run_id INTEGER NOT NULL, row_id INTEGER NOT NULL, lead_id INTEGER, email VARCHAR(255), status VARCHAR(50), PRIMARY KEY(run_id,row_id), UNIQUE KEY(run_id,lead_id), KEY(run_id, email, lead_id)) Engine=Innodb
11Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} after SQL: CREATE TABLE IF NOT EXISTS staging_campaign_member (run_id INTEGER NOT NULL, row_id INTEGER NOT NULL, lead_id INTEGER, email VARCHAR(255), status VARCHAR(50), PRIMARY KEY(run_id,row_id), UNIQUE KEY(run_id,lead_id), KEY(run_id, email, lead_id)) Engine=Innodb
12Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} batch campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm]: ran query SELECT s.id, s.email FROM (SELECT /*!60000 '__smlist_ctx: id=1432 subtype=temp inc=1 comp=0 ctx=campaign' */ mkt_person.ID, mkt_person.EMAIL FROM (mkt_person, (select mem.lead_person_id id from list_member mem where mem.list_header_id = 1046) t1) LEFT JOIN mkt_org ON (mkt_person.ORG_ID=mkt_org.ID) LEFT JOIN mkt_lead_interest ON (mkt_person.PRIMARY_LEAD_INTEREST_ID=mkt_lead_interest.ID) WHERE (mkt_person.IS_ANONYMOUS IS NOT NULL AND mkt_person.ID = t1.id) AND mkt_lead_interest.LEAD_PARTITION_ID IN (1) AND mkt_person.TYPE IN ('contact','pending lead') AND mkt_person.IS_EMPLOYEE=0) s in 0 seconds returning 1 rows
13Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 1 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'INSERT IGNORE INTO staging_campaign_member (run_id, row_id, lead_id, email, status) val
14ues ( 35, 1, 11 , 'info@salesforce.com', 'atStart');'
15Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} batch campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm]: inserted final 1 rows to temp table - total 1 should match 1 - memory used=262144
16Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} before SQL: CREATE TABLE IF NOT EXISTS staging_campaign_good_dup (run_id INTEGER NOT NULL, lead_id INTEGER NOT NULL, email VARCHAR(255), INDEX m1_staging_campaign_good_d
17up (run_id, lead_id)) Engine=Innodb
18Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} after SQL: CREATE TABLE IF NOT EXISTS staging_campaign_good_dup (run_id INTEGER NOT NULL, lead_id INTEGER NOT NULL, email VARCHAR(255), INDEX m1_staging_campaign_good_du
19p (run_id, lead_id)) Engine=Innodb
20Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} before SQL: INSERT INTO staging_campaign_good_dup(run_id, lead_id, email) SELECT run_id, MIN(lead_id) lead_id, email FROM staging_campaign_member WHERE run_id=35 GROUP B
21Y email HAVING COUNT(*) > 1
22Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 0 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'INSERT INTO staging_campaign_good_dup(run_id, lead_id, email) SELECT run_id, MIN(lead_id) lead_id, email FROM staging_campaign_member WHERE run_id=35 GROUP BY email HAVING COUNT(*) > 1'
23Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} after SQL: INSERT INTO staging_campaign_good_dup(run_id, lead_id, email) SELECT run_id, MIN(lead_id) lead_id, email FROM staging_campaign_member WHERE run_id=35 GROUP BY
24 email HAVING COUNT(*) > 1
25Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} before SQL: CREATE TABLE IF NOT EXISTS staging_campaign_bad_dup (run_id INTEGER NOT NULL, row_id INTEGER NOT NULL, lead_id INTEGER, email VARCHAR(255), status VARCHAR(50
26), INDEX m1_staging_campaign_good_dup (run_id, row_id)) Engine=Innodb
27Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} after SQL: CREATE TABLE IF NOT EXISTS staging_campaign_bad_dup (run_id INTEGER NOT NULL, row_id INTEGER NOT NULL, lead_id INTEGER, email VARCHAR(255), status VARCHAR(50)
28, INDEX m1_staging_campaign_good_dup (run_id, row_id)) Engine=Innodb
29Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} before SQL: INSERT INTO staging_campaign_bad_dup(run_id, row_id, lead_id, email, status) SELECT t1.* from staging_campaign_member t1 join staging_campaign_good_dup t2 ON
30 (t1.run_id = t2.run_id and t1.email = t2.email and t1.lead_id != t2.lead_id) WHERE t1.run_id=35
31Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 0 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'INSERT INTO staging_campaign_bad_dup(run_id, row_id, lead_id, email, status) SELECT t1.
32* from staging_campaign_member t1 join staging_campaign_good_dup t2 ON (t1.run_id = t2.run_id and t1.email = t2.email and t1.lead_id != t2.lead_id) WHERE t1.run_id=35'
33Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} after SQL: INSERT INTO staging_campaign_bad_dup(run_id, row_id, lead_id, email, status) SELECT t1.* from staging_campaign_member t1 join staging_campaign_good_dup t2 ON
34(t1.run_id = t2.run_id and t1.email = t2.email and t1.lead_id != t2.lead_id) WHERE t1.run_id=35
35Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} before SQL: UPDATE staging_campaign_member t1 join staging_campaign_bad_dup t2 on (t1.run_id=t2.run_id and t1.row_id=t2.row_id and t1.run_id=35) set t1.status = 'noEmail
36'
37Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 0 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'UPDATE staging_campaign_member t1 join staging_campaign_bad_dup t2 on (t1.run_id=t2.run
38_id and t1.row_id=t2.row_id and t1.run_id=35) set t1.status = 'noEmail''
39Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveBatchCampaignMembership} after SQL [0 updated to 'noEmail']: UPDATE staging_campaign_member t1 join staging_campaign_bad_dup t2 on (t1.run_id=t2.run_id and t1.row_id=t2.row_id and t1.run_id=35)
40set t1.status = 'noEmail'
41Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::saveMembershipChunk} inserted 1 rows in membership for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm]
42Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 1 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'DELETE FROM staging_campaign_member where run_id = 35'
43Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 0 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'DELETE FROM staging_campaign_good_dup where run_id = 35'
44Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktSmartCampaign::executeRetriableSQL} processed 0 rows for campaign 1045 [Run Action Change Score 2011-10-03 06:29:33 pm] sql:'DELETE FROM staging_campaign_bad_dup where run_id = 35'
45Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {MktFlow::executeBatch}: starting batch flow -- Cmpgn: 1045 start at step 0
46Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktStep::executeBatch}:: campaign Run Action Change Score 2011-10-03 06:29:33 pm 1045 - starting step 70 with token
47Oct 03 18:29:37 (1261456822825385985) <23955> [info] {addRuleFromJsonObj} skipping empty operator for condition 'Step Status'
48Oct 03 18:29:37 (1261456822825385985) <23955> [info] {addRuleFromJsonObj} skipping empty operator for condition 'Split Code'
49Oct 03 18:29:37 (1261456822825385985) <23955> [debug] rule ID not found in old list, presumed to be new
50Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {MktStepChoice::executeBatch}: pre-exec MktFlowActionChangeScore on campaign 1045 run 35 step[0] 70 choice[0] 166
51Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {MktStepChoice::executeBatch}: pre-exec MktFlowActionChangeScore ia->chunkSeq=0 ia->lastChunk=false ia->runId=35 on campaign 1045 step[0] 70 choice[0] 166
52Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {smlistComp} member filters for smart list ID 1434: compiled 1 of 1
53Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {smlistComp} checking rules for smart list ID 1434
54Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {smlistComp} rule ID 565 fully compiled
55Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {smlistComp} 1 rules compiled (1 expected), fullyCompiled = 1
56Oct 03 18:29:37 (1261456822825385985) <23955> [info] {MktCachedObject::findParentSmartListByObject} looking for parent smart list for mktMaterializedSmartList of ID=1047
57Oct 03 18:29:37 (1261456822825385985) <23955> [info] {mktList::getMembers} found denormInfo:
58Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {doExplain} EXPLAIN EXTENDED SELECT mkt_person.ID, mkt_person.TYPE, mkt_person.IS_LEAD FROM mkt_person LEFT JOIN mkt_org ON (mkt_person.ORG_ID=mkt_org.ID) LEFT JOIN mkt_lead_interest ON (mkt_person.PRIMARY_LEAD_INTEREST_ID=mkt_lead_interest.ID) JOIN list_member ON (mkt_person.ID=list_member.LEAD_PERSON_ID AND list_member.LIST_HEADER_ID=1047) WHERE mkt_lead_interest.LEAD_PARTITION_ID IN (1) ORDER BY mkt_person.ID ASC LIMIT 100
59Oct 03 18:29:37 (1261456822825385985) <23955> [debug] {doExplain} Array
60(
61 [0] => Array
62 (
63 [id] => 1
64 [select_type] => SIMPLE
65 [table] => list_member
66 [type] => ref
67 [possible_keys] => list_member_u1,list_member_m1,list_member_m2,list_member_m3,list_member_m4,list_member_m5,list_member_m6,list_member_FI_2
68 [key] => list_member_u1
69 [key_len] => 4
70 [ref] => const
71 [rows] => 1
72 [extra] => 100.00
73 )
74
75 [1] => Array
76 (
77 [id] => 1
78 [select_type] => SIMPLE
79 [table] => mkt_person
80 [type] => eq_ref
81 [possible_keys] => PRIMARY,mkt_person_FI_2
82 [key] => PRIMARY
83 [key_len] => 4
84 [ref] => ST_MSI_2Betacust.list_member.lead_person_id
85 [rows] => 1
86 [extra] => 100.00
87 )
88
89 [2] => Array
90 (
91 [id] => 1
92 [select_type] => SIMPLE
93 [table] => mkt_lead_interest
94 [type] => eq_ref
95 [possible_keys] => PRIMARY,mkt_lead_interest_FI_9
96 [key] => PRIMARY
97 [key_len] => 4
98 [ref] => ST_MSI_2Betacust.mkt_person.primary_lead_interest_id
99 [rows] => 1
100 [extra] => 100.00
101 )
102
103 [3] => Array
104 (
105 [id] => 1
106 [select_type] => SIMPLE
107 [table] => mkt_org
108 [type] => eq_ref
109 [possible_keys] => PRIMARY
110 [key] => PRIMARY
111 [key_len] => 4
112 [ref] => ST_MSI_2Betacust.mkt_person.org_id
113 [rows] => 1
114 [extra] => 100.00
115 )
116
117)