Details
Description
While running content editor bing for status change it throwing Null pointer exception.
Full Log
root@ebiz-st2-tsa-node-admax:/usr/local/tsa/bidmgr/scripts# ./contenteditor-bing.sh -d3 -U 26151
pid 8421's current affinity mask: 1
pid 8421's new affinity mask: 1
Java HotSpot(TM) 64-Bit Server VM warning: Can't detect initial thread stack location - find_vma failed
2014-03-19 13:27:19.694 (3) [main]: Debug Level set to 3
2014-03-19 13:27:19.807 (3) [main]: LicensingFileRefresher: modification detected on 1370620065000 for licensing.properties
2014-03-19 13:27:19.808 (3) [main]: Licensing environment detected, loading configuration.
2014-03-19 13:27:19.811 (3) [main]: Loaded property: tsa.google.mcc.email=gurpreet.singh.hibu@gmail.com
2014-03-19 13:27:19.811 (3) [main]: Loaded property: tsa.google.mcc.password=y3llc0m_123
2014-03-19 13:27:19.811 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
2014-03-19 13:27:19.811 (3) [main]: Loaded property: tsa.google.mcc.applicationToken=uoIAD-arHiCXJKtlGSg5qw
2014-03-19 13:27:19.812 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true
2014-03-19 13:27:19.812 (3) [main]: Loaded property: tsa.google.mcc.userAgent=MMS AdWords Software
2014-03-19 13:27:19.812 (3) [main]: Loaded property: tsa.google.isSandbox=false
2014-03-19 13:27:19.812 (3) [main]: Loaded property: tsa.bing.mcc.username=YellSandboxAPI
2014-03-19 13:27:19.812 (3) [main]: Loaded property: tsa.bing.mcc.password=api123
2014-03-19 13:27:19.813 (3) [main]: Loaded property: tsa.bing.mcc.developerToken=D9OP84AM
2014-03-19 13:27:19.813 (3) [main]: Loaded property: tsa.bing.mcc.isReseller=true
2014-03-19 13:27:19.813 (3) [main]: Loaded property: tsa.bing.mcc.userAgent=MMS AdCenter Software
2014-03-19 13:27:19.813 (3) [main]: Loaded property: tsa.bing.isSandbox=false
2014-03-19 13:27:19.815 (3) [main]: =============== Starting Bing Content Editor ================
2014-03-19 13:27:19.815 (3) [main]: ----------------Bing Content Editor starting
2014-03-19 13:27:20.541 (3) [P1T1]: Created shared sesystem connection rw
2014-03-19 13:27:20.807 (3) [P1T1]: DatabasePool with a limit of 80 created
2014-03-19 13:27:21.005 (3) [P1T1]: CampaignChangeRequest (accountID 27491): Sending 1 update requests
2014-03-19 13:27:27.045 (3) [P1T1]: CampaignDAO(accountID 27491) Request contained 0 adds, 1 updates, 0 deletes.
2014-03-19 13:27:27.046 (3) [P1T1]: CampaignDAO(accountID 27491) DB updates: 1 items updated, 1 pending changes deleted, 1 pending updates deleted, 0 errors cleared
2014-03-19 13:27:27.184 (3) [P1T1]: Clearing bce_textAdPendingChanges for campaigns: null
2014-03-19 13:27:27.185 (1) [P1T1]: Exception [Error while deleting entries at bce_textAdPendingChanges for campaigns: null .This will be ignored]:java.lang.NullPointerException
at com.thesearchagency.searchengines.bing.contenteditor.dao.ad.textad.TextAdDAO.buildPendingChangeDeleteQuery(TextAdDAO.java:574)
at com.thesearchagency.searchengines.bing.contenteditor.dao.ad.textad.TextAdDAO.clearTextAdPendingChanges(TextAdDAO.java:562)
at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$SearchEngineUserWorker.handleAds(BingContentEditor.java:1098)
at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$SearchEngineUserWorker.run(BingContentEditor.java:853)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
2014-03-19 13:27:27.225 (3) [P1T1]: Clearing bce_keywordPendingChanges for campaigns: null
2014-03-19 13:27:27.225 (1) [P1T1]: Exception [Error while deleting entries at bce_keywordPendingChanges for campaigns: null .This will be ignored]:java.lang.NullPointerException
at com.thesearchagency.searchengines.bing.contenteditor.dao.criterion.keyword.KeywordDAO.buildKeywordDeleteQuery(KeywordDAO.java:708)
at com.thesearchagency.searchengines.bing.contenteditor.dao.criterion.keyword.KeywordDAO.clearKeywordPendingChanges(KeywordDAO.java:696)
at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$SearchEngineUserWorker.handleNegativeKeywords(BingContentEditor.java:1212)
at com.thesearchagency.searchengines.bing.contenteditor.BingContentEditor$SearchEngineUserWorker.run(BingContentEditor.java:857)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
2014-03-19 13:27:27.226 (3) [P1T1]: ... SEUser 26151 finished
2014-03-19 13:27:27.226 (3) [main]: ------------Bing Content Editor done
2014-03-19 13:27:27.227 (3) [main]: =============== Completed Bing Content Editor ================
Note: The change request is working as expected, but its throwing exception.