=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.06.25 19:02:54 =~=~=~=~=~=~=~=~=~=~=~=
cleartail -f /home/TSAApp/apps/jboss-5.1.0.GA/tsa_messaging_node_server.log
ID: 1640
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4084</campaignID><businessAreaID>10008</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:33:16,105 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
13:33:16,106 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
13:33:16,107 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
13:33:16,118 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT


13:33:41,764 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1641
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=[450], 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>62</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:33:41,798 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:41,798 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:33:41,802 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=?
13:33:41,802 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:41,802 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=?]
13:33:41,806 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 62
13:33:41,807 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:41,807 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,'(-+|[[:>:]])')) ]
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:33:41,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:33:41,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:33:41,817 DEBUG [KeywordServiceImpl] 66 keywords found for BF: 0
13:33:41,817 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:41,817 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:33:41,819 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:41,819 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:33:41,820 DEBUG [KeywordServiceImpl] 66 keywords found for BF: 0
13:33:41,821 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-02-13 11:06:05
13:33:41,821 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
13:33:41,821 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:41,821 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]
13:33:41,825 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1360.4908/1847.5802
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1360.4908
13:33:41,825 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 1847.5802
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 1847.5802
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 56234.52
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:33:41,825 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 24
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:33:41,825 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 25.255
13:33:41,826 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 56234.52
13:33:41,826 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:33:41,826 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 6011.943
13:33:41,826 INFO  [BudgetEstimateServiceImpl] Request time: 58 millis
13:33:41,849 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1641
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>62</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-24T06:44:36.000Z</lastUpdateTime><minimumPrice>25.255</minimumPrice><maximumPrice>56234.52</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>6011.943</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:33:42,719 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1642
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:33:42,722 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,722 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:33:42,725 WARN  [CustomerDAO] Unable to find account: bpID ed73ad47-85b7-430e-bc3a-4f45205bf8a7
13:33:42,725 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:33:42,725 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,725 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:33:42,728 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1642
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:33:42,754 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1643
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>678b41d9-99f0-4f2f-914e-099f381a0af2</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID>
        <domainName>sss.cc????</domainName>
        <budget>1.0</budget>
        <anniversaryDate>2014-06-25</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"/>
        <businessAreaID>12370</businessAreaID>
        <keywordListID>2714</keywordListID>
        <businessLocationID>1</businessLocationID>
        <customLandingPage>
            <destinationURL>http://sss.cc????</destinationURL>
            <displayURL>sss.cc????</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">Wide Range of Photo Frames.</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">sss.cc????</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://sss.cc????</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 Frames to Fit Your Home.</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 Photo Frames</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 Frames to Fit Your Home.</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">sss.cc????</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://sss.cc????</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">Wide Range of Photo Frames.</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 Photo Frames}</value>
                </entry>
            </attributes>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
