Orders are going to error state due to the existing keywords which still had destination URL as not NULL in the DB

Orders are going to Error state due to the existing keywords which still had destination URL as not NULL

Steps:

1.Deploy an order through UI

2.Check the listener log

Actual result:

Listener log displays Exception for keywords and order gets Failed.

Also, it picks up campaignID 5,6 for checking destination URL for keywords. Basically, these campaign IDs should not be picked as they are not related to the order being processed here.

Snippet of listener log:

2016-06-03 11:54:17.071 (2) [pool-3-thread-4]: Error: CampID: 711_GT Info: Error during update request.
2016-06-03 11:54:17.071 (2) [pool-3-thread-4]: Error: CampID: 711_GM Info: Error during update request.
2016-06-03 11:54:17.072 (2) [pool-3-thread-4]: Error: CampID: 712_GT Info: Error during update request.
2016-06-03 11:54:17.072 (2) [pool-3-thread-4]: Error: CampID: 712_GM Info: Error during update request.
2016-06-03 11:54:17.072 (1) [pool-3-thread-4]: Exception [Error during update request.]:com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '342' for key 'PRIMARY'
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: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.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at com.thesearchagency.searchengines.google.contenteditor.dao.criterion.keyword.KeywordDAO.createDestinationURLUpdateRequest(KeywordDAO.java:487)
at com.thesearchagency.searchengines.google.contenteditor.dao.criterion.keyword.KeywordDAO.updateKeywordDestinationURLs(KeywordDAO.java:388)
at com.thesearchagency.searchengines.google.contenteditor.RequestCreator$KeywordURLUpdateTransaction.databaseCalls(RequestCreator.java:1723)
at com.carldunham.jst.db.SQLTransaction.execute(SQLTransaction.java:68)
at com.thesearchagency.searchengines.google.contenteditor.RequestCreator.updateKeywordDestinationURLs(RequestCreator.java:291)
at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor.updateKeywordDestinationURLs(GoogleContentEditor.java:283)
at com.thesearchagency.admaxlistener.deployer.MultiplexAccountDeployer.updateKeywordDestinationURLs(MultiplexAccountDeployer.java:400)
at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.campaignSync(CampaignUpdateWorker.java:540)
at com.thesearchagency.admaxlistener.worker.CampaignUpdateWorker.call(CampaignUpdateWorker.java:120)
at com.thesearchagency.admaxlistener.worker.AccountWorker.updateCampaigns(AccountWorker.java:530)
at com.thesearchagency.admaxlistener.worker.AccountWorker.deploySync(AccountWorker.java:396)
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)

Expected Result:

1 .New orders should be deployed successfully
2 Redeployment of the old accounts whose destination URL as not NULL in the database.