ID: 790
Address: /Optus-AD/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml;charset=UTF-8
Headers: {content-type=[text/xml;charset=UTF-8], host=[localhost:9985], Content-Length=[698], SOAPAction=["http://www.thesearchagency.com/AdMaxDeploymentService/updateCampaignBudgetAccrualStatus"], user-agent=[Jakarta Commons-HttpClient/3.1], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]}
Payload: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adm="http://www.thesearchagency.com/AdMaxDeploymentService/">
   <soapenv:Header/>
   <soapenv:Body>
      <adm:updateCampaignBudgetAccrualStatusRequest>
         <header>
            <requestID>1</requestID>
         </header>
         <customerID>AccuralStatus2</customerID>
         <!--1 or more repetitions:-->
         <campaignBudgetAccrualStatusList>
            <campaignID>ACST1</campaignID>
            <campaignBudgetAccrualStatus>active</campaignBudgetAccrualStatus>
         </campaignBudgetAccrualStatusList>
      </adm:updateCampaignBudgetAccrualStatusRequest>
   </soapenv:Body>
</soapenv:Envelope>
--------------------------------------
19:07:41,838 INFO  [AdMaxDeploymentServiceWSImpl] Entering AdMaxDeploymentService.updateCampaignBudgetAccrualStatus method.
19:07:41,839 DEBUG [JdbcTemplate] Executing prepared SQL query
19:07:41,840 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
19:07:41,851 DEBUG [JdbcTemplate] Executing prepared SQL query
19:07:41,852 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
19:07:41,853 DEBUG [JdbcTemplate] Executing prepared SQL query
19:07:41,853 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
19:07:41,864 DEBUG [AdMaxDeploymentServiceWSImpl] Updating CampaignID [ACST1] budget accrual status to [active]
19:07:41,866 INFO  [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
19:07:41,868 INFO  [CampaignBudgetAccrualStatusServiceBD] Searching for last CampaignBudgetAccrualStatus record for CampiagnId [265]
19:07:41,868 DEBUG [JdbcTemplate] Executing prepared SQL query
19:07:41,868 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL]
19:07:41,879 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [265] last CampaignBudgetAccrualStatus current status
CampaignBugetAccrualStatus [theId=292, theCampaignId=265, theStartDate=2012-10-18, theEndDate=null, theStatus=paused]
19:07:41,879 DEBUG [JdbcTemplate] Executing prepared SQL update
19:07:41,879 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ]
19:07:41,889 DEBUG [JdbcTemplate] SQL update affected 1 rows
19:07:41,889 DEBUG [JdbcTemplate] SQLWarning ignored: SQL state '01000', error code '1265', message [Data truncated for column 'endDate' at row 1]
19:07:41,890 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [265] last CampaignBudgetAccrualStatus updated status
CampaignBugetAccrualStatus [theId=292, theCampaignId=265, theStartDate=2012-10-18, theEndDate=Wed Oct 17 19:07:41 EST 2012, theStatus=paused]
19:07:41,890 DEBUG [JdbcTemplate] Executing prepared SQL update
19:07:41,890 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into admaxCampaignBudgetAccrualStatus(id,admaxCampaignID,startDate,endDate,status) values(?,?,?,?,?)on duplicate key update endDate=?, status=?]
19:07:41,901 DEBUG [JdbcTemplate] SQL update affected 3 rows
19:07:41,901 DEBUG [JdbcTemplate] SQLWarning ignored: SQL state '01000', error code '1265', message [Data truncated for column 'startDate' at row 1]
19:07:41,901 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [265] new CampaignBudgetAccrualStatus status
CampaignBugetAccrualStatus [theId=null, theCampaignId=265, theStartDate=Thu Oct 18 19:07:41 EST 2012, theEndDate=null, theStatus=active]
19:07:41,901 INFO  [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
19:07:41,903 INFO  [AdMaxDeploymentServiceWSImpl] Exiting AdMaxDeploymentService.updateCampaignBudgetAccrualStatus method.
19:07:41,904 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 790
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignBudgetAccrualStatusResponse xmlns:ns2="http://www.thesearchagency.com/AdMaxDeploymentService/"><header><requestID>1</requestID></header><customerID>AccuralStatus2</customerID><campaignResult><campaignID>ACST1</campaignID><result><resultCode>success</resultCode></result></campaignResult></ns2:updateCampaignBudgetAccrualStatusResponse></soap:Body></soap:Envelope>
--------------------------------------