2015-11-03 07:44:41.700 (3) [pool-4-thread-2]: No new jobs to execute for type: [4] 2015-11-03 07:44:43.692 (3) [pool-4-thread-1]: No new jobs to execute for type: [6] 2015-11-03 07:45:09.728 (3) [Thread-9]: Heartbeat #121 (1446536709720) received in 0.008s 2015-11-03 07:45:14.708 (3) [Thread-9]: Heartbeat #121 (1446536559720) received in 2m 34.987s 2015-11-03 07:45:14.713 (3) [Thread-9]: Heartbeat #121 (1446536589720) received in 2m 4.992s 2015-11-03 07:45:14.716 (3) [Thread-9]: Heartbeat #121 (1446536649720) received in 1m 4.996s 2015-11-03 07:45:39.727 (3) [Thread-9]: Heartbeat #122 (1446536739720) received in 0.007s 2015-11-03 07:46:09.725 (3) [Thread-9]: Heartbeat #123 (1446536769720) received in 0.005s 2015-11-03 07:46:39.726 (3) [Thread-9]: Heartbeat #124 (1446536799720) received in 0.006s 2015-11-03 07:47:09.725 (3) [Thread-9]: Heartbeat #125 (1446536829720) received in 0.005s 2015-11-03 07:47:39.728 (3) [Thread-9]: Heartbeat #126 (1446536859720) received in 0.008s 2015-11-03 07:48:09.726 (3) [Thread-9]: Heartbeat #127 (1446536889720) received in 0.006s 2015-11-03 07:48:39.726 (3) [Thread-9]: Heartbeat #128 (1446536919720) received in 0.006s 2015-11-03 07:49:09.726 (3) [Thread-9]: Heartbeat #129 (1446536949720) received in 0.006s 2015-11-03 07:49:39.727 (3) [Thread-9]: Heartbeat #130 (1446536979720) received in 0.007s 2015-11-03 07:50:09.726 (3) [Thread-9]: Heartbeat #131 (1446537009720) received in 0.006s 2015-11-03 07:50:39.726 (3) [Thread-9]: Heartbeat #132 (1446537039720) received in 0.006s 2015-11-03 07:51:09.726 (3) [Thread-9]: Heartbeat #133 (1446537069720) received in 0.006s 2015-11-03 07:51:39.725 (3) [Thread-9]: Heartbeat #134 (1446537099720) received in 0.005s 2015-11-03 07:51:42.134 (3) [Thread-9]: Request added to map for customerID 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:51:42.135 (3) [Thread-9]: Request worker created for 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:51:42.136 (3) [Thread-9]: Submitted executor job for 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:51:42.148 (3) [pool-3-thread-7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2015-11-03 07:51:42.150 (3) [pool-3-thread-7]: 09bd2350-824a-4efe-84f3-31c74edfdbdc is a new account. 2015-11-03 07:51:42.150 (3) [pool-3-thread-7]: Creating new tsa account: 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:51:42.306 (3) [pool-3-thread-7]: 09bd2350-824a-4efe-84f3-31c74edfdbdc has been assigned accountID 1027 2015-11-03 07:51:42.354 (3) [pool-3-thread-7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2015-11-03 07:51:42.362 (3) [pool-3-thread-7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2015-11-03 07:51:42.364 (3) [pool-3-thread-7]: Updating deployment status to 'InProgress' for campaignID: 4475 2015-11-03 07:51:42.365 (3) [pool-3-thread-7]: 4475 has no parent. Creating... 2015-11-03 07:51:42.368 (3) [pool-3-thread-7]: Updating advert budget for 09bd2350-824a-4efe-84f3-31c74edfdbdc_10135_44_4475 2015-11-03 07:51:42.375 (3) [pool-3-thread-7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2015-11-03 07:51:42.385 (3) [pool-3-thread-7]: Start processing DEPLOY request (d2f1a419-bbac-4bf9-880d-ed2dece5c908) for account 09bd2350-824a-4efe-84f3-31c74edfdbdc. 2 campaign(s). 2015-11-03 07:51:42.385 (3) [pool-3-thread-7]: Performing sync for account: 09bd2350-824a-4efe-84f3-31c74edfdbdc ID#1027 2015-11-03 07:51:42.392 (3) [pool-3-thread-7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2015-11-03 07:51:42.399 (3) [pool-3-thread-7]: Converted proximity target: latitude: 40.00069 longitude: -102.7232 radius: 270000 Converted lat: 40.00069046020508 lon: -102.72319793701172 radius unit: kilometers radius: 270.0 2015-11-03 07:51:42.399 (3) [pool-3-thread-7]: Converted proximity target: latitude: 40.00069 longitude: -108.18291 radius: 270000 Converted lat: 40.00069046020508 lon: -108.18290710449219 radius unit: kilometers radius: 270.0 2015-11-03 07:51:42.399 (3) [pool-3-thread-7]: Converted proximity target: latitude: 38.99793 longitude: -104.67355 radius: 472000 Converted lat: 38.997928619384766 lon: -104.67355346679688 radius unit: kilometers radius: 472.0 2015-11-03 07:51:42.399 (3) [pool-3-thread-7]: Converted proximity target: latitude: 38.99793 longitude: -106.42823 radius: 472000 Converted lat: 38.997928619384766 lon: -106.42823028564453 radius unit: kilometers radius: 472.0 2015-11-03 07:51:42.400 (3) [pool-3-thread-7]: Converted proximity target: latitude: 37.99518 longitude: -102.7232 radius: 270000 Converted lat: 37.99517822265625 lon: -102.72319793701172 radius unit: kilometers radius: 270.0 2015-11-03 07:51:42.400 (3) [pool-3-thread-7]: Converted proximity target: latitude: 37.99518 longitude: -108.18291 radius: 270000 Converted lat: 37.99517822265625 lon: -108.18290710449219 radius unit: kilometers radius: 270.0 2015-11-03 07:51:42.400 (3) [pool-3-thread-7]: Call data found: 310-582-5700 2015-11-03 07:51:42.400 (3) [pool-3-thread-7]: Location data found: 2015-11-03 07:51:42.400 (3) [pool-3-thread-7]: Site Link found: Testlink1/http://www.merchantsite.com/ 2015-11-03 07:51:42.400 (3) [pool-3-thread-7]: Site Link found: Testlink2/http://www.google.com 2015-11-03 07:51:42.402 (3) [pool-3-thread-7]: Call data found: 310-582-5700 2015-11-03 07:51:42.402 (3) [pool-3-thread-7]: Location data found: 2015-11-03 07:51:42.402 (3) [pool-3-thread-7]: Site Link found: Testlink1/http://www.merchantsite.com/ 2015-11-03 07:51:42.402 (3) [pool-3-thread-7]: Site Link found: Testlink2/http://www.google.com 2015-11-03 07:51:42.412 (3) [pool-3-thread-7]: 0 campaign(s) to update. 2015-11-03 07:51:42.412 (3) [pool-3-thread-7]: 2 campaign(s) to create. 2015-11-03 07:51:42.412 (3) [pool-3-thread-7]: 0 campaign(s) to retry and update. 2015-11-03 07:51:42.414 (3) [pool-3-thread-7]: 09bd2350-824a-4efe-84f3-31c74edfdbdc has 2 new campaign(s) for Bing. 2015-11-03 07:51:42.414 (3) [pool-3-thread-7]: 09bd2350-824a-4efe-84f3-31c74edfdbdc requires 1 new users for Bing. 2015-11-03 07:51:42,417 [pool-3-thread-7] INFO o.s.c.s.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@4d7f28ee: startup date [Tue Nov 03 07:51:42 UTC 2015]; root of context hierarchy 2015-11-03 07:51:42,417 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [bing-main-spring-config.xml] 2015-11-03 07:51:42,511 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.0-SNAPSHOT-dev-t20151030095440/libs/deployment-bidmgr-shaded-jar-2.9.0-SNAPSHOT.jar!/bing/bing-datasource-configuration.xml] 2015-11-03 07:51:42,542 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.0-SNAPSHOT-dev-t20151030095440/libs/deployment-bidmgr-shaded-jar-2.9.0-SNAPSHOT.jar!/bing/bing-service-component-configuration.xml] 2015-11-03 07:51:42,560 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.0-SNAPSHOT-dev-t20151030095440/libs/deployment-bidmgr-shaded-jar-2.9.0-SNAPSHOT.jar!/dao/bing-campaign-structure-dao-configuration.xml] 2015-11-03 07:51:42,582 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.0-SNAPSHOT-dev-t20151030095440/libs/deployment-bidmgr-shaded-jar-2.9.0-SNAPSHOT.jar!/dao/bing-error-dao-configuration.xml] 2015-11-03 07:51:42,609 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.0-SNAPSHOT-dev-t20151030095440/libs/deployment-bidmgr-shaded-jar-2.9.0-SNAPSHOT.jar!/bing/bing-client-factory-configuration.xml] 2015-11-03 07:51:42,624 [pool-3-thread-7] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/bidmgr-distribution-2.9.0-SNAPSHOT-dev-t20151030095440/libs/deployment-bidmgr-shaded-jar-2.9.0-SNAPSHOT.jar!/bing/bing-get-campaign-list-configuration.xml] 2015-11-03 07:51:42,734 [pool-3-thread-7] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [bing/bing-datasource.properties] 2015-11-03 07:51:42,736 [pool-3-thread-7] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [bing/bing-datasource-overrides.properties] 2015-11-03 07:51:42,736 [pool-3-thread-7] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [bing/bing-datasource-overrides.properties]: class path resource [bing/bing-datasource-overrides.properties] cannot be opened because it does not exist 2015-11-03 07:51:42,741 [pool-3-thread-7] INFO o.s.b.f.s.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@595b443e: defining beans [bing-datasource-property-configurer,bing-target-datasource,bing-datasource,bing-transaction-manager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,bing-campaign-structure-dao,bing-error-dao,bing-campaign-service-component,bing-client-factory,getBingCampaignList]; root of factory hierarchy 2015-11-03 07:51:42.767 (3) [pool-3-thread-7]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2015-11-03 07:51:42.768 (2) [pool-3-thread-7]: Error: CampID: 4475_GT Info: Error during add campaigns request. 2015-11-03 07:51:42.768 (2) [pool-3-thread-7]: Error: CampID: 4475_GM Info: Error during add campaigns request. 2015-11-03 07:51:42.769 (1) [pool-3-thread-7]: Exception [Error during add campaigns request. ]:java.lang.NullPointerException at com.thesearchagency.searchengines.bing.BingApiUtils.(BingApiUtils.java:68) at com.thesearchagency.searchengines.bing.BingAccountDeployer.(BingAccountDeployer.java:126) at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.createDeployers(MultiplexAccountDeployer.java:143) at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.getDeployers(MultiplexAccountDeployer.java:116) at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.getAccountCreatorFactory(MultiplexAccountDeployer.java:440) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.createSEUsers(SearchEngineUserWorker.java:210) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.manageSearchEngineUsersByDistribution(SearchEngineUserWorker.java:183) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.manageSearchEngineUsers(SearchEngineUserWorker.java:99) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.call(SearchEngineUserWorker.java:76) at com.thesearchagency.admaxlistener.worker.AccountWorker.createCampaigns(AccountWorker.java:450) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:407) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:151) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:446) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:96) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 2015-11-03 07:51:42.770 (3) [pool-3-thread-7]: Finished DEPLOY request for campaign 09bd2350-824a-4efe-84f3-31c74edfdbdc_10135_44_4475_GT: FAILED (merchant: 09bd2350-824a-4efe-84f3-31c74edfdbdc) 2015-11-03 07:51:42.770 (3) [pool-3-thread-7]: Finished DEPLOY request for campaign 09bd2350-824a-4efe-84f3-31c74edfdbdc_10135_44_4475_GM: FAILED (merchant: 09bd2350-824a-4efe-84f3-31c74edfdbdc) 2015-11-03 07:51:42.770 (3) [pool-3-thread-7]: 09bd2350-824a-4efe-84f3-31c74edfdbdc has 0 campaigns for a SE Update accounts sync. 2015-11-03 07:51:42.770 (3) [pool-3-thread-7]: 09bd2350-824a-4efe-84f3-31c74edfdbdc has 0 campaigns for a SE Update groups-listings sync. 2015-11-03 07:51:42.771 (3) [pool-3-thread-7]: Finished sub-campaign processing for DEPLOY deploymentID (d2f1a419-bbac-4bf9-880d-ed2dece5c908). account 09bd2350-824a-4efe-84f3-31c74edfdbdc. 2 submitted, 0 ok. 2015-11-03 07:51:42.772 (3) [pool-3-thread-7]: Updating deployment status to 'Failure' for campaignID: 4475 2015-11-03 07:51:42.772 (3) [pool-3-thread-7]: Finished DEPLOY request for 09bd2350-824a-4efe-84f3-31c74edfdbdc_10135_44_4475: FAILED (merchant: 09bd2350-824a-4efe-84f3-31c74edfdbdc) 2015-11-03 07:51:42.773 (3) [pool-3-thread-7]: Finished DEPLOY request, deploymentID (d2f1a419-bbac-4bf9-880d-ed2dece5c908), account 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:51:42.773 (3) [pool-3-thread-7]: Request removed from map for customerID 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:51:42.823 (3) [AdMaxListener]: Sent message to response queue. 2015-11-03 07:52:09.729 (3) [Thread-9]: Heartbeat #135 (1446537129720) received in 0.009s 2015-11-03 07:52:38.192 (3) [Thread-9]: Request added to map for customerID 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:52:38.192 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-8a34252b-7a56-4e0b-9445-9fb83969eba7 2015-11-03 07:52:38.192 (3) [Thread-9]: Request worker created for 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:52:38.192 (3) [Thread-9]: Submitted executor job for 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:52:38.198 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-8a34252b-7a56-4e0b-9445-9fb83969eba7 out of queue 2015-11-03 07:52:38.231 (3) [pool-3-thread-7]: Updating deployment status to 'InProgress' for campaignID: 4475 2015-11-03 07:52:38.234 (2) [pool-3-thread-7]: CampaignID: 4475: Update message (d2f1a419-bbac-4bf9-880d-ed2dece5c908) for account 09bd2350-824a-4efe-84f3-31c74edfdbdc contains updates for child campaigns that haven't been created yet. Advert 4475 2015-11-03 07:52:38.234 (2) [pool-3-thread-7]: Exception [Campaign request failed for accountID 1027.]:com.thesearchagency.admaxlistener.exception.AdMaxException: Update message (d2f1a419-bbac-4bf9-880d-ed2dece5c908) for account 09bd2350-824a-4efe-84f3-31c74edfdbdc contains updates for child campaigns that haven't been created yet. Advert 4475 at com.thesearchagency.admaxlistener.worker.RequestWorker.handleCampaign(RequestWorker.java:712) at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:835) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:407) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:96) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 2015-11-03 07:52:38.234 (1) [pool-3-thread-7]: No valid campaigns to process for 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:52:38.235 (3) [pool-3-thread-7]: Updating deployment status to 'Failure' for campaignID: 4475 2015-11-03 07:52:38.236 (3) [pool-3-thread-7]: Finished UPDATE request for 4475: FAILED (merchant: 09bd2350-824a-4efe-84f3-31c74edfdbdc) 2015-11-03 07:52:38.236 (3) [pool-3-thread-7]: Finished UPDATE request, deploymentID (d2f1a419-bbac-4bf9-880d-ed2dece5c908), account 09bd2350-824a-4efe-84f3-31c74edfdbdc 2015-11-03 07:52:38.237 (3) [pool-3-thread-7]: Request removed from map for customerID 09bd2350-824a-4efe-84f3-31c74edfdbdc