2012-12-14 16:20:01,648 INFO  [org.apache.cxf.interceptor.LoggingInInterceptor] (http-0.0.0.0-8080-1) Inbound Message
----------------------------
ID: 178
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=[aq-qa-jboss1:8080], Content-Length=[1056], SOAPAction=[""], user-agent=[Apache CXF 2.6.2], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:deployCampaigns xmlns:core="http://thesearchagency.com/smb/core">
<deployCampaignsRequest>
    <header>
        <requestID>33eeb7e5-2f43-434b-abb6-72ad327b9a53</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>c98d64c6-6426-4c62-9970-00b3e52eb26b</customerID>
        <domainName>www.testing.com</domainName>
        <budget>75.0</budget>
        <anniversaryDate>2012-12-14Z</anniversaryDate>
        <currencyID>1</currencyID>
    </customer>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <businessAreaID>10196</businessAreaID>
        <businessLocationID>18</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.testing.com</destinationURL>
            <displayURL>www.testing.com</displayURL>
        </customLandingPage>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
2012-12-14 16:20:01,651 INFO  [com.thesearchagency.core.smb.service.admaxdeployment.component.AdMaxAccountDeploymentBD] (http-0.0.0.0-8080-1) deployCampaigns: customerID = c98d64c6-6426-4c62-9970-00b3e52eb26b, requestID = 33eeb7e5-2f43-434b-abb6-72ad327b9a53
2012-12-14 16:20:01,671 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:01,671 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [select * from accounts where description = ? ]
2012-12-14 16:20:01,680 INFO  [org.apache.cxf.interceptor.LoggingInInterceptor] (http-0.0.0.0-8080-1) Outbound Message
---------------------------
ID: 178
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:deployCampaignsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><deployCampaignsResponse><header><requestID>33eeb7e5-2f43-434b-abb6-72ad327b9a53</requestID><retryID>1</retryID></header><result><resultCode>failure</resultCode><resultString>all non-deleted campaigns for the customer must be included in the request; please add the missing ones or delete them first (via updateCampaignStatus) then re-submit request</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
2012-12-14 16:20:02,400 INFO  [org.apache.cxf.interceptor.LoggingInInterceptor] (http-0.0.0.0-8080-1) Inbound Message
----------------------------
ID: 179
Address: /SMB-BES/BudgetEstimateService
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=[aq-qa-jboss1:8080], Content-Length=[385], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.6.2], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><businessAreaID>10196</businessAreaID><businessLocationID>18</businessLocationID><currencyID>1</currencyID></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
2012-12-14 16:20:02,404 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:02,405 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=?]
2012-12-14 16:20:02,413 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:02,413 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
2012-12-14 16:20:02,416 INFO  [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8080-1) Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
2012-12-14 16:20:02,416 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:02,416 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
2012-12-14 16:20:02,439 DEBUG [com.thesearchagency.core.smb.service.keyword.service.impl.KeywordServiceImpl] (http-0.0.0.0-8080-1) Getting keywords for BF: 10196
2012-12-14 16:20:02,440 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:02,440 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
2012-12-14 16:20:02,453 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'id' to property 'ID' of type int
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'keywordListID' to property 'keywordListID' of type int
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'keyword' to property 'keyword' of type class java.lang.String
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'isMobile' to property 'isMobile' of type boolean
2012-12-14 16:20:02,454 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8080-1) Mapping column 'isNegative' to property 'isNegative' of type boolean
2012-12-14 16:20:02,461 DEBUG [com.thesearchagency.core.smb.service.keyword.service.impl.KeywordServiceImpl] (http-0.0.0.0-8080-1) 63 keywords found for BF: 10196
2012-12-14 16:20:02,461 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:02,461 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?]
2012-12-14 16:20:02,463 DEBUG [com.thesearchagency.core.smb.service.keyword.service.impl.KeywordServiceImpl] (http-0.0.0.0-8080-1) 63 keywords found for BF: 10196
2012-12-14 16:20:02,464 INFO  [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8080-1) Requesting most recent demand map later than 2012-11-08 16:58:29
2012-12-14 16:20:02,464 INFO  [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8080-1) Query: SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.time DESC LIMIT 1
2012-12-14 16:20:02,464 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL query
2012-12-14 16:20:02,464 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8080-1) Executing prepared SQL statement [SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.time DESC LIMIT 1]
2012-12-14 16:20:02,467 ERROR [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8080-1) A demand map was found with min/max prices = 21.960674/29.82314
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Looking for target ID: 40
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Checking raw demand map for: 10196-0
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Finalizing demand map . . . minPrice = 21.960674
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1)                             maxPrice = 29.82314
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Daily pricing . . . maxPrice = 29.82314
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Budget estimate using multiplier (1.0) . . . maxPrice = 907.722
2012-12-14 16:20:02,467 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Set origin to: CACHE
2012-12-14 16:20:02,467 INFO  [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) BES - Number of keywords in estimate request: 19
2012-12-14 16:20:02,468 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Quota costs . . . 0.0
2012-12-14 16:20:02,468 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Final demand map . . . minPrice = 34.593
2012-12-14 16:20:02,468 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1)                        maxPrice = 907.722
2012-12-14 16:20:02,468 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1)                        minClicks = 3.0
2012-12-14 16:20:02,468 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1)                        maxClicks = 70.849
2012-12-14 16:20:02,468 INFO  [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8080-1) Request time: 65 millis
2012-12-14 16:20:02,483 INFO  [org.apache.cxf.interceptor.LoggingInInterceptor] (http-0.0.0.0-8080-1) Outbound Message
---------------------------
ID: 179
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>10196</businessAreaID><businessLocationID>18</businessLocationID><currencyID>1</currencyID></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2012-12-14T16:05:24.000Z</lastUpdateTime><minimumPrice>34.593</minimumPrice><maximumPrice>907.722</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>70.849</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------