14:43:30,233 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:43:30,233 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:43:30,234 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:43:30,245 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:44:30,244 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:44:30,244 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:44:30,245 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:44:30,265 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:44:31,836 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 162
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[453], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:31,840 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,840 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:31,843 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
14:44:31,843 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,843 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
14:44:31,849 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:31,849 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,849 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:31,852 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:31,852 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:31,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:31,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:31,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:31,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:31,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:31,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:31,863 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 163
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[451], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:31,863 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:31,863 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,863 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:31,865 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,865 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:31,866 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,867 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:31,867 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:31,868 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:31,868 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:44:31,868 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,868 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:44:31,869 INFO  [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?
14:44:31,869 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,869 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?]
14:44:31,873 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1.9813778/2.69076
14:44:31,873 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1.9813778
14:44:31,873 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2.69076
14:44:31,873 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2.69076
14:44:31,873 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 81.898
14:44:31,873 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:31,873 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:31,874 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:44:31,874 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 5.138
14:44:31,874 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 81.898
14:44:31,874 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:31,874 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 43.034
14:44:31,874 INFO  [BudgetEstimateServiceImpl] Request time: 36 millis
14:44:31,881 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:31,881 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,881 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:31,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:31,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:31,884 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:31,884 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:31,884 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:31,884 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:31,884 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:31,884 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:31,893 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:31,893 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,893 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:31,895 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,895 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:31,896 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:31,896 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:31,896 INFO  [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1
14:44:31,897 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:31,897 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1]
14:44:31,899 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 37.45429/149.81712
14:44:31,899 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 37.45429
14:44:31,899 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 149.81712
14:44:31,899 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 149.81712
14:44:31,899 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (0.02) . . . maxPrice = 91.199
14:44:31,899 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:31,899 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:31,899 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 13.923
14:44:31,900 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 91.199
14:44:31,900 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:31,900 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 19.651
14:44:31,900 INFO  [BudgetEstimateServiceImpl] Request time: 35 millis
14:44:32,049 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 162
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T11:52:42.000Z</lastUpdateTime><minimumPrice>5.138</minimumPrice><maximumPrice>81.898</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>43.034</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:32,054 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 163
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T12:19:56.000Z</lastUpdateTime><minimumPrice>13.923</minimumPrice><maximumPrice>91.199</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>19.651</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:43,301 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 164
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:44:43,302 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,302 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:44:43,304 WARN  [CustomerDAO] Unable to find account: bpID 3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5
14:44:43,304 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:44:43,305 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,305 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:44:43,307 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 164
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:43,383 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 165
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], transfer-encoding=[chunked], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:deployCampaigns xmlns:core="http://thesearchagency.com/smb/core">
<deployCampaignsRequest>
    <header>
        <requestID>919e0753-c8df-4a9b-a427-ed8333d9531e</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID>
        <domainName>www.merchantsite.com</domainName>
        <budget>10.0</budget>
        <anniversaryDate>2015-10-21</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>Bing</distribution>
        <businessAreaID>10135</businessAreaID>
        <keywordListID>384</keywordListID>
        <businessLocationID>44</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</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">Top Quality Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Top Quality Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</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">Exceptional Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Exceptional Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</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">Top Quality Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Top Quality Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</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">Exceptional Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Exceptional Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
    </campaignList>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <distribution>Google</distribution>
        <businessAreaID>10135</businessAreaID>
        <keywordListID>384</keywordListID>
        <businessLocationID>44</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</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">Top Quality Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Top Quality Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</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">Exceptional Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Exceptional Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</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">Top Quality Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reliable Locks For Secure Bikes.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">High Quality Bike Locks.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Top Quality Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</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">Exceptional Bike Locks</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Right Locks For You.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Better Bike Locks Dealer.</value>
                </entry>
                <entry>
                    <key>adHeadline</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Exceptional Bike Locks}</value>
                </entry>
            </attributes>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
