LCwXgTVE

12019-02-19T17:01:08.020Z - debug: 5 contact(s) placed into Signal_Preprocess
22019-02-19T17:01:08.021Z - debug: || ==>  CM:DE:PC\TDInfResolution\CY22\OInodeSytelManager20192217182110791668243254532
3
42019-02-19T17:01:12.295Z - debug: Status broadcast: 33 present, 0 added, 0 removed campaigns since last SB
52019-02-19T17:01:12.295Z - debug: preprocess complete on Signal_Preprocess
62019-02-19T17:01:12.295Z - debug: db query:
7SELECT `Signal_Preprocess`.*, `BrandedOffers_Filter`.`Suppressed`, IFNULL(`BrandedOffers_Calls_Count_View`.`totalCalls`, 0) totalCalls FROM `Signal_Preprocess` LEFT JOIN `BrandedOffers_Filter` ON `BrandedOffers_Filter`.`Suppressed` = `Signal_Preprocess`.`uniqueField` LEFT JOIN `BrandedOffers_Calls_Count_View` ON `BrandedOffers_Calls_Count_View`.`id` = `Signal_Preprocess`.`uniqueField`
82019-02-19T17:01:12.362Z - info: start insert 1 contacts into 1Tac_OC_US
92019-02-19T17:01:12.363Z - info: 📇 [{"leadNameFirst":"Test","leadNameLast":"Lead","leadAddress":"123 Test Dr.","leadAddress2":"","leadCity":"Testville","leadZip":"91108","leadCountry":"US","leadPhone":"8185551239","leadPhone2":null,"leadEmail":"dialertest@infocu5.com","leadIPAddress":"","leadCompany":null,"leadGender":"","leadCCNumber":"","leadProductList":"","leadProspectID":null,"leadDateCreated":null,"leadregistrationID":null,"leadFunction":null,"leadTitle":null,"leadSICDescription":null,"leadRevenue":null,"leadLoadDate":null,"leadState":"CA","uniqueField":2147483647,"CampaignID":"9367","CampaignName":"1Tac_OC_US","Filler_3":null,"Filler_4":null,"Filler_5":null,"Filler_6":null,"Filler_7":null,"Filler_8":null,"Filler_9":null,"Filler_10":null,"tz_lower":0.666666,"tz_upper":1.16667,"user_defined":null,"Switch_Result":null,"Agent_Result":null,"Result_TS":null,"Retry_Count":null,"Retry_Username":null,"Retry_TS":null,"Retry_Index":null,"Retry_Number":null,"Complete_TS":null,"Suppressed":null,"totalCalls":0}]
102019-02-19T17:01:12.363Z - debug: db query:
11CREATE TABLE IF NOT EXISTS 1Tac_OC_US LIKE Signal_Template;
122019-02-19T17:01:12.430Z - verbose: table created 1Tac_OC_US
132019-02-19T17:01:12.431Z - debug: db query:
14DESCRIBE 1Tac_OC_US;
152019-02-19T17:01:12.502Z - debug: db query:
16INSERT IGNORE INTO `1Tac_OC_US` (leadNameFirst, leadNameLast, leadAddress, leadAddress2, leadCity, leadZip, leadCountry, leadPhone, leadPhone2, leadEmail, leadIPAddress, leadCompany, leadGender, leadCCNumber, leadProductList, leadProspectID, leadDateCreated, leadregistrationID, leadFunction, leadTitle, leadSICDescription, leadRevenue, leadLoadDate, leadState, uniqueField, CampaignID, CampaignName, Filler_3, Filler_4, Filler_5, Filler_6, Filler_7, Filler_8, Filler_9, Filler_10, tz_lower, tz_upper, user_defined, Switch_Result, Agent_Result, Result_TS, Retry_Count, Retry_Username, Retry_TS, Retry_Index, Retry_Number, Complete_TS) VALUES ?
172019-02-19T17:01:12.569Z - debug: 1 contact(s) placed into 1Tac_OC_US
182019-02-19T17:01:12.570Z - debug: db query:
19INSERT INTO `SignalAggregated` (leadNameFirst, leadNameLast, leadAddress, leadAddress2, leadCity, leadZip, leadCountry, leadPhone, leadPhone2, leadEmail, leadIPAddress, leadCompany, leadGender, leadCCNumber, leadProductList, leadProspectID, leadDateCreated, leadregistrationID, leadFunction, leadTitle, leadSICDescription, leadRevenue, leadLoadDate, leadState, uniqueField, CampaignID, CampaignName, Filler_3, Filler_4, Filler_5, Filler_6, Filler_7, Filler_8, Filler_9, Filler_10, tz_lower, tz_upper, user_defined, Switch_Result, Agent_Result, Result_TS, Retry_Count, Retry_Username, Retry_TS, Retry_Index, Retry_Number, Complete_TS, last_dialer_load_date) VALUES ? ON DUPLICATE KEY UPDATE last_dialer_load_date='2019-02-19T17:01:12.570Z'
202019-02-19T17:01:12.639Z - debug: 1 contact(s) placed into SignalAggregated
212019-02-19T17:01:12.639Z - debug: lock released on Signal_Preprocess