2018-12-27 08:45:30.406 (3) [Thread-9]: Request added to map for customerID 2556ef23-69bd-4756-be32-1ab7d007763f
2018-12-27 08:45:30.406 (3) [Thread-9]: HighPriorityMessageHandler handling message ID ID:JBM-693837ad-bc5c-49e9-8d21-a0012ba3a45f
2018-12-27 08:45:30.406 (3) [Thread-9]: Request worker created for 2556ef23-69bd-4756-be32-1ab7d007763f
2018-12-27 08:45:30.406 (3) [Thread-9]: Submitted executor job for 2556ef23-69bd-4756-be32-1ab7d007763f
2018-12-27 08:45:30.413 (3) [Thread-9]: HighPriorityMessageHandler took message ID ID:JBM-693837ad-bc5c-49e9-8d21-a0012ba3a45f out of queue
2018-12-27 08:45:30.417 (3) [pool-3-thread-9]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-12-27 08:45:30.430 (3) [pool-3-thread-9]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-12-27 08:45:30.464 (3) [pool-3-thread-9]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-12-27 08:45:30.471 (3) [pool-3-thread-9]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-12-27 08:45:30.479 (3) [pool-3-thread-9]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'budgetType' in field list is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        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:1041)
        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:2815)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
        at com.thesearchagency.admax.dao.AdMaxSloshFactorsDAO.findSloshFactorsByAccountAndDistribution(AdMaxSloshFactorsDAO.java:206)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.handleDeletedCampaigns(RequestWorker.java:1019)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:984)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:925)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:268)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:102)
        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)
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'budgetType' in field list is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        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:1041)
        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:2815)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
        at com.thesearchagency.admax.dao.AdMaxSloshFactorsDAO.findFutureSloshFactorsByAccountAndDistribution(AdMaxSloshFactorsDAO.java:241)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.handleDeletedCampaigns(RequestWorker.java:1020)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:984)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:925)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:268)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:102)
        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)
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'budgetType' in field list is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        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:1041)
        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:2815)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
        at com.thesearchagency.admax.dao.AdMaxSloshLimitsDAO.findSloshLimitsByAccountAndDistribution(AdMaxSloshLimitsDAO.java:126)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.handleDeletedCampaigns(RequestWorker.java:1022)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:984)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:925)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:268)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:102)
        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)
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'budgetType' in field list is ambiguous
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        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:1041)
        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:2815)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
        at com.thesearchagency.admax.dao.AdMaxSloshLimitsDAO.findFutureSloshLimitsByAccountAndDistribution(AdMaxSloshLimitsDAO.java:161)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.handleDeletedCampaigns(RequestWorker.java:1023)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:984)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:925)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:268)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:102)
        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-12-27 08:45:30.493 (3) [pool-3-thread-9]: Nominal monthly budget was unchanged for AdMax campaign ID: 7759
2018-12-27 08:45:30.493 (3) [pool-3-thread-9]: Terminated budget for admaxCampaignID 7759
2018-12-27 08:45:30.494 (3) [pool-3-thread-9]: Nominal monthly budget was unchanged for AdMax campaign ID: 7760
2018-12-27 08:45:30.494 (3) [pool-3-thread-9]: Terminated budget for admaxCampaignID 7760
2018-12-27 08:45:30.495 (3) [pool-3-thread-9]: Nominal monthly budget was unchanged for AdMax campaign ID: 7761
2018-12-27 08:45:30.495 (3) [pool-3-thread-9]: Terminated budget for admaxCampaignID 7761
2018-12-27 08:45:30.495 (1) [pool-3-thread-9]: Exception [Unhandled exception, failing request]:java.lang.NullPointerException
        at com.thesearchagency.admaxlistener.worker.RequestWorker.handleDeletedCampaigns(RequestWorker.java:1091)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:984)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:925)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:268)
        at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:102)
        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-12-27 08:45:30.496 (2) [pool-3-thread-9]: No parent result for 27060, using message result.
2018-12-27 08:45:30.496 (3) [pool-3-thread-9]: Updating deployment status to 'Failure' for campaignID: 27060
2018-12-27 08:45:30.497 (3) [pool-3-thread-9]: Finished UPDATE request for 27060: FAILED (merchant: 2556ef23-69bd-4756-be32-1ab7d007763f)
2018-12-27 08:45:30.497 (2) [pool-3-thread-9]: No parent result for 27061, using message result.
2018-12-27 08:45:30.497 (3) [pool-3-thread-9]: Updating deployment status to 'Failure' for campaignID: 27061
2018-12-27 08:45:30.498 (3) [pool-3-thread-9]: Finished UPDATE request for 27061: FAILED (merchant: 2556ef23-69bd-4756-be32-1ab7d007763f)
2018-12-27 08:45:30.498 (2) [pool-3-thread-9]: No parent result for 27062, using message result.
2018-12-27 08:45:30.498 (3) [pool-3-thread-9]: Updating deployment status to 'Failure' for campaignID: 27062
2018-12-27 08:45:30.498 (3) [pool-3-thread-9]: Finished UPDATE request for 27062: FAILED (merchant: 2556ef23-69bd-4756-be32-1ab7d007763f)
2018-12-27 08:45:30.498 (3) [pool-3-thread-9]: Finished UPDATE request, deploymentID (4b375d76-2dda-4e14-aca6-98f2707de831), account 2556ef23-69bd-4756-be32-1ab7d007763f
2018-12-27 08:45:30.498 (3) [pool-3-thread-9]: Request removed from map for customerID 2556ef23-69bd-4756-be32-1ab7d007763f
2018-12-27 08:45:31.378 (3) [AdMaxListener]: Sent message to response queue.
2018-12-27 08:45:42.020 (3) [Thread-9]: Heartbeat #217 (1545900342015) received in 0.005s
2018-12-27 08:46:12.023 (3) [Thread-9]: Heartbeat #218 (1545900372015) received in 0.008s
2018-12-27 08:46:42.019 (3) [Thread-9]: Heartbeat #219 (1545900402015) received in 0.004s
2018-12-27 08:47:12.020 (3) [Thread-9]: Heartbeat #220 (1545900432015) received in 0.005s
2018-12-27 08:47:12.023 (3) [pool-4-thread-2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-12-27 08:47:12.029 (3) [pool-4-thread-2]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2018-12-27 08:47:12.031 (3) [pool-4-thread-2]: No new jobs to execute for type: [1,2]
2018-12-27 08:47:14.018 (3) [pool-4-thread-1]: No new jobs to execute for type: [4]
2018-12-27 08:47:16.017 (3) [pool-4-thread-2]: No new jobs to execute for type: [6]
2018-12-27 08:47:42.019 (3) [Thread-9]: Heartbeat #221 (1545900462015) received in 0.004s
2018-12-27 08:48:12.020 (3) [Thread-9]: Heartbeat #222 (1545900492015) received in 0.005s
2018-12-27 08:48:42.019 (3) [Thread-9]: Heartbeat #223 (1545900522015) received in 0.004s
2018-12-27 08:49:12.020 (3) [Thread-9]: Heartbeat #224 (1545900552015) received in 0.005s
2018-12-27 08:49:42.023 (3) [Thread-9]: Heartbeat #225 (1545900582015) received in 0.008s
2018-12-27 08:50:12.020 (3) [Thread-9]: Heartbeat #226 (1545900612015) received in 0.005s
2018-12-27 08:50:42.019 (3) [Thread-9]: Heartbeat #227 (1545900642015) received in 0.004s