2018-11-16 11:49:14.082 (3) [Thread-9]: Heartbeat #55 (1542368954079) received in 0.003s
2018-11-16 11:49:44.083 (3) [Thread-9]: Heartbeat #56 (1542368984079) received in 0.004s
2018-11-16 11:50:14.082 (3) [Thread-9]: Heartbeat #57 (1542369014079) received in 0.003s
2018-11-16 11:50:29.083 (3) [Thread-9]: Request added to map for customerID 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:29.083 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-f8c7ffe6-062d-4728-aa2f-f47c9957d64f
2018-11-16 11:50:29.084 (3) [Thread-9]: Request worker created for 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:29.084 (3) [Thread-9]: Submitted executor job for 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:29.087 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-f8c7ffe6-062d-4728-aa2f-f47c9957d64f out of queue
2018-11-16 11:50:29.090 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.119 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.125 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29,128 [pool-3-thread-4] INFO c.t.a.worker.RequestWorker - =========== Clearing carryover for an account: 2409 ===========
2018-11-16 11:50:29,133 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Find distribution level carryover for an account : 2409
2018-11-16 11:50:29,136 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Account common carryover for each distribution : [{3=0.0, 147=0.0}]
2018-11-16 11:50:29,138 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Max(endDate) from carryover table for an account : 2018-11-06
2018-11-16 11:50:29,140 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Active/Paused campaigns[6902, 7170, 6893, 6896] for a distribution 3
2018-11-16 11:50:29,140 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Removal carryover(Distribution carryover / number of campaigns): 0.0/4 = 0.0.
2018-11-16 11:50:29,140 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[6902] is 0.0.
2018-11-16 11:50:29,141 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[7170] is 0.0.
2018-11-16 11:50:29,141 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[6893] is 0.0.
2018-11-16 11:50:29,141 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[6896] is 0.0.
2018-11-16 11:50:29,145 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Active/Paused campaigns[6904, 7169, 6895, 6898] for a distribution 147
2018-11-16 11:50:29,145 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Removal carryover(Distribution carryover / number of campaigns): 0.0/4 = 0.0.
2018-11-16 11:50:29,145 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[6904] is 0.0.
2018-11-16 11:50:29,145 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[7169] is 0.0.
2018-11-16 11:50:29,145 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[6895] is 0.0.
2018-11-16 11:50:29,145 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Carryover adjustment for a campaign[6898] is 0.0.
2018-11-16 11:50:29,147 [pool-3-thread-4] INFO c.t.utils.AccountCarryoverUtil - Initializing admax summerizer with args: [-a2409, -T2018-11-05, -zAmerica/New_York, -d3]
2018-11-16 11:50:29.152 (3) [pool-3-thread-4]: Debug Level set to 3
2018-11-16 11:50:29.152 (3) [pool-3-thread-4]: AdMax Summarizer parameters: -a2409 -zAmerica/New_York -T2018-11-05 -d3 -L
2018-11-16 11:50:29.160 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.161 (3) [pool-3-thread-4]: DatabasePool with a limit of 16 created
2018-11-16 11:50:29.167 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.169 (3) [pool-3-thread-4]: Could not save process history start
2018-11-16 11:50:29.169 (3) [pool-3-thread-4]: =============== Starting AdMax Summarizer ================
2018-11-16 11:50:29.169 (3) [pool-3-thread-4]: ----------------AdMax Summarizer starting
2018-11-16 11:50:29.175 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.177 (3) [P7T1]: Starting Account ID #2409: 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:29.178 (3) [P7T1]: DatabasePool with a limit of 16 created
2018-11-16 11:50:29.184 (3) [P7T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.185 (3) [P7T1]: DatabasePool with a limit of 16 created
2018-11-16 11:50:29.190 (3) [P7T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.196 (3) [P7T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.197 (3) [P7T1]: DatabasePool with a limit of 16 created
2018-11-16 11:50:29.203 (3) [P7T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.204 (3) [P7T1]: DatabasePool with a limit of 16 created
2018-11-16 11:50:29.211 (3) [P7T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.213 (3) [P7T1]: Got migrator lock for Account ID #2409
2018-11-16 11:50:29.277 (3) [P7T1]: Applying algorithm [SABB] for Account ID #2409 in distributions [3, 178, 147]
2018-11-16 11:50:29.278 (3) [P7T1]: Processing data for 2018-11-05 00:00:00 EST
2018-11-16 11:50:29.356 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 6902
2018-11-16 11:50:29.357 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 6904
2018-11-16 11:50:29.358 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 6906
2018-11-16 11:50:29.359 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 7168
2018-11-16 11:50:29.360 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 7169
2018-11-16 11:50:29.361 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 7170
2018-11-16 11:50:29.362 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6893
2018-11-16 11:50:29.363 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6894
2018-11-16 11:50:29.364 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6895
2018-11-16 11:50:29.365 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6896
2018-11-16 11:50:29.366 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6897
2018-11-16 11:50:29.367 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6898
2018-11-16 11:50:29.369 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 6902
2018-11-16 11:50:29.372 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 6904
2018-11-16 11:50:29.373 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 6906
2018-11-16 11:50:29.374 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 7168
2018-11-16 11:50:29.375 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 7169
2018-11-16 11:50:29.376 (3) [P7T1]: Retrieved campaign status Active for AdMax campaign 7170
2018-11-16 11:50:29.377 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6893
2018-11-16 11:50:29.378 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6894
2018-11-16 11:50:29.379 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6895
2018-11-16 11:50:29.380 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6896
2018-11-16 11:50:29.381 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6897
2018-11-16 11:50:29.383 (3) [P7T1]: Retrieved campaign status Paused for AdMax campaign 6898
2018-11-16 11:50:29.440 (3) [P7T1]: Campaign 6906 is not from one of the specified distributions: [3, 178, 147]
2018-11-16 11:50:29.440 (3) [P7T1]: Campaign 7168 is not from one of the specified distributions: [3, 178, 147]
2018-11-16 11:50:29.441 (2) [P7T1]: Error in getting campaign mappings for account 2409, Reason:Could not retrieve campaign mappings for AdmaxCampaignID:6894
2018-11-16 11:50:29.475 (3) [P7T1]: Distribution Properties Cache: Loading new properties for 3c7e571f-6cd9-444d-b157-0272cc20255a_ALGORITHM
2018-11-16 11:50:29.648 (3) [P7T1]: Budget (status) has not changed for campaign ID 12845
2018-11-16 11:50:29.648 (3) [P7T1]: Budget (status) has not changed for campaign ID 12846
2018-11-16 11:50:29.650 (3) [P7T1]: Budget (status) has not changed for campaign ID 13574
2018-11-16 11:50:29.650 (3) [P7T1]: Budget (status) has not changed for campaign ID 13575
2018-11-16 11:50:29.656 (2) [P7T1]: Exception [Handling Account ID #2409]:java.lang.NullPointerException
at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBBudgetBalancer.run(AdMaxSABBBudgetBalancer.java:77)
at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:297)
at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:639)
at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:504)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018-11-16 11:50:29.658 (3) [P7T1]: DefaultPropertyFileMonitor: modification detected on 1535089574000 for com.thesearchagency.AlertUtils.properties
2018-11-16 11:50:29.658 (2) [P7T1]: sendAlert: executing command: [/usr/local/tsa/send_alarm.sh, WARNING, TSAOPS, AdMax Application [AdMaxSummarizer]: General - Error Handling Account ID #2409null]
2018-11-16 11:50:29.669 (3) [P7T1]: Released migrator lock for Account ID #2409
2018-11-16 11:50:29.669 (3) [P7T1]: Completed Account ID #2409: 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:29.670 (3) [pool-3-thread-4]: ------------AdMax Summarizer done
2018-11-16 11:50:29.670 (3) [pool-3-thread-4]: =============== Completed AdMax Summarizer ================
2018-11-16 11:50:29.670 (3) [pool-3-thread-4]: Could not save process history stop
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: =============== Stats ================
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: --- Process ---
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: ABU Process(start): Fri Nov 16 11:50:29 UTC 2018
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: ABU Process(stop): Fri Nov 16 11:50:29 UTC 2018
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: --- Accounts ---
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: Accounts Processed: 1
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: Accounts Skipped: 0
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: Accounts Processed Successfully: 0
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: --- Campaigns ---
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: Campaigns Processed: 12
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: Campaigns Processed Successfully: 0
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: Campaign Budgets Capped: 0
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: --- SE Campaigns ---
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: SE Campaigns Processed: 24
2018-11-16 11:50:29.671 (3) [pool-3-thread-4]: SE Campaigns Processed Successfully: 0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: --- Budget/Spend ---
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: SE Campaign Budgets Updated: 10
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: SE Campaign Budgets Sent To Google: 0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: SE Campaign Budgets Sent To Yahoo Japan:0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: SE Campaign Budgets Sent To Bing: 0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: Spend Total: 0.0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: Common Carryover Total: 0.0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: --- Bids ---
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]: New Campaign Bids: 0
2018-11-16 11:50:29.672 (3) [pool-3-thread-4]:
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: AdMaxSummarizer: 0.519s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: by key:
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: db: 0.044s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: by thread:
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: pool-3-thread-4: 0.001s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: P7T1: 0.043s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: other: 0.475s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: AdMaxJMSListener: 0.000s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: by key:
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: AccountWorker: DEPLOY: 1m 4.684s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: by thread:
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: pool-3-thread-1: 1m 3.849s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: pool-3-thread-2: 0.835s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: AccountWorker: UPDATE: 1m 46.883s
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: by thread:
2018-11-16 11:50:29.673 (3) [pool-3-thread-4]: pool-3-thread-1: 26.488s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-3-thread-2: 22.014s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-3-thread-3: 58.381s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: db: 47.144s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: by thread:
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-3-thread-4: 0.004s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-9-thread-2: 0.015s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: P7T1: 0.043s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: P4T1: 0.160s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-3-thread-1: 0.106s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: P3T1: 0.028s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-16-thread-1: 0.002s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-9-thread-1: 0.002s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-3-thread-2: 46.279s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: pool-16-thread-2: 0.001s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: P6T1: 0.028s
2018-11-16 11:50:29.674 (3) [pool-3-thread-4]: P5T1: 0.022s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-3-thread-3: 0.044s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-13-thread-1: 0.005s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-6-thread-1: 0.021s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-12-thread-3: 0.005s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-22-thread-3: 0.004s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-22-thread-1: 0.001s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-5-thread-1: 0.002s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: P2T1: 0.298s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: P1T1: 0.056s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-4-thread-1: 0.005s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-4-thread-2: 0.012s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-19-thread-1: 0.001s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: RequestWorker: 3m 38.500s
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: by thread:
2018-11-16 11:50:29.675 (3) [pool-3-thread-4]: pool-3-thread-1: 1m 30.760s
2018-11-16 11:50:29.676 (3) [pool-3-thread-4]: pool-3-thread-2: 1m 9.235s
2018-11-16 11:50:29.676 (3) [pool-3-thread-4]: pool-3-thread-3: 58.505s
2018-11-16 11:50:29.676 (3) [pool-3-thread-4]: other: -437.211s
2018-11-16 11:50:29.682 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.692 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 7168
2018-11-16 11:50:29.692 (3) [pool-3-thread-4]: Terminated budget for admaxCampaignID 7168
2018-11-16 11:50:29.694 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6906
2018-11-16 11:50:29.708 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 7169
2018-11-16 11:50:29.708 (3) [pool-3-thread-4]: Terminated budget for admaxCampaignID 7169
2018-11-16 11:50:29.711 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6904
2018-11-16 11:50:29.718 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6895
2018-11-16 11:50:29.721 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6898
2018-11-16 11:50:29.725 (3) [pool-3-thread-4]: Nominal monthly budget was unchanged for AdMax campaign ID: 7170
2018-11-16 11:50:29.725 (3) [pool-3-thread-4]: Terminated budget for admaxCampaignID 7170
2018-11-16 11:50:29.732 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6902
2018-11-16 11:50:29.735 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6893
2018-11-16 11:50:29.737 (3) [pool-3-thread-4]: Created tomorrow's budget for admaxCampaignID 6896
2018-11-16 11:50:29.737 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 25372
2018-11-16 11:50:29.743 (3) [pool-3-thread-4]: Terminating advert budget for 25372
2018-11-16 11:50:29.745 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 25373
2018-11-16 11:50:29.750 (3) [pool-3-thread-4]: Terminating advert budget for 25373
2018-11-16 11:50:29.752 (3) [pool-3-thread-4]: Updating deployment status to 'InProgress' for campaignID: 25374
2018-11-16 11:50:29.757 (3) [pool-3-thread-4]: Terminating advert budget for 25374
2018-11-16 11:50:29.767 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.767 (3) [pool-3-thread-4]: Start processing UPDATE request (08f029db-dc10-4f9c-bc3b-7106b88803a4) for account 3c7e571f-6cd9-444d-b157-0272cc20255a. 8 campaign(s).
2018-11-16 11:50:29.767 (3) [pool-3-thread-4]: Performing update for account: 3c7e571f-6cd9-444d-b157-0272cc20255a ID#2409
2018-11-16 11:50:29.773 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:29.784 (3) [pool-3-thread-4]: Distribution Properties Cache: Loading new properties for 3c7e571f-6cd9-444d-b157-0272cc20255a_CONTENT_EDITOR
2018-11-16 11:50:29.870 (3) [pool-3-thread-4]: 8 campaign(s) to update.
2018-11-16 11:50:29.870 (3) [pool-3-thread-4]: 0 campaign(s) to retry and update.
2018-11-16 11:50:29.870 (3) [pool-3-thread-4]: Update campaign status for accountID 2409
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: CampaignWorker initialized for account: 2409
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1 Status: Deleted
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2 Status: Deleted
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3 Status: Deleted
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4 Status: Deleted
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GM Status: Deleted
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GT Status: Deleted
2018-11-16 11:50:29.871 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GM Status: Deleted
2018-11-16 11:50:29.872 (3) [pool-3-thread-4]: Updating 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GT Status: Deleted
2018-11-16 11:50:29.872 (3) [pool-3-thread-4]: CampaignUpdateWorker started...
2018-11-16 11:50:29,952 [pool-3-thread-4] DEBUG c.t.searchengines.bing.BingApiUtils - Getting Bing properties using distribution service
2018-11-16 11:50:29.952 (3) [pool-3-thread-4]: Distribution Properties Cache: Loading new properties for 3c7e571f-6cd9-444d-b157-0272cc20255a_CONTENT_EDITOR
2018-11-16 11:50:30.036 (3) [pool-3-thread-4]: Retrieving credentials : client id : 869cad8e-f7c6-4854-b1bb-4f7955d142c3 , client secret :YZpgReOeKSmN3uEvwdvpumW , refresh token : MCQpoWdKkKN55SnQAlL!yXJR5yjGmsFx9kRx*PSDnWE2jzfOjtBu3lYFX!UwgHVBIRjCV6caxrQOqe!8W8aPwwvlJ3H8H51m9HjX*e9pv0kGkds8QVgiWb3f92CGa2vklhp9ViUsX0TlpTSifZd5fHKV55fH69VVJCucQ*n*E0Mris7fB8A5*ik6lyjg31yGo2knVRqff6anhA8WE0bvu55nUSQxsNU5rgz5*spV4iMSp0beKlTgkcBehGvdQ*za3rkCZ*gWt5ids5fOZP734nLfnNcbcJRyHalSJNzJEIhJb9GYLKh46Jr8QtsiGk5Nnv6ZIhpDgklbVaMdyNDPkj0zpA442YVH!B0d4vLZomL03
2018-11-16 11:50:30,037 [pool-3-thread-4] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = EwAYA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAARaNKPbVB+MPwNoM3sjzKM3gkMXBNW/rhEMSjL7kCJNmuVt1wFJscdRUV2qgZq7CsgfV1lbi1zRFbN6iZ7wKfqmpKyM7kHZ5fB0xD6iKllr1pMEUTr/L7bdly/ln+tG+dDE0LyO3ekHna7Ud2kju9QAVIPOiKgq7JuglWjk//ZieNXT4KrPn65LaArWGwXMKe6FSQrHiXNh8yv+nsyhkIWc2JrlFP8zl5JdMlhVnQyJoIzt7jWw1wre2aItmUQ+PU7IdG4fS12NDHvRMQJR4prMRnwfoR1GUD0rN7m9wWkgK/DYiSy50eWoqJ9XFLLlwi3rD5X19aj/m4ThIYtr+65gDZgAACAIV8Xgyok7S6AH6YPi3EmuDBs2aqY9xS9fmv77stXwgYHAIOvafr+9ygzG1tza9INbmo+aprHPOGBIaf0ibJFlofjqpqQQTIMJZPzLZAyd7tKZ8pcoEHDL6S8ZIGBRtBjKWuCErOslU7il/k50Z8MvCTfk4+nCTT7K6nNfD78w7jlQQtge30uAp4F9Hlz676KAbxCHpNAG8yJjYhz/fV8wy7smZNHzG/iZX1DkGvJJsZuWV7r5UEX4ywwHO3Kd5ZM9YXNN5wuOjF23q8tjGxlhKNdvbpcz8XyOB3qsBpA60zX0bVJCg2/bgpfTH9N2aA0jH4n0W1gpwpwobmxcu9cfHmTCoKJvHllzHfW2rkHygUP+3U7s680RR7ST87do6MDlteRhE+K4Vqf0M79pPYK1iy0Z0KxujBG/eh/9tmvYf3vyyB/0sT3Ap2llylosn+kQ18EeNM2KuFC97FSdTrc2Lk5n+ZXrCmBmqu7qcP6/oxt0CC8YZtd6iy+55WmZaFsst4IZS2aDx+42XgGh0Ke2hHptU4ZcKdsMKI4R/nUcUGnl9dPkSVBibeNwgOGiPWStOsWQIiZrjRXyt7cJgjz6frPlFjb5fRLfPaau46vYQzC6U1olX9FzAeTtbrcMWuYQjoxhDWVkpvUUEElx0gZ9GeR4C for bing (clientID=869cad8e-f7c6-4854-b1bb-4f7955d142c3)
2018-11-16 11:50:30.037 (3) [pool-3-thread-4]: [oauth] Returning access token from OAuth service: EwAYA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAARaNKPbVB+MPwNoM3sjzKM3gkMXBNW/rhEMSjL7kCJNmuVt1wFJscdRUV2qgZq7CsgfV1lbi1zRFbN6iZ7wKfqmpKyM7kHZ5fB0xD6iKllr1pMEUTr/L7bdly/ln+tG+dDE0LyO3ekHna7Ud2kju9QAVIPOiKgq7JuglWjk//ZieNXT4KrPn65LaArWGwXMKe6FSQrHiXNh8yv+nsyhkIWc2JrlFP8zl5JdMlhVnQyJoIzt7jWw1wre2aItmUQ+PU7IdG4fS12NDHvRMQJR4prMRnwfoR1GUD0rN7m9wWkgK/DYiSy50eWoqJ9XFLLlwi3rD5X19aj/m4ThIYtr+65gDZgAACAIV8Xgyok7S6AH6YPi3EmuDBs2aqY9xS9fmv77stXwgYHAIOvafr+9ygzG1tza9INbmo+aprHPOGBIaf0ibJFlofjqpqQQTIMJZPzLZAyd7tKZ8pcoEHDL6S8ZIGBRtBjKWuCErOslU7il/k50Z8MvCTfk4+nCTT7K6nNfD78w7jlQQtge30uAp4F9Hlz676KAbxCHpNAG8yJjYhz/fV8wy7smZNHzG/iZX1DkGvJJsZuWV7r5UEX4ywwHO3Kd5ZM9YXNN5wuOjF23q8tjGxlhKNdvbpcz8XyOB3qsBpA60zX0bVJCg2/bgpfTH9N2aA0jH4n0W1gpwpwobmxcu9cfHmTCoKJvHllzHfW2rkHygUP+3U7s680RR7ST87do6MDlteRhE+K4Vqf0M79pPYK1iy0Z0KxujBG/eh/9tmvYf3vyyB/0sT3Ap2llylosn+kQ18EeNM2KuFC97FSdTrc2Lk5n+ZXrCmBmqu7qcP6/oxt0CC8YZtd6iy+55WmZaFsst4IZS2aDx+42XgGh0Ke2hHptU4ZcKdsMKI4R/nUcUGnl9dPkSVBibeNwgOGiPWStOsWQIiZrjRXyt7cJgjz6frPlFjb5fRLfPaau46vYQzC6U1olX9FzAeTtbrcMWuYQjoxhDWVkpvUUEElx0gZ9GeR4C
2018-11-16 11:50:30,143 [pool-3-thread-4] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service
2018-11-16 11:50:30.143 (3) [pool-3-thread-4]: Distribution Properties Cache: Loading new properties for 3c7e571f-6cd9-444d-b157-0272cc20255a_CONTENT_EDITOR
2018-11-16 11:50:30,234 [pool-3-thread-4] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook currencyCode USD for accountID 2409
2018-11-16 11:50:30,235 [pool-3-thread-4] DEBUG c.t.s.f.FacebookAccountDeployer - Facebook timeZoneID America/New_York for accountID 2409
2018-11-16 11:50:30.241 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:30.247 (3) [pool-3-thread-4]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:30,254 [pool-3-thread-4] INFO c.t.s.bing.BingAccountDeployer - BingAccountDeployer:getExistingCampaigns
2018-11-16 11:50:30,256 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4966,4967)
2018-11-16 11:50:30,272 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - FacebookAccountDeployer:getExistingCampaigns
2018-11-16 11:50:30,274 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (2028,2029,2030,2031)
2018-11-16 11:50:30,278 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - calculating carryover for seuserID 3626
2018-11-16 11:50:30,278 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - Fetching performance data for seuserID 3626 and campaign SEIdentifiers [56ae8271616744efa448d425e260cba8, d8cc375994454910b62da70cee69eb06, ef3eb076422249c8979560efb0b4e3c9, cef51fe9dcdf4398bde6b58cb81ff780]
2018-11-16 11:50:30,281 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = '56ae8271616744efa448d425e260cba8'
2018-11-16 11:50:30,282 [pool-3-thread-4] DEBUG c.t.services.client.tp.impl.TPClient - Created TPClient for 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:35,282 [pool-3-thread-4] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [56ae8271616744efa448d425e260cba8] details for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:35,286 [pool-3-thread-4] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 37
Address: https://api.tigerpistol.com/v1/campaigns/56ae8271616744efa448d425e260cba8
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:35,773 [pool-3-thread-4] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 37
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[778], content-type=[application/json; charset=utf-8], Date=[Fri, 16 Nov 2018 11:50:35 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null,"id":"56ae8271616744efa448d425e260cba8","customerId":"4bf955aa25e04e96ac32da77129333b8","name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1","start":"2018-08-29T12:10:00+00:00","end":"2018-09-29T03:59:00+00:00","budget":6893.00,"objective":"page_likes","status":"error","publishPhase":"error","errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method."}
--------------------------------------
2018-11-16 11:50:35,776 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2028,'2018-11-16','error',0.0,0,0,6893,'08/29/2018
12:10:00.000','09/29/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)
2018-11-16 11:50:35,777 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 2028 and `performance`.`date` = '2018-11-16'
2018-11-16 11:50:35,778 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'd8cc375994454910b62da70cee69eb06'
2018-11-16 11:50:40,779 [pool-3-thread-4] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [d8cc375994454910b62da70cee69eb06] details for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:40,783 [pool-3-thread-4] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 38
Address: https://api.tigerpistol.com/v1/campaigns/d8cc375994454910b62da70cee69eb06
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:41,167 [pool-3-thread-4] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 38
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[778], content-type=[application/json; charset=utf-8], Date=[Fri, 16 Nov 2018 11:50:40 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null,"id":"d8cc375994454910b62da70cee69eb06","customerId":"4bf955aa25e04e96ac32da77129333b8","name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2","start":"2018-08-29T12:10:00+00:00","end":"2018-09-29T03:59:00+00:00","budget":6893.00,"objective":"page_likes","status":"error","publishPhase":"error","errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method."}
--------------------------------------
2018-11-16 11:50:41,169 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2029,'2018-11-16','error',0.0,0,0,6893,'08/29/2018
12:10:00.000','09/29/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)
2018-11-16 11:50:41,170 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 2029 and `performance`.`date` = '2018-11-16'
2018-11-16 11:50:41,171 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'ef3eb076422249c8979560efb0b4e3c9'
2018-11-16 11:50:44.083 (3) [Thread-9]: Heartbeat #58 (1542369044079) received in 0.003s
2018-11-16 11:50:46,172 [pool-3-thread-4] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [ef3eb076422249c8979560efb0b4e3c9] details for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:46,176 [pool-3-thread-4] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 39
Address: https://api.tigerpistol.com/v1/campaigns/ef3eb076422249c8979560efb0b4e3c9
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:46,604 [pool-3-thread-4] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 39
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[778], content-type=[application/json; charset=utf-8], Date=[Fri, 16 Nov 2018 11:50:46 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null,"id":"ef3eb076422249c8979560efb0b4e3c9","customerId":"4bf955aa25e04e96ac32da77129333b8","name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3","start":"2018-08-29T12:10:00+00:00","end":"2018-09-29T03:59:00+00:00","budget":6893.00,"objective":"page_likes","status":"error","publishPhase":"error","errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method."}
--------------------------------------
2018-11-16 11:50:46,606 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2030,'2018-11-16','error',0.0,0,0,6893,'08/29/2018
12:10:00.000','09/29/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)
2018-11-16 11:50:46,607 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 2030 and `performance`.`date` = '2018-11-16'
2018-11-16 11:50:46,608 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`tpId` = 'cef51fe9dcdf4398bde6b58cb81ff780'
2018-11-16 11:50:51,609 [pool-3-thread-4] INFO c.t.s.c.t.i.s.CampaignServiceClient - Getting TP campaign [cef51fe9dcdf4398bde6b58cb81ff780] details for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:51,612 [pool-3-thread-4] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 40
Address: https://api.tigerpistol.com/v1/campaigns/cef51fe9dcdf4398bde6b58cb81ff780
Http-Method: GET
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:51,985 [pool-3-thread-4] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 40
Response-Code: 200
Encoding: UTF-8
Content-Type: application/json; charset=utf-8
Headers: {Content-Length=[778], content-type=[application/json; charset=utf-8], Date=[Fri, 16 Nov 2018 11:50:51 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
Payload: {"variations":[{"index":0,"reviewError":null}],"displayMargin":1.0,"hasError":true,"spend":0.0,"clicks":0,"cpc":null,"ctr":null,"impressions":0,"cpm":null,"leads":0,"cpl":null,"pageLikes":0,"postEngagements":0,"cppl":null,"cppe":null,"reach":0,"videoViews":0,"cpvv":null,"videoAveragePercentViewed":null,"offersSaved":0,"cpos":null,"id":"cef51fe9dcdf4398bde6b58cb81ff780","customerId":"4bf955aa25e04e96ac32da77129333b8","name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4","start":"2018-08-29T12:10:00+00:00","end":"2018-09-29T03:59:00+00:00","budget":6893.00,"objective":"page_likes","status":"error","publishPhase":"error","errorMessage":"You must have a valid payment method associated with your ad account before you can create ads. Please add a payment method."}
--------------------------------------
2018-11-16 11:50:51,987 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `performance` (`campaignID`, `date`, `status`, `spend`, `clicks`, `impressions`,
`budget`, `startDate`, `endDate`, `lastUpdated`) VALUES (2031,'2018-11-16','error',0.0,0,0,6893,'08/29/2018
12:10:00.000','09/29/2018 03:59:00.000',NOW()) ON DUPLICATE KEY UPDATE `status`=VALUES(`status`),
`spend`=VALUES(`spend`), `clicks`=VALUES(`clicks`), `impressions`=VALUES(`impressions`), `budget`=VALUES(`budget`),
`lastUpdated`=VALUES(`lastUpdated`)
2018-11-16 11:50:51,988 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `performance`.`id`, `performance`.`campaignID`, `performance`.`date`, `performance`.`status`,
`performance`.`spend`, `performance`.`clicks`, `performance`.`impressions`, `performance`.`budget`,
`performance`.`startDate`, `performance`.`endDate`, `performance`.`lastUpdated` FROM `campaigns`
JOIN `performance` ON `performance`.`campaignID` = `campaigns`.`id` WHERE `campaigns`.`id`
= 2031 and `performance`.`date` = '2018-11-16'
2018-11-16 11:50:51,990 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - Sucessfully fetched facebook campaign performance data for seuserID 3626, perf data ([TPCampaignPerformanceDTO [theID=3563, theCampaignID=2028, theDate=2018-11-16, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=6893, theStartDate=2018-08-29T12:10:00.000Z, theEndDate=2018-09-29T03:59:00.000Z, theLastUpdated=2018-11-16T11:50:35.000Z], TPCampaignPerformanceDTO [theID=3564, theCampaignID=2029, theDate=2018-11-16, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=6893, theStartDate=2018-08-29T12:10:00.000Z, theEndDate=2018-09-29T03:59:00.000Z, theLastUpdated=2018-11-16T11:50:41.000Z], TPCampaignPerformanceDTO [theID=3565, theCampaignID=2030, theDate=2018-11-16, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=6893, theStartDate=2018-08-29T12:10:00.000Z, theEndDate=2018-09-29T03:59:00.000Z, theLastUpdated=2018-11-16T11:50:46.000Z], TPCampaignPerformanceDTO [theID=3566, theCampaignID=2031, theDate=2018-11-16, theStatus=error, theSpend=0.0, theClicks=0, theImpressions=0, theBudget=6893, theStartDate=2018-08-29T12:10:00.000Z, theEndDate=2018-09-29T03:59:00.000Z, theLastUpdated=2018-11-16T11:50:51.000Z]])
2018-11-16 11:50:51,990 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2028 [seuserID 3626] ===========
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2028 : 68.93 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2028 : 0.0 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-29T08:10:00.000-04:00 America/New_York, end date 2018-09-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-11-16T06:50:51.990-05:00 America/New_York for campaignID 2028
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2028 active for 78 days (num_of_days_active) and 23 hours (num_of_hours_active)
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2028 : 2.2235484
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2028 : 0.09264785
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2028 : 173.43678
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2028 : 2.1309006
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2028 : 175.56769
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2028 : 175.57
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2029 [seuserID 3626] ===========
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2029 : 68.93 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2029 : 0.0 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-29T08:10:00.000-04:00 America/New_York, end date 2018-09-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-11-16T06:50:51.991-05:00 America/New_York for campaignID 2029
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2029 active for 78 days (num_of_days_active) and 23 hours (num_of_hours_active)
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2029 : 2.2235484
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2029 : 0.09264785
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2029 : 173.43678
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2029 : 2.1309006
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2029 : 175.56769
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2029 : 175.57
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2030 [seuserID 3626] ===========
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2030 : 68.93 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2030 : 0.0 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-29T08:10:00.000-04:00 America/New_York, end date 2018-09-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-11-16T06:50:51.991-05:00 America/New_York for campaignID 2030
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2030 active for 78 days (num_of_days_active) and 23 hours (num_of_hours_active)
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2030 : 2.2235484
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2030 : 0.09264785
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2030 : 173.43678
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2030 : 2.1309006
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2030 : 175.56769
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2030 : 175.57
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - =========== Processing carryover for campaignID 2031 [seuserID 3626] ===========
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_monthly_budget for campaignID 2031 : 68.93 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - actual_spend for campaignID 2031 : 0.0 USD
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaign start date 2018-08-29T08:10:00.000-04:00 America/New_York, end date 2018-09-28T23:59:00.000-04:00 America/New_York, days 31.0, current date 2018-11-16T06:50:51.991-05:00 America/New_York for campaignID 2031
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - campaignID 2031 active for 78 days (num_of_days_active) and 23 hours (num_of_hours_active)
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - daily_budget [actual_monthly_budget / 31.0] for campaignID 2031 : 2.2235484
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - hourly_budget [daily_budget / 24] for campaignID 2031 : 0.09264785
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_daily_spend [daily_budget * num_of_days_active] for campaignID 2031 : 173.43678
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_hourly_spend [hourly_budget * num_of_hours_active] for campaignID 2031 : 2.1309006
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - expected_spend [expected_daily_spend + expected_hourly_spend] for campaignID 2031 : 175.56769
2018-11-16 11:50:51,991 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - dedicatedCarryover [expected_spend - actual_spend] for campaignID 2031 : 175.57
2018-11-16 11:50:51,995 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`,
mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID` = c.`id` WHERE
c.`searchEngineUserId` = 3626 AND mc.`type` = 'boosted' AND mc.`date` = (SELECT MAX(DATE) FROM
monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` and c.`searchEngineUserId` =
c.`searchEngineUserId` AND mc1.`type` = 'boosted') ORDER BY c.`id` DESC LIMIT 4
2018-11-16 11:50:51,998 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - Found campaign carryover data for seuserID 3626, boosted carryover data ([TPCampaignCarryoverDTO [theID=1392, theCampaignID=1979, theDate=2018-08-28, theDedicatedCarryover=0.18, thePooledCarryover=37.68, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=1391, theCampaignID=1978, theDate=2018-08-28, theDedicatedCarryover=0.18, thePooledCarryover=37.68, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=1390, theCampaignID=1977, theDate=2018-08-28, theDedicatedCarryover=0.18, thePooledCarryover=37.68, theCarryoverType=boosted], TPCampaignCarryoverDTO [theID=1389, theCampaignID=1976, theDate=2018-08-28, theDedicatedCarryover=0.18, thePooledCarryover=37.68, theCarryoverType=boosted]])
2018-11-16 11:50:52,000 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `id`, `searchEngineUserId`, `date`, `carryoverAdjustment`, `type` FROM `monthlyCarryoverAdjustments`
WHERE `searchEngineUserId` = 3626 and `date` = '2018-11-16' and `type` = 'normal'
2018-11-16 11:50:52,002 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - Total boostedCarryover for seuserID 3626 and date 2018-11-16 is 150.72
2018-11-16 11:50:52,002 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - Total carryover Adjustment for seuserID 3626 and date 2018-11-16 is 0.0
2018-11-16 11:50:52,002 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - Total pooledCarryOver [(totalPooledCarryover + totalBoostedCarryover) - carryoverAdjustment] for seuserID 3626 and date 2018-11-16 is 853.0
2018-11-16 11:50:52,002 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2028, theDate=2018-11-16, theDedicatedCarryover=175.57, thePooledCarryover=213.25, theCarryoverType=normal] for campaignID 2028
2018-11-16 11:50:52,005 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`,
`type`) VALUES (2028,'2018-11-16',175.57,213.25,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`),
`pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`)
2018-11-16 11:50:52,006 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers`
WHERE `campaignID` = 2028 and `date` = '2018-11-16' and `type` = 'normal'
2018-11-16 11:50:52,008 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2029, theDate=2018-11-16, theDedicatedCarryover=175.57, thePooledCarryover=213.25, theCarryoverType=normal] for campaignID 2029
2018-11-16 11:50:52,010 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`,
`type`) VALUES (2029,'2018-11-16',175.57,213.25,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`),
`pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`)
2018-11-16 11:50:52,011 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers`
WHERE `campaignID` = 2029 and `date` = '2018-11-16' and `type` = 'normal'
2018-11-16 11:50:52,013 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2030, theDate=2018-11-16, theDedicatedCarryover=175.57, thePooledCarryover=213.25, theCarryoverType=normal] for campaignID 2030
2018-11-16 11:50:52,016 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`,
`type`) VALUES (2030,'2018-11-16',175.57,213.25,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`),
`pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`)
2018-11-16 11:50:52,016 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers`
WHERE `campaignID` = 2030 and `date` = '2018-11-16' and `type` = 'normal'
2018-11-16 11:50:52,018 [pool-3-thread-4] INFO c.t.s.f.FacebookAccountDeployer - saving carryover TPCampaignCarryoverDTO [theID=null, theCampaignID=2031, theDate=2018-11-16, theDedicatedCarryover=175.57, thePooledCarryover=213.25, theCarryoverType=normal] for campaignID 2031
2018-11-16 11:50:52,021 [pool-3-thread-4] INFO jdbc.sqlonly - INSERT INTO `monthlyCarryovers` (`campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`,
`type`) VALUES (2031,'2018-11-16',175.57,213.25,'normal') ON DUPLICATE KEY UPDATE `dedicatedCarryover`=VALUES(`dedicatedCarryover`),
`pooledCarryover`=VALUES(`pooledCarryover`), `type`=VALUES(`type`)
2018-11-16 11:50:52,022 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `id`, `campaignID`, `date`, `dedicatedCarryover`, `pooledCarryover`, `type` FROM `monthlyCarryovers`
WHERE `campaignID` = 2031 and `date` = '2018-11-16' and `type` = 'normal'
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GT status change (Paused->Deleted)
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GM status change (Paused->Deleted)
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1 status change (Active->Deleted)
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2 status change (Active->Deleted)
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3 status change (Active->Deleted)
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.024 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4 status change (Active->Deleted)
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GT status change (Paused->Deleted)
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GM status change (Paused->Deleted)
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping target sync.
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping call data sync
2018-11-16 11:50:52.025 (3) [pool-3-thread-4]: Campaign deleted, skipping location data sync
2018-11-16 11:50:52.025 (3) [pool-25-thread-1]: Starting Google Update Campaign Worker..
2018-11-16 11:50:52.025 (3) [pool-25-thread-2]: Starting Bing Update Campaign Worker..
2018-11-16 11:50:52,025 [pool-25-thread-2] INFO c.t.s.bing.BingAccountDeployer - BingAccountDeployer: updateCampaigns
2018-11-16 11:50:52.027 (3) [pool-25-thread-3]: Starting Facebook Update Campaign Worker..
2018-11-16 11:50:52,027 [pool-25-thread-3] INFO c.t.s.f.FacebookAccountDeployer - FBAccountDeployer: updateCampaigns
2018-11-16 11:50:52,028 [pool-25-thread-2] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (4966,4967)
2018-11-16 11:50:52,030 [pool-25-thread-3] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` IN (2028,2029,2030,2031)
2018-11-16 11:50:52.035 (3) [pool-25-thread-1]: Skipping feed sync
2018-11-16 11:50:52.035 (3) [pool-25-thread-1]: ----------------Google Content Editor starting
2018-11-16 11:50:52,036 [pool-25-thread-3] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1
2018-11-16 11:50:52,036 [pool-25-thread-3] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2
2018-11-16 11:50:52,036 [pool-25-thread-3] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3
2018-11-16 11:50:52,036 [pool-25-thread-3] INFO c.t.s.f.FacebookAccountDeployer - Delete request for 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4
2018-11-16 11:50:52,036 [pool-25-thread-3] INFO c.t.s.f.FacebookAccountDeployer - accountID 2409: deleting 4 Facebook campaigns
2018-11-16 11:50:52,036 [pool-25-thread-2] INFO c.t.s.bing.BingAccountDeployer - Delete request for 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GT
2018-11-16 11:50:52,036 [pool-25-thread-2] INFO c.t.s.bing.BingAccountDeployer - Delete request for 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GM
2018-11-16 11:50:52,036 [pool-25-thread-2] INFO c.t.s.bing.BingAccountDeployer - accountID 2409: deleting 2 campaigns
2018-11-16 11:50:52.042 (3) [pool-25-thread-1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:52.042 (3) [pool-25-thread-2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:52,045 [pool-25-thread-3] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [cef51fe9dcdf4398bde6b58cb81ff780] status to [pause] for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:52,049 [pool-25-thread-3] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 41
Address: https://api.tigerpistol.com/v1/campaigns/cef51fe9dcdf4398bde6b58cb81ff780/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:52.050 (3) [P8T1]: DistributionServiceRemoteClient created for 3c7e571f-6cd9-444d-b157-0272cc20255a_3_qa4amltest_Facebook_budget_7
2018-11-16 11:50:52,050 [pool-25-thread-2] INFO c.t.s.c.b.impl.BingAdsServiceFactory - USING PRODUCTION ENVIRONMENT
2018-11-16 11:50:52,050 [pool-25-thread-2] DEBUG c.t.s.client.bing.impl.BingAdsClient - Created BingAdsClient for 149152996
2018-11-16 11:50:52,061 [pool-25-thread-2] INFO c.t.s.c.b.i.s.CampaignServiceClient - Deleting 2 Bing campaigns from account 149152996
2018-11-16 11:50:52,118 [pool-25-thread-2] INFO o.a.c.w.s.f.ReflectionServiceFactoryBean - Creating Service {https://bingads.microsoft.com/CampaignManagement/v12}CampaignManagementService from class com.microsoft.bingads.v12.campaignmanagement.ICampaignManagementService
2018-11-16 11:50:52.174 (3) [P8T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-11-16 11:50:52.179 (3) [P8T1]: Retrieving credentials for search engine user id : 3627 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-11-16 11:50:52,179 [P8T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8 for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-11-16 11:50:52.179 (3) [P8T1]: [oauth] Returning access token from OAuth service: ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8
2018-11-16 11:50:52.179 (3) [P8T1]: Retrieving credentials for search engine user id : 3627 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-11-16 11:50:52,179 [P8T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8 for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-11-16 11:50:52.179 (3) [P8T1]: [oauth] Returning access token from OAuth service: ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8
2018-11-16 11:50:52.179 (3) [P8T1]: DistributionServiceRemoteClient created for GMB
2018-11-16 11:50:52.222 (3) [P8T1]: Retrieving GMB credentials for search engine user id : 3627 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-11-16 11:50:52,222 [P8T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1WBmDRVdWpeRMlNwaRzEnM6N_3yzuGokS6rMDg1NkLoy2xkloYcDh-8z6Sid224yv6k2juU1lPvCYfp8upks4twuJrX3pfd4r1VCY2sFg2rDog9-gzWCcl5LEuk_Y for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-11-16 11:50:52.222 (3) [P8T1]: DistributionServiceRemoteClient created for 3c7e571f-6cd9-444d-b157-0272cc20255a_3_qa4amltest_Facebook_budget_7
2018-11-16 11:50:52.320 (3) [P8T1]: Creating API for reseller DistributionSettings b8a7d340-30e0-4369-97d0-8f901d238f86
2018-11-16 11:50:52.321 (3) [P8T1]: Retrieving credentials for search engine user id : 3627 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-11-16 11:50:52,321 [P8T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8 for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-11-16 11:50:52.321 (3) [P8T1]: [oauth] Returning access token from OAuth service: ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8
2018-11-16 11:50:52.321 (3) [P8T1]: Retrieving credentials for search engine user id : 3627 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/XElVvzhFJlFc7FcqtcZJbj1-erQxMLsEVlrN60XCc4JMrEt0pnthZ_A8mZru5Ei4
2018-11-16 11:50:52,321 [P8T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8 for adwords (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-11-16 11:50:52.321 (3) [P8T1]: [oauth] Returning access token from OAuth service: ya29.Gl1WBtxyuHASP7Zro8f_1rm6NZm2z-2mH5lCULy7V69aapFfNFOvWnLnndicRDMJoSm2x4qA5fnPqLXzYL-zWwHpS-YAYNE93mwpfN7dzFndNbDjqPGDbyemvai95c8
2018-11-16 11:50:52.321 (3) [P8T1]: DistributionServiceRemoteClient created for GMB
2018-11-16 11:50:52.359 (3) [P8T1]: Retrieving GMB credentials for search engine user id : 3627 || client id : 627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com , client secret :uO1pQj_ihl6Jy1fSA7FzCTFE , refresh token : 1/fH9q5og0rO9LI5NBJqM4k_YTHb-0XSo2-Qv53oyo5a0
2018-11-16 11:50:52,360 [P8T1] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = ya29.Gl1WBmDRVdWpeRMlNwaRzEnM6N_3yzuGokS6rMDg1NkLoy2xkloYcDh-8z6Sid224yv6k2juU1lPvCYfp8upks4twuJrX3pfd4r1VCY2sFg2rDog9-gzWCcl5LEuk_Y for gmb (clientID=627054770038-n8balm8g191c2lu95qaks208j5orhbns.apps.googleusercontent.com)
2018-11-16 11:50:52,444 [pool-25-thread-3] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 41
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Fri, 16 Nov 2018 11:50:52 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-11-16 11:50:52,444 [pool-25-thread-3] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [56ae8271616744efa448d425e260cba8] status to [pause] for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:52,447 [pool-25-thread-3] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 42
Address: https://api.tigerpistol.com/v1/campaigns/56ae8271616744efa448d425e260cba8/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:52.533 (3) [P8T1]: (handleCampaigns - original targets) Network target found: GoogleSearch
2018-11-16 11:50:52.533 (3) [P8T1]: (handleCampaigns - original targets) Network target found: SearchNetwork
2018-11-16 11:50:52.599 (3) [P8T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-11-16 11:50:52.606 (3) [P8T1]: (handleCampaigns - original targets) Network target found: GoogleSearch
2018-11-16 11:50:52.606 (3) [P8T1]: (handleCampaigns - original targets) Network target found: SearchNetwork
2018-11-16 11:50:52.621 (3) [P8T1]: CampaignChangeRequest (accountID 2409): Sending 2 update requests
2018-11-16 11:50:52,826 [pool-25-thread-3] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 42
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Fri, 16 Nov 2018 11:50:52 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-11-16 11:50:52,827 [pool-25-thread-3] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [ef3eb076422249c8979560efb0b4e3c9] status to [pause] for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:52,830 [pool-25-thread-3] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 43
Address: https://api.tigerpistol.com/v1/campaigns/ef3eb076422249c8979560efb0b4e3c9/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:52,859 [P8T1] DEBUG c.g.a.a.c.l.u.l.A.ads_api_lib - Could not load optional configuration: ConfigurationInfo{location=ads.properties, isOptional=true}
2018-11-16 11:50:53,266 [pool-25-thread-3] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 43
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Fri, 16 Nov 2018 11:50:52 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-11-16 11:50:53,266 [pool-25-thread-3] INFO c.t.s.c.t.i.s.CampaignServiceClient - Updating TP campaign [d8cc375994454910b62da70cee69eb06] status to [pause] for account 4bf955aa25e04e96ac32da77129333b8
2018-11-16 11:50:53,269 [pool-25-thread-3] INFO o.a.c.i.LoggingOutInterceptor - Outbound Message
---------------------------
ID: 44
Address: https://api.tigerpistol.com/v1/campaigns/d8cc375994454910b62da70cee69eb06/pause
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json], Content-Type=[application/json], Authorization=[Token IcHjX0XyED53f6ShTWlqq4xbRXkEoiloVA1IXqtU]}
--------------------------------------
2018-11-16 11:50:53,736 [pool-25-thread-3] INFO o.a.c.i.LoggingInInterceptor - Inbound Message
----------------------------
ID: 44
Response-Code: 200
Encoding: ISO-8859-1
Content-Type:
Headers: {Content-Length=[0], Date=[Fri, 16 Nov 2018 11:50:53 GMT], Strict-Transport-Security=[max-age=31536000], X-Frame-Options=[SAMEORIGIN]}
--------------------------------------
2018-11-16 11:50:53,742 [pool-25-thread-3] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `elementName` IN ('3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1','3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2','3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3','3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4')
2018-11-16 11:50:53,743 [pool-25-thread-3] INFO c.t.s.client.tp.dao.TPErrorDAO - Removed '4' Previous Errors
2018-11-16 11:50:53,744 [pool-25-thread-3] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = '56ae8271616744efa448d425e260cba8', `campaigns`.`name`
= '3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '11/16/2018 11:50:52.036', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1","status":"Deleted","id":"56ae8271616744efa448d425e260cba8","customerId":"4bf955aa25e04e96ac32da77129333b8","objective":"page_likes","budget":6893,"start":"2018-08-29T12:10:44.244Z","maxEnd":"2018-11-16T11:50:52.036Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"region","id":"3844"}]}],"copies":[{"headline":"Find
a Bed & Breakfast","body":"Alaska B&B. We''ll Make Your Experience Perfect.","description":"Alaska
B&B Rooms","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-5.jpg"],"cta":[]}},"searchEngineUserId":3626}'
WHERE `campaigns`.`id` = 2028
2018-11-16 11:50:53,745 [pool-25-thread-3] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2028
2018-11-16 11:50:53,746 [pool-25-thread-3] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'd8cc375994454910b62da70cee69eb06', `campaigns`.`name`
= '3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '11/16/2018 11:50:52.036', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2","status":"Deleted","id":"d8cc375994454910b62da70cee69eb06","customerId":"4bf955aa25e04e96ac32da77129333b8","objective":"page_likes","budget":6893,"start":"2018-08-29T12:10:44.257Z","maxEnd":"2018-11-16T11:50:52.036Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"region","id":"3844"}]}],"copies":[{"headline":"Alaska
B&B Rooms","body":"Alaska B&B. We''ll Make Your Experience Perfect.","description":"Find a
Bed & Breakfast","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-4.jpg"],"cta":[]}},"searchEngineUserId":3626}'
WHERE `campaigns`.`id` = 2029
2018-11-16 11:50:53,748 [pool-25-thread-3] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2029
2018-11-16 11:50:53,752 [pool-25-thread-3] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'ef3eb076422249c8979560efb0b4e3c9', `campaigns`.`name`
= '3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '11/16/2018 11:50:52.036', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3","status":"Deleted","id":"ef3eb076422249c8979560efb0b4e3c9","customerId":"4bf955aa25e04e96ac32da77129333b8","objective":"page_likes","budget":6893,"start":"2018-08-29T12:10:44.264Z","maxEnd":"2018-11-16T11:50:52.036Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"region","id":"3844"}]}],"copies":[{"headline":"Luxury
Bed & Breakfast","body":"Alaska - B&B. You''ll Have a Great Stay Here!","description":"Alaska
B&B Room","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-3.jpg"],"cta":[]}},"searchEngineUserId":3626}'
WHERE `campaigns`.`id` = 2030
2018-11-16 11:50:53,764 [pool-25-thread-3] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2030
2018-11-16 11:50:53,772 [pool-25-thread-3] INFO jdbc.sqlonly - UPDATE `campaigns` SET `campaigns`.`tpId` = 'cef51fe9dcdf4398bde6b58cb81ff780', `campaigns`.`name`
= '3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4', `campaigns`.`status` = 'Deleted',
`campaigns`.`endDate` = '11/16/2018 11:50:52.036', `campaigns`.`lastUpdated` = NOW(), `campaigns`.`json`
= '{"campaign":{"name":"3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4","status":"Deleted","id":"cef51fe9dcdf4398bde6b58cb81ff780","customerId":"4bf955aa25e04e96ac32da77129333b8","objective":"page_likes","budget":6893,"start":"2018-08-29T12:10:44.272Z","maxEnd":"2018-11-16T11:50:52.036Z","placement":["desktopfeed","mobilefeed","instagramfeed","rightcolumn"],"details":{"audiences":[{"ageFrom":18,"ageTo":65,"gender":"all","locationTypes":["home","recent"],"demographics":{"behaviors":["6002714895372"],"interests":["6002926108721"]},"locations":[{"type":"region","id":"3844"}]}],"copies":[{"headline":"Alaska
B&B Room","body":"Alaska - B&B. You''ll Have a Great Stay Here!","description":"Luxury Bed
& Breakfast","destinationUrl":"http://www.merchantsite.com/"}],"images":["https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-2.jpg"],"cta":[]}},"searchEngineUserId":3626}'
WHERE `campaigns`.`id` = 2031
2018-11-16 11:50:53,773 [pool-25-thread-3] INFO jdbc.sqlonly - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`id` = 2031
2018-11-16 11:50:53.792 (3) [pool-25-thread-3]: Completed Facebook Update Campaign Worker..
2018-11-16 11:50:54,009 [P8T1] INFO c.g.a.a.a.l.c.A.requestInfoLogger - Request made: Service: CampaignService Method: mutate clientCustomerId: 4338893417 URL: https://adwords.google.com/api/adwords/cm/v201802/CampaignService Request ID: 00057ac6c78d9fb00a370615ee03e97c ResponseTime(ms): 234 OperationsCount: 2 IsFault: false FaultMessage: null
2018-11-16 11:50:54,120 [P8T1] DEBUG c.g.a.a.a.l.c.A.soapXmlLogger - SOAP request:
4338893417
REDACTED
AML QA4 (AwApi-Java, AdWords-Axis/3.14.1, Common-Java/3.14.1, Axis/1.4, Java/1.8.0_144, maven)
false
false
SET
1533336661
REMOVED
20371230
SET
1533336664
REMOVED
20371230
2018-11-16 11:50:54,121 [P8T1] DEBUG c.g.a.a.a.l.c.A.soapXmlLogger - SOAP response:
00057ac6c78d9fb00a370615ee03e97c
CampaignService
mutate
2
234
CampaignReturnValue
1533336661
3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GT
REMOVED
NONE
20180829
20371230
1588376117
3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GT
Money
10000
STANDARD
true
ENABLED
false
CAMPAIGN_IS_NOT_ACTIVE
CONVERSION_TRACKING_NOT_ENABLED
OPTIMIZE
GeoTargetTypeSetting
DONT_CARE
DONT_CARE
SEARCH
true
false
false
false
MANUAL_CPC
ManualCpcBiddingScheme
false
BASE
1533336661
1533336664
3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GM
REMOVED
NONE
20180829
20371230
1588376297
3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GM
Money
10000
STANDARD
true
ENABLED
false
CAMPAIGN_IS_NOT_ACTIVE
CONVERSION_TRACKING_NOT_ENABLED
OPTIMIZE
GeoTargetTypeSetting
DONT_CARE
DONT_CARE
SEARCH
true
false
false
false
MANUAL_CPC
ManualCpcBiddingScheme
false
BASE
1533336664
2018-11-16 11:50:54.151 (2) [P8T1]: Unexpected deleted status returned by api. should delete campaign
2018-11-16 11:50:54.152 (2) [P8T1]: Unexpected deleted status returned by api. should delete campaign
2018-11-16 11:50:54.154 (3) [P8T1]: CampaignDAO(accountID 2409) Request contained 0 adds, 2 updates, 0 deletes.
2018-11-16 11:50:54.154 (3) [P8T1]: CampaignDAO(accountID 2409) DB updates: 2 items updated, 2 pending changes deleted, 2 pending updates deleted, 0 errors cleared
2018-11-16 11:50:54.168 (3) [P8T1]: ... SEUser 3627 finished
2018-11-16 11:50:54.169 (3) [pool-25-thread-1]: ------------Google Content Editor done
2018-11-16 11:50:54.176 (3) [pool-25-thread-1]: Completed Google Update Campaign Worker..
2018-11-16 11:50:54,717 [pool-25-thread-2] INFO o.a.c.w.s.f.ReflectionServiceFactoryBean - Creating Service {https://bingads.microsoft.com/CampaignManagement/v12}CampaignManagementService from class com.microsoft.bingads.v12.campaignmanagement.ICampaignManagementService
2018-11-16 11:50:55,059 [pool-25-thread-2] INFO o.a.c.s.C.I.ICampaignManagementService - Outbound Message
---------------------------
ID: 45
Address: https://campaign.api.bingads.microsoft.com/Api/Advertiser/CampaignManagement/v12/CampaignManagementService.svc
Encoding: UTF-8
Http-Method: POST
Content-Type: text/xml
Headers: {Accept=[*/*], SOAPAction=[DeleteCampaigns]}
Payload: EwAYA3hlBAAUS26g+KHGWHId2M6BBkwqoP+OSdAAARaNKPbVB+MPwNoM3sjzKM3gkMXBNW/rhEMSjL7kCJNmuVt1wFJscdRUV2qgZq7CsgfV1lbi1zRFbN6iZ7wKfqmpKyM7kHZ5fB0xD6iKllr1pMEUTr/L7bdly/ln+tG+dDE0LyO3ekHna7Ud2kju9QAVIPOiKgq7JuglWjk//ZieNXT4KrPn65LaArWGwXMKe6FSQrHiXNh8yv+nsyhkIWc2JrlFP8zl5JdMlhVnQyJoIzt7jWw1wre2aItmUQ+PU7IdG4fS12NDHvRMQJR4prMRnwfoR1GUD0rN7m9wWkgK/DYiSy50eWoqJ9XFLLlwi3rD5X19aj/m4ThIYtr+65gDZgAACAIV8Xgyok7S6AH6YPi3EmuDBs2aqY9xS9fmv77stXwgYHAIOvafr+9ygzG1tza9INbmo+aprHPOGBIaf0ibJFlofjqpqQQTIMJZPzLZAyd7tKZ8pcoEHDL6S8ZIGBRtBjKWuCErOslU7il/k50Z8MvCTfk4+nCTT7K6nNfD78w7jlQQtge30uAp4F9Hlz676KAbxCHpNAG8yJjYhz/fV8wy7smZNHzG/iZX1DkGvJJsZuWV7r5UEX4ywwHO3Kd5ZM9YXNN5wuOjF23q8tjGxlhKNdvbpcz8XyOB3qsBpA60zX0bVJCg2/bgpfTH9N2aA0jH4n0W1gpwpwobmxcu9cfHmTCoKJvHllzHfW2rkHygUP+3U7s680RR7ST87do6MDlteRhE+K4Vqf0M79pPYK1iy0Z0KxujBG/eh/9tmvYf3vyyB/0sT3Ap2llylosn+kQ18EeNM2KuFC97FSdTrc2Lk5n+ZXrCmBmqu7qcP6/oxt0CC8YZtd6iy+55WmZaFsst4IZS2aDx+42XgGh0Ke2hHptU4ZcKdsMKI4R/nUcUGnl9dPkSVBibeNwgOGiPWStOsWQIiZrjRXyt7cJgjz6frPlFjb5fRLfPaau46vYQzC6U1olX9FzAeTtbrcMWuYQjoxhDWVkpvUUEElx0gZ9GeR4C149152996250120822DN8ELHL3149152996350546758350546759
--------------------------------------
2018-11-16 11:50:55,265 [pool-25-thread-2] INFO o.a.c.s.C.I.ICampaignManagementService - Inbound Message
----------------------------
ID: 45
Response-Code: 200
Encoding: UTF-8
Content-Type: text/xml; charset=utf-8
Headers: {Cache-Control=[private], Content-Length=[423], content-type=[text/xml; charset=utf-8], Date=[Fri, 16 Nov 2018 11:50:54 GMT], Server=[Microsoft-IIS/10.0], X-AspNet-Version=[4.0.30319], X-Powered-By=[ASP.NET]}
Payload: 010b6484-0731-4995-b70d-f28f15bb384a
--------------------------------------
2018-11-16 11:50:55,317 [pool-25-thread-2] INFO c.t.s.c.b.i.s.CampaignServiceClient - Successfully deleted 2/2 Bing campaigns from account 149152996
2018-11-16 11:50:55,317 [pool-25-thread-2] INFO jdbc.sqlonly - DELETE FROM `errors` WHERE `campaignName` IN ('3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GT','3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GM')
2018-11-16 11:50:55,319 [pool-25-thread-2] INFO c.t.s.client.bing.dao.BingErrorDAO - Removed '0' Previous Errors
2018-11-16 11:50:55,319 [pool-25-thread-2] INFO jdbc.sqlonly - DELETE FROM `campaigns` WHERE `campaigns`.`id` = 4966
2018-11-16 11:50:55,320 [pool-25-thread-2] INFO jdbc.sqlonly - DELETE FROM `campaigns` WHERE `campaigns`.`id` = 4967
2018-11-16 11:50:55.322 (3) [pool-25-thread-2]: Completed Bing Update Campaign Worker..
2018-11-16 11:50:55.326 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1 status updated to Deleted
2018-11-16 11:50:55.328 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2 status updated to Deleted
2018-11-16 11:50:55.329 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3 status updated to Deleted
2018-11-16 11:50:55.330 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4 status updated to Deleted
2018-11-16 11:50:55.332 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GT status updated to Deleted
2018-11-16 11:50:55.333 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GM status updated to Deleted
2018-11-16 11:50:55.334 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GT status updated to Deleted
2018-11-16 11:50:55.336 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GM status updated to Deleted
2018-11-16 11:50:55.336 (3) [pool-3-thread-4]: Campaign structure sync not enabled for this request.
2018-11-16 11:50:55,338 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4966)
2018-11-16 11:50:55.340 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.340 (3) [pool-3-thread-4]: 25373_GT has no applicable GCE errors.
2018-11-16 11:50:55,342 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (4967)
2018-11-16 11:50:55.344 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.344 (3) [pool-3-thread-4]: 25373_GM has no applicable GCE errors.
2018-11-16 11:50:55.352 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.352 (3) [pool-3-thread-4]: 25374_GT has no applicable GCE errors.
2018-11-16 11:50:55.365 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.365 (3) [pool-3-thread-4]: 25374_GM has no applicable GCE errors.
2018-11-16 11:50:55,369 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (2028)
2018-11-16 11:50:55.371 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.371 (3) [pool-3-thread-4]: 25372_S1 has no applicable GCE errors.
2018-11-16 11:50:55,374 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (2029)
2018-11-16 11:50:55.376 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.376 (3) [pool-3-thread-4]: 25372_S2 has no applicable GCE errors.
2018-11-16 11:50:55,379 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (2030)
2018-11-16 11:50:55.382 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.382 (3) [pool-3-thread-4]: 25372_S3 has no applicable GCE errors.
2018-11-16 11:50:55,385 [pool-3-thread-4] INFO jdbc.sqlonly - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`elementName` = `campaigns`.`name`
WHERE `campaigns`.`id` IN (2031)
2018-11-16 11:50:55.387 (3) [pool-3-thread-4]: Ignoring 0 other operation errors for deleted campaign.
2018-11-16 11:50:55.387 (3) [pool-3-thread-4]: 25372_S4 has no applicable GCE errors.
2018-11-16 11:50:55.388 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S1: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.389 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S2: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.389 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S3: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.390 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25372_S4: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.391 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GM: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.391 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25373_GT: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.392 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GM: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.393 (3) [pool-3-thread-4]: Finished UPDATE request for campaign 3c7e571f-6cd9-444d-b157-0272cc20255a_10004_49_25374_GT: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.393 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a has 0 campaigns for a SE Update accounts sync.
2018-11-16 11:50:55.393 (3) [pool-3-thread-4]: 3c7e571f-6cd9-444d-b157-0272cc20255a has 0 campaigns for a SE Update groups-listings sync.
2018-11-16 11:50:55.393 (3) [pool-3-thread-4]: Finished sub-campaign processing for UPDATE deploymentID (08f029db-dc10-4f9c-bc3b-7106b88803a4). account 3c7e571f-6cd9-444d-b157-0272cc20255a. 8 submitted, 8 ok.
2018-11-16 11:50:55.395 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 25372
2018-11-16 11:50:55.396 (3) [pool-3-thread-4]: Finished UPDATE request for 25372: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.396 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 25373
2018-11-16 11:50:55.396 (3) [pool-3-thread-4]: Finished UPDATE request for 25373: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.396 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: 25374
2018-11-16 11:50:55.397 (3) [pool-3-thread-4]: Finished UPDATE request for 25374: SUCCEEDED (merchant: 3c7e571f-6cd9-444d-b157-0272cc20255a)
2018-11-16 11:50:55.397 (3) [pool-3-thread-4]: Finished UPDATE request, deploymentID (08f029db-dc10-4f9c-bc3b-7106b88803a4), account 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:55.397 (3) [pool-3-thread-4]: Request removed from map for customerID 3c7e571f-6cd9-444d-b157-0272cc20255a
2018-11-16 11:50:55.512 (3) [AdMaxListener]: Sent message to response queue.