18:16:13,929 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 3889 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[677], x-newrelic-id=[UAIPV1dXGwEAVFNSDwU=], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], x-newrelic-transaction=[PxQOUAdWDQQEAVMDDgNTUQcAFB8EBw8RVT8=], pragma=[no-cache]} Payload:
aa1aec2b-afd8-4971-8531-092e37120c13
2cb5c073-2805-4a1d-ab5c-144c2851b502 3837 active -------------------------------------- 18:16:13,940 INFO [AdMaxAccountDeploymentBD] validated: [] 18:16:13,941 DEBUG [JdbcTemplate] Executing prepared SQL query 18:16:13,941 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 18:16:13,944 DEBUG [JdbcTemplate] Executing prepared SQL query 18:16:13,945 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ] 18:16:13,947 DEBUG [JdbcTemplate] Executing prepared SQL query 18:16:13,948 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ] 18:16:13,968 INFO [AdMaxAccountDeploymentBD] Account: Account [theAccountID=649, theDescription=2cb5c073-2805-4a1d-ab5c-144c2851b502, theTier=1, thePriority=50, theReportClickOuts=0, theReportConversions=0, theConversionTypes=[], isBidManaged=1, isActive=true, thePerformanceMetric=cpa, theProvidesConversionData=true, theAddConversionDate=false, theFractionalConversionCounts=false, theHideNullSources=0, theNowTime=Mon Jan 20 18:16:13 UTC 2014, theWarehouseDB=warehouse_1, theDatabaseInstance=1, theWarehouseInstance=1, isOnline=true, currencyCode=, theSites=[Site [theSiteId=643, theAccountId=649, isDefault=true, theDescription=2cb5c073-2805-4a1d-ab5c-144c2851b502_Main, theInternalURLPattern=, hasIgnorePixels=false, theWaypoints=[Waypoint [theWaypointId=1277, theSiteId=643, theGroupId=0, theType=2, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Page View, thePassParams=, theDebounceWindow=30, theLimitPerWindow=1, theLastTestedDate=null, theTestStatus=null], Waypoint [theWaypointId=1278, theSiteId=643, theGroupId=0, theType=4, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Conversion, thePassParams=, theDebounceWindow=0, theLimitPerWindow=0, theLastTestedDate=null, theTestStatus=null]]]]] 18:16:13,968 INFO [AdMaxAccountDeploymentBD] Updating CampaignID [3837] budget accrual status to [active] 18:16:13,974 DEBUG [JdbcTemplate] Executing prepared SQL query 18:16:13,974 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL] 18:16:13,990 INFO [CampaignBudgetAccrualStatusServiceBD] AdMaxCampaignId [1209] current CampaignBudgetAccrualStatus: CampaignBugetAccrualStatus [theId=1844, theCampaignId=1209, theStartDate=2014-01-20, theEndDate=null, theStatus=paused] 18:16:13,990 DEBUG [JdbcTemplate] Executing prepared SQL query 18:16:13,991 DEBUG [JdbcTemplate] Executing prepared SQL statement [select accountID, currencyCode, timeZoneId from gce_googleAccount where accountID = ? ] 18:16:14,255 INFO [AdMaxAccountDeploymentBD] exception after calling budget accrual service javax.ejb.EJBException: com.thesearchagency.core.smb.dao.DAOException: ERROR Could not read Page :: Incorrect result size: expected 1, actual 2 at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:77) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176) at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164) at $Proxy964.updateCampaignBudgetAccrualStatus(Unknown Source) at com.thesearchagency.core.smb.service.admaxdeployment.component.AdMaxAccountDeploymentBD.updateCampaignBudgetAccrualStatus(AdMaxAccountDeploymentBD.java:212) at com.thesearchagency.core.smb.service.admaxdeployment.binding.AdMaxDeploymentWS.updateCampaignBudgetAccrualStatus(AdMaxDeploymentWS.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:129) at org.jboss.wsf.stack.cxf.AbstractInvoker._invokeInternal(AbstractInvoker.java:164) at org.jboss.wsf.stack.cxf.AbstractInvoker.invoke(AbstractInvoker.java:112) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113) at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:97) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:461) at org.jboss.wsf.stack.cxf.ServletControllerExt.invoke(ServletControllerExt.java:172) at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:57) at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:162) at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:90) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:103) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662) Caused by: com.thesearchagency.core.smb.dao.DAOException: ERROR Could not read Page :: Incorrect result size: expected 1, actual 2 at com.thesearchagency.core.smb.dao.account.impl.GoogleAccountDAOSpringJDBC.findByAccountId(GoogleAccountDAOSpringJDBC.java:40) at com.thesearchagency.core.smb.service.campaign.service.component.CampaignBudgetAccrualStatusServiceBD.getNewDate(CampaignBudgetAccrualStatusServiceBD.java:272) at com.thesearchagency.core.smb.service.campaign.service.component.CampaignBudgetAccrualStatusServiceBD.updateCampaignBudgetAccrualStatus(CampaignBudgetAccrualStatusServiceBD.java:112) at com.thesearchagency.core.smb.service.campaign.service.binding.CampaignBudgetAccrualStatusEJB.updateCampaignBudgetAccrualStatus(CampaignBudgetAccrualStatusEJB.java:43) at sun.reflect.GeneratedMethodAccessor749.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59) at sun.reflect.GeneratedMethodAccessor527.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_469629494.invoke(InvocationContextInterceptor_z_fillMethod_469629494.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_469629494.invoke(InvocationContextInterceptor_z_setup_469629494.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) ... 66 more Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:74) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:729) at com.thesearchagency.core.smb.dao.account.impl.GoogleAccountDAOSpringJDBC.findByAccountId(GoogleAccountDAOSpringJDBC.java:33) ... 99 more 18:16:14,259 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 3889 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
aa1aec2b-afd8-4971-8531-092e37120c13
2cb5c073-2805-4a1d-ab5c-144c2851b5023837failureCould not update campaign budget accrual status: com.thesearchagency.core.smb.dao.DAOException: ERROR Could not read Page :: Incorrect result size: expected 1, actual 2 --------------------------------------