CLONE - OPTUS:Radius Boosting for Proximity location throws Null Pointer exception

Radius Boosting for Proximity location throws Null Pointer exception!

• Deploy SGS and ADS

{CustomerID - ProxTarradboost1.5test1,BA=2000001 and BL=NT242}

==== Attached===
• INSERT INTO mms_common.pointRadiusModifiers (advertID,multiplier,incrementer) values ('radprox1.5',3.0,0);

INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radprox1.5_GM',6,now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radprox1.5_GT',6,now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radprox1.5_MO',6,now());

• Verify the listener logs, Radius values gets updated with multiplier
• Update the multiplier to original i.e. 1 and verify => it gets updated to original radius value
• Now create new Brand Campaign through Brand Campaign UI and update

INSERT INTO mms_common.pointRadiusModifiers (advertID,multiplier,incrementer) values ('ProxTarradboost1.5test1-1_BRAND',3.0,0);
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('ProxTarradboost1.5test1-1_BRAND', 6, now());

• Verify the listener logs, Radius values gets updated with multiplier
• Update the Optus campaigns (GT/GM/MO) with multiplier ‘3’

mysql> update mms_common.pointRadiusModifiers set multiplier=3 where id=5;
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radprox1.5_GM',6,now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radprox1.5_GT',6,now());
INSERT INTO clients.externalCampaignJobItem (externalCampaignID, externalCampaignJobTypeID, createTime) values ('radprox1.5_MO',6,now());

• Verify the Adwords UI and Listener logs

It is observed that Adwords UI - https://adwords.google.com/cm/CampaignMgmt?__u=4919949356&__c=6540356099&syncServiceIdentity=true#r.ONLINE.st&app=cm
hasn’t updated radius value and listener log displays exception! -===Log attached===

2012-10-25 22:18:54.878 (4) [pool-4-thread-2]: No budget changes
2012-10-25 22:18:54.878 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where accountID = ? and typeID=1]
2012-10-25 22:18:54.880 (1) [pool-4-thread-2]: Exception [Unhandled exception, failing request]:java.lang.NullPointerException
at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:718)
at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:505)
at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java: