14:44:27,373 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:44:27,374 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:44:27,374 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:44:27,387 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:45:27,387 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:45:27,387 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:45:27,388 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:45:27,403 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:46:13,351 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 493
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=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], 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:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>b95726aa-4034-4242-b68a-300da377e92e</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:46:13,352 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,352 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:46:13,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:13,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:46:13,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:46:13,354 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:46:13,354 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,355 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:46:13,356 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:46:13,361 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4285: Active -> Active
14:46:13,361 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4285 -> ACTIVE
14:46:13,363 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4286: Active -> Active
14:46:13,363 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4286 -> ACTIVE
14:46:13,364 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:46:13,364 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,364 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:46:13,368 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,368 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:46:13,370 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,370 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:46:13,372 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,372 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:46:13,376 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 493
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getCampaignsByCustomerIDResponse xmlns:ns2="http://thesearchagency.com/smb/core"><CampaignListResponse><customerID>b95726aa-4034-4242-b68a-300da377e92e</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4285</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4286</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:46:13,421 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 494
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], transfer-encoding=[chunked], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], 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>a8a9e252-6a00-4383-95c7-cad78ce39fa4</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>b95726aa-4034-4242-b68a-300da377e92e</customerID>
        <domainName>www.merchantsite.com</domainName>
        <budget>2.0</budget>
        <anniversaryDate>2015-10-16</anniversaryDate>
        <currencyCode>USD</currencyCode>
        <timeZone>America/New_York</timeZone>
        <countryCode>US</countryCode>
    </customer>
    <campaignList>
        <campaignID>4285</campaignID>
        <distribution>Google</distribution>
        <businessAreaID>10135</businessAreaID>
        <keywordListID>384</keywordListID>
        <businessLocationID>44</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Secure Option For Bike Locks.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Stronger Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Excellent Range Of Bike Locks.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Customer Satisfaction Assured.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Locks For Your Bike</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Customer Satisfaction Assured.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Excellent Range Of Bike Locks.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Locks For Your Bike}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Secure Option For Bike Locks.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Stronger Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
