[TSAApp@aml-qa3-core1 jboss-5.1.0.GA]$ tail -f tsa_messaging_node_server.log
ID: 480
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorDetailsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorDetailsResponse/></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:40:30,446 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:40:30,462 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:40:30,462 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:40:30,476 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:41:17,635 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 481
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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:41:17,639 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,639 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:41:17,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:17,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:41:17,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:41:17,642 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}
14:41:17,642 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,642 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=?]
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:41:17,644 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:41:17,645 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:41:17,645 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:41:17,651 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1584: Deleted -> Deleted
14:41:17,651 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1584 -> TERMINATED
14:41:17,652 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:41:17,652 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,652 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:41:17,677 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,677 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:41:17,680 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,680 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:41:17,682 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,682 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:41:17,685 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 481
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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>1584</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>49</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:17,770 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 482
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>c0299900-11ca-4001-ab2d-a61dec342288</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>a1ff3963-26da-4274-9902-0fae30c589a6</customerID>
        <domainName>www.merchantsite.com</domainName>
        <budget>1.0</budget>
        <anniversaryDate>2014-02-28</anniversaryDate>
        <currencyCode>USD</currencyCode>
        <timeZone>Asia/Seoul</timeZone>
        <countryCode>US</countryCode>
    </customer>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <businessAreaID>10997</businessAreaID>
        <keywordListID>358</keywordListID>
        <businessLocationID>41</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Simplify Your Life.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Local Food Processor Dealers.</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:Better Food Processors}</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">A Wealth of Experience &amp; Expertise.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">The Choice for Food Processors.</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:Want a Food Processor?}</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">Local Food Processor Dealers.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Simplify Your Life.</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">Better Food Processors</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 Choice for Food Processors.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">www.merchantsite.com</value>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/</value>
                </entry>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">A Wealth of Experience &amp; Expertise.</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">Want a Food Processor?</value>
                </entry>
            </attributes>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
14:41:17,776 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = a1ff3963-26da-4274-9902-0fae30c589a6, requestID = c0299900-11ca-4001-ab2d-a61dec342288
14:41:17,839 INFO  [ValidationUtils] TIMEZONE = Asia/Seoul
14:41:17,840 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,840 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:41:17,844 DEBUG [JdbcTemplate] Executing prepared SQL update
14:41:17,844 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
14:41:17,846 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:41:17,847 INFO  [AdMaxDeploymentServiceImpl] xkeywordListID + 358
14:41:17,848 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,848 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL from mms_common.campaigns where advertID = ?]
14:41:17,850 WARN  [CustomerDAO] Unable to find campaign: advertID a1ff3963-26da-4274-9902-0fae30c589a6-QF0XULzZ7V
14:41:17,850 DEBUG [JdbcTemplate] Executing SQL update and returning generated keys
14:41:17,850 DEBUG [JdbcTemplate] Executing prepared SQL statement
14:41:17,852 DEBUG [JdbcTemplate] SQL update affected 1 rows and returned 1 keys
14:41:17,854 DEBUG [JdbcTemplate] Executing prepared SQL update
14:41:17,854 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set advertID=? where id=?]
14:41:17,856 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:41:17,866 WARN  [QueueUtils] Setting message priority to 4
14:41:17,872 INFO  [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: 1586
14:41:17,874 INFO  [AdMaxDeploymentServiceImpl] Starting deploy campaign message conversion
14:41:17,882 INFO  [AdMaxDeploymentServiceImpl] UpdateTypes: [ALL]
14:41:17,884 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 482
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>c0299900-11ca-4001-ab2d-a61dec342288</requestID><retryID>1</retryID></header><result><resultCode>queued</resultCode><resultString>queued</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:17,913 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,913 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
14:41:17,954 DEBUG [JdbcTemplate] Executing prepared SQL update
14:41:17,954 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?]
14:41:17,956 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:41:17,956 INFO  [AdMaxDeploymentServiceImpl] 1 Campaign(s) to process.
14:41:17,980 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:41:17,980 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:17,980 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:41:18,014 DEBUG [AdMaxDeploymentServiceImpl] Processing CampaignInfo...
14:41:18,014 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessLocationId [41]
14:41:18,014 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessAreaID [10997]
14:41:18,014 DEBUG [AdMaxDeploymentServiceImpl] Retrieving KeywordListID [358]
14:41:18,145 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,146 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=?]
14:41:18,147 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,147 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 = ?]
14:41:18,154 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,154 DEBUG [JdbcTemplate] Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=? order by bcam.businessCategoryID limit 1]
14:41:18,156 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessLocation
Location:  ID: 41 Description: Kansas Short Description: Kansas Status: active Type: State ParentBusinessLocationID: 1 Use SE Defined Targets: false Use Point Radius Targets: true Is Sellable: true
14:41:18,156 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessArea
BusinessArea:  ID: 10997 Description: Food Processors Status: active BusinessCategoryID: 13
14:41:18,161 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,161 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id and merchantUUID='') where l.businessFunctionID = ? and k.matchType = ?]
14:41:18,166 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10997
14:41:18,167 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,167 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' ]
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:41:18,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:41:18,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:41:18,174 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 10997, keywordListID: 358
14:41:18,174 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,174 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:41:18,177 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,177 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:41:18,178 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 10997, keywordListID: 358
14:41:18,198 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,198 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, locationID, aliasType, description, descType, ordering, shortDescription  from mms_common.locationAliases where locationID=? and aliasType=? order by ordering asc]
14:41:18,203 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10997
14:41:18,203 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,203 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' ]
14:41:18,204 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:18,204 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:18,204 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:41:18,204 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:41:18,205 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:41:18,205 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:41:18,205 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:41:18,205 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:41:18,212 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 10997, keywordListID: 358
14:41:18,212 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:41:18,216 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,216 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:41:18,217 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 10997, keywordListID: 358
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,218 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,219 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,219 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,219 DEBUG [KeywordServiceImpl] Multi-lang support is: false and path for templates is :null
14:41:18,228 DEBUG [JdbcTemplate] Executing prepared SQL update
14:41:18,229 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 = ?]
14:41:18,230 DEBUG [JdbcTemplate] SQL update affected 2 rows
14:41:18,231 INFO  [CustomerDAO] setting keywordListID to 358 for advertID 1586
14:41:18,231 DEBUG [JdbcTemplate] Executing prepared SQL update
14:41:18,231 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set keywordListID = ? where advertID = ?]
14:41:18,232 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:41:18,233 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,233 DEBUG [JdbcTemplate] Executing prepared SQL statement [select p.id, p.locationID, p.latitudeDegrees, p.longitudeDegrees, p.radiusMeters, (case when m.advertID is not null then m.multiplier else 1 end) as multiplier, (case when m.advertID is not null then m.incrementer else 0 end) as incrementer from pointRadius p left join pointRadiusModifiers m on (m.advertID = ?) where locationID = ?]
14:41:18,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:18,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:41:18,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'latitudeDegrees' to property 'latitudeDegrees' of type float
14:41:18,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'longitudeDegrees' to property 'longitudeDegrees' of type float
14:41:18,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'radiusMeters' to property 'radiusMeters' of type int
14:41:18,235 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'multiplier' to property 'multiplier' of type float
14:41:18,235 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'incrementer' to property 'incrementer' of type int
14:41:18,236 DEBUG [JdbcTemplate] Executing SQL query [select multiplier from pointRadiusModifiers where advertID is null]
14:41:18,237 INFO  [AdMaxDeploymentServiceImpl] Using global radius multiplier of 1.0
14:41:18,237 INFO  [AdMaxDeploymentServiceImpl] Finished deploy campaign message conversion. 1 converted.
14:41:18,237 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,237 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:41:18,239 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,239 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:41:18,240 DEBUG [JdbcTemplate] Executing prepared SQL update
14:41:18,240 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
14:41:18,241 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:41:18,253 WARN  [QueueUtils] Setting message priority to 4
14:41:18,260 INFO  [AdMaxDeploymentRequestMDB] Sent DEPLOY request to listener. BPID: a1ff3963-26da-4274-9902-0fae30c589a6 DeployID: c0299900-11ca-4001-ab2d-a61dec342288
14:41:18,571 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:18,572 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
14:41:19,778 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 483
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>41</businessLocationID><keywordListID>358</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:41:19,799 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:19,799 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=?]
14:41:19,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=?
14:41:19,802 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:19,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=?]
14:41:19,818 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 358
14:41:19,818 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:19,818 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:41:19,821 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:19,821 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:19,821 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:41:19,821 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:41:19,821 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:41:19,822 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:41:19,822 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:41:19,822 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:41:19,827 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 0
14:41:19,827 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:19,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:41:19,831 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:19,832 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:41:19,834 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 0
14:41:19,834 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-09-09 12:57:27
14:41:19,834 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:41:19,834 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:19,834 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:41:19,855 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 19.301493/26.211906
14:41:19,855 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 17
14:41:19,856 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
14:41:19,856 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 19.301493
14:41:19,856 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 26.211906
14:41:19,856 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 26.211906
14:41:19,856 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 797.808
14:41:19,856 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:41:19,856 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 27
14:41:19,857 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:41:19,857 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.474
14:41:19,857 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 797.808
14:41:19,857 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:41:19,857 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 288.196
14:41:19,857 INFO  [BudgetEstimateServiceImpl] Request time: 60 millis
14:41:19,899 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 483
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>358</keywordListID><businessLocationID>41</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-02-28T14:40:05.000Z</lastUpdateTime><minimumPrice>7.474</minimumPrice><maximumPrice>797.808</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>288.196</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:20,690 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 484
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>41</businessLocationID><keywordListID>358</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:41:20,694 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,694 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=?]
14:41:20,728 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 485
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>41</businessLocationID><keywordListID>358</keywordListID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
14:41:20,731 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
14:41:20,731 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,731 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
14:41:20,733 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,735 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=?]
14:41:20,738 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 358
14:41:20,738 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,738 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:41:20,741 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:41:20,743 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
14:41:20,826 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
14:41:20,827 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 0
14:41:20,827 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:41:20,829 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,829 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:41:20,831 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 0
14:41:20,832 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-09-09 12:57:27
14:41:20,832 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:41:20,832 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,832 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:41:20,833 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 358
14:41:20,834 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,834 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
14:41:20,835 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 19.301493/26.211906
14:41:20,835 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 17
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 19.301493
14:41:20,836 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 26.211906
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 26.211906
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 797.808
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:41:20,836 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 27
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:41:20,836 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.474
14:41:20,836 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 797.808
14:41:20,837 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:41:20,837 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 288.196
14:41:20,837 INFO  [BudgetEstimateServiceImpl] Request time: 145 millis
14:41:20,838 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
14:41:20,853 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
14:41:20,860 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 484
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>358</keywordListID><businessLocationID>41</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-02-28T14:40:05.000Z</lastUpdateTime><minimumPrice>7.474</minimumPrice><maximumPrice>797.808</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>288.196</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:20,882 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 0
14:41:20,882 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,882 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
14:41:20,884 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,884 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
14:41:20,885 DEBUG [KeywordServiceImpl] 50 keywords found for BF: 0
14:41:20,885 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-09-09 12:57:27
14:41:20,885 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
14:41:20,886 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:20,886 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
14:41:20,888 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 19.301493/26.211906
14:41:20,888 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 17
14:41:20,888 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 0-0
14:41:20,888 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 19.301493
14:41:20,888 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 26.211906
14:41:20,888 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 26.211906
14:41:20,888 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 797.808
14:41:20,888 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
14:41:20,889 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 27
14:41:20,889 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
14:41:20,889 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.474
14:41:20,889 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 797.808
14:41:20,889 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
14:41:20,889 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 288.196
14:41:20,889 INFO  [BudgetEstimateServiceImpl] Request time: 157 millis
14:41:20,907 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 485
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>358</keywordListID><businessLocationID>41</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2014-02-28T14:40:05.000Z</lastUpdateTime><minimumPrice>7.474</minimumPrice><maximumPrice>797.808</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>288.196</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:26,495 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 486
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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:41:26,514 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,514 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:41:26,516 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:26,516 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:41:26,516 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:41:26,517 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}
14:41:26,517 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,517 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=?]
14:41:26,519 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:41:26,520 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:41:26,523 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1584: Deleted -> Deleted
14:41:26,523 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1584 -> TERMINATED
14:41:26,525 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1586: Paused -> Paused
14:41:26,525 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1586 -> PAUSED
14:41:26,526 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:41:26,526 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,526 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:41:26,529 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,529 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:41:26,531 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,531 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:41:26,533 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,533 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:41:26,536 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 486
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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID><domain>www.merchantsite.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>1584</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>49</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><localeName>en_US</localeName></campaignList><campaignList><campaignID>1586</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>41</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>InProgress</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:26,552 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 487
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>1584</campaigns>
</operationErrorsRequest>
</core:getOperationErrors></soap:Body></soap:Envelope>
--------------------------------------
14:41:26,553 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1584')]
14:41:26,553 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 ('1584')]
14:41:26,556 INFO  [ErrorDAOSpringJDBC] GCE_CAMPAIGNS:1112, 1111
14:41:26,556 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 ('1112', '1111') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:41:26,556 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 ('1112', '1111') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:41:26,557 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 ('1112', '1111') AND gce_campaignFeedPendingChange.isFailed='true']
14:41:26,558 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 ('1112', '1111') AND gce_campaignFeedPendingChange.isFailed='true']
14:41:26,559 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 ('1112', '1111') AND gce_feedPendingChange.isFailed='true']
14:41:26,559 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 ('1112', '1111') AND gce_feedPendingChange.isFailed='true']
14:41:26,560 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 ('1112', '1111') AND gce_feedItemPendingChange.isFailed='true']
14:41:26,560 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 ('1112', '1111') AND gce_feedItemPendingChange.isFailed='true']
14:41:26,562 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 ('1112', '1111') AND gce_feedMappingPendingChange.isFailed='true']
14:41:26,562 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 ('1112', '1111') AND gce_feedMappingPendingChange.isFailed='true']
14:41:26,564 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 487
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorsResponse/></ns2:getOperationErrorsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:26,573 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 488
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>1584</campaigns>
</operationErrorsRequest>
</core:getOperationErrorDetails></soap:Body></soap:Envelope>
--------------------------------------
14:41:26,574 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1584')]
14:41:26,574 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 ('1584')]
14:41:26,576 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,576 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 ('1112','1111') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_textAd.status != ? ]
14:41:26,578 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1584')]
14:41:26,578 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 ('1584')]
14:41:26,580 DEBUG [JdbcTemplate] Executing prepared SQL query
14:41:26,580 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 ('1112','1111') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_keyword.status not in (?,?,?,?) ]
14:41:26,583 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 488
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorDetailsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorDetailsResponse/></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:41:30,476 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:41:30,478 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:41:30,479 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:41:30,493 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:42:04,577 INFO  [AuditorServiceBD] Entering the audit method...
14:42:04,628 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:04,628 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
14:42:04,632 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:04,632 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?]
14:42:04,642 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:04,642 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
14:42:04,643 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:04,644 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:42:04,744 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:04,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)]
14:42:04,746 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:04,747 INFO  [AuditorServiceBD] Exiting the audit method...
14:42:04,862 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
14:42:04,958 INFO  [AdMaxDeploymentMessageConverter] Campaings for the Result: 1
14:42:04,967 INFO  [AdMaxDeploymentMessageConverter] Assuming No Message Fault, Campaigns count:  1 topResultCode: null
14:42:04,967 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:04,978 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:42:05,021 INFO  [AuditorServiceBD] Entering the audit method...
14:42:05,022 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:05,022 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
14:42:05,025 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:05,025 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?]
14:42:05,027 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:05,027 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
14:42:05,028 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:05,028 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()]
14:42:05,037 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:05,037 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)]
14:42:05,038 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:05,039 INFO  [AuditorServiceBD] Exiting the audit method...
14:42:05,083 INFO  [AdMaxDeploymentResponseMDB] Handling publish deploy status resp
14:42:26,507 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 489
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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,509 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,509 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:42:26,511 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:42:26,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:42:26,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:42:26,513 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}
14:42:26,513 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,513 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=?]
14:42:26,514 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:42:26,514 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:42:26,514 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:42:26,514 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:42:26,515 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:42:26,515 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:42:26,515 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:42:26,515 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:42:26,515 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:42:26,523 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1584: Deleted -> Deleted
14:42:26,523 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1584 -> TERMINATED
14:42:26,525 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1586: Paused -> Paused
14:42:26,525 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1586 -> PAUSED
14:42:26,526 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:42:26,526 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,526 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:42:26,538 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,538 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:42:26,542 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,542 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:42:26,544 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,544 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:42:26,558 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 489
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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>1584</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>49</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><localeName>en_US</localeName></campaignList><campaignList><campaignID>1586</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>41</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,578 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 490
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>1584</campaigns>
</operationErrorsRequest>
</core:getOperationErrors></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,579 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1584')]
14:42:26,579 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 ('1584')]
14:42:26,583 INFO  [ErrorDAOSpringJDBC] GCE_CAMPAIGNS:1112, 1111
14:42:26,583 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 ('1112', '1111') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:42:26,583 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 ('1112', '1111') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:42:26,585 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 ('1112', '1111') AND gce_campaignFeedPendingChange.isFailed='true']
14:42:26,585 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 ('1112', '1111') AND gce_campaignFeedPendingChange.isFailed='true']
14:42:26,587 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 ('1112', '1111') AND gce_feedPendingChange.isFailed='true']
14:42:26,587 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 ('1112', '1111') AND gce_feedPendingChange.isFailed='true']
14:42:26,589 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 ('1112', '1111') AND gce_feedItemPendingChange.isFailed='true']
14:42:26,589 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 ('1112', '1111') AND gce_feedItemPendingChange.isFailed='true']
14:42:26,591 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 ('1112', '1111') AND gce_feedMappingPendingChange.isFailed='true']
14:42:26,591 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 ('1112', '1111') AND gce_feedMappingPendingChange.isFailed='true']
14:42:26,594 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 490
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorsResponse/></ns2:getOperationErrorsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,603 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 491
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>1584</campaigns>
</operationErrorsRequest>
</core:getOperationErrorDetails></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,604 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1584')]
14:42:26,604 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 ('1584')]
14:42:26,607 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,607 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 ('1112','1111') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_textAd.status != ? ]
14:42:26,609 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1584')]
14:42:26,609 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 ('1584')]
14:42:26,611 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,611 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 ('1112','1111') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_keyword.status not in (?,?,?,?) ]
14:42:26,620 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 491
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorDetailsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorDetailsResponse/></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,632 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 492
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>1586</campaigns>
</operationErrorsRequest>
</core:getOperationErrors></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,633 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1586')]
14:42:26,633 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 ('1586')]
14:42:26,636 INFO  [ErrorDAOSpringJDBC] GCE_CAMPAIGNS:1114, 1113
14:42:26,636 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 ('1114', '1113') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:42:26,636 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 ('1114', '1113') AND gce_campaignAdExtensionMapPendingChange.isFailed='true']
14:42:26,640 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 ('1114', '1113') AND gce_campaignFeedPendingChange.isFailed='true']
14:42:26,640 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 ('1114', '1113') AND gce_campaignFeedPendingChange.isFailed='true']
14:42:26,642 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 ('1114', '1113') AND gce_feedPendingChange.isFailed='true']
14:42:26,642 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 ('1114', '1113') AND gce_feedPendingChange.isFailed='true']
14:42:26,643 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 ('1114', '1113') AND gce_feedItemPendingChange.isFailed='true']
14:42:26,644 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 ('1114', '1113') AND gce_feedItemPendingChange.isFailed='true']
14:42:26,645 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 ('1114', '1113') AND gce_feedMappingPendingChange.isFailed='true']
14:42:26,645 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 ('1114', '1113') AND gce_feedMappingPendingChange.isFailed='true']
14:42:26,648 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 492
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorsResponse/></ns2:getOperationErrorsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,657 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 493
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[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>1586</campaigns>
</operationErrorsRequest>
</core:getOperationErrorDetails></soap:Body></soap:Envelope>
--------------------------------------
14:42:26,658 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1586')]
14:42:26,658 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 ('1586')]
14:42:26,660 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,660 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 ('1114','1113') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_textAd.status != ? ]
14:42:26,664 INFO  [ErrorDAOSpringJDBC] getGceCampaignIDs [select gceCampaignID from clients.externalCampaignParent join clients.externalCampaign on clients.externalCampaign.externalCampaignParentID=clients.externalCampaignParent.id where clients.externalCampaignParent.description IN ('1586')]
14:42:26,664 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 ('1586')]
14:42:26,665 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,665 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 ('1114','1113') and gce_campaign.status != ? and gce_adGroup.status != ? and gce_keyword.status not in (?,?,?,?) ]
14:42:26,669 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:26,669 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL from mms_common.campaigns where advertID = ?]
14:42:26,671 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:42:26,672 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:42:26,675 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 493
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getOperationErrorDetailsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><getOperationErrorDetailsResponse><operationErrorDetails><category>Keyword</category><campaignID>1586</campaignID><keywordListID>358</keywordListID><itemPath><description>a1ff3963-26da-4274-9902-0fae30c589a6_1</description><externalID>4945307208</externalID><status>Active</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_GM</description><externalID>199132990</externalID><status>Paused</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_Kansas</description><externalID>13793109430</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>CriterionError</code><trigger>badkeyword, testing in Kansas</trigger><field>operations[33].operand.criterion.text</field><reason>KEYWORD_HAS_INVALID_CHARS</reason><policyName></policyName></operationErrorCodes><itemFields><field>KeywordText</field><value>badkeyword, testing in Kansas</value></itemFields><itemFields><field>MatchType</field><value>Exact</value></itemFields><itemFields><field>IsNegative</field><value>false</value></itemFields><itemFields><field>KeywordStatus</field><value>Active</value></itemFields></operationErrorDetails><operationErrorDetails><category>Keyword</category><campaignID>1586</campaignID><keywordListID>358</keywordListID><itemPath><description>a1ff3963-26da-4274-9902-0fae30c589a6_1</description><externalID>4945307208</externalID><status>Active</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_GM</description><externalID>199132990</externalID><status>Paused</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_Kansas</description><externalID>13793109430</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>CriterionError</code><trigger>badkeyword, testing Kansas</trigger><field>operations[12].operand.criterion.text</field><reason>KEYWORD_HAS_INVALID_CHARS</reason><policyName></policyName></operationErrorCodes><itemFields><field>KeywordText</field><value>badkeyword, testing Kansas</value></itemFields><itemFields><field>MatchType</field><value>Exact</value></itemFields><itemFields><field>IsNegative</field><value>false</value></itemFields><itemFields><field>KeywordStatus</field><value>Active</value></itemFields></operationErrorDetails><operationErrorDetails><category>Keyword</category><campaignID>1586</campaignID><keywordListID>358</keywordListID><itemPath><description>a1ff3963-26da-4274-9902-0fae30c589a6_1</description><externalID>4945307208</externalID><status>Active</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_GM</description><externalID>199132990</externalID><status>Paused</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_Kansas</description><externalID>13793109430</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>CriterionError</code><trigger>Kansas badkeyword, testing</trigger><field>operations[16].operand.criterion.text</field><reason>KEYWORD_HAS_INVALID_CHARS</reason><policyName></policyName></operationErrorCodes><itemFields><field>KeywordText</field><value>Kansas badkeyword, testing</value></itemFields><itemFields><field>MatchType</field><value>Exact</value></itemFields><itemFields><field>IsNegative</field><value>false</value></itemFields><itemFields><field>KeywordStatus</field><value>Active</value></itemFields></operationErrorDetails><operationErrorDetails><category>Keyword</category><campaignID>1586</campaignID><keywordListID>358</keywordListID><itemPath><description>a1ff3963-26da-4274-9902-0fae30c589a6_1</description><externalID>4945307208</externalID><status>Active</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586_GT</description><externalID>199132870</externalID><status>Paused</status><child><description>a1ff3963-26da-4274-9902-0fae30c589a6_10997_41_1586</description><externalID>13793109310</externalID><status>Enabled</status></child></child></itemPath><operationErrorCodes><code>CriterionError</code><trigger>badkeyword, testing</trigger><field>operations[10].operand.criterion.text</field><reason>KEYWORD_HAS_INVALID_CHARS</reason><policyName></policyName></operationErrorCodes><itemFields><field>KeywordText</field><value>badkeyword, testing</value></itemFields><itemFields><field>MatchType</field><value>Exact</value></itemFields><itemFields><field>IsNegative</field><value>false</value></itemFields><itemFields><field>KeywordStatus</field><value>Active</value></itemFields></operationErrorDetails></getOperationErrorDetailsResponse></ns2:getOperationErrorDetailsResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:27,347 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 494
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], 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>a1ff3963-26da-4274-9902-0fae30c589a6</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
14:42:27,348 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,348 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
14:42:27,351 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:42:27,351 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
14:42:27,351 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
14:42:27,352 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}
14:42:27,352 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,352 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=?]
14:42:27,353 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
14:42:27,354 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
14:42:27,357 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1584: Deleted -> Deleted
14:42:27,357 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1584 -> TERMINATED
14:42:27,360 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 1586: Paused -> Paused
14:42:27,360 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 1586 -> PAUSED
14:42:27,361 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
14:42:27,361 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,361 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
14:42:27,364 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,364 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
14:42:27,366 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,366 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:42:27,368 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,368 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
14:42:27,371 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 494
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getCampaignsByCustomerIDResponse xmlns:ns2="http://thesearchagency.com/smb/core"><CampaignListResponse><customerID>a1ff3963-26da-4274-9902-0fae30c589a6</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>1584</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>49</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><localeName>en_US</localeName></campaignList><campaignList><campaignID>1586</campaignID><businessAreaID>10997</businessAreaID><keywordListID>358</keywordListID><businessLocationID>41</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus><localeName>en_US</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:27,391 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 495
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>c0299900-11ca-4001-ab2d-a61dec342288</requestID>
    </header>
    <customerID>a1ff3963-26da-4274-9902-0fae30c589a6</customerID>
    <campaignStatusList>
        <campaignID>1586</campaignID>
        <campaignStatus>active</campaignStatus>
    </campaignStatusList>
</updateCampaignStatusRequest>
</core:updateCampaignStatus></soap:Body></soap:Envelope>
--------------------------------------
14:42:27,393 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,393 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:42:27,395 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,395 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
14:42:27,397 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,397 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
14:42:27,424 WARN  [QueueUtils] Setting message priority to 4
14:42:27,438 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,442 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
14:42:27,444 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,444 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:42:27,469 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,469 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
14:42:27,471 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:27,471 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
14:42:27,472 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:27,476 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,476 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:42:27,479 INFO  [AdMaxDeploymentFauxSyncMessenger] Starting campaign status update blocking loop
14:42:27,480 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,480 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:42:27,493 WARN  [QueueUtils] Setting message priority to 9
14:42:27,500 INFO  [AdMaxDeploymentRequestMDB] Sent UPDATE request to listener. BPID: a1ff3963-26da-4274-9902-0fae30c589a6 DeployID: c0299900-11ca-4001-ab2d-a61dec342288
14:42:27,582 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:27,582 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
14:42:28,481 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:28,481 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:42:29,485 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:29,485 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:42:29,920 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
14:42:30,003 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:30,003 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campUpdateResp(deploymentID, responseMsg) values (?, ?) on duplicate key update responseMsg = ?]
14:42:30,007 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:30,008 WARN  [AdMaxDeploymentFauxSyncMessenger] Put update ok for deploy c0299900-11ca-4001-ab2d-a61dec342288
14:42:30,008 INFO  [AdMaxDeploymentResponseMDB] Handling update campaign status.
14:42:30,489 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:30,489 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
14:42:30,492 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:42:30,492 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:42:30,492 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:42:30,531 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:42:31,518 INFO  [AdMaxDeploymentFauxSyncMessenger] Exited blocking loop
14:42:31,526 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:31,526 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?]
14:42:31,529 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:31,532 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 495
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignStatusResponse xmlns:ns2="http://thesearchagency.com/smb/core"><updateCampaignStatusResponse><header><requestID>c0299900-11ca-4001-ab2d-a61dec342288</requestID></header><customerID>a1ff3963-26da-4274-9902-0fae30c589a6</customerID><campaignResult><campaignID>1586</campaignID><result><resultCode>success</resultCode><resultString>Information: [1586_GM:SUCCEEDED] [1586_GT:SUCCEEDED] </resultString></result></campaignResult></updateCampaignStatusResponse></ns2:updateCampaignStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
14:42:31,547 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 496
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>c0299900-11ca-4001-ab2d-a61dec342288</requestID>
    </header>
    <customerID>a1ff3963-26da-4274-9902-0fae30c589a6</customerID>
    <campaignBudgetAccrualStatusList>
        <campaignID>1586</campaignID>
        <campaignBudgetAccrualStatus>active</campaignBudgetAccrualStatus>
    </campaignBudgetAccrualStatusList>