13:33:42,757 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = ed73ad47-85b7-430e-bc3a-4f45205bf8a7, requestID = 678b41d9-99f0-4f2f-914e-099f381a0af2
13:33:42,776 INFO  [ValidationUtils] TIMEZONE = America/New_York
13:33:42,776 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,776 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:33:42,778 DEBUG [AdMaxAccountDeploymentBD] New account [ed73ad47-85b7-430e-bc3a-4f45205bf8a7]
13:33:42,778 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:42,778 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
13:33:42,780 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:42,782 INFO  [AdMaxDeploymentServiceImpl] xkeywordListID + 2714
13:33:42,782 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,782 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL from mms_common.campaigns where advertID = ?]
13:33:42,784 WARN  [CustomerDAO] Unable to find campaign: advertID ed73ad47-85b7-430e-bc3a-4f45205bf8a7-hCd4U7AqUM
13:33:42,784 DEBUG [JdbcTemplate] Executing SQL update and returning generated keys
13:33:42,784 DEBUG [JdbcTemplate] Executing prepared SQL statement
13:33:42,786 DEBUG [JdbcTemplate] SQL update affected 1 rows and returned 1 keys
13:33:42,787 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:42,787 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set advertID=? where id=?]
13:33:42,788 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:42,799 WARN  [QueueUtils] Setting message priority to 4
13:33:42,804 INFO  [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: 4135
13:33:42,807 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1643
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>678b41d9-99f0-4f2f-914e-099f381a0af2</requestID><retryID>1</retryID></header><result><resultCode>queued</resultCode><resultString>queued</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
13:33:42,847 INFO  [AdMaxDeploymentServiceImpl] Starting deploy campaign message conversion
13:33:42,848 INFO  [AdMaxDeploymentServiceImpl] UpdateTypes: [ALL]
13:33:42,878 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,878 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
13:33:42,881 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:42,881 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
13:33:42,882 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:42,882 INFO  [AdMaxDeploymentServiceImpl] 1 Campaign(s) to process.
13:33:42,886 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:33:42,887 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,887 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:33:42,889 DEBUG [AdMaxDeploymentServiceImpl] Processing CampaignInfo...
13:33:42,889 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessLocationId [1]
13:33:42,889 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessAreaID [12370]
13:33:42,889 DEBUG [AdMaxDeploymentServiceImpl] Retrieving KeywordListID [2714]
13:33:42,895 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,895 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:33:42,897 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,897 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, target, description, type, code from mms_common.googleLocationTargets join mms_common.googleLocationTargetMap on googleLocationTargetID = id where businessLocationID = ?]
13:33:42,903 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,903 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]
13:33:42,905 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessLocation
Location:  ID: 1 Description: United States Short Description: United States Status: active Type: Country ParentBusinessLocationID: 0 Use SE Defined Targets: true Use Point Radius Targets: false Is Sellable: true
13:33:42,905 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessArea
BusinessArea:  ID: 12370 Description: Photo Frames Status: active BusinessCategoryID: 16
13:33:42,909 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,909 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 = ?]
13:33:42,916 DEBUG [KeywordServiceImpl] Getting keywords for BF: 12370
13:33:42,916 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,916 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' ]
13:33:42,918 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:33:42,918 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:33:42,918 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:33:42,918 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:33:42,919 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:33:42,919 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:33:42,919 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:33:42,919 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:33:42,940 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 12370, keywordListID: 2714
13:33:42,941 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,941 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:33:42,942 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,942 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:33:42,943 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 12370, keywordListID: 2714
13:33:42,964 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,964 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]
13:33:42,969 DEBUG [KeywordServiceImpl] Getting keywords for BF: 12370
13:33:42,969 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:42,969 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' ]
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:33:42,971 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:33:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:33:43,023 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 12370, keywordListID: 2714
13:33:43,023 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,023 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:33:43,024 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,024 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:33:43,026 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 12370, keywordListID: 2714
13:33:43,026 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +affordable +photo +frame +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +affordable +photo +frames +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +big +photo +frame +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +big +photo +frames +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +collage +photo +frame +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +collage +photo +frames +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,027 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +contemporary +photo +frame +United +States 
13:33:43,027 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +contemporary +photo +frames +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +custom +photo +frame +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +custom +photo +frames +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +decorative +photo +frame +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +decorative +photo +frames +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +display +photo +frame +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +display +photo +frames +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +folding +photo +frame +United +States 
13:33:43,028 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,028 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +folding +photo +frames +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +frameless +photo +frame +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +framesless +photo +frames +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +full +length +photo +frame +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +full +length +photo +frames +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +gallery +photo +frame +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +gallery +photo +frames +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +kitchen +photo +frame +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,029 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +kitchen +photo +frames +United +States 
13:33:43,029 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +metal +photo +frame +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +metal +photo +frames +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +modern +photo +frame +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +modern +photo +frames +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +oval +photo +frame +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +oval +photo +frames +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,030 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +company +United +States 
13:33:43,030 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +retailer +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +retailers +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +seller +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +sellers +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +shop +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +shops +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +store +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,031 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frame +stores +United +States 
13:33:43,031 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +company +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +retailer +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +retailers +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +seller +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +sellers +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +shop +United +States 
13:33:43,032 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,032 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +shops +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +store +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photo +frames +stores +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frame +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frame +shop +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frame +shops +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frame +store +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,033 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frame +stores +United +States 
13:33:43,033 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frames +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frames +shop +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +photograph +frames +store +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +round +photo +frame +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +round +photo +frames +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +small +photo +frame +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +small +photo +frames +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,034 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +standard +photo +frame +United +States 
13:33:43,034 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,035 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +standard +photo +frames +United +States 
13:33:43,035 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,035 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +steel +photo +frame +United +States 
13:33:43,035 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,035 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +steel +photo +frames +United +States 
13:33:43,035 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,035 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +wall +photo +frame +United +States 
13:33:43,035 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,035 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +wall +photo +frames +United +States 
13:33:43,035 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,035 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +wood +photo +frame +United +States 
13:33:43,035 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,036 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +wood +photo +frames +United +States 
13:33:43,036 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,036 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +wooden +photo +frame +United +States 
13:33:43,036 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates
13:33:43,036 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +wooden +photo +frames +United +States 
13:33:43,043 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,044 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campaigns (accountID, advertID, businessFunctionID, locationID, customerDisplayURL, customerDestinationURL, localeName) select a.id, ?, ?, ?, ?, ?, ? from mms_common.accounts a where a.bpID = ? on duplicate key update customerDisplayURL = ?, customerDestinationURL = ?]
13:33:43,045 DEBUG [JdbcTemplate] SQL update affected 2 rows
13:33:43,046 INFO  [CustomerDAO] setting keywordListID to 2714 for advertID 4135
13:33:43,046 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,046 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set keywordListID = ? where advertID = ?]
13:33:43,047 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,048 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,048 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 = ?]
13:33:43,050 DEBUG [JdbcTemplate] Executing SQL query [select multiplier from pointRadiusModifiers where advertID is null]
13:33:43,050 INFO  [AdMaxDeploymentServiceImpl] Using global radius multiplier of 1.0
13:33:43,051 INFO  [AdMaxDeploymentServiceImpl] Finished deploy campaign message conversion. 1 converted.
13:33:43,051 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,051 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
13:33:43,052 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,052 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
13:33:43,053 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,053 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
13:33:43,054 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,070 WARN  [QueueUtils] Setting message priority to 4
13:33:43,077 INFO  [AdMaxDeploymentRequestMDB] Sent DEPLOY request to listener. BPID: ed73ad47-85b7-430e-bc3a-4f45205bf8a7 DeployID: 678b41d9-99f0-4f2f-914e-099f381a0af2
13:33:43,165 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,166 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts(description,tier,priority,conversionTypes,isBidManaged,isActive,perfMetric,providesConversionData,addConversionData,databaseInstance,warehouseInstance,isOnline,currencyCode) values(?,?,?,?,?,?,?,?,?,?,?,?,?)]
13:33:43,170 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,171 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
13:33:43,172 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,172 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into sites(accountID,isDefault,description,internalURLPattern,ignorePixels) values(?,?,?,?,?)]
13:33:43,173 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,173 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
13:33:43,175 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,175 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into userAccountMap(userID,accountID) values(?,?)]
13:33:43,176 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,176 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,176 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`description` = ?]
13:33:43,177 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,178 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?]
13:33:43,179 INFO  [DatabaseInstancePersistenceManager] Database URL: jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&amp;characterEncoding=UTF-8
13:33:43,179 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,179 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accountChannelMap(accountID,channelID) values(?,?)]
13:33:43,187 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,188 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,188 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
13:33:43,196 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,197 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,197 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
13:33:43,206 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,206 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,206 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)]
13:33:43,214 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,214 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,214 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)]
13:33:43,238 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,239 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
13:33:43,247 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,247 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)]
13:33:43,254 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:43,255 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
13:33:43,279 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,279 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`id` = ?]
13:33:43,290 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,290 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?]
13:33:43,292 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:43,292 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
13:33:43,307 DEBUG [JdbcTemplate] Executing prepared SQL update
13:33:43,307 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into admaxAccountAnniversary(accountId,anniversaryDate,startDate) values(?,?,?) on duplicate key update endDate= ?]
13:33:43,315 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:33:45,105 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1644
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>2714</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:33:45,108 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,108 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:33:45,113 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=?
13:33:45,113 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,113 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=?]
13:33:45,119 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2714
13:33:45,119 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,119 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,'(-+|[[:>:]])')) ]
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:33:45,123 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:33:45,147 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:33:45,148 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,148 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:33:45,149 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,149 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:33:45,150 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:33:45,152 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-04-16 13:39:33
13:33:45,152 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
13:33:45,152 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,152 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]
13:33:45,155 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1829.3423/2484.2925
13:33:45,155 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1829.3423
13:33:45,156 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2484.2925
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2484.2925
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 75614.04
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:33:45,156 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 220
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:33:45,156 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 14.725
13:33:45,156 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 75614.04
13:33:45,156 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:33:45,156 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13864.994
13:33:45,156 INFO  [BudgetEstimateServiceImpl] Request time: 49 millis
13:33:45,176 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1644
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-25T13:31:48.000Z</lastUpdateTime><minimumPrice>14.725</minimumPrice><maximumPrice>75614.04</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13864.994</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:33:45,715 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1645
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>2714</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:33:45,718 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,718 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:33:45,722 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=?
13:33:45,722 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,722 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=?]
13:33:45,727 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2714
13:33:45,727 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,727 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,'(-+|[[:>:]])')) ]
13:33:45,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:33:45,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:33:45,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:33:45,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:33:45,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:33:45,730 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:33:45,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:33:45,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:33:45,754 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:33:45,754 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,754 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:33:45,755 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:33:45,758 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:33:45,759 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-04-16 13:39:33
13:33:45,760 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
13:33:45,760 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:45,760 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]
13:33:45,762 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1829.3423/2484.2925
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1829.3423
13:33:45,763 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2484.2925
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2484.2925
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 75614.04
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:33:45,763 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 220
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:33:45,763 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 14.725
13:33:45,764 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 75614.04
13:33:45,764 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:33:45,764 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13864.994
13:33:45,764 INFO  [BudgetEstimateServiceImpl] Request time: 47 millis
13:33:45,799 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1645
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-25T13:31:48.000Z</lastUpdateTime><minimumPrice>14.725</minimumPrice><maximumPrice>75614.04</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13864.994</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:33:58,066 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1646
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>2714</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:33:58,072 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:58,072 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:33:58,077 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=?
13:33:58,077 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:58,077 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=?]
13:33:58,112 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2714
13:33:58,112 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:58,112 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,'(-+|[[:>:]])')) ]
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:33:58,117 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:33:58,118 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:33:58,140 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:33:58,140 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:58,140 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:33:58,142 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:58,142 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:33:58,143 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:33:58,145 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-04-16 13:39:33
13:33:58,145 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
13:33:58,145 DEBUG [JdbcTemplate] Executing prepared SQL query
13:33:58,145 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]
13:33:58,147 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1829.3423/2484.2925
13:33:58,147 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:33:58,147 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:33:58,147 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1829.3423
13:33:58,147 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2484.2925
13:33:58,147 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2484.2925
13:33:58,147 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 75614.04
13:33:58,147 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:33:58,148 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 220
13:33:58,148 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:33:58,148 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 14.725
13:33:58,148 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 75614.04
13:33:58,148 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:33:58,148 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13864.994
13:33:58,148 INFO  [BudgetEstimateServiceImpl] Request time: 78 millis
13:33:58,174 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1646
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-25T13:31:48.000Z</lastUpdateTime><minimumPrice>14.725</minimumPrice><maximumPrice>75614.04</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13864.994</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,734 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1647
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,735 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,735 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,738 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,738 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,738 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,739 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,739 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,739 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,742 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,742 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,742 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,742 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,742 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,742 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,748 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4089 -> null
13:34:09,749 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,749 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,749 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,753 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,753 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,755 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,759 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1647
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4089</campaignID><businessAreaID>10002</businessAreaID><keywordListID>0</keywordListID><businessLocationID>51</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,773 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1648
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,774 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,774 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,776 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,776 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,776 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,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=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,777 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,777 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,780 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,781 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,781 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,781 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,781 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,784 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4135: Paused -> Paused
13:34:09,784 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4135 -> PAUSED
13:34:09,785 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,785 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,785 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,788 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,788 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,790 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,790 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,792 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,792 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 = ? ]
13:34:09,796 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1648
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID><domain>sss.cc????</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4135</campaignID><businessAreaID>12370</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://sss.cc????</destinationURL><displayURL>sss.cc????</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,801 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1649
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,802 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,803 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,806 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,806 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,807 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,809 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,810 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,813 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4112 -> null
13:34:09,814 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,814 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,814 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,817 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,817 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,819 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,819 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,822 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1649
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID><domain>w.ss</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4112</campaignID><businessAreaID>11262</businessAreaID><keywordListID>0</keywordListID><businessLocationID>3</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,827 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1650
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,828 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,828 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,830 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,830 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,830 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,831 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,831 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,832 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,834 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,837 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4090 -> null
13:34:09,838 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,838 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,838 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,841 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,842 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,843 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,843 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,846 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1650
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4090</campaignID><businessAreaID>10006</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,851 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1651
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,852 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,852 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,854 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,854 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,854 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,855 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,855 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,855 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,858 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,862 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4080 -> null
13:34:09,862 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,862 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,862 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,866 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,866 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,868 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,868 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,870 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1651
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4080</campaignID><businessAreaID>10003</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,876 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1652
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,877 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,877 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,879 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,879 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,879 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,880 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,880 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,880 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,882 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,882 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,882 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,883 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,886 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4094 -> null
13:34:09,887 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,887 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,887 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,890 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,890 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,892 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,892 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,894 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1652
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID><domain>v.co</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4094</campaignID><businessAreaID>11979</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,900 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1653
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:34:09,901 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,901 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:34:09,904 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,904 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:34:09,904 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:34:09,905 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:34:09,905 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,905 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:34:09,908 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:09,908 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:34:09,908 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:34:09,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:34:09,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:09,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:34:09,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:34:09,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:34:09,909 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:34:09,912 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4084 -> null
13:34:09,913 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:34:09,913 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,913 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:34:09,916 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,916 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:34:09,918 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:09,918 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:34:09,920 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1653
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4084</campaignID><businessAreaID>10008</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:34:16,118 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
13:34:16,120 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
13:34:16,121 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
13:34:16,133 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
13:34:19,522 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1654
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=[450], 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>62</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:34:19,527 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:19,527 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:34:19,531 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=?
13:34:19,531 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:19,531 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=?]
13:34:19,538 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 62
13:34:19,539 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:19,539 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,'(-+|[[:>:]])')) ]
13:34:19,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:34:19,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:34:19,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:34:19,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:34:19,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:34:19,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:34:19,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:34:19,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:34:19,549 DEBUG [KeywordServiceImpl] 66 keywords found for BF: 0
13:34:19,549 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:19,549 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:34:19,550 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:19,551 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:34:19,552 DEBUG [KeywordServiceImpl] 66 keywords found for BF: 0
13:34:19,552 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-02-13 11:06:05
13:34:19,552 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
13:34:19,552 DEBUG [JdbcTemplate] Executing prepared SQL query
13:34:19,552 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]
13:34:19,554 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1360.4908/1847.5802
13:34:19,554 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1360.4908
13:34:19,555 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 1847.5802
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 1847.5802
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 56234.52
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:34:19,555 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 24
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:34:19,555 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 25.255
13:34:19,555 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 56234.52
13:34:19,555 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:34:19,555 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 6011.943
13:34:19,555 INFO  [BudgetEstimateServiceImpl] Request time: 29 millis
13:34:19,563 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1654
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>62</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-24T06:44:36.000Z</lastUpdateTime><minimumPrice>25.255</minimumPrice><maximumPrice>56234.52</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>6011.943</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:01,173 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1655
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>2714</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:35:01,217 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:01,218 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:35:01,220 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=?
13:35:01,220 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:01,220 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=?]
13:35:01,225 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2714
13:35:01,227 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:01,227 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,'(-+|[[:>:]])')) ]
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:35:01,236 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:35:01,283 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:35:01,283 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:01,284 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:35:01,285 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:01,285 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:35:01,288 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:35:01,290 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-04-16 13:39:33
13:35:01,290 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
13:35:01,290 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:01,290 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]
13:35:01,292 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1829.3423/2484.2925
13:35:01,292 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:35:01,292 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:35:01,292 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1829.3423
13:35:01,293 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2484.2925
13:35:01,293 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2484.2925
13:35:01,293 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 75614.04
13:35:01,293 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:35:01,293 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 220
13:35:01,293 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:35:01,293 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 14.725
13:35:01,293 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 75614.04
13:35:01,293 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:35:01,293 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13864.994
13:35:01,293 INFO  [BudgetEstimateServiceImpl] Request time: 118 millis
13:35:01,301 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1655
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-25T13:31:48.000Z</lastUpdateTime><minimumPrice>14.725</minimumPrice><maximumPrice>75614.04</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13864.994</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,751 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1656
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,753 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,753 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,755 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,755 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,755 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,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=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,756 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,756 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,758 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,760 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4089 -> null
13:35:09,761 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,761 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,761 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,764 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,764 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,765 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,765 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,768 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1656
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4089</campaignID><businessAreaID>10002</businessAreaID><keywordListID>0</keywordListID><businessLocationID>51</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,776 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1657
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,778 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,778 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,794 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,794 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,795 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,796 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,797 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,797 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,798 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,802 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4135: Paused -> Paused
13:35:09,802 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4135 -> PAUSED
13:35:09,803 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,803 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,803 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,809 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,809 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,810 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,811 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,812 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,812 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 = ? ]
13:35:09,817 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1657
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID><domain>sss.cc????</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4135</campaignID><businessAreaID>12370</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://sss.cc????</destinationURL><displayURL>sss.cc????</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,823 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1658
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,824 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,824 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,826 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,826 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,826 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,828 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,831 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4112 -> null
13:35:09,831 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,831 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,831 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,835 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,835 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,836 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,836 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,839 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1658
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID><domain>w.ss</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4112</campaignID><businessAreaID>11262</businessAreaID><keywordListID>0</keywordListID><businessLocationID>3</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,845 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1659
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,846 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,846 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,848 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,848 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,848 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,850 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,850 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,850 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,852 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,852 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,852 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,852 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,854 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4090 -> null
13:35:09,855 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,855 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,855 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,858 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,859 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,860 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,860 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,863 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1659
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4090</campaignID><businessAreaID>10006</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,868 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1660
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,869 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,869 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,872 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,872 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,872 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,873 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,873 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,873 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,874 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,877 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4080 -> null
13:35:09,878 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,878 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,878 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,881 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,881 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,883 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,883 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,885 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1660
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4080</campaignID><businessAreaID>10003</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,890 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1661
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,891 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,891 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,893 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,893 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,893 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,893 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,893 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,893 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,894 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,895 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,897 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4094 -> null
13:35:09,898 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,898 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,898 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,902 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,902 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,903 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,903 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,906 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1661
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID><domain>v.co</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4094</campaignID><businessAreaID>11979</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,911 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1662
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:35:09,912 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,912 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:35:09,913 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,913 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:35:09,914 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:35:09,914 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:35:09,914 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,914 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:35:09,915 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:35:09,915 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:35:09,915 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:35:09,916 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:35:09,916 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:35:09,916 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:35:09,916 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:35:09,916 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:35:09,916 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:35:09,918 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4084 -> null
13:35:09,919 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:35:09,919 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,919 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:35:09,922 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,922 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:35:09,924 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:09,924 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:35:09,926 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1662
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4084</campaignID><businessAreaID>10008</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:35:16,132 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
13:35:16,133 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
13:35:16,134 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
13:35:16,151 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
13:35:35,410 INFO  [AuditorServiceBD] Entering the audit method...
13:35:35,411 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:35,411 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
13:35:35,416 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:35,416 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?]
13:35:35,417 DEBUG [JdbcTemplate] Executing prepared SQL update
13:35:35,417 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
13:35:35,418 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:35:35,419 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
13:35:35,422 DEBUG [JdbcTemplate] Executing prepared SQL update
13:35:35,422 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)]
13:35:35,423 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:35:35,424 INFO  [AuditorServiceBD] Exiting the audit method...
13:35:35,649 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
13:35:35,679 INFO  [AdMaxDeploymentMessageConverter] Campaings for the Result: 1
13:35:35,679 INFO  [AdMaxDeploymentMessageConverter] Assuming No Message Fault, Campaigns count:  1 topResultCode: null 
13:35:35,684 INFO  [AuditorServiceBD] Entering the audit method...
13:35:35,685 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:35,685 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
13:35:35,688 DEBUG [JdbcTemplate] Executing prepared SQL query
13:35:35,688 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?]
13:35:35,689 DEBUG [JdbcTemplate] Executing prepared SQL update
13:35:35,689 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
13:35:35,690 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:35:35,691 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
13:35:35,695 DEBUG [JdbcTemplate] Executing prepared SQL update
13:35:35,695 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)]
13:35:35,696 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:35:35,697 INFO  [AuditorServiceBD] Exiting the audit method...
13:35:35,710 INFO  [AdMaxDeploymentResponseMDB] Handling publish deploy status resp
13:36:09,727 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1663
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:09,728 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,728 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:09,729 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:09,729 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:09,729 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:09,730 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:09,730 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,730 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:09,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:09,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:09,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:09,731 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:09,732 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:09,732 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:09,732 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:09,732 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:09,732 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:09,734 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4089 -> null
13:36:09,735 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:09,736 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,736 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:09,738 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,738 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:09,741 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,741 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:09,744 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1663
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4089</campaignID><businessAreaID>10002</businessAreaID><keywordListID>0</keywordListID><businessLocationID>51</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:09,750 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1664
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:09,751 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,751 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:09,753 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:09,753 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:09,753 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:09,754 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:09,754 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,754 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:09,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:09,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:09,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:09,756 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:09,757 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:09,761 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4135: Paused -> Paused
13:36:09,761 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4135 -> PAUSED
13:36:09,762 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:09,762 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:09,766 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,766 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:09,767 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,767 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:09,769 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,769 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 = ? ]
13:36:09,771 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1664
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID><domain>sss.cc????</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4135</campaignID><businessAreaID>12370</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://sss.cc????</destinationURL><displayURL>sss.cc????</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:09,777 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1665
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>4135</campaigns>
</operationErrorsRequest>
</core:getOperationErrors></soap:Body></soap:Envelope>
--------------------------------------
13:36:09,779 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('4135')]
13:36:09,779 DEBUG [JdbcTemplate] Executing SQL query [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('4135')]
13:36:09,783 INFO  [ErrorDAOSpringJDBC] GCE_CAMPAIGNS:2762, 2761
13:36:09,783 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 ('2762', '2761') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
13:36:09,783 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 ('2762', '2761') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
13:36:09,785 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 ('2762', '2761') AND gce_campaignFeedPendingChange.isFailed='true']
13:36:09,785 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 ('2762', '2761') AND gce_campaignFeedPendingChange.isFailed='true']
13:36:09,787 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 ('2762', '2761') AND gce_feedPendingChange.isFailed='true']
13:36:09,787 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 ('2762', '2761') AND gce_feedPendingChange.isFailed='true']
13:36:09,788 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 ('2762', '2761') AND gce_feedItemPendingChange.isFailed='true']
13:36:09,789 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 ('2762', '2761') AND gce_feedItemPendingChange.isFailed='true']
13:36:09,790 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 ('2762', '2761') AND gce_feedMappingPendingChange.isFailed='true']
13:36:09,790 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 ('2762', '2761') AND gce_feedMappingPendingChange.isFailed='true']
13:36:09,792 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1665
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>
--------------------------------------
13:36:09,799 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1666
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>4135</campaigns>
</operationErrorsRequest>
</core:getOperationErrorDetails></soap:Body></soap:Envelope>
--------------------------------------
13:36:09,839 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('4135')]
13:36:09,839 DEBUG [JdbcTemplate] Executing SQL query [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('4135')]
13:36:09,841 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,841 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 ('2762','2761') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_textAd.status != ? ]
13:36:09,844 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('4135')]
13:36:09,844 DEBUG [JdbcTemplate] Executing SQL query [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('4135')]
13:36:09,845 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,845 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 ('2762','2761') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_keyword.status not in (?,?,?,?) ]
13:36:09,849 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:09,849 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL from mms_common.campaigns where advertID = ?]
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:09,851 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:09,854 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1666
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><operationErrorDetails><category>TextAd</category><campaignID>4135</campaignID><keywordListID>2714</keywordListID><itemPath><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_1</description><externalID>3120453212</externalID><status>Active</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135_GT</description><externalID>175794781</externalID><status>Paused</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135</description><externalID>13227664741</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>AdError</code><trigger></trigger><field>operations[1].operand.ad.url</field><reason>AdError.URL_INVALID_TOP_LEVEL_DOMAIN</reason><policyName></policyName></operationErrorCodes><itemFields><field>Headline</field><value>{KeyWord:Top Photo Frames}</value></itemFields><itemFields><field>Description1</field><value>The Frames to Fit Your Home.</value></itemFields><itemFields><field>Description2</field><value>Wide Range of Photo Frames.</value></itemFields><itemFields><field>DisplayURL</field><value>sss.cc????</value></itemFields><itemFields><field>DestinationURL</field><value>http://sss.cc????</value></itemFields></operationErrorDetails><operationErrorDetails><category>TextAd</category><campaignID>4135</campaignID><keywordListID>2714</keywordListID><itemPath><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_1</description><externalID>3120453212</externalID><status>Active</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135_GT</description><externalID>175794781</externalID><status>Paused</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135</description><externalID>13227664741</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>AdError</code><trigger></trigger><field>operations[0].operand.ad.url</field><reason>AdError.URL_INVALID_TOP_LEVEL_DOMAIN</reason><policyName></policyName></operationErrorCodes><itemFields><field>Headline</field><value>Top Photo Frames</value></itemFields><itemFields><field>Description1</field><value>Wide Range of Photo Frames.</value></itemFields><itemFields><field>Description2</field><value>The Frames to Fit Your Home.</value></itemFields><itemFields><field>DisplayURL</field><value>sss.cc????</value></itemFields><itemFields><field>DestinationURL</field><value>http://sss.cc????</value></itemFields></operationErrorDetails><operationErrorDetails><category>TextAd</category><campaignID>4135</campaignID><keywordListID>2714</keywordListID><itemPath><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_1</description><externalID>3120453212</externalID><status>Active</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135_GM</description><externalID>175794901</externalID><status>Paused</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135_United States</description><externalID>13227664861</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>AdError</code><trigger></trigger><field>operations[1].operand.ad.url</field><reason>AdError.URL_INVALID_TOP_LEVEL_DOMAIN</reason><policyName></policyName></operationErrorCodes><itemFields><field>Headline</field><value>{KeyWord:Top Photo Frames}</value></itemFields><itemFields><field>Description1</field><value>The Frames to Fit Your Home.</value></itemFields><itemFields><field>Description2</field><value>Wide Range of Photo Frames.</value></itemFields><itemFields><field>DisplayURL</field><value>sss.cc????</value></itemFields><itemFields><field>DestinationURL</field><value>http://sss.cc????</value></itemFields></operationErrorDetails><operationErrorDetails><category>TextAd</category><campaignID>4135</campaignID><keywordListID>2714</keywordListID><itemPath><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_1</description><externalID>3120453212</externalID><status>Active</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135_GM</description><externalID>175794901</externalID><status>Paused</status><child><description>ed73ad47-85b7-430e-bc3a-4f45205bf8a7_12370_1_4135_United States</description><externalID>13227664861</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>AdError</code><trigger></trigger><field>operations[0].operand.ad.url</field><reason>AdError.URL_INVALID_TOP_LEVEL_DOMAIN</reason><policyName></policyName></operationErrorCodes><itemFields><field>Headline</field><value>Top Photo Frames</value></itemFields><itemFields><field>Description1</field><value>Wide Range of Photo Frames.</value></itemFields><itemFields><field>Description2</field><value>The Frames to Fit Your Home.</value></itemFields><itemFields><field>DisplayURL</field><value>sss.cc????</value></itemFields><itemFields><field>DestinationURL</field><value>http://sss.cc????</value></itemFields></operationErrorDetails></getOperationErrorDetailsResponse></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:10,701 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1667
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:10,702 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,703 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:10,704 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:10,704 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:10,704 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:10,705 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:10,705 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,705 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:10,706 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:10,711 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 4135: Paused -> Paused
13:36:10,711 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4135 -> PAUSED
13:36:10,712 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:10,712 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,712 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:10,715 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,715 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:10,716 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,716 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:10,718 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,718 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 = ? ]
13:36:10,720 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1667
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>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID><domain>sss.cc????</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>4135</campaignID><businessAreaID>12370</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><customLandingPage><destinationURL>http://sss.cc????</destinationURL><displayURL>sss.cc????</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:10,734 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1668
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=[573], 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>678b41d9-99f0-4f2f-914e-099f381a0af2</requestID>
    </header>
    <customerID>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID>
    <campaignStatusList>
        <campaignID>4135</campaignID>
        <campaignStatus>active</campaignStatus>
    </campaignStatusList>
