[TSAApp@aq-qa2-core1 ~]$ tail -f /home/TSAApp/apps/jboss-5.1.0.GA/tsa_messaging_node_server.log
09:53:44,911 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:53:44,942 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
09:54:44,943 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:54:44,943 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:54:44,944 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:54:44,985 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
09:55:44,987 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:55:44,987 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:55:44,989 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:55:45,025 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT



09:56:45,025 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:56:45,026 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:56:45,027 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:56:45,060 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
09:57:45,060 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:57:45,060 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:57:45,061 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:57:45,095 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
09:58:45,095 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:58:45,095 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:58:45,096 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:58:45,125 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
09:58:51,488 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=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>595</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
09:58:51,497 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,497 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=?]
09:58:51,510 INFO  [AuthChallengeProcessor] digest authentication scheme selected
09:58:51,531 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
09:58:51,537 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=?
09:58:51,537 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,537 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=?]
09:58:51,556 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 595
09:58:51,556 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,557 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,'(-+|[[:>:]])')) ]
09:58:51,564 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:58:51,565 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:58:51,573 DEBUG [KeywordServiceImpl] 80 keywords found for KL: 595
09:58:51,573 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,573 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:58:51,575 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,575 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:58:51,578 DEBUG [KeywordServiceImpl] 80 keywords found for KL: 595
09:58:51,593 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
09:58:51,596 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
09:58:51,596 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
09:58:51,596 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,597 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]
09:58:51,600 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 514.6398/698.8934
09:58:51,601 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 514.6398
09:58:51,601 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 698.8934
09:58:51,602 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 698.8934
09:58:51,602 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 21272.113
09:58:51,602 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
09:58:51,602 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 42
09:58:51,603 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
09:58:51,603 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 18.336
09:58:51,603 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 21272.113
09:58:51,603 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
09:58:51,604 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 3132.368
09:58:51,604 INFO  [BudgetEstimateServiceImpl] Request time: 111 millis
09:58:51,637 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>Google</distribution><keywordListID>595</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-04-21T14:21:05.000Z</lastUpdateTime><minimumPrice>18.336</minimumPrice><maximumPrice>21272.113</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>3132.368</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
09:58:51,905 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 499
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 3.0.7], 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>da625292-2e04-4b42-829d-55951154a19d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
09:58:51,910 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,911 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
09:58:51,918 WARN  [CustomerDAO] Unable to find account: bpID da625292-2e04-4b42-829d-55951154a19d
09:58:51,918 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=false, smb-admax-deployment-service.hostname=localhost}
09:58:51,919 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:51,920 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=?]
09:58:51,928 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 499
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>da625292-2e04-4b42-829d-55951154a19d</customerID></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
09:58:52,010 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 500
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 3.0.7], 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>fc2f69af-b0a8-4587-8ad0-288e40f79976</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>da625292-2e04-4b42-829d-55951154a19d</customerID>
        <domainName>www.example.com</domainName>
        <budget>
            <attributes>
                <entry>
                    <key>GOOGLE</key>
                    <value>52.0</value>
                </entry>
            </attributes>
        </budget>
        <anniversaryDate>2016-04-22</anniversaryDate>
        <currencyCode>USD</currencyCode>
        <timeZone>America/New_York</timeZone>
        <countryCode>US</countryCode>
    </customer>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <distribution>Google</distribution>
        <businessAreaID>10001</businessAreaID>
        <keywordListID>595</keywordListID>
        <businessLocationID>1</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.example.com</destinationURL>
            <displayURL>www.example.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <campaignDataList>
            <type>phoneNumber</type>
            <attributes>
                <entry>
                    <key>countryCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">US</value>
                </entry>
                <entry>
                    <key>number</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">+81 3-3470-4611</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>location</type>
            <attributes>
                <entry>
                    <key>postalCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">2903</value>
                </entry>
                <entry>
                    <key>encodedLocation</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">234</value>
                </entry>
                <entry>
                    <key>streetAddress1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">42 Ladd Street Building 3</value>
                </entry>
                <entry>
                    <key>streetAddress2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Unit 321</value>
                </entry>
                <entry>
                    <key>provinceCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">RI</value>
                </entry>
                <entry>
                    <key>countryCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">US</value>
                </entry>
                <entry>
                    <key>number</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">2165442323</value>
                </entry>
                <entry>
                    <key>companyName</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">admaxLocal</value>
                </entry>
                <entry>
                    <key>city</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">East GreenWich</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>siteLink</type>
            <attributes>
                <entry>
                    <key>linkText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Test Sitelink</value>
                </entry>
                <entry>
                    <key>url</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/link1</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>siteLink</type>
            <attributes>
                <entry>
                    <key>linkText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Test Sitelink2</value>
                </entry>
                <entry>
                    <key>url</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/link2</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</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">We'll See You Soon!</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">http://www.example.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.example.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">United States Hotel Room.</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:Luxury Spa Resort}</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">United States Spa Resort.</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">http://www.example.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.example.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">You'll Be Glad You Stayed With Us.</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">The Spa Resort for You</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">United States Hotel Room.</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">http://www.example.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.example.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">We'll See You Soon!</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">Luxury Spa Resort</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">You'll Be Glad You Stayed With Us.</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">http://www.example.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.example.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">United States Spa Resort.</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:The Spa Resort for You}</value>
                </entry>
            </attributes>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
