2011-11-03 04:59:45.435 (3) [main]: Debug Level set to 4
2011-11-03 04:59:45.740 (3) [main]: =============== Starting AdMax MCPC Initializer ================
2011-11-03 04:59:45.741 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 04:59:45.742 (3) [main]: ----------------AdMax MCPC Initializer starting
2011-11-03 04:59:46.073 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 04:59:46.080 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (541))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc]
2011-11-03 04:59:46.144 (4) [main]: time=0.063
2011-11-03 04:59:46.150 (4) [main]: Query executed in 0.063s
2011-11-03 04:59:46.166 (3) [main]: Service URL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl
Nov 3, 2011 4:59:46 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.apache.cxf.bus.spring.BusApplicationContext@48ee22f7: display name [org.apache.cxf.bus.spring.BusApplicationContext@48ee22f7]; startup date [Thu Nov 03 04:59:46 PDT 2011]; root of context hierarchy
Nov 3, 2011 4:59:46 AM org.apache.cxf.bus.spring.BusApplicationContext getConfigResources
INFO: No cxf.xml configuration file detected, relying on defaults.
Nov 3, 2011 4:59:47 AM org.springframework.beans.factory.support.DefaultListableBeanFactory registerBeanDefinition
INFO: Overriding bean definition for bean 'org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder': replacing [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder]; scope=singleton; 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/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]] with [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder]; scope=singleton; 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/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]]
Nov 3, 2011 4:59:47 AM org.springframework.beans.factory.support.DefaultListableBeanFactory registerBeanDefinition
INFO: Overriding bean definition for bean 'org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder': replacing [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder]; scope=singleton; 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/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]] with [Generic bean: class [org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder]; scope=singleton; 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/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]]
Nov 3, 2011 4:59:47 AM org.springframework.beans.factory.support.DefaultListableBeanFactory registerBeanDefinition
INFO: Overriding bean definition for bean 'org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider': replacing [Generic bean: class [org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]; scope=singleton; 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/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]] with [Generic bean: class [org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]; scope=singleton; 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/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]]
Nov 3, 2011 4:59:47 AM org.springframework.beans.factory.support.DefaultListableBeanFactory registerBeanDefinition
INFO: Overriding bean definition for bean 'org.apache.cxf.transport.http.ClientOnlyHTTPTransportFactory': replacing [Generic bean: class [org.apache.cxf.transport.http.ClientOnlyHTTPTransportFactory]; scope=singleton; abstract=false; lazyInit=true; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]] with [Generic bean: class [org.apache.cxf.transport.http.ClientOnlyHTTPTransportFactory]; scope=singleton; abstract=false; lazyInit=true; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in URL [jar:file:/usr/local/tsa/Bid_Manager_-_Trunk_Mavenized/69/tsa-build-bidmgr-2011-10-29-p69-r30808/libs/bidmgrbundle.jar!/META-INF/cxf/cxf-extension-http.fixml]]
Nov 3, 2011 4:59:47 AM org.springframework.context.support.AbstractApplicationContext obtainFreshBeanFactory
INFO: Bean factory for application context [org.apache.cxf.bus.spring.BusApplicationContext@48ee22f7]: org.springframework.beans.factory.support.DefaultListableBeanFactory@580eac5a
Nov 3, 2011 4:59:47 AM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@580eac5a: defining beans [cxf,org.apache.cxf.bus.spring.BusApplicationListener,org.apache.cxf.bus.spring.BusWiringBeanFactoryPostProcessor,org.apache.cxf.bus.spring.Jsr250BeanPostProcessor,org.apache.cxf.bus.spring.BusExtensionPostProcessor,org.apache.cxf.resource.ResourceManager,org.apache.cxf.configuration.Configurer,org.apache.cxf.binding.BindingFactoryManager,org.apache.cxf.transport.DestinationFactoryManager,org.apache.cxf.transport.ConduitInitiatorManager,org.apache.cxf.wsdl.WSDLManager,org.apache.cxf.phase.PhaseManager,org.apache.cxf.workqueue.WorkQueueManager,org.apache.cxf.buslifecycle.BusLifeCycleManager,org.apache.cxf.endpoint.ServerRegistry,org.apache.cxf.endpoint.ServerLifeCycleManager,org.apache.cxf.endpoint.ClientLifeCycleManager,org.apache.cxf.transports.http.QueryHandlerRegistry,org.apache.cxf.endpoint.EndpointResolverRegistry,org.apache.cxf.headers.HeaderManager,org.apache.cxf.catalog.OASISCatalogManager,org.apache.cxf.endpoint.ServiceContractResolverRegistry,org.apache.cxf.binding.corba.CorbaBindingFactory,org.apache.cxf.binding.corba.wsdl.WSDLExtensionRegister#0,org.apache.cxf.jaxws.context.WebServiceContextResourceResolver,org.apache.cxf.jaxws.context.WebServiceContextImpl,org.apache.cxf.binding.soap.SoapBindingFactory,org.apache.cxf.binding.soap.SoapTransportFactory,org.apache.cxf.binding.soap.customEditorConfigurer,org.apache.cxf.binding.xml.XMLBindingFactory,org.apache.cxf.ws.addressing.policy.AddressingAssertionBuilder,org.apache.cxf.ws.addressing.policy.AddressingPolicyInterceptorProvider,org.apache.cxf.ws.addressing.policy.UsingAddressingAssertionBuilder,org.apache.cxf.javascript.JavascriptQueryHandlerRegistry,org.apache.cxf.transport.local.LocalTransportFactory,org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder,org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder,org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider,org.apache.cxf.transport.http.ClientOnlyHTTPTransportFactory,org.apache.cxf.management.InstrumentationManager,org.apache.cxf.transport.http_jetty.JettyHTTPTransportFactory,org.apache.cxf.transport.jms.JMSTransportFactory,org.apache.cxf.binding.object.ObjectBindingFactory,org.apache.cxf.binding.http.HttpBindingFactory,org.apache.cxf.jaxrs.JAXRSBindingFactory,org.apache.cxf.ws.security.policy.WSSecurityPolicyLoader,org.apache.cxf.ws.policy.AssertionBuilderRegistry,org.apache.cxf.ws.policy.PolicyInterceptorProviderRegistry,org.apache.cxf.ws.policy.attachment.external.DomainExpressionBuilderRegistry,org.apache.cxf.ws.policy.attachment.external.EndpointReferenceDomainExpressionBuilder,org.apache.cxf.ws.policy.PolicyBuilder,org.apache.cxf.ws.policy.PolicyEngine,org.apache.cxf.ws.policy.attachment.wsdl11.Wsdl11AttachmentPolicyProvider,org.apache.cxf.ws.policy.attachment.ServiceModelPolicyProvider,org.apache.cxf.ws.policy.mtom.MTOMAssertionBuilder,org.apache.cxf.ws.policy.mtom.MTOMPolicyInterceptorProvider,org.apache.cxf.ws.rm.RMManager,org.apache.cxf.ws.rm.policy.RMPolicyInterceptorProvider,org.apache.cxf.ws.rm.RMAssertionBuilder]; root of factory hierarchy
Nov 3, 2011 4:59:53 AM org.apache.cxf.configuration.spring.ConfigurerImpl getBeanName
INFO: Could not determine bean name for instance of class org.apache.cxf.jaxws.JaxWsClientFactoryBean.
Nov 3, 2011 4:59:53 AM org.apache.cxf.service.factory.ReflectionServiceFactoryBean buildServiceFromWSDL
INFO: Creating Service {urn:v2.UserAccountService.services.thesearchagency.com}UserAccountService2.0 from WSDL: http://svc-useracctv2.svc.thesearchagency.com:8080/svc-useracctv2.0/UserAccountService2.0?wsdl
2011-11-03 04:59:53.652 (2) [main]: Could not get UserAccountServiceEndPoint object. Making a direct database call instead.
2011-11-03 04:59:53.653 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 04:59:53.846 (3) [main]: DatabasePool with a limit of 80 created
2011-11-03 04:59:53.849 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2011-11-03 04:59:53.940 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 04:59:53.943 (4) [main]: Created new Object
2011-11-03 04:59:53.944 (4) [main]: spike: SQL->[select @@version]
2011-11-03 04:59:53.946 (4) [main]: time=0.0020
2011-11-03 04:59:53.947 (4) [main]: Query executed in 0.002s
2011-11-03 04:59:53.948 (4) [main]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-11-03 04:59:53.952 (4) [main]: spike: SQL->[select `identifier` from `tsacommon`.`accounts` join `tsacommon`.`timeZones` on ((`tsacommon`.`accounts`.`timeZoneID`=`tsacommon`.`timeZones`.`id`)) where ((`tsacommon`.`accounts`.`id`=541))]
2011-11-03 04:59:53.955 (4) [main]: time=0.0030
2011-11-03 04:59:53.956 (4) [main]: Query executed in 0.003s
2011-11-03 04:59:53.957 (4) [main]: Returning Object to Pool
2011-11-03 04:59:53.960 (3) [main]: Instantiating a DateUtil object for time zone Europe/London
2011-11-03 04:59:53.965 (4) [main]: Account ID: 541, Date: 2011-11-01 00:00:00 GMT
2011-11-03 04:59:54.046 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2011-11-03 04:59:54.077 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 04:59:54.078 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=541) limit 1]
2011-11-03 04:59:54.081 (4) [P1T1]: time=0.0030
2011-11-03 04:59:54.082 (4) [P1T1]: Query executed in 0.003s
2011-11-03 04:59:54.085 (4) [P1T1]:   Record Loaded
2011-11-03 04:59:54.086 (4) [P1T1]: DataCache: put key acct-st-tracker 541
2011-11-03 04:59:54.091 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`type`="mysql") and (`name`="acct-st-tracker-1")) limit 1]
2011-11-03 04:59:54.094 (4) [P1T1]: time=0.0030
2011-11-03 04:59:54.095 (4) [P1T1]: Query executed in 0.003s
2011-11-03 04:59:54.096 (4) [P1T1]:   Record Loaded
2011-11-03 04:59:54.097 (4) [P1T1]: DataCache: put key acct-st-tracker-1
2011-11-03 04:59:54.099 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 04:59:54.100 (3) [P1T1]: DatabasePool with a limit of 20 created
2011-11-03 04:59:54.151 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 04:59:54.152 (4) [P1T1]: Created new Object
2011-11-03 04:59:54.153 (4) [P1T1]: spike: SQL->[select @@version]
2011-11-03 04:59:54.156 (4) [P1T1]: time=0.0020
2011-11-03 04:59:54.156 (4) [P1T1]: Query executed in 0.002s
2011-11-03 04:59:54.157 (4) [P1T1]: test query succeeded, returned "5.1.49-rel11.3"
2011-11-03 04:59:54.158 (3) [P1T1]: Starting Account #541: TSA - Martian Tourism for 2011-11-01 00:00:00 GMT
2011-11-03 04:59:54.163 (3) [P1T1]: Requesting WSDL from http://svc-rptv2.svc.thesearchagency.com:8080/svc-rptv2.1/ReportService2.1?wsdl with 180000 ms timeout
2011-11-03 04:59:58.286 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` inner join `tsacommon`.`searchEngineUsers` on (((`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`=`tsacommon`.`searchEngineUsers`.`id`))) inner join `tsacommon`.`accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) where ((`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") or (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="disabled") and (`tsacommon`.`searchEngineAccounts`.`paused`="true"))))) and (`tsacommon`.`searchEngineAccounts`.`accountID`="541") and (`tsacommon`.`searchEngineAccounts`.`distributionID`="3")) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc,`tsacommon`.`searchEngineAccounts`.`lastChecked` asc]
2011-11-03 04:59:58.329 (4) [P1T1]: time=0.043
2011-11-03 04:59:58.330 (4) [P1T1]: Query executed in 0.043s
2011-11-03 04:59:58.338 (3) [P1T1]: Start Date: 2011-11-01 00:00:00 GMT End Date: 2011-11-01 23:59:59 GMT
2011-11-03 04:59:58.887 (4) [P1T1]: Account# 541 ID(354331) waiting for ReportService
2011-11-03 05:00:03.913 (3) [P1T1]: Connected to URL "http://tvvm-staging-svc2:8080//reports/1/report_354331.csv"
2011-11-03 05:00:03.925 (2) [P1T1]: Exception [handling account #541]:java.lang.NullPointerException
	at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)
	at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:149)
	at com.thesearchagency.admax.algorithms.AdMaxTestSettings.loadDefaults(AdMaxTestSettings.java:83)
	at com.thesearchagency.admax.algorithms.AdMaxTestSettings.load(AdMaxTestSettings.java:146)
	at com.thesearchagency.admax.algorithms.AdMaxMCPCAlgorithm.initializerSetup(AdMaxMCPCAlgorithm.java:618)
	at com.thesearchagency.admax.AdMaxMCPCInitializer$AccountWorker.processReportInitialize(AdMaxMCPCInitializer.java:182)
	at com.thesearchagency.admax.AdMaxInitializer$AccountWorker.processDay(AdMaxInitializer.java:358)
	at com.thesearchagency.admax.AdMaxInitializer$AccountWorker.run(AdMaxInitializer.java:265)
	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)

2011-11-03 05:00:03.972 (3) [P1T1]: Completed Account #541: TSA - Martian Tourism for 2011-11-01 00:00:00 GMT
2011-11-03 05:00:03.972 (4) [P1T1]: Returning Object to Pool
2011-11-03 05:00:03.975 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-11-03 05:00:03.975 (3) [main]: ------------AdMax MCPC Initializer done
2011-11-03 05:00:03.975 (3) [main]: =============== Completed AdMax MCPC Initializer ================
2011-11-03 05:00:03.976 (4) [main]: time=18.236
2011-11-03 05:00:03.976 (3) [main]: AdMaxInitializer:	18.236s
2011-11-03 05:00:03.976 (3) [main]:     by key:
2011-11-03 05:00:03.976 (4) [main]: time=0.119
2011-11-03 05:00:03.976 (3) [main]:         db:	0.119s
2011-11-03 05:00:03.976 (3) [main]:             by thread:
2011-11-03 05:00:03.977 (4) [main]: time=0.068
2011-11-03 05:00:03.977 (3) [main]:                 main:	0.068s
2011-11-03 05:00:03.977 (4) [main]: time=0.051
2011-11-03 05:00:03.977 (3) [main]:                 P1T1:	0.051s
2011-11-03 05:00:03.977 (4) [main]: time=18.117
2011-11-03 05:00:03.977 (3) [main]:         other:	18.117s