14:44:43,397 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = 3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5, requestID = 919e0753-c8df-4a9b-a427-ed8333d9531e
14:44:43,420 INFO  [ValidationUtils] TIMEZONE = America/New_York
14:44:43,420 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,420 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:44:43,422 DEBUG [AdMaxAccountDeploymentBD] New account [3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5]
14:44:43,422 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,422 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
14:44:43,424 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,426 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,426 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
14:44:43,428 WARN  [CustomerDAO] Unable to find campaign: advertID 3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5-y8L4xCIY14
14:44:43,428 DEBUG [JdbcTemplate] Executing SQL update and returning generated keys
14:44:43,428 DEBUG [JdbcTemplate] Executing prepared SQL statement
14:44:43,430 DEBUG [JdbcTemplate] SQL update affected 1 rows and returned 1 keys
14:44:43,431 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,431 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set advertID=? where id=?]
14:44:43,432 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,433 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,433 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
14:44:43,435 WARN  [CustomerDAO] Unable to find campaign: advertID 3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5-lbrxGQCeIu
14:44:43,435 DEBUG [JdbcTemplate] Executing SQL update and returning generated keys
14:44:43,435 DEBUG [JdbcTemplate] Executing prepared SQL statement
14:44:43,436 DEBUG [JdbcTemplate] SQL update affected 1 rows and returned 1 keys
14:44:43,436 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,436 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set advertID=? where id=?]
14:44:43,437 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,447 WARN  [QueueUtils] Setting message priority to 4
14:44:43,453 INFO  [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: 4368
14:44:43,454 INFO  [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: 4369
14:44:43,456 INFO  [AdMaxDeploymentServiceImpl] Starting deploy campaign message conversion
14:44:43,456 INFO  [AdMaxDeploymentServiceImpl] UpdateTypes: [ALL]
14:44:43,456 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 165
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>919e0753-c8df-4a9b-a427-ed8333d9531e</requestID><retryID>1</retryID></header><result><resultCode>queued</resultCode><resultString>queued</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:43,474 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,474 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
14:44:43,477 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,477 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
14:44:43,478 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,479 INFO  [AdMaxDeploymentServiceImpl] 2 Campaign(s) to process.
14:44:43,482 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:44:43,483 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,483 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:44:43,487 DEBUG [AdMaxDeploymentServiceImpl] Processing CampaignInfo...
14:44:43,487 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessLocationId [44]
14:44:43,487 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessAreaID [10135]
14:44:43,487 DEBUG [AdMaxDeploymentServiceImpl] Retrieving KeywordListID [384]
14:44:43,493 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,493 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:43,501 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,501 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]
14:44:43,503 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessLocation
Location:  ID: 44 Description: Colorado Short Description: Colorado Status: active Type: State ParentBusinessLocationID: 1 Use SE Defined Targets: [com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@6583b9b5, com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@2b154e24] Use Point Radius Targets: [com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@3bd3395, com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@7a857d1d] Is Sellable: true
14:44:43,503 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessArea
BusinessArea:  ID: 10135 Description: Bike Locks Status: active BusinessCategoryID: 26
14:44:43,505 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,505 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, type, code from mms_common.bingLocationTargets  join mms_common.businessLocationTargetMap bltm on bltm.distributionID = 147 and bltm.businessLocationTargetID = id where bltm.businessLocationID = ?]
14:44:43,511 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,511 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 = ?]
14:44:43,518 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10135
14:44:43,518 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,518 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' ]
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:43,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:43,528 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,528 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,528 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:43,529 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,529 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:43,530 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,533 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,533 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]
14:44:43,534 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,534 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:44:43,534 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'aliasType' to property 'aliasType' of type int
14:44:43,534 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'description' to property 'description' of type class java.lang.String
14:44:43,534 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'descType' to property 'descType' of type int
14:44:43,534 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'ordering' to property 'ordering' of type int
14:44:43,535 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'shortDescription' to property 'shortDescription' of type class java.lang.String
14:44:43,543 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10135
14:44:43,543 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,543 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' ]
14:44:43,544 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:43,545 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:43,553 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,553 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,553 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:43,554 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,554 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:43,556 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,678 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,679 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 = ?]
14:44:43,680 DEBUG [JdbcTemplate] SQL update affected 2 rows
14:44:43,680 INFO  [CustomerDAO] setting keywordListID to 384 for advertID 4368
14:44:43,680 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,680 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set keywordListID = ? where advertID = ?]
14:44:43,681 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,682 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,682 DEBUG [JdbcTemplate] Executing prepared SQL statement [select p.id, p.locationID, p.latitudeDegrees, p.longitudeDegrees, p.radiusMeters, (case when m.advertID is not null then m.multiplier else 1 end) as multiplier, (case when m.advertID is not null then m.incrementer else 0 end) as incrementer from pointRadius p left join pointRadiusModifiers m on (m.advertID = ?) where locationID = ?]
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'latitudeDegrees' to property 'latitudeDegrees' of type float
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'longitudeDegrees' to property 'longitudeDegrees' of type float
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'radiusMeters' to property 'radiusMeters' of type int
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'multiplier' to property 'multiplier' of type float
14:44:43,683 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'incrementer' to property 'incrementer' of type int
14:44:43,687 DEBUG [JdbcTemplate] Executing SQL query [select multiplier from pointRadiusModifiers where advertID is null]
14:44:43,689 INFO  [AdMaxDeploymentServiceImpl] Using global radius multiplier of 2.0
14:44:43,689 DEBUG [AdMaxDeploymentServiceImpl] Processing CampaignInfo...
14:44:43,689 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessLocationId [44]
14:44:43,689 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessAreaID [10135]
14:44:43,689 DEBUG [AdMaxDeploymentServiceImpl] Retrieving KeywordListID [384]
14:44:43,691 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,691 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:43,694 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,694 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]
14:44:43,696 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessLocation
Location:  ID: 44 Description: Colorado Short Description: Colorado Status: active Type: State ParentBusinessLocationID: 1 Use SE Defined Targets: [com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@be00b4d, com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@2205f252] Use Point Radius Targets: [com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@3467f6f1, com.thesearchagency.core.smb.domain.businesslocation.DistributionFlag@15856318] Is Sellable: true
14:44:43,696 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessArea
BusinessArea:  ID: 10135 Description: Bike Locks Status: active BusinessCategoryID: 26
14:44:43,697 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,697 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 = ?]
14:44:43,699 INFO  [BusinessLocationServiceBD] No target found for BL [44], distribution [Google]
14:44:43,702 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,702 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 = ?]
14:44:43,706 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10135
14:44:43,706 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,706 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' ]
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:43,707 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:43,708 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:43,715 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,716 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,716 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:43,717 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,717 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:43,718 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,720 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,721 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]
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'aliasType' to property 'aliasType' of type int
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'description' to property 'description' of type class java.lang.String
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'descType' to property 'descType' of type int
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'ordering' to property 'ordering' of type int
14:44:43,722 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'shortDescription' to property 'shortDescription' of type class java.lang.String
14:44:43,730 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10135
14:44:43,731 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,731 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' ]
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:43,734 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:43,742 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,742 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,742 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:43,744 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:43,745 DEBUG [KeywordServiceImpl] 93 keywords found for BF: 10135, keywordListID: 384
14:44:43,870 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,870 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 = ?]
14:44:43,873 DEBUG [JdbcTemplate] SQL update affected 2 rows
14:44:43,873 INFO  [CustomerDAO] setting keywordListID to 384 for advertID 4369
14:44:43,873 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,873 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set keywordListID = ? where advertID = ?]
14:44:43,875 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,876 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,876 DEBUG [JdbcTemplate] Executing prepared SQL statement [select p.id, p.locationID, p.latitudeDegrees, p.longitudeDegrees, p.radiusMeters, (case when m.advertID is not null then m.multiplier else 1 end) as multiplier, (case when m.advertID is not null then m.incrementer else 0 end) as incrementer from pointRadius p left join pointRadiusModifiers m on (m.advertID = ?) where locationID = ?]
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'latitudeDegrees' to property 'latitudeDegrees' of type float
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'longitudeDegrees' to property 'longitudeDegrees' of type float
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'radiusMeters' to property 'radiusMeters' of type int
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'multiplier' to property 'multiplier' of type float
14:44:43,877 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'incrementer' to property 'incrementer' of type int
14:44:43,878 DEBUG [JdbcTemplate] Executing SQL query [select multiplier from pointRadiusModifiers where advertID is null]
14:44:43,879 INFO  [AdMaxDeploymentServiceImpl] Using global radius multiplier of 2.0
14:44:43,879 INFO  [AdMaxDeploymentServiceImpl] Finished deploy campaign message conversion. 2 converted.
14:44:43,879 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,879 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:44:43,881 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:43,881 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:44:43,882 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:43,882 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
14:44:43,883 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:43,910 WARN  [QueueUtils] Setting message priority to 4
14:44:43,956 INFO  [AdMaxDeploymentRequestMDB] Sent DEPLOY request to listener. BPID: 3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5 DeployID: 919e0753-c8df-4a9b-a427-ed8333d9531e
14:44:44,051 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,052 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts(description,tier,priority,conversionTypes,isBidManaged,isActive,perfMetric,providesConversionData,addConversionData,databaseInstance,warehouseInstance,isOnline,currencyCode,timeZoneID) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)]
14:44:44,056 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,057 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:44:44,058 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,058 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into sites(accountID,isDefault,description,internalURLPattern,ignorePixels) values(?,?,?,?,?)]
14:44:44,059 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,060 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:44:44,061 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,061 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into userAccountMap(userID,accountID) values(?,?)]
14:44:44,062 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,062 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:44,062 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`description` = ?]
14:44:44,064 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:44,064 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?]
14:44:44,065 INFO  [DatabaseInstancePersistenceManager] Database URL: jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&amp;characterEncoding=UTF-8
14:44:44,065 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,065 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accountChannelMap(accountID,channelID) values(?,?)]
14:44:44,072 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,073 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,073 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
14:44:44,080 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,081 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,081 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
14:44:44,089 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,090 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,090 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
14:44:44,097 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,098 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,098 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)]
14:44:44,105 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,116 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:44:44,124 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,124 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)]
14:44:44,132 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:44,133 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:44:44,164 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:44,164 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`id` = ?]
14:44:44,166 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:44,166 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?]
14:44:44,168 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:44,168 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
14:44:44,183 DEBUG [JdbcTemplate] Executing prepared SQL update
14:44:44,183 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into admaxAccountAnniversary(accountId,anniversaryDate,startDate) values(?,?,?) on duplicate key update endDate= ?]
14:44:44,191 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:44:45,433 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 166
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[453], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:45,437 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,437 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:45,439 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
14:44:45,439 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,439 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
14:44:45,444 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:45,444 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,444 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:45,446 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:45,454 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,455 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,455 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:45,456 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,456 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:45,457 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,457 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:45,457 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:44:45,457 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,457 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:44:45,459 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1.9813778/2.69076
14:44:45,459 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1.9813778
14:44:45,459 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2.69076
14:44:45,459 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2.69076
14:44:45,460 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 81.898
14:44:45,460 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:45,460 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:45,460 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:44:45,460 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 5.138
14:44:45,460 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 81.898
14:44:45,460 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:45,460 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 43.034
14:44:45,460 INFO  [BudgetEstimateServiceImpl] Request time: 25 millis
14:44:45,500 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 166
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T11:52:42.000Z</lastUpdateTime><minimumPrice>5.138</minimumPrice><maximumPrice>81.898</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>43.034</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:45,734 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 167
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[451], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:45,738 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,738 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:45,741 INFO  [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?
14:44:45,741 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,741 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?]
14:44:45,746 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:45,746 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,746 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:45,748 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:45,748 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:45,748 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:45,748 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:45,748 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:45,749 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:45,749 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:45,749 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:45,757 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,757 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,757 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:45,759 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,759 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:45,760 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,761 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:45,761 INFO  [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1
14:44:45,761 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,761 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1]
14:44:45,763 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 37.45429/149.81712
14:44:45,763 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 37.45429
14:44:45,763 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 149.81712
14:44:45,763 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 149.81712
14:44:45,763 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (0.02) . . . maxPrice = 91.199
14:44:45,763 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:45,763 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:45,763 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 13.923
14:44:45,763 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 91.199
14:44:45,763 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:45,763 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 19.651
14:44:45,764 INFO  [BudgetEstimateServiceImpl] Request time: 27 millis
14:44:45,796 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 167
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T12:19:56.000Z</lastUpdateTime><minimumPrice>13.923</minimumPrice><maximumPrice>91.199</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>19.651</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:45,932 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 168
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[451], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:45,935 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,935 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:45,940 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 169
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[453], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:45,942 INFO  [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?
14:44:45,942 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,943 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?]
14:44:45,945 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,945 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:45,951 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:45,951 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,951 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:45,952 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
14:44:45,952 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,952 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
14:44:45,954 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:45,954 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:45,954 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:45,955 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:45,955 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:45,955 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:45,955 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:45,955 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:45,958 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:45,958 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,958 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:45,961 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:45,964 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,964 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,964 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:45,966 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,966 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:45,967 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,968 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:45,968 INFO  [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1
14:44:45,968 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,968 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1]
14:44:45,977 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,979 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,979 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:45,977 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 37.45429/149.81712
14:44:45,980 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 37.45429
14:44:45,980 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 149.81712
14:44:45,980 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 149.81712
14:44:45,980 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (0.02) . . . maxPrice = 91.199
14:44:45,980 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:45,980 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:45,980 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 13.923
14:44:45,980 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 91.199
14:44:45,980 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:45,980 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 19.651
14:44:45,980 INFO  [BudgetEstimateServiceImpl] Request time: 46 millis
14:44:45,982 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,982 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:45,983 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:45,984 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:45,984 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:44:45,984 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:45,984 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:44:45,987 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1.9813778/2.69076
14:44:45,987 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1.9813778
14:44:45,987 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2.69076
14:44:45,987 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2.69076
14:44:45,987 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 81.898
14:44:45,987 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:45,987 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:45,987 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:44:45,987 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 5.138
14:44:45,987 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 81.898
14:44:45,987 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:45,988 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 43.034
14:44:45,988 INFO  [BudgetEstimateServiceImpl] Request time: 46 millis
14:44:46,053 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 168
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T12:19:56.000Z</lastUpdateTime><minimumPrice>13.923</minimumPrice><maximumPrice>91.199</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>19.651</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:46,053 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 169
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T11:52:42.000Z</lastUpdateTime><minimumPrice>5.138</minimumPrice><maximumPrice>81.898</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>43.034</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:48,201 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 170
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[453], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:48,204 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,204 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:48,210 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
14:44:48,210 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,210 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
14:44:48,216 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:48,216 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,216 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:48,218 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:48,218 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:48,218 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:48,218 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:48,218 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:48,218 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:48,219 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:48,219 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:48,227 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:48,227 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,227 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:48,228 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,229 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:48,229 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:48,230 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:48,230 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:44:48,230 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,230 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:44:48,232 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1.9813778/2.69076
14:44:48,232 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1.9813778
14:44:48,232 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2.69076
14:44:48,232 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2.69076
14:44:48,232 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 81.898
14:44:48,232 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:48,232 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:48,232 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:44:48,232 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 5.138
14:44:48,232 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 81.898
14:44:48,232 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:48,233 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 43.034
14:44:48,233 INFO  [BudgetEstimateServiceImpl] Request time: 30 millis
14:44:48,264 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 171
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[451], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:44:48,267 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,267 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
14:44:48,270 INFO  [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?
14:44:48,270 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,270 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?]
14:44:48,276 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 384
14:44:48,276 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,276 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:44:48,281 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:44:48,289 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:48,289 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,290 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:44:48,293 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,293 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:44:48,294 DEBUG [KeywordServiceImpl] 93 keywords found for KL: 384
14:44:48,295 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-23 00:25:09
14:44:48,295 INFO  [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1
14:44:48,295 DEBUG [JdbcTemplate] Executing prepared SQL query
14:44:48,295 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1]
14:44:48,298 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 37.45429/149.81712
14:44:48,298 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 37.45429
14:44:48,298 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 149.81712
14:44:48,298 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 149.81712
14:44:48,299 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (0.02) . . . maxPrice = 91.199
14:44:48,299 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:44:48,299 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 48
14:44:48,299 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 13.923
14:44:48,299 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 91.199
14:44:48,299 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:44:48,299 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 19.651
14:44:48,299 INFO  [BudgetEstimateServiceImpl] Request time: 33 millis
14:44:48,353 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 170
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T11:52:42.000Z</lastUpdateTime><minimumPrice>5.138</minimumPrice><maximumPrice>81.898</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>43.034</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:44:48,376 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 171
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-10-21T12:19:56.000Z</lastUpdateTime><minimumPrice>13.923</minimumPrice><maximumPrice>91.199</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>19.651</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
^[[4~14:45:30,259 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:45:30,259 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:45:30,260 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:45:30,272 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:45:31,754 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 172
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:45:31,755 DEBUG [JdbcTemplate] Executing prepared SQL query
14:45:31,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:45:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:45:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:45:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:45:31,758 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:45:31,758 DEBUG [JdbcTemplate] Executing prepared SQL query
14:45:31,758 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:45:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:45:31,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:45:31,766 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:45:31,766 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:45:31,769 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:45:31,769 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:45:31,770 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:45:31,770 DEBUG [JdbcTemplate] Executing prepared SQL query
14:45:31,770 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:45:31,775 DEBUG [JdbcTemplate] Executing prepared SQL query
14:45:31,775 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:45:31,777 DEBUG [JdbcTemplate] Executing prepared SQL query
14:45:31,777 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:45:31,779 DEBUG [JdbcTemplate] Executing prepared SQL query
14:45:31,780 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:45:31,784 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 172
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:46:30,271 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:46:30,272 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:46:30,272 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:46:30,287 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:46:31,751 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 173
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:46:31,752 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:31,752 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:46:31,753 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:31,753 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:46:31,754 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:46:31,755 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:46:31,755 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:31,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:46:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:46:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:46:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:46:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:46:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:46:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:46:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:46:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:46:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:46:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:46:31,760 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:46:31,760 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:46:31,762 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:46:31,762 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:46:31,763 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:46:31,763 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:31,763 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:46:31,767 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:31,767 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:46:31,768 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:31,768 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:46:31,770 DEBUG [JdbcTemplate] Executing prepared SQL query
14:46:31,770 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:46:31,773 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 173
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:47:30,287 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:47:30,287 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:47:30,287 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:47:30,304 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:47:31,753 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 174
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:47:31,754 DEBUG [JdbcTemplate] Executing prepared SQL query
14:47:31,754 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:47:31,755 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:47:31,755 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:47:31,755 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:47:31,756 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:47:31,756 DEBUG [JdbcTemplate] Executing prepared SQL query
14:47:31,756 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:47:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:47:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:47:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:47:31,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:47:31,761 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:47:31,761 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:47:31,763 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:47:31,763 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:47:31,764 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:47:31,764 DEBUG [JdbcTemplate] Executing prepared SQL query
14:47:31,764 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:47:31,767 DEBUG [JdbcTemplate] Executing prepared SQL query
14:47:31,767 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:47:31,768 DEBUG [JdbcTemplate] Executing prepared SQL query
14:47:31,768 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:47:31,771 DEBUG [JdbcTemplate] Executing prepared SQL query
14:47:31,771 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:47:31,774 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 174
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:48:30,932 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:48:30,932 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:48:30,939 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:48:30,951 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:48:31,752 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 175
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:48:31,753 DEBUG [JdbcTemplate] Executing prepared SQL query
14:48:31,753 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:48:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:48:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:48:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:48:31,757 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:48:31,757 DEBUG [JdbcTemplate] Executing prepared SQL query
14:48:31,757 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:48:31,759 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:48:31,760 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:48:31,764 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:48:31,764 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:48:31,767 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:48:31,767 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:48:31,768 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:48:31,768 DEBUG [JdbcTemplate] Executing prepared SQL query
14:48:31,768 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:48:31,772 DEBUG [JdbcTemplate] Executing prepared SQL query
14:48:31,772 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:48:31,774 DEBUG [JdbcTemplate] Executing prepared SQL query
14:48:31,774 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:48:31,776 DEBUG [JdbcTemplate] Executing prepared SQL query
14:48:31,776 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:48:31,780 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 175
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:49:30,950 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:49:30,950 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:49:30,951 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:49:30,969 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:49:31,757 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 176
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:49:31,759 DEBUG [JdbcTemplate] Executing prepared SQL query
14:49:31,760 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:49:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:49:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:49:31,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:49:31,762 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:49:31,762 DEBUG [JdbcTemplate] Executing prepared SQL query
14:49:31,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:49:31,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:49:31,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:49:31,764 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:49:31,767 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:49:31,767 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:49:31,769 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:49:31,769 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:49:31,770 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:49:31,770 DEBUG [JdbcTemplate] Executing prepared SQL query
14:49:31,770 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:49:31,776 DEBUG [JdbcTemplate] Executing prepared SQL query
14:49:31,777 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:49:31,778 DEBUG [JdbcTemplate] Executing prepared SQL query
14:49:31,779 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:49:31,780 DEBUG [JdbcTemplate] Executing prepared SQL query
14:49:31,780 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:49:31,783 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 176
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:50:30,966 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:50:30,966 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:50:30,967 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:50:30,980 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:50:31,751 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 177
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:50:31,752 DEBUG [JdbcTemplate] Executing prepared SQL query
14:50:31,752 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:50:31,754 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:50:31,754 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:50:31,754 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:50:31,755 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:50:31,755 DEBUG [JdbcTemplate] Executing prepared SQL query
14:50:31,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:50:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:50:31,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:50:31,759 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:50:31,759 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:50:31,761 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:50:31,761 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:50:31,762 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:50:31,762 DEBUG [JdbcTemplate] Executing prepared SQL query
14:50:31,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:50:31,766 DEBUG [JdbcTemplate] Executing prepared SQL query
14:50:31,766 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:50:31,768 DEBUG [JdbcTemplate] Executing prepared SQL query
14:50:31,768 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:50:31,770 DEBUG [JdbcTemplate] Executing prepared SQL query
14:50:31,770 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:50:31,773 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 177
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:51:30,979 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:51:31,011 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:51:31,012 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:51:31,033 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:51:31,760 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 178
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:51:31,761 DEBUG [JdbcTemplate] Executing prepared SQL query
14:51:31,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:51:31,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:51:31,955 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:51:31,956 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:51:31,957 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:51:31,957 DEBUG [JdbcTemplate] Executing prepared SQL query
14:51:31,957 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:51:31,964 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:51:31,964 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:51:31,964 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:51:31,964 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:51:31,964 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:51:31,965 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:51:31,965 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:51:31,965 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:51:31,965 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:51:31,965 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:51:31,976 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:51:31,976 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:51:31,984 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:51:31,984 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:51:31,985 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:51:31,985 DEBUG [JdbcTemplate] Executing prepared SQL query
14:51:31,985 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:51:31,994 DEBUG [JdbcTemplate] Executing prepared SQL query
14:51:31,994 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:51:31,996 DEBUG [JdbcTemplate] Executing prepared SQL query
14:51:31,996 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:51:31,998 DEBUG [JdbcTemplate] Executing prepared SQL query
14:51:31,999 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:51:32,005 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 178
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getCampaignsByCustomerIDResponse xmlns:ns2="http://thesearchagency.com/smb/core"><CampaignListResponse><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
^[[4~14:52:26,579 INFO  [AuditorServiceBD] Entering the audit method...
14:52:26,641 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:26,641 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
14:52:26,646 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:26,646 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?]
14:52:26,647 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:26,647 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
14:52:26,649 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:26,650 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:52:26,680 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:26,680 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)]
14:52:26,681 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:26,681 INFO  [AuditorServiceBD] Exiting the audit method...
14:52:26,918 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
14:52:26,962 INFO  [AdMaxDeploymentMessageConverter] Campaings for the Result: 2
14:52:26,962 INFO  [AdMaxDeploymentMessageConverter] Assuming No Message Fault, Campaigns count:  2 topResultCode: null
14:52:26,967 INFO  [AuditorServiceBD] Entering the audit method...
14:52:26,967 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:26,967 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
14:52:26,972 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:26,972 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?]
14:52:26,974 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:26,974 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
14:52:26,975 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:26,976 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:52:26,981 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:26,981 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)]
14:52:26,985 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:26,986 INFO  [AuditorServiceBD] Exiting the audit method...
14:52:27,014 INFO  [AdMaxDeploymentResponseMDB] Handling publish deploy status resp
14:52:31,027 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:52:31,028 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:52:31,028 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:52:31,043 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:52:31,753 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 179
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,755 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:52:31,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:52:31,775 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:52:31,775 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:52:31,777 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:52:31,777 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,777 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:52:31,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:52:31,787 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:52:31,787 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:52:31,791 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:52:31,791 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:52:31,792 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:52:31,792 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,792 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:52:31,795 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,795 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:52:31,798 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,798 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:52:31,800 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,800 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:52:31,803 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 179
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getCampaignsByCustomerIDResponse xmlns:ns2="http://thesearchagency.com/smb/core"><CampaignListResponse><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,814 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 180
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=[293], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getOperationErrors xmlns:core="http://thesearchagency.com/smb/core">
<operationErrorsRequest>
    <campaigns>4368</campaigns>
