[TSAApp@aml-qa4-core1 republisher]$ ./campaign-republisher.sh -a no-deploy -d 2019-05-15 -z America/New_York -s http://aml-qa4-front1:8080/sapi/rest/ -su madhanmohan.pulipati@admaxlocal.com -sp Test123 -sr mars2 Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release 253 [main] INFO c.a.republisher.common.ParamParser - Using endDate: 2019-05-14T23:59:59.999-04:00, TimeZone: America/New_York 294 [main] INFO o.s.c.s.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@3712b94: startup date [Tue Jun 04 08:53:51 UTC 2019]; root of context hierarchy 329 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [republisher-spring-config.xml] 459 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-properties-configuration.xml] 603 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-component-configuration.xml] 634 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-properties-configuration.xml] 652 [main] INFO o.s.b.f.s.DefaultListableBeanFactory - Overriding bean definition for bean 'republisher-property-configurer' with a different definition: replacing [Generic bean: class [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-properties-configuration.xml]] with [Generic bean: class [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-properties-configuration.xml]] 653 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-ds-configuration.xml] 689 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-dao-configuration.xml] 709 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-ds-configuration.xml] 724 [main] INFO o.s.b.f.xml.XmlBeanDefinitionReader - Loading XML bean definitions from URL [jar:file:/usr/local/tsa/campaign-republisher-1.0.0/libs/republisher-1.0.0.jar!/services/republisher-dao-configuration.xml] 829 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [services/republisher.properties] 830 [main] INFO o.s.b.f.c.PropertyPlaceholderConfigurer - Loading properties file from class path resource [services/republisher-overrides.properties] 830 [main] WARN o.s.b.f.c.PropertyPlaceholderConfigurer - Could not load properties from class path resource [services/republisher-overrides.properties]: class path resource [services/republisher-overrides.properties] cannot be opened because it does not exist 1214 [main] INFO c.a.r.campaign.CampaignRepublisher - campaign endDate:2019-05-14 23:59:59, TimeZone: America/New_York 1214 [main] INFO c.a.r.campaign.CampaignRepublisher - campaign endDate:2019-05-15 03:59:59, TimeZone: UTC 1214 [main] INFO c.a.r.campaign.CampaignRepublisher - =============== Starting Campaign Republishing ================ 1214 [main] INFO c.a.r.campaign.MerchantDispatcher - ============= Running Campaign Republisher ============= 1216 [main] INFO c.a.r.campaign.MerchantDispatcher - getCustomersByCampaignEndDate 2019-05-15 03:59:59 1617 [main] INFO jdbc.sqlonly - SELECT cu.`id`, cu.`json` FROM `campaigns` c JOIN `tsacommon`.`searchEngineUsers` u ON c.`searchEngineUserId` = u.`id` JOIN `tsacommon`.`accounts` a ON u.`accountID` = a.`id` JOIN `customers` cu ON a.`description` = cu.`name` WHERE c.`status` = 'Active' and c.`endDate` LIKE concat('2019-05-15 03:59:59','%') and a.`timeZoneID`= 'America/New_York' GROUP BY cu.`id` 1704 [main] INFO c.a.r.dao.CampaignRepublisherDAO - Customers Found : 3 1707 [main] INFO c.a.r.campaign.MerchantDispatcher - GET Merchant a2535708-3a89-44fe-8e9a-f1ed01f4120f 1724 [main] ERROR c.a.r.campaign.MerchantDispatcher - Execption while retreving Merchant/Order Service java.lang.NullPointerException: null at com.admaxlocal.republisher.campaign.MerchantDispatcher.call(MerchantDispatcher.java:84) at com.admaxlocal.republisher.campaign.CampaignRepublisher.process(CampaignRepublisher.java:97) at com.admaxlocal.republisher.campaign.CampaignRepublisher.main(CampaignRepublisher.java:50) 1724 [main] INFO c.a.r.campaign.MerchantDispatcher - GET Merchant adafa3b3-5228-4767-84f2-8fb8597c2810 1727 [main] ERROR c.a.r.campaign.MerchantDispatcher - Execption while retreving Merchant/Order Service java.lang.NullPointerException: null at com.admaxlocal.republisher.campaign.MerchantDispatcher.call(MerchantDispatcher.java:84) at com.admaxlocal.republisher.campaign.CampaignRepublisher.process(CampaignRepublisher.java:97) at com.admaxlocal.republisher.campaign.CampaignRepublisher.main(CampaignRepublisher.java:50) 1728 [main] INFO c.a.r.campaign.MerchantDispatcher - GET Merchant 051ad32b-d1dd-46a8-8722-529f890f5892 1731 [main] ERROR c.a.r.campaign.MerchantDispatcher - Execption while retreving Merchant/Order Service java.lang.NullPointerException: null at com.admaxlocal.republisher.campaign.MerchantDispatcher.call(MerchantDispatcher.java:84) at com.admaxlocal.republisher.campaign.CampaignRepublisher.process(CampaignRepublisher.java:97) at com.admaxlocal.republisher.campaign.CampaignRepublisher.main(CampaignRepublisher.java:50) 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - =============== Completed Campaign Republishing ================ 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - =============================================================== 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - Number of Order PROCESSED : 0 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - Number of Order in ERROR : 0 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - Number of Order in PROCESSING : 0 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - Number of Order IGNORED : 0 1731 [main] INFO c.a.r.campaign.CampaignRepublisher - Number of Order in EXCEPTION : 3 1732 [main] INFO c.a.r.campaign.CampaignRepublisher - =============================================================== 1732 [main] INFO c.a.r.campaign.CampaignRepublisher - Total Number of Merchant Processed : 3 1732 [main] INFO c.a.r.campaign.CampaignRepublisher - Total Number of Merchant republished sucessfully : 0 1732 [main] INFO c.a.r.campaign.CampaignRepublisher - =============================================================== 1732 [Thread-0] INFO o.s.c.s.ClassPathXmlApplicationContext - Closing org.springframework.context.support.ClassPathXmlApplicationContext@3712b94: startup date [Tue Jun 04 08:53:51 UTC 2019]; root of context hierarchy