· 8 years ago · Jul 31, 2018, 05:50 PM
1402|smrt-s | 2018-07-31T17:36:32.558Z - debug: lock acquired on Internet_Preprocess
2402|smrt-s | 2018-07-31T17:36:32.563Z - debug: db query:
3402|smrt-s | TRUNCATE `Internet_Preprocess`
4402|smrt-s | 2018-07-31T17:36:32.634Z - verbose: truncated Internet_Preprocess
5402|smrt-s | 2018-07-31T17:36:32.635Z - debug: db query:
6402|smrt-s | DESCRIBE Internet_Preprocess;
7402|smrt-s | 2018-07-31T17:36:32.706Z - debug: db query:
8402|smrt-s | INSERT IGNORE INTO `Internet_Preprocess` (ID, ExtractDateTime, lNameImportQueueId, szHomePhone, szOtherPhone, szWorkPhone, szFirstName, szLastName, szCampaignId, szCampaign, szAccountNo, szAccountName, szMakeMdlYear, user_defined, tz_lower, tz_upper, Switch_Result, Agent_Result, Result_TS, Retry_Count, Retry_Username, Retry_TS, Retry_Index, Retry_Number, Complete_TS, dtAdded, leadIndex, MaxAttempt, Tenant, CampaignGroup, CampaignName, cmName, CLI, Multilingual, originalMasterCampaign, currentMasterCampaign) VALUES ?
9402|smrt-s | 2018-07-31T17:36:33.516Z - debug: 300 contact(s) placed into Internet_Preprocess
10402|smrt-s | 2018-07-31T17:36:33.516Z - debug: || ==> CM:DE:PC\TDApollo\CY11\OInodeSytelManager2018721736335162518830513070395
11402|smrt-s | 2018-07-31T17:36:33.841Z - debug: Status broadcast: 13 present, 0 added, 0 removed campaigns since last SB
12402|smrt-s | 2018-07-31T17:36:43.981Z - debug: Status broadcast: 13 present, 0 added, 0 removed campaigns since last SB
13402|smrt-s | 2018-07-31T17:36:54.117Z - debug: Status broadcast: 13 present, 0 added, 0 removed campaigns since last SB
14402|smrt-s | 2018-07-31T17:37:04.260Z - debug: Status broadcast: 13 present, 0 added, 0 removed campaigns since last SB
15402|smrt-s | 2018-07-31T17:37:14.400Z - debug: Status broadcast: 13 present, 0 added, 0 removed campaigns since last SB
16402|smrt-s | 2018-07-31T17:37:14.400Z - debug: preprocess complete on Internet_Preprocess
17402|smrt-s | 2018-07-31T17:37:14.401Z - debug: db query:
18402|smrt-s | UPDATE Internet_Preprocess AS a JOIN Internet_Aggregated AS ag on a.lNameImportQueueId = ag.lNameImportQueueId SET a.Multilingual = ag.Multilingual
19402|smrt-s | 2018-07-31T17:37:14.471Z - debug: multilingual import ready on Internet_Preprocess
20402|smrt-s | 2018-07-31T17:37:14.472Z - debug: db query:
21402|smrt-s | SELECT `Internet_Preprocess`.*, `Internet_Filter`.`Suppressed`, IFNULL(`Internet_Calls_Count_View`.`totalCalls`, 0) totalCalls FROM `Internet_Preprocess` LEFT JOIN `Internet_Filter` ON `Internet_Filter`.`Suppressed` = `Internet_Preprocess`.`lNameImportQueueId` LEFT JOIN `Internet_Calls_Count_View` ON `Internet_Calls_Count_View`.`id` = `Internet_Preprocess`.`lNameImportQueueId`
22402|smrt-s | 2018-07-31T17:37:14.949Z - info: start insert 300 contacts into Internet_GP2
23402|smrt-s | 2018-07-31T17:37:14.949Z - debug: db query:
24402|smrt-s | CREATE TABLE IF NOT EXISTS Internet_GP2 LIKE Internet_Template;
25402|smrt-s | 2018-07-31T17:37:15.022Z - verbose: table created Internet_GP2
26402|smrt-s | 2018-07-31T17:37:15.022Z - debug: || ==> CM:DE:GP\TDApollo\CY10\OInodeSytelManager20187217371522251887218956644\TKApollo=10_STG_SSSnodeSytelManager2518872.18980856
27402|smrt-s | 2018-07-31T17:37:15.049Z - debug: got properties for Internet_Template
28402|smrt-s | 2018-07-31T17:37:15.053Z - debug: || ==> CM:DE:AC\TDApollo\CNInternet_GP2\OInodeSytelManager20187217371553251887249981234\DT<CampaignParams DSN="ELeadRC" SchemaName="" DBUser="BetterWRX" DBPassword="b3tt3r!" DBVerified="false"> <CampaignName>Internet_GP2</CampaignName> <TelColumn>szHomePhone</TelColumn> <KeyColumn>lNameImportQueueId</KeyColumn> <AbandonRate>5.00000000</AbandonRate> <AbandonDelay>1</AbandonDelay> <MaxWrapTime>3600</MaxWrapTime> <WrapOutcome/> <WrapData/> <RingTimeout>16</RingTimeout> <EstimateTalk>2</EstimateTalk> <CacheSize>50</CacheSize> <AutoSize>true</AutoSize> <TableName>Internet_GP2</TableName> <CLICol/> <AMCol/> <LastDialed/> <ResultPrimaryTable>Internet_GP2</ResultPrimaryTable> <ResultTimestampCol>Result_TS</ResultTimestampCol> <RetryCountCol>Retry_Count</RetryCountCol> <RetryTimestampCol>Retry_TS</RetryTimestampCol> <RetryUserName>Retry_Username</RetryUserName> <ResultColumn>Switch_Result</ResultColumn> <KeyNumeric>false</KeyNumeric> <RetryMode>2</RetryMode> <EnableCallbacks>true</EnableCallbacks> <DatabaseMode>2</DatabaseMode> <CampaignType>0</CampaignType> <AgentResultCol>Agent_Result</AgentResultCol> <CTLayerID/> <LCRCode/> <RetryParams MaxRetries="3" MaxRetriesNotPresent="3" MaxRetriesAccelerated="1" MaxTimeOfDay="0.95833333" MinTimeOfDay="0.37500000" MultipleNumberStrategy="3" MultiRetryThreshold="0" LimitAcrossAllNumbers="true" MaxOverdue="0.00347222" OverdueOffset="0.16666667"> <Retry Outcome="0"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="1"> <RetryDetail Offset="0.04166667" MaxAttempts="3" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="2"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="true" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="3"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="true" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="20"> <RetryDetail Offset="0.16666667" MaxAttempts="3" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="4"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="true" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="21"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="310"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="5"> <RetryDetail Offset="0.16666667" MaxAttempts="3" NotPresent="true" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="22"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="23"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="6"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="7"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="24"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="8"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="25"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="314"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="9"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="26"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="317"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="30"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="302"> <RetryDetail Offset="0.16666667" MaxAttempts="1" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="31"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> <Retry Outcome="32"> <RetryDetail Offset="0.16666667" MaxAttempts="2" NotPresent="false" BadNumber="false" MaxTimeOfDay="0.87500000" MinTimeOfDay="0.50000000"/> </Retry> </RetryParams> <WriteAudittrail>true</WriteAudittrail> <RouteExternal>false</RouteExternal> <ExternalTimeOut>0</ExternalTimeOut> <RunUsers/> <ManageUsers/> <AlternateNumberCols> <Item>szHomePhone</Item> </AlternateNumberCols> <AlternateNumberCLICols> <Item/> </AlternateNumberCLICols> <CleanGlobal>false</CleanGlobal> <CleanCallCenter>false</CleanCallCenter> <CleanCampaign>false</CleanCampaign> <CheckedFlagField/> <TZBoundUpper>tz_upper</TZBoundUpper> <TZBoundLower>tz_lower</TZBoundLower> <TZStateCodeField/> <TZPostCodeField/> <NumDigitsAreaCode>3</NumDigitsAreaCode> <TZLegislaturesFile/> <DNCListsSelected/> <DNCListsCleaned/> <FilterList> <Item> <Filter Name="ContactsFilter" Apply="false" FreeForm="true" FreeFormText="`Suppressed` IS NULL"> <ConditionList/> </Filter> </Item> <Item> <Filter Name="ComposedFilter" Apply="true" FreeForm="true" FreeFormText="(`Suppressed` IS NULL)"> <ConditionList/> </Filter> </Item> </FilterList> <PoolCallbacksOnPlannedNotMade>false</PoolCallbacksOnPlannedNotMade> <OrderColumn>lNameImportQueueId</OrderColumn> <CallbackNumber>Retry_Number</CallbackNumber> <RecTagCol1/> <RecTagCol2/> <RecTagCol3/> <RecTagCol4/> <RecTagCol5/> <RecTagCol6/> <RecLabel1/> <RecLabel2/> <RecLabel3/> <RecLabel4/> <RecLabel5/> <RecLabel6/> <BlanketRecording>false</BlanketRecording> <AnsMachineDetMode>1</AnsMachineDetMode> <AnsMachineMsg/> <AgentlessSpoofAgents>0</AgentlessSpoofAgents> <Agentless_Behaviour>2</Agentless_Behaviour> <AgentlessPredictiveMode>false</AgentlessPredictiveMode> <AgentlessMessage/> <AgentlessEnabled>false</AgentlessEnabled> <CLIPresented/> <RetryIndexColName>Retry_Index</RetryIndexColName> <AbandonMessage/> <MultiNumFlagging>false</MultiNumFlagging> <CliPerNumFlagging>false</CliPerNumFlagging> <DiallingPrefix/> <DiallingPostfix/> <MultiNumFlagCols> <Item/> </MultiNumFlagCols> <MultiNumProgressModes> <Item>-1</Item> </MultiNumProgressModes> <MinCallTimeForColumn> <Item>0.333333</Item> </MinCallTimeForColumn> <MaxCallTimeForColumn> <Item>0.958333</Item> </MaxCallTimeForColumn> <EndOfListBehaviour>0</EndOfListBehaviour> <ChainCampaignName/> <PreviewTimeout>0</PreviewTimeout> <BreatherTimeout>0</BreatherTimeout> <PreviewOnHook>false</PreviewOnHook> <PoolCallbacksOnRetry>true</PoolCallbacksOnRetry> <DialerCampaign>InternetMaster</DialerCampaign> <ApportionmentType>0</ApportionmentType> <ApportionmentRatio>1</ApportionmentRatio> <RecordTypeCol/> <CompleteCol>Complete_TS</CompleteCol> <SBRType>0</SBRType> <QueueCol/> <QueueAddress/> <SBRAbandonOutcome>0</SBRAbandonOutcome> <ConstrainRetries>true</ConstrainRetries> <QuotedIdentifiers>false</QuotedIdentifiers> <RetryPrecedence>0</RetryPrecedence> <CallsToSupplyMaster>0</CallsToSupplyMaster> <LastRequestedCount>0</LastRequestedCount> <FilterResultCols/> <Schedule IsScheduled="true" IsStartScheduled="false"> <Day Index="0" StartTime="0.37500000" EndTime="0.87500000"/> <Day Index="1" StartTime="0.37500000" EndTime="0.87500000"/> <Day Index="2" StartTime="0.37500000" EndTime="0.87500000"/> <Day Index="3" StartTime="0.37500000" EndTime="0.87500000"/> <Day Index="4" StartTime="0.37500000" EndTime="0.87500000"/> <Day Index="5" StartTime="0.37500000" EndTime="0.87500000"/> <Day Index="6" StartTime="0.37500000" EndTime="0.87500000"/> </Schedule></CampaignParams>
29402|smrt-s | 2018-07-31T17:37:24.541Z - debug: New campaign Internet_GP2 from SB
30402|smrt-s | 2018-07-31T17:37:24.541Z - debug: Status broadcast: 14 present, 1 added, 0 removed campaigns since last SB
31402|smrt-s | 2018-07-31T17:37:24.541Z - verbose: campaign Internet_GP2 created
32402|smrt-s | 2018-07-31T17:37:24.541Z - debug: db query:
33402|smrt-s | DESCRIBE Internet_GP2;
34402|smrt-s | 2018-07-31T17:37:24.615Z - debug: db query:
35402|smrt-s | INSERT INTO `Internet_GP2` (ID, ExtractDateTime, lNameImportQueueId, szHomePhone, szOtherPhone, szWorkPhone, szFirstName, szLastName, szCampaignId, szAccountNo, szAccountName, szMakeMdlYear, szCampaign, tz_lower, tz_upper, user_defined, Switch_Result, Agent_Result, Result_TS, Retry_Count, Retry_Username, Retry_TS, Retry_Index, Retry_Number, Complete_TS, dtAdded, listAddedDateTime, leadIndex, MaxAttempt, Tenant, CampaignGroup, CampaignName, cmName, CLI, Multilingual, Suppressed, totalCalls, last_dialer_load_date, originalMasterCampaign, currentMasterCampaign) VALUES ? ON DUPLICATE KEY UPDATE last_dialer_load_date='2018-07-31T17:37:24.610Z'
36402|smrt-s | 2018-07-31T17:37:25.077Z - debug: 300 contact(s) placed into Internet_GP2
37402|smrt-s | 2018-07-31T17:37:25.077Z - debug: || ==> CM:DE:OC\TDApollo\CY1\OInodeSytelManager20187217372577251888273970062
38402|smrt-s | 2018-07-31T17:37:34.678Z - debug: Status broadcast: 14 present, 0 added, 0 removed campaigns since last SB
39402|smrt-s | 2018-07-31T17:37:34.679Z - debug: campaign started InternetMaster
40402|smrt-s | 2018-07-31T17:37:34.679Z - debug: || ==> CM:DE:OC\TDApollo\CY8\OInodeSytelManager20187217372577251888273595216
41402|smrt-s | 2018-07-31T17:37:44.821Z - debug: Status broadcast: 14 present, 0 added, 0 removed campaigns since last SB
42402|smrt-s | 2018-07-31T17:37:44.821Z - debug: campaign started Internet_GP2
43402|smrt-s | 2018-07-31T17:37:44.822Z - debug: || ==> CM:DE:RL\TXSTG_SSSnodeSytelManager2518901.818282624\CY8\TDApollo\OInodeSytelManager2018721737448222518901818256360
44402|smrt-s | 2018-07-31T17:37:44.832Z - debug: campaign reloaded Internet_GP2
45402|smrt-s | 2018-07-31T17:37:44.841Z - debug: db query:
46402|smrt-s | INSERT INTO `Internet_Aggregated` (ID, ExtractDateTime, lNameImportQueueId, szHomePhone, szOtherPhone, szWorkPhone, szFirstName, szLastName, szCampaignId, szCampaign, szAccountNo, szAccountName, szMakeMdlYear, user_defined, tz_lower, tz_upper, Switch_Result, Agent_Result, Result_TS, Retry_Count, Retry_Username, Retry_TS, Retry_Index, Retry_Number, Complete_TS, dtAdded, importDateTime, totalCalls, isHomeBad, isOtherBad, isWorkBad, isRecordBad, isDoNotCall, isContact, isPitch, isAppt, isHot, isSvcOps, scriptName, dealerName, dispositionDateTime, lastFinalDisposition, leadIndex, MaxAttempt, Tenant, CampaignGroup, CampaignName, cmName, CLI, Multilingual, Suppressed, last_dialer_load_date, language, originalMasterCampaign, currentMasterCampaign) VALUES ? ON DUPLICATE KEY UPDATE last_dialer_load_date='2018-07-31T17:37:44.833Z'
47402|smrt-s | 2018-07-31T17:37:45.222Z - debug: 300 contact(s) placed into Internet_Aggregated
48402|smrt-s | 2018-07-31T17:37:45.223Z - debug: lock released on Internet_Preprocess
49402|smrt-s | 2018-07-31T17:37:54.961Z - debug: Status broadcast: 14 present, 0 added, 0 removed campaigns since last SB