</operationErrorsRequest>
</core:getOperationErrors></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,815 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,815 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT distribution, advertID as parentCampaignID, externalCampaign.id as childCampaignID, gceCampaignID, searchEngineAccounts.description as distributionCampaignName, keywordListID from mms_common.campaigns join clients.externalCampaignParent on (campaigns.advertID = externalCampaignParent.description) join clients.externalCampaign on (externalCampaignParentID=externalCampaignParent.id) join tsacommon.searchEngineAccounts on searchEngineAccountID = searchEngineAccounts.id where campaigns.advertID in (?) AND externalCampaign.enabled=?]
14:52:31,821 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,822 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT `errors`.`errorJson` FROM `bing`.`campaigns` JOIN `bing`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (?, ?)]
14:52:31,824 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 180
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorsResponse/></ns2:getOperationErrorsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,832 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 181
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=[305], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getOperationErrorDetails xmlns:core="http://thesearchagency.com/smb/core">
<operationErrorsRequest>
    <campaigns>4368</campaigns>
</operationErrorsRequest>
</core:getOperationErrorDetails></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,833 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,833 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT distribution, advertID as parentCampaignID, externalCampaign.id as childCampaignID, gceCampaignID, searchEngineAccounts.description as distributionCampaignName, keywordListID from mms_common.campaigns join clients.externalCampaignParent on (campaigns.advertID = externalCampaignParent.description) join clients.externalCampaign on (externalCampaignParentID=externalCampaignParent.id) join tsacommon.searchEngineAccounts on searchEngineAccountID = searchEngineAccounts.id where campaigns.advertID in (?) AND externalCampaign.enabled=?]
14:52:31,836 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,836 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT `errors`.`errorJson` FROM `bing`.`campaigns` JOIN `bing`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (?, ?)]
14:52:31,838 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 181
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorDetailsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorDetailsResponse/></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,849 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 182
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=[293], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getOperationErrors xmlns:core="http://thesearchagency.com/smb/core">
<operationErrorsRequest>
    <campaigns>4369</campaigns>