14:46:13,426 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = b95726aa-4034-4242-b68a-300da377e92e, requestID = a8a9e252-6a00-4383-95c7-cad78ce39fa4
14:46:13,444 INFO  [ValidationUtils] TIMEZONE = America/New_York
14:46:13,444 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:13,444 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:46:13,450 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 494
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>a8a9e252-6a00-4383-95c7-cad78ce39fa4</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>
--------------------------------------
14:46:15,351 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 495
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=[aml-svc-campaign:8080], Content-Length=[453], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], 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><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:46:15,354 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,354 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:46:15,358 INFO  [BudgetEstimateDAO] 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=?
14:46:15,358 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,358 DEBUG [JdbcTemplate] 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=?]
14:46:15,363 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:46:15,363 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,363 DEBUG [JdbcTemplate] 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 k.keywordListID = ? 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,'(-+|[[:>:]])')) ]
14:46:15,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:15,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:46:15,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:46:15,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:46:15,366 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:46:15,366 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:46:15,366 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:46:15,366 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:46:15,373 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:15,373 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,373 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:46:15,374 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,375 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:46:15,376 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:15,376 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:46:15,376 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:46:15,376 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,376 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:46:15,378 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1.4913535/2.025296
14:46:15,378 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1.4913535
14:46:15,378 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2.025296
14:46:15,378 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2.025296
14:46:15,378 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 61.644
14:46:15,378 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:46:15,378 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:46:15,378 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:46:15,379 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 15.698
14:46:15,379 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 61.644
14:46:15,379 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:46:15,379 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 10.603
14:46:15,379 INFO  [BudgetEstimateServiceImpl] Request time: 26 millis
14:46:15,467 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 495
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><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-01T15:23:10.000Z</lastUpdateTime><minimumPrice>15.698</minimumPrice><maximumPrice>61.644</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>10.603</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:46:15,636 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 496
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=[aml-svc-campaign:8080], Content-Length=[451], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], 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><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:46:15,639 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,640 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:46:15,642 INFO  [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?
14:46:15,642 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,642 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?]
14:46:15,665 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:46:15,665 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,665 DEBUG [JdbcTemplate] 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 k.keywordListID = ? 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,'(-+|[[:>:]])')) ]
14:46:15,667 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:15,667 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:46:15,667 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:46:15,667 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:46:15,668 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:46:15,668 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:46:15,668 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:46:15,668 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:46:15,675 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:15,675 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,675 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:46:15,677 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,677 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:46:15,678 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:15,678 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:46:15,678 INFO  [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1
14:46:15,678 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:15,679 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1]
14:46:15,680 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 12.650002/50.598568
14:46:15,680 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 12.650002
14:46:15,681 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 50.598568
14:46:15,681 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 50.598568
14:46:15,681 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (0.02) . . . maxPrice = 30.801
14:46:15,681 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:46:15,681 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:46:15,681 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.701
14:46:15,681 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 30.801
14:46:15,681 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 2.495
14:46:15,681 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 9.982
14:46:15,681 INFO  [BudgetEstimateServiceImpl] Request time: 43 millis
14:46:15,850 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 496
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><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-12T13:37:42.000Z</lastUpdateTime><minimumPrice>7.701</minimumPrice><maximumPrice>30.801</maximumPrice><minimumClicks>2.495</minimumClicks><maximumClicks>9.982</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:46:16,143 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 497
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=[aml-svc-campaign:8080], Content-Length=[453], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], 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><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:46:16,146 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,146 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:46:16,149 INFO  [BudgetEstimateDAO] 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=?
14:46:16,149 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,149 DEBUG [JdbcTemplate] 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=?]
14:46:16,154 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:46:16,154 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,154 DEBUG [JdbcTemplate] 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 k.keywordListID = ? 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,'(-+|[[:>:]])')) ]
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:46:16,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:46:16,163 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:16,163 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,163 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:46:16,165 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:46:16,166 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:16,166 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:46:16,166 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:46:16,166 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,167 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 498
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=[aml-svc-campaign:8080], Content-Length=[451], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], 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><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:46:16,168 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:46:16,171 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,171 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:46:16,171 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1.4913535/2.025296
14:46:16,171 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1.4913535
14:46:16,171 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2.025296
14:46:16,172 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2.025296
14:46:16,172 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 61.644
14:46:16,172 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:46:16,172 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:46:16,172 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:46:16,172 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 15.698
14:46:16,172 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 61.644
14:46:16,172 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:46:16,172 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 10.603
14:46:16,172 INFO  [BudgetEstimateServiceImpl] Request time: 27 millis
14:46:16,173 INFO  [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?
14:46:16,173 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,173 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?]
14:46:16,178 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:46:16,178 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,178 DEBUG [JdbcTemplate] 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 k.keywordListID = ? 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,'(-+|[[:>:]])')) ]
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:46:16,180 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:46:16,187 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:16,188 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,188 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:46:16,189 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,189 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:46:16,191 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:46:16,191 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:46:16,191 INFO  [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1
14:46:16,191 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:16,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1]
14:46:16,193 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 12.650002/50.598568
14:46:16,194 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 12.650002
14:46:16,194 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 50.598568
14:46:16,194 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 50.598568
14:46:16,194 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (0.02) . . . maxPrice = 30.801
14:46:16,194 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:46:16,194 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:46:16,194 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.701
14:46:16,194 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 30.801
14:46:16,194 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 2.495
14:46:16,194 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 9.982
14:46:16,194 INFO  [BudgetEstimateServiceImpl] Request time: 25 millis
14:46:16,418 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 497
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><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-01T15:23:10.000Z</lastUpdateTime><minimumPrice>15.698</minimumPrice><maximumPrice>61.644</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>10.603</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:46:16,419 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 498
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><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-12T13:37:42.000Z</lastUpdateTime><minimumPrice>7.701</minimumPrice><maximumPrice>30.801</maximumPrice><minimumClicks>2.495</minimumClicks><maximumClicks>9.982</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:46:27,402 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:46:27,402 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:46:27,402 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:46:27,417 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT