2017-04-05 10:22:43.526 (3) [Thread-9]: Request added to map for customerID bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:22:43.526 (3) [Thread-9]: Request worker created for bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:22:43.526 (3) [Thread-9]: Submitted executor job for bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:22:43.534 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-04-05 10:22:43.536 (3) [pool-3-thread-8]: bce67ee4-d8b4-4144-8615-44d14f999bdb is a new account. 2017-04-05 10:22:43.537 (3) [pool-3-thread-8]: Creating new tsa account: bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:22:43.634 (3) [pool-3-thread-8]: bce67ee4-d8b4-4144-8615-44d14f999bdb has been assigned accountID 2036 2017-04-05 10:22:43.679 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-04-05 10:22:43.686 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-04-05 10:22:43.688 (3) [pool-3-thread-8]: Updating deployment status to 'InProgress' for campaignID: 13955 2017-04-05 10:22:43.689 (3) [pool-3-thread-8]: 13955 has no parent. Creating... 2017-04-05 10:22:43.692 (3) [pool-3-thread-8]: Updating advert budget for bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13955 2017-04-05 10:22:43.698 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-04-05 10:22:43.708 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-04-05 10:22:43.711 (3) [pool-3-thread-8]: Updating deployment status to 'InProgress' for campaignID: 13956 2017-04-05 10:22:43.712 (3) [pool-3-thread-8]: 13956 has no parent. Creating... 2017-04-05 10:22:43.715 (3) [pool-3-thread-8]: Updating advert budget for bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13956 2017-04-05 10:22:43.728 (3) [pool-3-thread-8]: Start processing DEPLOY request (bf04b9e5-d09d-4ef7-9266-af39a7fbe445) for account bce67ee4-d8b4-4144-8615-44d14f999bdb. 4 campaign(s). 2017-04-05 10:22:43.729 (3) [pool-3-thread-8]: Performing sync for account: bce67ee4-d8b4-4144-8615-44d14f999bdb ID#2036 2017-04-05 10:22:43.735 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2017-04-05 10:22:43.741 (3) [pool-3-thread-8]: 0 campaign(s) to update. 2017-04-05 10:22:43.741 (3) [pool-3-thread-8]: 4 campaign(s) to create. 2017-04-05 10:22:43.741 (3) [pool-3-thread-8]: 0 campaign(s) to retry and update. 2017-04-05 10:22:43.744 (3) [pool-3-thread-8]: bce67ee4-d8b4-4144-8615-44d14f999bdb has 2 new campaign(s) for Bing. 2017-04-05 10:22:43.744 (3) [pool-3-thread-8]: bce67ee4-d8b4-4144-8615-44d14f999bdb requires 1 new users for Bing. 2017-04-05 10:22:43,850 [pool-3-thread-8] DEBUG c.t.searchengines.bing.BingApiUtils - Getting Bing properties using distribution service 2017-04-05 10:22:43.943 (3) [pool-3-thread-8]: Retrieving credentials : client id : 869cad8e-f7c6-4854-b1bb-4f7955d142c3 , client secret :YZpgReOeKSmN3uEvwdvpumW , refresh token : MCbtuwgJYfIwjSF5tzKkxZOTA1Df7xJIDCAPORkwL1OlVHCg36JuxYDxL9XmKks44w!IBdaxt!TlVGOZIAztYYoPIkPupslFkaYDBdUV4hHFklXLhvryrGdwj01JgVw36vVPGkvLxvNWz5hdh2OFP44f!cEBqGFQtWO4MkuXtzSvYBCwE8qyDtWtmvmAs5LXKePW1ec8ifYQfz0Y0YysdtJ*wa9YYGT37SIptAasLVETnFvfpqRjOyDElqP1BVYfrFuPL2Sgh9hiNR1qe6!iLa0CvXrX6OJeK6E7QG63av93KNhzoxNYAt3fi5w2IQ0JNQZp2FIn2sF4eVet7uT2Dp1g$ 2017-04-05 10:22:43,943 [pool-3-thread-8] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Getting new access token 2017-04-05 10:22:44,415 [pool-3-thread-8] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Return OAuth credential. Access token = EwAQA3hlBAAUgdQjroa0siFqrG5FNB4+4uqtlVkAARfLlUHTM4yi4RZUSXo6B2jI+x4++U9xUZLdS1VPVS8KgQ06gG0UKka5yeJV6JQWy5egXtSX8cKO1QctY3OGuesZcE//NMRRVAWxTO9MmpbUHetmPQvh+G0tR9Kf+3u2UsKcascAcaR50xapcMEAztFqm9mMBIkw8fIm4joo83wOeNG0mCy/Exoa1y82OuenA69rYb+DXAhCu/b3qymYDQw8kRqLJH+NA22jhQ4O57z702nT9PoQoW1qG+dDg3+tlAI0jE/rrckelJ5G544FMm6abAaGkNwXEEWfUdQv2neUTvRq8XHv5ciDCIIKgGq5Q0WJpshBbNI8pEquzmJd00wDZgAACEh7DvOPPhGL4AECXzdi0EjFTQS42NGAgn1SAtQMOdlJranEURDdaa0FcTafIKiV4+VX08i9HiuGNB+ZVqygKnJrP6wToYABlgylyP6NXRoisG4x35a/+1a6/HU4AhaXPKra65pB7dqgu1EK/bhMcL8EH6QJp+7M3TFLHZg6SCPzeazKIir2LaOyg06cZuYHakbHYOqUeZbr1pGu2HNRmLkahQAhb3/+nE7Ma4wyY+Ay6RPguKshWi6JXyVS4o5kIIPyBI1Kj5T6zYwmH/rMvCnQxa2cD42qnZutRNmT/gjl6b6kpIa1YByYM6y/F0zeMLrl0mcIBqxBocPjwiilnzjEN9XzWfWZheV143zOEt2nFnUzya9rZ2I+iqtA9AvFAGSJkboxddiq27RUfVmQBmoCVrYZktTtFBCUhUPOueSKAyaZKPlfUzXx9dgJHt39GCOmUsbBMjEHfsmx9JG0AS5QX0bey+ye4Ctof/PLlxSh4WFacWHJ3pbwXFfnVA6jWw1flMJhVSZ4MDe/3s/YsQVfVm3xY+d3TnybZmpfp+yuoOAiMMnWj5G2w6nJVM4NrQW/FtoC2jVETO0PjhB0RbgdyGuBYK08WzWKu4led2uUUx8+/WqxdUe498LBSer1qo+2nPxydyyqweIMAg== for bing (clientID=869cad8e-f7c6-4854-b1bb-4f7955d142c3) 2017-04-05 10:22:44.415 (3) [pool-3-thread-8]: [oauth] Returning access token from OAuth service: EwAQA3hlBAAUgdQjroa0siFqrG5FNB4+4uqtlVkAARfLlUHTM4yi4RZUSXo6B2jI+x4++U9xUZLdS1VPVS8KgQ06gG0UKka5yeJV6JQWy5egXtSX8cKO1QctY3OGuesZcE//NMRRVAWxTO9MmpbUHetmPQvh+G0tR9Kf+3u2UsKcascAcaR50xapcMEAztFqm9mMBIkw8fIm4joo83wOeNG0mCy/Exoa1y82OuenA69rYb+DXAhCu/b3qymYDQw8kRqLJH+NA22jhQ4O57z702nT9PoQoW1qG+dDg3+tlAI0jE/rrckelJ5G544FMm6abAaGkNwXEEWfUdQv2neUTvRq8XHv5ciDCIIKgGq5Q0WJpshBbNI8pEquzmJd00wDZgAACEh7DvOPPhGL4AECXzdi0EjFTQS42NGAgn1SAtQMOdlJranEURDdaa0FcTafIKiV4+VX08i9HiuGNB+ZVqygKnJrP6wToYABlgylyP6NXRoisG4x35a/+1a6/HU4AhaXPKra65pB7dqgu1EK/bhMcL8EH6QJp+7M3TFLHZg6SCPzeazKIir2LaOyg06cZuYHakbHYOqUeZbr1pGu2HNRmLkahQAhb3/+nE7Ma4wyY+Ay6RPguKshWi6JXyVS4o5kIIPyBI1Kj5T6zYwmH/rMvCnQxa2cD42qnZutRNmT/gjl6b6kpIa1YByYM6y/F0zeMLrl0mcIBqxBocPjwiilnzjEN9XzWfWZheV143zOEt2nFnUzya9rZ2I+iqtA9AvFAGSJkboxddiq27RUfVmQBmoCVrYZktTtFBCUhUPOueSKAyaZKPlfUzXx9dgJHt39GCOmUsbBMjEHfsmx9JG0AS5QX0bey+ye4Ctof/PLlxSh4WFacWHJ3pbwXFfnVA6jWw1flMJhVSZ4MDe/3s/YsQVfVm3xY+d3TnybZmpfp+yuoOAiMMnWj5G2w6nJVM4NrQW/FtoC2jVETO0PjhB0RbgdyGuBYK08WzWKu4led2uUUx8+/WqxdUe498LBSer1qo+2nPxydyyqweIMAg== 2017-04-05 10:22:44.559 (1) [pool-3-thread-8]: Exception [Error saving record]:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bce67ee4' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1899) at com.carldunham.jst.db.Database.executeUpdate(Database.java:412) at com.carldunham.jst.db.BaseDatabaseTable.insert(BaseDatabaseTable.java:345) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:484) at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:418) at com.thesearchagency.admaxlistener.dao.TSACommonDAO.createSearchEngineUser(TSACommonDAO.java:483) at com.thesearchagency.admaxlistener.deployer.accountcreation.AccountCreatorFactory.assignSEUser(AccountCreatorFactory.java:18) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.createSEUsers(SearchEngineUserWorker.java:220) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.manageSearchEngineUsersByDistribution(SearchEngineUserWorker.java:184) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.manageSearchEngineUsers(SearchEngineUserWorker.java:100) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.call(SearchEngineUserWorker.java:77) at com.thesearchagency.admaxlistener.worker.AccountWorker.createCampaigns(AccountWorker.java:449) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:406) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:151) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:297) 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) 2017-04-05 10:22:44.560 (2) [pool-3-thread-8]: Error: CampID: 13955_GT Info: Error during add campaigns request. 2017-04-05 10:22:44.560 (2) [pool-3-thread-8]: Error: CampID: 13955_GM Info: Error during add campaigns request. 2017-04-05 10:22:44.560 (2) [pool-3-thread-8]: Error: CampID: 13956_GT Info: Error during add campaigns request. 2017-04-05 10:22:44.560 (2) [pool-3-thread-8]: Error: CampID: 13956_GM Info: Error during add campaigns request. 2017-04-05 10:22:44.561 (1) [pool-3-thread-8]: Exception [Error during add campaigns request. ]:com.thesearchagency.admaxlistener.exception.AdMaxException: Error creating tsacommon SE User(s) for account 2036 at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.createSEUsers(SearchEngineUserWorker.java:223) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.manageSearchEngineUsersByDistribution(SearchEngineUserWorker.java:184) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.manageSearchEngineUsers(SearchEngineUserWorker.java:100) at com.thesearchagency.admaxlistener.worker.SearchEngineUserWorker.call(SearchEngineUserWorker.java:77) at com.thesearchagency.admaxlistener.worker.AccountWorker.createCampaigns(AccountWorker.java:449) at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:406) at com.thesearchagency.admaxlistener.worker.AccountWorker.call(AccountWorker.java:151) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:297) 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) 2017-04-05 10:22:44.563 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13955_GT: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:22:44.563 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13955_GM: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:22:44.563 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13956_GT: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:22:44.563 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13956_GM: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:22:44.563 (3) [pool-3-thread-8]: bce67ee4-d8b4-4144-8615-44d14f999bdb has 0 campaigns for a SE Update accounts sync. 2017-04-05 10:22:44.564 (3) [pool-3-thread-8]: bce67ee4-d8b4-4144-8615-44d14f999bdb has 0 campaigns for a SE Update groups-listings sync. 2017-04-05 10:22:44.564 (3) [pool-3-thread-8]: Finished sub-campaign processing for DEPLOY deploymentID (bf04b9e5-d09d-4ef7-9266-af39a7fbe445). account bce67ee4-d8b4-4144-8615-44d14f999bdb. 4 submitted, 0 ok. 2017-04-05 10:22:44.568 (3) [pool-3-thread-8]: Updating deployment status to 'Failure' for campaignID: 13955 2017-04-05 10:22:44.573 (3) [pool-3-thread-8]: Finished DEPLOY request for bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13955: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:22:44.573 (3) [pool-3-thread-8]: Updating deployment status to 'Failure' for campaignID: 13956 2017-04-05 10:22:44.574 (3) [pool-3-thread-8]: Finished DEPLOY request for bce67ee4-d8b4-4144-8615-44d14f999bdb_12535_57_13956: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:22:44.574 (3) [pool-3-thread-8]: Finished DEPLOY request, deploymentID (bf04b9e5-d09d-4ef7-9266-af39a7fbe445), account bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:22:44.575 (3) [pool-3-thread-8]: Request removed from map for customerID bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:22:44.639 (3) [AdMaxListener]: Sent message to response queue. 2017-04-05 10:22:56.899 (3) [Thread-9]: Heartbeat #117 (1491387776894) received in 0.005s 2017-04-05 10:23:06.468 (3) [Thread-9]: Request added to map for customerID bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:23:06.469 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-55efb8df-705e-48c5-9415-6c0a762c0585 2017-04-05 10:23:06.469 (3) [Thread-9]: Request worker created for bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:23:06.469 (3) [Thread-9]: Submitted executor job for bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:23:06.476 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-55efb8df-705e-48c5-9415-6c0a762c0585 out of queue 2017-04-05 10:23:06.500 (3) [pool-3-thread-8]: Updating deployment status to 'InProgress' for campaignID: 13955 2017-04-05 10:23:06.501 (2) [pool-3-thread-8]: CampaignID: 13955: Update message (bf04b9e5-d09d-4ef7-9266-af39a7fbe445) for account bce67ee4-d8b4-4144-8615-44d14f999bdb contains updates for child campaigns that haven't been created yet. Advert 13955 2017-04-05 10:23:06.501 (2) [pool-3-thread-8]: Exception [Campaign request failed for accountID 2036.]:com.thesearchagency.admaxlistener.exception.AdMaxException: Update message (bf04b9e5-d09d-4ef7-9266-af39a7fbe445) for account bce67ee4-d8b4-4144-8615-44d14f999bdb contains updates for child campaigns that haven't been created yet. Advert 13955 at com.thesearchagency.admaxlistener.worker.RequestWorker.handleCampaign(RequestWorker.java:563) at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:681) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:258) 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) 2017-04-05 10:23:06.502 (3) [pool-3-thread-8]: Updating deployment status to 'InProgress' for campaignID: 13956 2017-04-05 10:23:06.503 (2) [pool-3-thread-8]: CampaignID: 13956: Update message (bf04b9e5-d09d-4ef7-9266-af39a7fbe445) for account bce67ee4-d8b4-4144-8615-44d14f999bdb contains updates for child campaigns that haven't been created yet. Advert 13956 2017-04-05 10:23:06.503 (2) [pool-3-thread-8]: Exception [Campaign request failed for accountID 2036.]:com.thesearchagency.admaxlistener.exception.AdMaxException: Update message (bf04b9e5-d09d-4ef7-9266-af39a7fbe445) for account bce67ee4-d8b4-4144-8615-44d14f999bdb contains updates for child campaigns that haven't been created yet. Advert 13956 at com.thesearchagency.admaxlistener.worker.RequestWorker.handleCampaign(RequestWorker.java:563) at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:681) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:258) 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) 2017-04-05 10:23:06.503 (1) [pool-3-thread-8]: No valid campaigns to process for bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:23:06.504 (3) [pool-3-thread-8]: Updating deployment status to 'Failure' for campaignID: 13955 2017-04-05 10:23:06.505 (3) [pool-3-thread-8]: Finished UPDATE request for 13955: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:23:06.505 (3) [pool-3-thread-8]: Updating deployment status to 'Failure' for campaignID: 13956 2017-04-05 10:23:06.505 (3) [pool-3-thread-8]: Finished UPDATE request for 13956: FAILED (merchant: bce67ee4-d8b4-4144-8615-44d14f999bdb) 2017-04-05 10:23:06.505 (3) [pool-3-thread-8]: Finished UPDATE request, deploymentID (bf04b9e5-d09d-4ef7-9266-af39a7fbe445), account bce67ee4-d8b4-4144-8615-44d14f999bdb 2017-04-05 10:23:06.505 (3) [pool-3-thread-8]: Request removed from map for customerID bce67ee4-d8b4-4144-8615-44d14f999bdb