</updateCampaignStatusRequest>
</core:updateCampaignStatus></soap:Body></soap:Envelope>
--------------------------------------
13:36:10,735 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,735 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:10,737 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,737 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
13:36:10,740 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,740 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
13:36:10,760 WARN  [QueueUtils] Setting message priority to 4
13:36:10,781 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,781 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:36:10,783 INFO  [AdMaxDeploymentFauxSyncMessenger] Starting campaign status update blocking loop
13:36:10,783 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,783 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:36:10,810 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,810 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
13:36:10,814 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,814 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
13:36:10,817 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,817 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
13:36:10,818 DEBUG [JdbcTemplate] Executing prepared SQL update
13:36:10,818 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
13:36:10,819 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:36:10,828 WARN  [QueueUtils] Setting message priority to 9
13:36:10,833 INFO  [AdMaxDeploymentRequestMDB] Sent UPDATE request to listener. BPID: ed73ad47-85b7-430e-bc3a-4f45205bf8a7 DeployID: 678b41d9-99f0-4f2f-914e-099f381a0af2
13:36:10,852 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:10,859 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
13:36:11,626 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
13:36:11,647 DEBUG [JdbcTemplate] Executing prepared SQL update
13:36:11,647 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campUpdateResp(deploymentID, responseMsg) values (?, ?) on duplicate key update responseMsg = ?]
13:36:11,650 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:36:11,651 WARN  [AdMaxDeploymentFauxSyncMessenger] Put update ok for deploy 678b41d9-99f0-4f2f-914e-099f381a0af2
13:36:11,651 INFO  [AdMaxDeploymentResponseMDB] Handling update campaign status.
13:36:11,785 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:11,786 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:36:12,794 INFO  [AdMaxDeploymentFauxSyncMessenger] Exited blocking loop
13:36:12,800 DEBUG [JdbcTemplate] Executing prepared SQL update
13:36:12,800 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?]
13:36:12,802 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:36:12,804 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1668
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>678b41d9-99f0-4f2f-914e-099f381a0af2</requestID></header><customerID>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID><campaignResult><campaignID>4135</campaignID><result><resultCode>success</resultCode><resultString>Information: [4135_GM:SUCCEEDED] [4135_GT:SUCCEEDED] </resultString></result></campaignResult></updateCampaignStatusResponse></ns2:updateCampaignStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:12,815 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1669
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=[677], 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>678b41d9-99f0-4f2f-914e-099f381a0af2</requestID>
    </header>
    <customerID>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID>
    <campaignBudgetAccrualStatusList>
        <campaignID>4135</campaignID>
        <campaignBudgetAccrualStatus>active</campaignBudgetAccrualStatus>
    </campaignBudgetAccrualStatusList>