</operationErrorsRequest>
</core:getOperationErrors></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,850 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,850 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT distribution, advertID as parentCampaignID, externalCampaign.id as childCampaignID, gceCampaignID, searchEngineAccounts.description as distributionCampaignName, keywordListID from mms_common.campaigns join clients.externalCampaignParent on (campaigns.advertID = externalCampaignParent.description) join clients.externalCampaign on (externalCampaignParentID=externalCampaignParent.id) join tsacommon.searchEngineAccounts on searchEngineAccountID = searchEngineAccounts.id where campaigns.advertID in (?) AND externalCampaign.enabled=?]
14:52:31,855 INFO  [ErrorDAOSpringJDBC] GCE_CAMPAIGNS:2390, 2389
14:52:31,855 INFO  [ErrorDAOSpringJDBC] getOperationErrorsResponse [SELECT `reason`, `field`, `trigger` FROM gce_campaignAdExtensionMapPendingChange INNER JOIN gce_campaignAdExtensionMapError ON gce_campaignAdExtensionMapPendingChange.campaignID = gce_campaignAdExtensionMapError.campaignID INNER JOIN gce_campaignAdExtensionMap ON gce_campaignAdExtensionMap.campaignID = gce_campaignAdExtensionMapPendingChange.campaignID WHERE gce_campaignAdExtensionMap.campaignID IN ('2390', '2389') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:52:31,855 DEBUG [JdbcTemplate] Executing SQL query [SELECT `reason`, `field`, `trigger` FROM gce_campaignAdExtensionMapPendingChange INNER JOIN gce_campaignAdExtensionMapError ON gce_campaignAdExtensionMapPendingChange.campaignID = gce_campaignAdExtensionMapError.campaignID INNER JOIN gce_campaignAdExtensionMap ON gce_campaignAdExtensionMap.campaignID = gce_campaignAdExtensionMapPendingChange.campaignID WHERE gce_campaignAdExtensionMap.campaignID IN ('2390', '2389') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:52:31,858 INFO  [ErrorDAOSpringJDBC] getOperationErrorsResponse [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_campaignFeedPendingChange INNER JOIN gce_campaignFeedError ON gce_campaignFeedPendingChange.`campaignFeedID` = gce_campaignFeedError.`campaignFeedID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.id=gce_campaignFeedPendingChange.campaignFeedID INNER JOIN gce_feed ON gce_feed.id = gce_campaignFeed.feedID WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_campaignFeedPendingChange.isFailed='true']
14:52:31,858 DEBUG [JdbcTemplate] Executing SQL query [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_campaignFeedPendingChange INNER JOIN gce_campaignFeedError ON gce_campaignFeedPendingChange.`campaignFeedID` = gce_campaignFeedError.`campaignFeedID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.id=gce_campaignFeedPendingChange.campaignFeedID INNER JOIN gce_feed ON gce_feed.id = gce_campaignFeed.feedID WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_campaignFeedPendingChange.isFailed='true']
14:52:31,862 INFO  [ErrorDAOSpringJDBC] getOperationErrorsResponse [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedPendingChange INNER JOIN gce_feedError ON gce_feedPendingChange.`feedID` = gce_feedError.`feedID` INNER JOIN gce_feed ON gce_feed.id=gce_feedError.`feedID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feed.id WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_feedPendingChange.isFailed='true']
14:52:31,862 DEBUG [JdbcTemplate] Executing SQL query [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedPendingChange INNER JOIN gce_feedError ON gce_feedPendingChange.`feedID` = gce_feedError.`feedID` INNER JOIN gce_feed ON gce_feed.id=gce_feedError.`feedID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feed.id WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_feedPendingChange.isFailed='true']
14:52:31,865 INFO  [ErrorDAOSpringJDBC] getOperationErrorsResponse [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedItemPendingChange INNER JOIN gce_feedItemError ON gce_feedItemPendingChange.`feedItemID` = gce_feedItemError.`feedItemID` INNER JOIN gce_feedItem ON gce_feedItem.id=gce_feedItemError.`feedItemID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feedItem.feedID INNER JOIN gce_feed ON gce_feed.id = gce_feedItem.feedID WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_feedItemPendingChange.isFailed='true']
14:52:31,865 DEBUG [JdbcTemplate] Executing SQL query [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedItemPendingChange INNER JOIN gce_feedItemError ON gce_feedItemPendingChange.`feedItemID` = gce_feedItemError.`feedItemID` INNER JOIN gce_feedItem ON gce_feedItem.id=gce_feedItemError.`feedItemID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feedItem.feedID INNER JOIN gce_feed ON gce_feed.id = gce_feedItem.feedID WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_feedItemPendingChange.isFailed='true']
14:52:31,867 INFO  [ErrorDAOSpringJDBC] getOperationErrorsResponse [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedMappingPendingChange INNER JOIN gce_feedMappingError ON gce_feedMappingPendingChange.`feedMappingID` = gce_feedMappingError.`feedMappingID` INNER JOIN gce_feedMapping ON gce_feedMapping.id=gce_feedMappingError.`feedMappingID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feedMapping.feedID INNER JOIN gce_feed ON gce_feed.id = gce_feedMapping.feedID WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_feedMappingPendingChange.isFailed='true']
14:52:31,867 DEBUG [JdbcTemplate] Executing SQL query [SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedMappingPendingChange INNER JOIN gce_feedMappingError ON gce_feedMappingPendingChange.`feedMappingID` = gce_feedMappingError.`feedMappingID` INNER JOIN gce_feedMapping ON gce_feedMapping.id=gce_feedMappingError.`feedMappingID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feedMapping.feedID INNER JOIN gce_feed ON gce_feed.id = gce_feedMapping.feedID WHERE gce_campaignFeed.campaignID IN ('2390', '2389') AND gce_feedMappingPendingChange.isFailed='true']
14:52:31,870 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 182
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorsResponse/></ns2:getOperationErrorsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,878 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 183
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=[305], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getOperationErrorDetails xmlns:core="http://thesearchagency.com/smb/core">
<operationErrorsRequest>
    <campaigns>4369</campaigns>
</operationErrorsRequest>
</core:getOperationErrorDetails></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,879 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,879 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT distribution, advertID as parentCampaignID, externalCampaign.id as childCampaignID, gceCampaignID, searchEngineAccounts.description as distributionCampaignName, keywordListID from mms_common.campaigns join clients.externalCampaignParent on (campaigns.advertID = externalCampaignParent.description) join clients.externalCampaign on (externalCampaignParentID=externalCampaignParent.id) join tsacommon.searchEngineAccounts on searchEngineAccountID = searchEngineAccounts.id where campaigns.advertID in (?) AND externalCampaign.enabled=?]
14:52:31,883 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,883 DEBUG [JdbcTemplate] Executing prepared SQL statement [select externalCampaignParent.description as `CampaignID`,searchEngineUsers.description as `AccountDescription`,searchEngineUsers.searchEngineIdentifier as `AccountIdentifier`,gce_campaign.name as `CampaignName`,gce_campaign.searchEngineIdentifier as `CampaignIdentifier`,gce_campaign.status as `CampaignStatus`,gce_adGroup.name as `AdGroupName`,gce_adGroup.searchEngineIdentifier as `AdGroupIdentifier`,gce_adGroup.status as `AdGroupStatus`,gce_textAd.headline as `Headline`,gce_textAd.description1 as `Description1`,gce_textAd.description2 as `Description2`,gce_textAd.status as `TextAdStatus`,gce_textAd.displayURL as `DisplayURL`,gce_textAd.destinationURL as `DestinationURL`,gce_textAd.id as `TextAdID`,errorTable.errorCode as `ErrorCode`,errorTable.errorText as `ErrorText`,errorTable.reason as `Reason`,errorTable.policyName as `PolicyName`,errorTable.`field` as `Field`,errorTable.`trigger` as `Trigger`,errorTable.isExemptable as `IsExemptable`from content_editor_google.gce_campaign join tsacommon.searchEngineUsers on (searchEngineUserID=searchEngineUsers.id) join content_editor_google.gce_adGroup on (gce_campaign.id=campaignID) join content_editor_google.gce_textAd on (adGroupID=gce_adGroup.id) join content_editor_google.gce_textAdError errorTable on (errorTable.textAdID=gce_textAd.id) join clients.externalCampaign on (gceCampaignID = gce_campaign.id) join clients.externalCampaignParent on (externalCampaignParent.id=externalCampaignParentID) where gce_campaign.id in ('2390','2389') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_textAd.status != ? ]
14:52:31,890 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,890 DEBUG [JdbcTemplate] Executing prepared SQL statement [select externalCampaignParent.description as `CampaignID`,searchEngineUsers.description as `AccountDescription`,searchEngineUsers.searchEngineIdentifier as `AccountIdentifier`,gce_campaign.name as `CampaignName`,gce_campaign.searchEngineIdentifier as `CampaignIdentifier`,gce_campaign.status as `CampaignStatus`,gce_adGroup.name as `AdGroupName`,gce_adGroup.searchEngineIdentifier as `AdGroupIdentifier`,gce_adGroup.status as `AdGroupStatus`,gce_keyword.text as `KeywordText`,gce_keyword.keywordType as `MatchType`,gce_keyword.isNegative as `IsNegative`,gce_keyword.status as `KeywordStatus`,gce_keyword.id as `KeywordID`,errorTable.errorCode as `ErrorCode`,errorTable.errorText as `ErrorText`,errorTable.reason as `Reason`,errorTable.policyName as `PolicyName`,errorTable.`field` as `Field`,errorTable.`trigger` as `Trigger`,errorTable.isExemptable as `IsExemptable`from content_editor_google.gce_campaign join tsacommon.searchEngineUsers on (searchEngineUserID=searchEngineUsers.id) join content_editor_google.gce_adGroup on (gce_campaign.id=campaignID) join content_editor_google.gce_keyword on (adGroupID=gce_adGroup.id) join content_editor_google.gce_keywordError errorTable on (errorTable.keywordID=gce_keyword.id) join clients.externalCampaign on (gceCampaignID = gce_campaign.id) join clients.externalCampaignParent on (externalCampaignParent.id=externalCampaignParentID) where gce_campaign.id in ('2390','2389') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_keyword.status not in (?,?,?,?) ]
14:52:31,894 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 183
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorDetailsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorDetailsResponse/></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,905 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 184
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,906 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,906 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:52:31,907 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:52:31,907 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:52:31,907 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:52:31,908 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
14:52:31,908 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,908 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:52:31,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:52:31,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:52:31,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:52:31,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:52:31,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:52:31,910 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:52:31,910 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:52:31,910 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:52:31,910 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:52:31,910 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:52:31,913 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4368: Paused -> Paused
14:52:31,913 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4368 -> PAUSED
14:52:31,915 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4369: Paused -> Paused
14:52:31,915 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4369 -> PAUSED
14:52:31,916 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:52:31,916 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,916 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:52:31,919 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,919 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:52:31,921 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,921 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:52:31,923 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,923 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:52:31,925 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 184
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>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4368</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName></campaignList><campaignList><campaignID>4369</campaignID><businessAreaID>10135</businessAreaID><keywordListID>384</keywordListID><businessLocationID>44</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,953 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 185
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=[710], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:updateCampaignStatus xmlns:core="http://thesearchagency.com/smb/core">
<updateCampaignStatusRequest>
    <header>
        <requestID>919e0753-c8df-4a9b-a427-ed8333d9531e</requestID>
    </header>
    <customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID>
    <campaignStatusList>
        <campaignID>4368</campaignID>
        <campaignStatus>active</campaignStatus>
    </campaignStatusList>
    <campaignStatusList>
        <campaignID>4369</campaignID>
        <campaignStatus>active</campaignStatus>
    </campaignStatusList>
</updateCampaignStatusRequest>
</core:updateCampaignStatus></soap:Body></soap:Envelope>
--------------------------------------
14:52:31,955 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,955 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:52:31,957 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,957 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
14:52:31,959 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,959 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
14:52:31,977 WARN  [QueueUtils] Setting message priority to 4
14:52:31,989 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,989 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
14:52:31,991 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,991 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:31,991 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:31,991 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:52:32,001 INFO  [AdMaxDeploymentFauxSyncMessenger] Starting campaign status update blocking loop
14:52:32,001 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:32,002 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:32,002 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:32,002 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:52:32,003 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:32,003 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
14:52:32,004 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:32,067 WARN  [QueueUtils] Setting message priority to 9
14:52:32,073 INFO  [AdMaxDeploymentRequestMDB] Sent UPDATE request to listener. BPID: 3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5 DeployID: 919e0753-c8df-4a9b-a427-ed8333d9531e
14:52:32,100 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:32,100 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
14:52:33,003 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:33,003 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:34,005 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:34,005 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:35,008 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:35,008 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:35,924 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
14:52:35,960 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:35,960 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campUpdateResp(deploymentID, responseMsg) values (?, ?) on duplicate key update responseMsg = ?]
14:52:35,963 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:35,964 WARN  [AdMaxDeploymentFauxSyncMessenger] Put update ok for deploy 919e0753-c8df-4a9b-a427-ed8333d9531e
14:52:35,965 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:35,965 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
14:52:35,967 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:52:35,968 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
14:52:35,973 INFO  [AdMaxDeploymentResponseMDB] Handling update campaign status.
14:52:36,010 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:36,010 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:37,012 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:37,012 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:52:38,022 INFO  [AdMaxDeploymentFauxSyncMessenger] Exited blocking loop
14:52:38,031 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:38,031 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?]
14:52:38,034 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:38,037 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 185
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignStatusResponse xmlns:ns2="http://thesearchagency.com/smb/core"><updateCampaignStatusResponse><header><requestID>919e0753-c8df-4a9b-a427-ed8333d9531e</requestID></header><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><campaignResult><campaignID>4368</campaignID><result><resultCode>failure</resultCode><resultString>Information: [4368_GM:FAILED] Error during update request. [4368_GT:FAILED] Error during update request. </resultString></result></campaignResult><campaignResult><campaignID>4369</campaignID><result><resultCode>failure</resultCode><resultString>Information: [4369_GM:FAILED] Error during update request. [4369_GT:FAILED] Error during update request. </resultString></result></campaignResult></updateCampaignStatusResponse></ns2:updateCampaignStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
14:52:38,053 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 186
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=[866], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:updateCampaignBudgetAccrualStatus xmlns:core="http://thesearchagency.com/smb/core">
<updateCampaignBudgetAccrualStatusRequest>
    <header>
        <requestID>919e0753-c8df-4a9b-a427-ed8333d9531e</requestID>
    </header>
    <customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID>
    <campaignBudgetAccrualStatusList>
        <campaignID>4368</campaignID>
        <campaignBudgetAccrualStatus>active</campaignBudgetAccrualStatus>
    </campaignBudgetAccrualStatusList>
    <campaignBudgetAccrualStatusList>
        <campaignID>4369</campaignID>
        <campaignBudgetAccrualStatus>active</campaignBudgetAccrualStatus>
    </campaignBudgetAccrualStatusList>