09:58:52,022 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = da625292-2e04-4b42-829d-55951154a19d, requestID = fc2f69af-b0a8-4587-8ad0-288e40f79976
09:58:52,069 INFO  [ValidationUtils] TIMEZONE = America/New_York
09:58:52,069 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,069 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
09:58:52,074 DEBUG [AdMaxAccountDeploymentBD] New account [da625292-2e04-4b42-829d-55951154a19d]
09:58:52,075 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,075 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
09:58:52,079 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,084 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,084 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
09:58:52,089 WARN  [CustomerDAO] Unable to find campaign: advertID da625292-2e04-4b42-829d-55951154a19d-XSkWKu0E0M
09:58:52,089 DEBUG [JdbcTemplate] Executing SQL update and returning generated keys
09:58:52,089 DEBUG [JdbcTemplate] Executing prepared SQL statement
09:58:52,093 DEBUG [JdbcTemplate] SQL update affected 1 rows and returned 1 keys
09:58:52,095 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,095 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set advertID=? where id=?]
09:58:52,099 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,165 WARN  [QueueUtils] Setting message priority to 4
09:58:52,179 INFO  [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: 293
09:58:52,184 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 500
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>fc2f69af-b0a8-4587-8ad0-288e40f79976</requestID><retryID>1</retryID></header><result><resultCode>queued</resultCode><resultString>queued</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
09:58:52,186 INFO  [AdMaxDeploymentServiceImpl] Starting deploy campaign message conversion
09:58:52,187 INFO  [AdMaxDeploymentServiceImpl] UpdateTypes: [ALL]
09:58:52,204 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,204 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
09:58:52,214 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,214 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
09:58:52,217 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,219 INFO  [AdMaxDeploymentServiceImpl] 1 Campaign(s) to process.
09:58:52,234 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
09:58:52,234 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,235 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
09:58:52,244 DEBUG [AdMaxDeploymentServiceImpl] Processing CampaignInfo...
09:58:52,244 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessLocationId [1]
09:58:52,244 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessAreaID [10001]
09:58:52,245 DEBUG [AdMaxDeploymentServiceImpl] Retrieving KeywordListID [595]
09:58:52,252 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,252 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=?]
09:58:52,262 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,262 DEBUG [JdbcTemplate] 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=? order by bcam.businessCategoryID limit 1]
09:58:52,265 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessLocation
Location:  ID: 1 Description: United States Short Description: United States Status: active Type: Country ParentBusinessLocationID: 0 Use SE Defined Targets: [com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@2cb50008] Use Point Radius Targets: [com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@1f152426] Is Sellable: true
09:58:52,265 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessArea
BusinessArea:  ID: 10001 Description: Spa Resorts Status: active BusinessCategoryID: 1
09:58:52,267 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,267 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, target, description, type, code from mms_common.googleLocationTargets join mms_common.businessLocationTargetMap bltm on bltm.distributionID = 3 and bltm.businessLocationTargetID = id where bltm.businessLocationID = ?]
09:58:52,275 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,275 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 and merchantUUID='') where l.businessFunctionID = ? and k.matchType = ?]
09:58:52,284 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10001
09:58:52,284 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,284 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' ]
09:58:52,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:58:52,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:58:52,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:58:52,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:58:52,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:58:52,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:58:52,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:58:52,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:58:52,294 DEBUG [KeywordServiceImpl] 80 keywords found for BF: 10001, keywordListID: 595
09:58:52,294 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,295 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:58:52,297 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,297 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:58:52,300 DEBUG [KeywordServiceImpl] 80 keywords found for BF: 10001, keywordListID: 595
09:58:52,302 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,303 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, locationID, aliasType, description, descType, ordering, shortDescription  from mms_common.locationAliases where locationID=? and aliasType=? order by ordering asc]
09:58:52,304 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:58:52,304 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
09:58:52,304 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'aliasType' to property 'aliasType' of type int
09:58:52,305 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'description' to property 'description' of type class java.lang.String
09:58:52,305 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'descType' to property 'descType' of type int
09:58:52,305 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'ordering' to property 'ordering' of type int
09:58:52,305 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'shortDescription' to property 'shortDescription' of type class java.lang.String
09:58:52,324 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10001
09:58:52,324 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,324 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' ]
09:58:52,326 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:58:52,326 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:58:52,326 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:58:52,327 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:58:52,327 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:58:52,327 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:58:52,327 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:58:52,327 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:58:52,335 DEBUG [KeywordServiceImpl] 80 keywords found for BF: 10001, keywordListID: 595
09:58:52,336 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,336 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:58:52,338 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,338 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:58:52,341 DEBUG [KeywordServiceImpl] 80 keywords found for BF: 10001, keywordListID: 595
09:58:52,442 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,442 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campaigns (accountID, advertID, businessFunctionID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution) select a.id, ?, ?, ?, ?, ?, ?, ? from mms_common.accounts a where a.bpID = ? on duplicate key update customerDisplayURL = ?, customerDestinationURL = ?]
09:58:52,445 DEBUG [JdbcTemplate] SQL update affected 2 rows
09:58:52,446 INFO  [CustomerDAO] setting keywordListID to 595 for advertID 293
09:58:52,446 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,447 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set keywordListID = ? where advertID = ?]
09:58:52,448 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,449 INFO  [AdMaxDeploymentServiceImpl] Finished deploy campaign message conversion. 1 converted.
09:58:52,449 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,450 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
09:58:52,452 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,452 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
09:58:52,455 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,455 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
09:58:52,456 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,487 WARN  [QueueUtils] Setting message priority to 4
09:58:52,540 INFO  [AdMaxDeploymentRequestMDB] Sent DEPLOY request to listener. BPID: da625292-2e04-4b42-829d-55951154a19d DeployID: fc2f69af-b0a8-4587-8ad0-288e40f79976
09:58:52,671 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,673 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts(description,tier,priority,conversionTypes,isBidManaged,isActive,perfMetric,providesConversionData,addConversionData,databaseInstance,warehouseInstance,isOnline,currencyCode,timeZoneID) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)]
09:58:52,683 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,684 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
09:58:52,687 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,687 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into sites(accountID,isDefault,description,internalURLPattern,ignorePixels) values(?,?,?,?,?)]
09:58:52,691 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,692 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
09:58:52,695 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,695 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into userAccountMap(userID,accountID) values(?,?)]
09:58:52,697 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,698 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,698 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`description` = ?]
09:58:52,701 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,702 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?]
09:58:52,706 INFO  [DatabaseInstancePersistenceManager] Database URL: jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&amp;characterEncoding=UTF-8
09:58:52,706 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,706 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accountChannelMap(accountID,channelID) values(?,?)]
09:58:52,729 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,731 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,731 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
09:58:52,754 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,756 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,757 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
09:58:52,780 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,782 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,782 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
09:58:52,805 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,807 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,807 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)]
09:58:52,832 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,834 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
09:58:52,859 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,859 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)]
09:58:52,893 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:58:52,894 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
09:58:52,950 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,950 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`id` = ?]
09:58:52,956 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,956 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?]
09:58:52,959 DEBUG [JdbcTemplate] Executing prepared SQL query
09:58:52,959 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
09:58:52,998 DEBUG [JdbcTemplate] Executing prepared SQL update
09:58:52,999 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into admaxAccountAnniversary(accountId,anniversaryDate,startDate) values(?,?,?) on duplicate key update endDate= ?]
09:58:53,017 DEBUG [JdbcTemplate] SQL update affected 1 rows
09:59:00,261 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 501
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 3.0.7], 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>da625292-2e04-4b42-829d-55951154a19d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
09:59:00,265 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:00,266 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
09:59:00,271 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:59:00,271 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
09:59:00,271 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
09:59:00,274 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=false, smb-admax-deployment-service.hostname=localhost}
09:59:00,274 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:00,274 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=?]
09:59:00,279 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:59:00,280 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
09:59:00,280 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
09:59:00,280 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
09:59:00,280 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:59:00,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
09:59:00,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
09:59:00,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
09:59:00,282 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
09:59:00,282 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
09:59:00,292 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 293: Paused -> Paused
09:59:00,292 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 293 -> PAUSED
09:59:00,295 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
09:59:00,295 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:00,295 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
09:59:00,308 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:00,309 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
09:59:00,315 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:00,315 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
09:59:00,321 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:00,322 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 = ? ]
09:59:00,330 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 501
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>da625292-2e04-4b42-829d-55951154a19d</customerID><domain>www.example.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>293</campaignID><businessAreaID>10001</businessAreaID><keywordListID>595</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://www.example.com</destinationURL><displayURL>www.example.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
09:59:40,390 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 502
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=[454], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>1391</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
09:59:40,400 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,400 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=?]
09:59:40,409 INFO  [AuthChallengeProcessor] digest authentication scheme selected
09:59:40,428 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
09:59:40,431 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=?
09:59:40,432 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,432 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=?]
09:59:40,452 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1391
09:59:40,453 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,453 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,'(-+|[[:>:]])')) ]
09:59:40,458 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:59:40,463 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:59:40,463 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:59:40,464 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:59:40,464 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:59:40,464 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:59:40,464 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:59:40,464 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:59:40,472 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 1391
09:59:40,473 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,473 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:59:40,477 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,477 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:59:40,479 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 1391
09:59:40,495 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
09:59:40,498 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
09:59:40,498 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
09:59:40,498 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,499 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]
09:59:40,504 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 718.16394/975.2843
09:59:40,505 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 718.16394
09:59:40,505 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 975.2843
09:59:40,505 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 975.2843
09:59:40,505 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 29684.582
09:59:40,505 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
09:59:40,505 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 50
09:59:40,506 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
09:59:40,506 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 37.438
09:59:40,506 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 29684.582
09:59:40,506 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
09:59:40,506 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 2140.802
09:59:40,507 INFO  [BudgetEstimateServiceImpl] Request time: 112 millis
09:59:40,591 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 502
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>1391</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-04-22T07:17:10.000Z</lastUpdateTime><minimumPrice>37.438</minimumPrice><maximumPrice>29684.582</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>2140.802</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
09:59:40,665 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 503
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=[454], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>1391</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
09:59:40,685 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,685 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=?]
09:59:40,695 INFO  [AuthChallengeProcessor] digest authentication scheme selected
09:59:40,714 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
09:59:40,716 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=?
09:59:40,716 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,716 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=?]
09:59:40,726 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1391
09:59:40,726 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,726 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,'(-+|[[:>:]])')) ]
09:59:40,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:59:40,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:59:40,741 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 1391
09:59:40,741 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,741 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:59:40,743 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,743 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:59:40,746 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 1391
09:59:40,762 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
09:59:40,769 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
09:59:40,769 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
09:59:40,769 DEBUG [JdbcTemplate] Executing prepared SQL query
09:59:40,769 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]
09:59:40,774 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 718.16394/975.2843
09:59:40,774 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 718.16394
09:59:40,775 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 975.2843
09:59:40,775 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 975.2843
09:59:40,775 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 29684.582
09:59:40,775 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
09:59:40,775 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 50
09:59:40,775 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
09:59:40,775 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 37.438
09:59:40,775 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 29684.582
09:59:40,775 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
09:59:40,775 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 2140.802
09:59:40,776 INFO  [BudgetEstimateServiceImpl] Request time: 93 millis
09:59:40,836 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 503
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>1391</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-04-22T07:17:10.000Z</lastUpdateTime><minimumPrice>37.438</minimumPrice><maximumPrice>29684.582</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>2140.802</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
09:59:45,127 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:59:45,130 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:59:45,131 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:59:45,177 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
10:00:00,266 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 504
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 3.0.7], 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>da625292-2e04-4b42-829d-55951154a19d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
10:00:00,271 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:00,271 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
10:00:00,276 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:00:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
10:00:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
10:00:00,279 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=false, smb-admax-deployment-service.hostname=localhost}
10:00:00,280 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:00,280 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=?]
10:00:00,284 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:00:00,285 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
10:00:00,285 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
10:00:00,285 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
10:00:00,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:00:00,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
10:00:00,286 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
10:00:00,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
10:00:00,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
10:00:00,287 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
10:00:00,297 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 293: Paused -> Paused
10:00:00,297 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 293 -> PAUSED
10:00:00,299 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
10:00:00,300 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:00,300 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
10:00:00,310 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:00,311 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
10:00:00,317 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:00,317 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
10:00:00,323 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:00,323 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 = ? ]
10:00:00,332 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 504
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>da625292-2e04-4b42-829d-55951154a19d</customerID><domain>www.example.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>293</campaignID><businessAreaID>10001</businessAreaID><keywordListID>595</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://www.example.com</destinationURL><displayURL>www.example.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
10:00:15,990 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 505
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=[454], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>1102</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:00:16,038 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 506
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=[454], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>1102</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:00:16,085 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,086 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=?]
10:00:16,088 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,089 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=?]
10:00:16,161 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:00:16,162 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:00:16,180 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
10:00:16,183 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
10:00:16,185 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=?
10:00:16,185 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,185 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=?]
10:00:16,187 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=?
10:00:16,187 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,188 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=?]
10:00:16,223 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1102
10:00:16,224 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,224 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,'(-+|[[:>:]])')) ]
10:00:16,229 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1102
10:00:16,229 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,230 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,'(-+|[[:>:]])')) ]
10:00:16,321 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:00:16,321 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:00:16,321 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:00:16,322 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:00:16,322 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:00:16,322 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:00:16,322 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:00:16,322 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:00:16,324 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:00:16,343 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:00:16,356 DEBUG [KeywordServiceImpl] 92 keywords found for KL: 1102
10:00:16,357 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,357 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:00:16,357 DEBUG [KeywordServiceImpl] 92 keywords found for KL: 1102
10:00:16,358 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,358 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:00:16,360 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,360 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:00:16,363 DEBUG [KeywordServiceImpl] 92 keywords found for KL: 1102
10:00:16,373 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,373 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:00:16,376 DEBUG [KeywordServiceImpl] 92 keywords found for KL: 1102
10:00:16,378 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
10:00:16,381 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:00:16,381 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
10:00:16,381 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,381 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]
10:00:16,385 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 3.6625807/4.973875
10:00:16,386 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 3.6625807
10:00:16,386 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 4.973875
10:00:16,386 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 4.973875
10:00:16,386 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 151.389
10:00:16,386 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:00:16,386 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
10:00:16,386 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
10:00:16,386 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 3.997
10:00:16,386 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 151.389
10:00:16,386 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:00:16,387 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 102.268
10:00:16,387 INFO  [BudgetEstimateServiceImpl] Request time: 305 millis
10:00:16,395 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
10:00:16,398 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:00:16,398 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
10:00:16,398 DEBUG [JdbcTemplate] Executing prepared SQL query
10:00:16,398 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]
10:00:16,402 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 3.6625807/4.973875
10:00:16,402 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 3.6625807
10:00:16,402 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 4.973875
10:00:16,402 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 4.973875
10:00:16,402 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 151.389
10:00:16,402 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:00:16,402 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
10:00:16,402 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
10:00:16,403 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 3.997
10:00:16,403 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 151.389
10:00:16,403 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:00:16,403 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 102.268
10:00:16,403 INFO  [BudgetEstimateServiceImpl] Request time: 319 millis
10:00:16,518 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 506
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>1102</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-04-22T07:55:33.000Z</lastUpdateTime><minimumPrice>3.997</minimumPrice><maximumPrice>151.389</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>102.268</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:00:16,519 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 505
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>1102</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-04-22T07:55:33.000Z</lastUpdateTime><minimumPrice>3.997</minimumPrice><maximumPrice>151.389</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>102.268</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:00:45,174 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
10:00:45,236 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
10:00:45,238 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
10:00:45,278 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
10:01:00,261 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 507
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 3.0.7], 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>da625292-2e04-4b42-829d-55951154a19d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
10:01:00,321 DEBUG [JdbcTemplate] Executing prepared SQL query
10:01:00,321 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
10:01:00,324 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:01:00,324 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
10:01:00,324 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
10:01:00,326 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=false, smb-admax-deployment-service.hostname=localhost}
10:01:00,326 DEBUG [JdbcTemplate] Executing prepared SQL query
10:01:00,326 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=?]
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
10:01:00,335 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
10:01:00,336 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
10:01:00,336 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
10:01:00,361 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 293: Paused -> Paused
10:01:00,379 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 293 -> PAUSED
10:01:00,380 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
10:01:00,380 DEBUG [JdbcTemplate] Executing prepared SQL query
10:01:00,380 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
10:01:00,407 DEBUG [JdbcTemplate] Executing prepared SQL query
10:01:00,407 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
10:01:00,428 DEBUG [JdbcTemplate] Executing prepared SQL query
10:01:00,428 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
10:01:00,441 DEBUG [JdbcTemplate] Executing prepared SQL query
10:01:00,441 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 = ? ]
10:01:00,498 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 507
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>da625292-2e04-4b42-829d-55951154a19d</customerID><domain>www.example.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>293</campaignID><businessAreaID>10001</businessAreaID><keywordListID>595</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://www.example.com</destinationURL><displayURL>www.example.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
10:01:45,277 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
10:01:45,348 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
10:01:45,348 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
10:01:45,381 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
10:02:00,252 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 508
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 3.0.7], 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>da625292-2e04-4b42-829d-55951154a19d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
10:02:00,265 DEBUG [JdbcTemplate] Executing prepared SQL query
10:02:00,265 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
10:02:00,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:02:00,271 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
10:02:00,271 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
10:02:00,273 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=false, smb-admax-deployment-service.hostname=localhost}
10:02:00,286 DEBUG [JdbcTemplate] Executing prepared SQL query
10:02:00,286 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=?]
10:02:00,288 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:02:00,288 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
10:02:00,288 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
10:02:00,288 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
10:02:00,288 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:02:00,288 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
10:02:00,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
10:02:00,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
10:02:00,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
10:02:00,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
10:02:00,295 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 293: Paused -> Paused
10:02:00,295 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 293 -> PAUSED
10:02:00,296 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
10:02:00,296 DEBUG [JdbcTemplate] Executing prepared SQL query
10:02:00,296 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
10:02:00,303 DEBUG [JdbcTemplate] Executing prepared SQL query
10:02:00,303 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
10:02:00,306 DEBUG [JdbcTemplate] Executing prepared SQL query
10:02:00,306 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
10:02:00,310 DEBUG [JdbcTemplate] Executing prepared SQL query
10:02:00,310 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 = ? ]
10:02:00,334 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 508
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>da625292-2e04-4b42-829d-55951154a19d</customerID><domain>www.example.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>293</campaignID><businessAreaID>10001</businessAreaID><keywordListID>595</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://www.example.com</destinationURL><displayURL>www.example.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
10:02:45,373 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
10:02:45,375 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
10:02:45,377 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
10:02:45,422 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
10:03:00,260 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 509
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 3.0.7], 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>da625292-2e04-4b42-829d-55951154a19d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
10:03:00,266 DEBUG [JdbcTemplate] Executing prepared SQL query
10:03:00,266 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
10:03:00,269 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:03:00,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
10:03:00,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
10:03:00,271 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=false, smb-admax-deployment-service.hostname=localhost}
10:03:00,272 DEBUG [JdbcTemplate] Executing prepared SQL query
10:03:00,272 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=?]
10:03:00,276 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:03:00,276 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
10:03:00,276 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
10:03:00,276 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
10:03:00,276 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:03:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
10:03:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
10:03:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
10:03:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
10:03:00,277 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
10:03:00,293 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 293: Paused -> Paused
10:03:00,294 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 293 -> PAUSED
10:03:00,296 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
10:03:00,296 DEBUG [JdbcTemplate] Executing prepared SQL query
10:03:00,296 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
10:03:00,309 DEBUG [JdbcTemplate] Executing prepared SQL query
10:03:00,310 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
10:03:00,318 DEBUG [JdbcTemplate] Executing prepared SQL query
10:03:00,318 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
10:03:00,322 DEBUG [JdbcTemplate] Executing prepared SQL query
10:03:00,322 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 = ? ]
10:03:00,328 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 509
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>da625292-2e04-4b42-829d-55951154a19d</customerID><domain>www.example.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>293</campaignID><businessAreaID>10001</businessAreaID><keywordListID>595</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://www.example.com</destinationURL><displayURL>www.example.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------