</updateCampaignBudgetAccrualStatusRequest>
</core:updateCampaignBudgetAccrualStatus></soap:Body></soap:Envelope>
--------------------------------------
13:36:12,825 INFO  [AdMaxAccountDeploymentBD] validated: []
13:36:12,825 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:12,825 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:12,827 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:12,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
13:36:12,829 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:12,829 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
13:36:12,837 INFO  [AdMaxAccountDeploymentBD] Account: Account [theAccountID=837, theDescription=ed73ad47-85b7-430e-bc3a-4f45205bf8a7, 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 Jun 25 13:36:12 UTC 2014, theWarehouseDB=warehouse_1, theDatabaseInstance=1, theWarehouseInstance=1, isOnline=true, currencyCode=, theSites=[Site [theSiteId=836, theAccountId=837, isDefault=true, theDescription=ed73ad47-85b7-430e-bc3a-4f45205bf8a7_Main, theInternalURLPattern=, hasIgnorePixels=false, theWaypoints=[Waypoint [theWaypointId=1671, theSiteId=836, 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=1672, theSiteId=836, 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]]]]]
13:36:12,837 INFO  [AdMaxAccountDeploymentBD] Updating CampaignID [4135] budget accrual status to [active]
13:36:12,838 DEBUG [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus
13:36:12,840 DEBUG [CampaignBudgetAccrualStatusServiceBD] CampaignBudgetAccrualStatusServiceBD.getCurrentAccrualStatus - Searching for current CampaignBudgetAccrualStatus record for CampaignId [1324]
13:36:12,840 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:12,840 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL]
13:36:12,849 INFO  [CampaignBudgetAccrualStatusServiceBD] AdMaxCampaignId [1324] current CampaignBudgetAccrualStatus: CampaignBugetAccrualStatus [theId=2562, theCampaignId=1324, theStartDate=2014-06-25, theEndDate=null, theStatus=paused]
13:36:12,850 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:12,850 DEBUG [JdbcTemplate] Executing prepared SQL statement [select accountID, currencyCode, timeZoneId from gce_googleAccount where accountID = ? ]
13:36:12,852 DEBUG [JdbcTemplate] Executing prepared SQL update
13:36:12,852 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ]
13:36:12,859 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:36:12,860 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [1324] updated CampaignBudgetAccrualStatus updated status
CampaignBugetAccrualStatus [theId=2562, theCampaignId=1324, theStartDate=2014-06-25, theEndDate=null, theStatus=active]
13:36:12,860 DEBUG [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
13:36:12,890 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1669
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>678b41d9-99f0-4f2f-914e-099f381a0af2</requestID></header><customerID>ed73ad47-85b7-430e-bc3a-4f45205bf8a7</customerID><campaignResult><campaignID>4135</campaignID><result><resultCode>success</resultCode></result></campaignResult></updateCampaignBudgetAccrualStatusResponse></ns2:updateCampaignBudgetAccrualStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,106 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1670
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,107 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,107 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:13,109 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,109 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:13,109 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:13,110 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:13,110 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,110 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:13,111 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:13,114 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4112 -> null
13:36:13,114 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:13,114 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,115 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:13,117 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,117 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:13,119 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,119 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:13,121 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1670
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID><domain>w.ss</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4112</campaignID><businessAreaID>11262</businessAreaID><keywordListID>0</keywordListID><businessLocationID>3</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,132 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1671
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,133 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,133 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:13,134 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,134 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:13,134 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:13,135 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:13,135 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,135 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:13,136 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:13,139 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4090 -> null
13:36:13,139 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:13,140 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,140 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:13,142 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,142 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:13,144 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,144 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:13,146 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1671
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4090</campaignID><businessAreaID>10006</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,151 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1672
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,152 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,152 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:13,153 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,153 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:13,153 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:13,154 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:13,154 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,154 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:13,155 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:13,156 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:13,159 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4080 -> null
13:36:13,160 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:13,160 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,160 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:13,163 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,163 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:13,164 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,164 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:13,167 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1672
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4080</campaignID><businessAreaID>10003</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,172 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1673
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,173 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,173 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:13,174 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,174 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:13,174 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:13,175 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:13,175 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,175 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:13,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:13,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:13,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:13,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:13,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:13,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:13,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:13,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:13,180 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4094 -> null
13:36:13,180 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:13,181 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,181 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:13,184 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,184 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:13,185 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,185 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:13,187 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1673
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID><domain>v.co</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4094</campaignID><businessAreaID>11979</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,192 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1674
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:36:13,193 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,193 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:36:13,194 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,195 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:36:13,195 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:36:13,195 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:36:13,195 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,196 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:36:13,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:36:13,200 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4084 -> null
13:36:13,201 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:36:13,201 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,201 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:36:13,204 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,204 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:36:13,206 DEBUG [JdbcTemplate] Executing prepared SQL query
13:36:13,206 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:36:13,211 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1674
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4084</campaignID><businessAreaID>10008</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:36:16,145 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
13:36:16,147 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
13:36:16,147 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
13:36:16,158 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
13:37:09,732 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1675
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,735 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,736 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:37:09,737 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,737 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:37:09,737 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:37:09,738 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:37:09,738 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,738 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:37:09,739 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,739 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:37:09,739 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:37:09,740 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:37:09,740 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:09,740 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:37:09,740 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:37:09,740 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:37:09,740 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:37:09,743 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4089 -> null
13:37:09,743 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:37:09,744 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:37:09,747 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,747 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:37:09,749 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,749 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:37:09,752 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1675
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>f62c8990-078c-4a24-9b4f-7bfbb192a762</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4089</campaignID><businessAreaID>10002</businessAreaID><keywordListID>0</keywordListID><businessLocationID>51</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,758 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1676
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,759 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,759 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:37:09,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:37:09,761 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:37:09,761 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:37:09,762 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:37:09,763 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:37:09,767 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4112 -> null
13:37:09,768 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:37:09,768 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,768 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:37:09,771 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,771 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:37:09,773 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,773 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:37:09,775 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1676
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>7b3ae2d2-5169-42ff-9e5c-ef182d011f8d</customerID><domain>w.ss</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4112</campaignID><businessAreaID>11262</businessAreaID><keywordListID>0</keywordListID><businessLocationID>3</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,780 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1677
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,781 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,782 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:37:09,783 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,783 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:37:09,783 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:37:09,783 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:37:09,783 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,784 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:37:09,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:37:09,788 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4090 -> null
13:37:09,789 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:37:09,789 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,789 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:37:09,792 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,792 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:37:09,793 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,793 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:37:09,796 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1677
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>82bba25c-ec25-400a-bfe9-9297295aa314</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4090</campaignID><businessAreaID>10006</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,801 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1678
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,802 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,802 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:37:09,803 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,803 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:37:09,803 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:37:09,804 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:37:09,804 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,804 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:37:09,805 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:37:09,806 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:37:09,806 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:37:09,808 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4080 -> null
13:37:09,809 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:37:09,809 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,809 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:37:09,812 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,812 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:37:09,813 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,813 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:37:09,816 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1678
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>a787a11e-ff3e-4ab5-b46b-811eada05ad2</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4080</campaignID><businessAreaID>10003</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,821 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1679
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,822 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,822 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:37:09,823 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,823 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:37:09,823 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:37:09,824 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:37:09,824 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,824 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:37:09,825 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:37:09,826 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:37:09,828 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4094 -> null
13:37:09,828 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:37:09,829 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,829 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:37:09,831 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,831 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:37:09,833 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,833 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:37:09,835 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1679
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>b282ca5c-9d1b-4141-97b6-0dc38e594d04</customerID><domain>v.co</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4094</campaignID><businessAreaID>11979</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,840 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1680
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:37:09,841 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,841 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:37:09,842 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,842 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:37:09,842 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:37:09,843 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
13:37:09,843 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,843 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:37:09,844 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:37:09,845 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:37:09,847 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 4084 -> null
13:37:09,847 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:37:09,847 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,848 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:37:09,850 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,850 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:37:09,852 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:09,852 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:37:09,854 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1680
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>58f12818-200b-488c-9d92-ec4acc0731fd</customerID><domain>w.re</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>4084</campaignID><businessAreaID>10008</businessAreaID><keywordListID>0</keywordListID><businessLocationID>1</businessLocationID><deploymentStatus>Pending</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:37:16,158 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
13:37:16,159 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
13:37:16,159 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
13:37:16,172 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
13:37:43,204 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 1681
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 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><businessAreaID>0</businessAreaID><businessLocationID>1</businessLocationID><keywordListID>2714</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:37:43,212 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:43,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
13:37:43,214 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=?
13:37:43,215 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:43,215 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=?]
13:37:43,221 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2714
13:37:43,221 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:43,221 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,'(-+|[[:>:]])')) ]
13:37:43,224 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:37:43,224 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:37:43,224 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:37:43,224 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:37:43,224 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:37:43,224 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:37:43,225 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:37:43,225 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:37:43,247 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:37:43,247 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:43,247 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:37:43,248 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:43,248 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:37:43,249 DEBUG [KeywordServiceImpl] 253 keywords found for BF: 0
13:37:43,251 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-04-16 13:39:33
13:37:43,251 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
13:37:43,251 DEBUG [JdbcTemplate] Executing prepared SQL query
13:37:43,252 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]
13:37:43,254 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 1829.3423/2484.2925
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 1829.3423
13:37:43,254 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 2484.2925
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 2484.2925
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 75614.04
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:37:43,254 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 220
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:37:43,254 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 14.725
13:37:43,255 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 75614.04
13:37:43,255 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
13:37:43,255 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13864.994
13:37:43,255 INFO  [BudgetEstimateServiceImpl] Request time: 47 millis
13:37:43,276 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 1681
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><businessAreaID>0</businessAreaID><keywordListID>2714</keywordListID><businessLocationID>1</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-06-25T13:31:48.000Z</lastUpdateTime><minimumPrice>14.725</minimumPrice><maximumPrice>75614.04</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13864.994</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
^C
[TSAApp@aml-qa3-core1 ~]$