</updateCampaignBudgetAccrualStatusRequest>
</core:updateCampaignBudgetAccrualStatus></soap:Body></soap:Envelope>
--------------------------------------
14:52:38,072 INFO  [AdMaxAccountDeploymentBD] validated: []
14:52:38,079 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,079 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:52:38,083 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,083 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
14:52:38,085 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,085 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
14:52:38,095 INFO  [AdMaxAccountDeploymentBD] Account: Account [theAccountID=991, theDescription=3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5, theTier=1, thePriority=50, theReportClickOuts=0, theReportConversions=0, theConversionTypes=[], isBidManaged=1, isActive=true, thePerformanceMetric=cpa, theProvidesConversionData=true, theAddConversionDate=false, theFractionalConversionCounts=false, theHideNullSources=0, theNowTime=Wed Oct 21 14:52:38 UTC 2015, theWarehouseDB=warehouse_1, theDatabaseInstance=1, theWarehouseInstance=1, isOnline=true, currencyCode=, theSites=[Site [theSiteId=990, theAccountId=991, isDefault=true, theDescription=3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5_Main, theInternalURLPattern=, hasIgnorePixels=false, theWaypoints=[Waypoint [theWaypointId=1979, theSiteId=990, theGroupId=0, theType=2, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Page View, thePassParams=, theDebounceWindow=30, theLimitPerWindow=1, theLastTestedDate=null, theTestStatus=null], Waypoint [theWaypointId=1980, theSiteId=990, theGroupId=0, theType=4, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Conversion, thePassParams=, theDebounceWindow=0, theLimitPerWindow=0, theLastTestedDate=null, theTestStatus=null]]]]]
14:52:38,095 INFO  [AdMaxAccountDeploymentBD] Updating CampaignID [4368] budget accrual status to [active]
14:52:38,098 DEBUG [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus
14:52:38,101 DEBUG [CampaignBudgetAccrualStatusServiceBD] CampaignBudgetAccrualStatusServiceBD.getCurrentAccrualStatus - Searching for current CampaignBudgetAccrualStatus record for CampaignId [1602]
14:52:38,101 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,101 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL]
14:52:38,109 INFO  [CampaignBudgetAccrualStatusServiceBD] AdMaxCampaignId [1602] current CampaignBudgetAccrualStatus: CampaignBugetAccrualStatus [theId=2433, theCampaignId=1602, theStartDate=2015-10-21, theEndDate=null, theStatus=paused]
14:52:38,109 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,109 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where id = ? ]
14:52:38,111 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:38,111 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ]
14:52:38,118 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:38,120 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [1602] updated CampaignBudgetAccrualStatus updated status
CampaignBugetAccrualStatus [theId=2433, theCampaignId=1602, theStartDate=2015-10-21, theEndDate=null, theStatus=active]
14:52:38,120 DEBUG [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
14:52:38,121 INFO  [AdMaxAccountDeploymentBD] Updating CampaignID [4369] budget accrual status to [active]
14:52:38,122 DEBUG [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus
14:52:38,126 DEBUG [CampaignBudgetAccrualStatusServiceBD] CampaignBudgetAccrualStatusServiceBD.getCurrentAccrualStatus - Searching for current CampaignBudgetAccrualStatus record for CampaignId [1603]
14:52:38,126 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,126 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL]
14:52:38,135 INFO  [CampaignBudgetAccrualStatusServiceBD] AdMaxCampaignId [1603] current CampaignBudgetAccrualStatus: CampaignBugetAccrualStatus [theId=2434, theCampaignId=1603, theStartDate=2015-10-21, theEndDate=null, theStatus=paused]
14:52:38,135 DEBUG [JdbcTemplate] Executing prepared SQL query
14:52:38,135 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where id = ? ]
14:52:38,137 DEBUG [JdbcTemplate] Executing prepared SQL update
14:52:38,137 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ]
14:52:38,144 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:52:38,145 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [1603] updated CampaignBudgetAccrualStatus updated status
CampaignBugetAccrualStatus [theId=2434, theCampaignId=1603, theStartDate=2015-10-21, theEndDate=null, theStatus=active]
14:52:38,145 DEBUG [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
14:52:38,147 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 186
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignBudgetAccrualStatusResponse xmlns:ns2="http://thesearchagency.com/smb/core"><updateCampaignBudgetAccrualStatusResponse><header><requestID>919e0753-c8df-4a9b-a427-ed8333d9531e</requestID></header><customerID>3b3001af-0bb3-4f8f-a50c-c0d9cb995dd5</customerID><campaignResult><campaignID>4368</campaignID><result><resultCode>success</resultCode></result></campaignResult><campaignResult><campaignID>4369</campaignID><result><resultCode>success</resultCode></result></campaignResult></updateCampaignBudgetAccrualStatusResponse></ns2:updateCampaignBudgetAccrualStatusResponse></soap:Body></soap:Envelope>
--------------------------------------