</updateCampaignBudgetAccrualStatusRequest>
</core:updateCampaignBudgetAccrualStatus></soap:Body></soap:Envelope>
--------------------------------------
14:42:31,557 INFO  [AdMaxAccountDeploymentBD] validated: []
14:42:31,557 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:31,557 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
14:42:31,560 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:31,560 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
14:42:31,563 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:31,563 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
14:42:31,573 INFO  [AdMaxAccountDeploymentBD] Account: Account [theAccountID=353, theDescription=a1ff3963-26da-4274-9902-0fae30c589a6, theTier=1, thePriority=50, theReportClickOuts=0, theReportConversions=0, theConversionTypes=[], isBidManaged=1, isActive=true, thePerformanceMetric=cpa, theProvidesConversionData=true, theAddConversionDate=false, theFractionalConversionCounts=false, theHideNullSources=0, theNowTime=Fri Feb 28 14:42:31 UTC 2014, theWarehouseDB=warehouse_1, theDatabaseInstance=1, theWarehouseInstance=1, isOnline=true, currencyCode=, theSites=[Site [theSiteId=352, theAccountId=353, isDefault=true, theDescription=a1ff3963-26da-4274-9902-0fae30c589a6_Main, theInternalURLPattern=, hasIgnorePixels=false, theWaypoints=[Waypoint [theWaypointId=703, theSiteId=352, 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=704, theSiteId=352, theGroupId=0, theType=4, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Conversion, thePassParams=, theDebounceWindow=0, theLimitPerWindow=0, theLastTestedDate=null, theTestStatus=null]]]]]
14:42:31,573 INFO  [AdMaxAccountDeploymentBD] Updating CampaignID [1586] budget accrual status to [active]
14:42:31,574 DEBUG [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus
14:42:31,577 DEBUG [CampaignBudgetAccrualStatusServiceBD] CampaignBudgetAccrualStatusServiceBD.getCurrentAccrualStatus - Searching for current CampaignBudgetAccrualStatus record for CampaignId [499]
14:42:31,577 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:31,577 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL]
14:42:31,591 INFO  [CampaignBudgetAccrualStatusServiceBD] AdMaxCampaignId [499] current CampaignBudgetAccrualStatus: CampaignBugetAccrualStatus [theId=935, theCampaignId=499, theStartDate=2014-02-28, theEndDate=null, theStatus=paused]
14:42:31,592 DEBUG [JdbcTemplate] Executing prepared SQL query
14:42:31,592 DEBUG [JdbcTemplate] Executing prepared SQL statement [select accountID, currencyCode, timeZoneId from gce_googleAccount where accountID = ? ]
14:42:31,595 DEBUG [JdbcTemplate] Executing prepared SQL update
14:42:31,595 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ]
14:42:31,605 DEBUG [JdbcTemplate] SQL update affected 1 rows
14:42:31,606 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [499] updated CampaignBudgetAccrualStatus updated status
CampaignBugetAccrualStatus [theId=935, theCampaignId=499, theStartDate=2014-02-28, theEndDate=null, theStatus=active]
14:42:31,606 DEBUG [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
14:42:31,612 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 496
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignBudgetAccrualStatusResponse xmlns:ns2="http://thesearchagency.com/smb/core"><updateCampaignBudgetAccrualStatusResponse><header><requestID>c0299900-11ca-4001-ab2d-a61dec342288</requestID></header><customerID>a1ff3963-26da-4274-9902-0fae30c589a6</customerID><campaignResult><campaignID>1586</campaignID><result><resultCode>success</resultCode></result></campaignResult></updateCampaignBudgetAccrualStatusResponse></ns2:updateCampaignBudgetAccrualStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
14:43:30,529 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:43:30,532 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:43:30,532 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:43:30,548 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:44:30,547 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:44:30,550 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:44:30,550 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:44:30,563 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:45:30,563 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:45:30,563 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:45:30,564 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:45:30,578 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:46:30,576 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:46:30,577 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:46:30,577 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:46:30,590 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
14:47:30,590 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
14:47:30,590 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
14:47:30,591 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
14:47:30,603 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT