ID: 15
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[457], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>2233</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
07:32:28,168 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,168 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
07:32:28,174 INFO  [AuthChallengeProcessor] digest authentication scheme selected
07:32:28,189 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=?
07:32:28,189 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,189 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=?]
07:32:28,192 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
07:32:28,192 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,192 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
07:32:28,208 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2233
07:32:28,208 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,208 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,'(-+|[[:>:]])')) ]
07:32:28,210 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:32:28,210 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:32:28,210 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
07:32:28,210 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
07:32:28,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
07:32:28,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
07:32:28,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
07:32:28,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
07:32:28,214 DEBUG [KeywordServiceImpl] 85 keywords found for KL: 2233
07:32:28,214 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,214 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
07:32:28,215 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,215 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
07:32:28,216 DEBUG [KeywordServiceImpl] 85 keywords found for KL: 2233
07:32:28,230 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-04-21 07:31:18
07:32:28,230 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
07:32:28,230 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:28,230 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
07:32:28,232 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 9415.936/12826.986
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] #########################################################################
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 5
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 2233
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 9415.936
07:32:28,232 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 12826.986
07:32:28,232 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 1673.8384
07:32:28,232 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 2045.8026
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 12826.986
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 501.173
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
07:32:28,232 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :85
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
07:32:28,232 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 16.876
07:32:28,232 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 501.173
07:32:28,232 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
07:32:28,232 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 79.933
07:32:28,232 INFO  [BudgetEstimateServiceImpl] Request time: 65 millis
07:32:28,239 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 15
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>2233</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-04-21T07:31:21.000Z</lastUpdateTime><minimumPrice>16.876</minimumPrice><maximumPrice>501.173</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>79.933</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
07:32:29,943 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 16
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:32:29,986 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:29,987 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:32:29,989 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:32:29,989 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:32:29,989 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:32:29,990 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}
07:32:30,000 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:30,000 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:32:30,029 WARN  [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container
07:32:30,029 WARN  [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container
07:32:30,038 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:32:30,040 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:30,040 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:32:30,076 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:30,076 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:32:30,085 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:30,085 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:32:30,103 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:30,103 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 = ? ]
07:32:30,123 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 16
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:32:31,386 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 17
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[457], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>2233</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
07:32:31,390 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,391 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
07:32:31,396 INFO  [AuthChallengeProcessor] digest authentication scheme selected
07:32:31,412 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=?
07:32:31,412 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,412 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=?]
07:32:31,414 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
07:32:31,414 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,414 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
07:32:31,417 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 2233
07:32:31,417 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,417 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,'(-+|[[:>:]])')) ]
07:32:31,418 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
07:32:31,419 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
07:32:31,423 DEBUG [KeywordServiceImpl] 85 keywords found for KL: 2233
07:32:31,423 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,423 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
07:32:31,424 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,424 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
07:32:31,425 DEBUG [KeywordServiceImpl] 85 keywords found for KL: 2233
07:32:31,438 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-04-21 07:31:18
07:32:31,438 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
07:32:31,438 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:31,438 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]
07:32:31,439 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 9415.936/12826.986
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] #########################################################################
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 5
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 2233
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 9415.936
07:32:31,440 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 12826.986
07:32:31,440 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 1673.8384
07:32:31,440 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 2045.8026
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 12826.986
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 501.173
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
07:32:31,440 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :85
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
07:32:31,440 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 16.876
07:32:31,441 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 501.173
07:32:31,441 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
07:32:31,441 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 79.933
07:32:31,441 INFO  [BudgetEstimateServiceImpl] Request time: 52 millis
07:32:31,447 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 17
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>2233</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-04-21T07:31:21.000Z</lastUpdateTime><minimumPrice>16.876</minimumPrice><maximumPrice>501.173</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>79.933</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
07:32:35,172 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 18
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:32:35,173 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:35,173 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:32:35,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:32:35,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:32:35,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:32:35,177 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}
07:32:35,177 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:35,177 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:32:35,179 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:32:35,180 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:35,180 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:32:35,182 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:35,182 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:32:35,183 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:35,183 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:32:35,187 DEBUG [JdbcTemplate] Executing prepared SQL query
07:32:35,187 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 = ? ]
07:32:35,189 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 18
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:33:12,181 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:33:12,181 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:33:12,181 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:33:12,193 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:33:35,177 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 19
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:33:35,179 DEBUG [JdbcTemplate] Executing prepared SQL query
07:33:35,179 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:33:35,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:33:35,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:33:35,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:33:35,181 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}
07:33:35,181 DEBUG [JdbcTemplate] Executing prepared SQL query
07:33:35,181 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:33:35,183 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:33:35,183 DEBUG [JdbcTemplate] Executing prepared SQL query
07:33:35,183 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:33:35,186 DEBUG [JdbcTemplate] Executing prepared SQL query
07:33:35,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:33:35,187 DEBUG [JdbcTemplate] Executing prepared SQL query
07:33:35,187 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:33:35,189 DEBUG [JdbcTemplate] Executing prepared SQL query
07:33:35,189 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 = ? ]
07:33:35,191 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 19
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:34:12,192 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:34:12,193 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:34:12,193 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:34:12,205 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:34:35,175 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 20
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:34:35,177 DEBUG [JdbcTemplate] Executing prepared SQL query
07:34:35,177 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:34:35,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:34:35,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:34:35,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:34:35,179 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}
07:34:35,179 DEBUG [JdbcTemplate] Executing prepared SQL query
07:34:35,179 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:34:35,181 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:34:35,181 DEBUG [JdbcTemplate] Executing prepared SQL query
07:34:35,181 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:34:35,184 DEBUG [JdbcTemplate] Executing prepared SQL query
07:34:35,184 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:34:35,186 DEBUG [JdbcTemplate] Executing prepared SQL query
07:34:35,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:34:35,187 DEBUG [JdbcTemplate] Executing prepared SQL query
07:34:35,187 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 = ? ]
07:34:35,192 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 20
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:35:12,205 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:35:12,205 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:35:12,205 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:35:12,217 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:35:35,156 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 21
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:35:35,157 DEBUG [JdbcTemplate] Executing prepared SQL query
07:35:35,157 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:35:35,159 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:35:35,159 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:35:35,159 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:35:35,159 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}
07:35:35,159 DEBUG [JdbcTemplate] Executing prepared SQL query
07:35:35,159 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:35:35,161 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:35:35,161 DEBUG [JdbcTemplate] Executing prepared SQL query
07:35:35,161 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:35:35,164 DEBUG [JdbcTemplate] Executing prepared SQL query
07:35:35,164 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:35:35,166 DEBUG [JdbcTemplate] Executing prepared SQL query
07:35:35,166 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:35:35,169 DEBUG [JdbcTemplate] Executing prepared SQL query
07:35:35,169 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 = ? ]
07:35:35,171 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 21
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:36:12,218 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:36:12,219 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:36:12,219 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:36:12,230 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:36:35,182 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 22
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:36:35,183 DEBUG [JdbcTemplate] Executing prepared SQL query
07:36:35,184 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:36:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:36:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:36:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:36:35,186 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}
07:36:35,186 DEBUG [JdbcTemplate] Executing prepared SQL query
07:36:35,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:36:35,188 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:36:35,188 DEBUG [JdbcTemplate] Executing prepared SQL query
07:36:35,188 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:36:35,191 DEBUG [JdbcTemplate] Executing prepared SQL query
07:36:35,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:36:35,193 DEBUG [JdbcTemplate] Executing prepared SQL query
07:36:35,193 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:36:35,194 DEBUG [JdbcTemplate] Executing prepared SQL query
07:36:35,194 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 = ? ]
07:36:35,197 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 22
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:37:12,231 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:37:12,231 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:37:12,232 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:37:12,245 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:37:35,181 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 23
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:37:35,183 DEBUG [JdbcTemplate] Executing prepared SQL query
07:37:35,183 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:37:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:37:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:37:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:37:35,185 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}
07:37:35,185 DEBUG [JdbcTemplate] Executing prepared SQL query
07:37:35,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:37:35,187 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:37:35,187 DEBUG [JdbcTemplate] Executing prepared SQL query
07:37:35,187 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:37:35,190 DEBUG [JdbcTemplate] Executing prepared SQL query
07:37:35,190 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:37:35,191 DEBUG [JdbcTemplate] Executing prepared SQL query
07:37:35,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:37:35,193 DEBUG [JdbcTemplate] Executing prepared SQL query
07:37:35,193 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 = ? ]
07:37:35,195 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 23
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:38:12,245 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:38:12,246 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:38:12,246 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:38:12,268 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:38:35,181 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 24
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:38:35,182 DEBUG [JdbcTemplate] Executing prepared SQL query
07:38:35,183 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:38:35,184 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:38:35,184 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:38:35,184 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:38:35,185 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}
07:38:35,185 DEBUG [JdbcTemplate] Executing prepared SQL query
07:38:35,185 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:38:35,187 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:38:35,187 DEBUG [JdbcTemplate] Executing prepared SQL query
07:38:35,187 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:38:35,190 DEBUG [JdbcTemplate] Executing prepared SQL query
07:38:35,190 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:38:35,191 DEBUG [JdbcTemplate] Executing prepared SQL query
07:38:35,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:38:35,192 DEBUG [JdbcTemplate] Executing prepared SQL query
07:38:35,192 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 = ? ]
07:38:35,195 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 24
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:39:12,259 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:39:12,259 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:39:12,260 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:39:12,272 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:39:35,208 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 25
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:39:35,209 DEBUG [JdbcTemplate] Executing prepared SQL query
07:39:35,209 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:39:35,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:39:35,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:39:35,211 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:39:35,211 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}
07:39:35,212 DEBUG [JdbcTemplate] Executing prepared SQL query
07:39:35,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:39:35,214 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:39:35,214 DEBUG [JdbcTemplate] Executing prepared SQL query
07:39:35,214 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:39:35,217 DEBUG [JdbcTemplate] Executing prepared SQL query
07:39:35,218 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:39:35,219 DEBUG [JdbcTemplate] Executing prepared SQL query
07:39:35,219 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:39:35,220 DEBUG [JdbcTemplate] Executing prepared SQL query
07:39:35,221 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 = ? ]
07:39:35,223 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 25
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:40:12,273 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:40:12,273 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:40:12,274 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:40:12,286 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:40:35,172 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 26
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:40:35,173 DEBUG [JdbcTemplate] Executing prepared SQL query
07:40:35,173 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:40:35,175 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:40:35,175 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:40:35,175 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:40:35,175 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
07:40:35,175 DEBUG [JdbcTemplate] Executing prepared SQL query
07:40:35,175 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:40:35,178 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:40:35,178 DEBUG [JdbcTemplate] Executing prepared SQL query
07:40:35,178 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:40:35,180 DEBUG [JdbcTemplate] Executing prepared SQL query
07:40:35,181 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:40:35,182 DEBUG [JdbcTemplate] Executing prepared SQL query
07:40:35,182 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:40:35,183 DEBUG [JdbcTemplate] Executing prepared SQL query
07:40:35,183 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 = ? ]
07:40:35,186 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 26
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:41:12,285 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:41:12,286 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:41:12,286 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:41:12,297 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:41:35,159 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 27
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:41:35,161 DEBUG [JdbcTemplate] Executing prepared SQL query
07:41:35,161 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:41:35,162 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:41:35,162 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:41:35,162 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:41:35,163 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}
07:41:35,163 DEBUG [JdbcTemplate] Executing prepared SQL query
07:41:35,163 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:41:35,165 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:41:35,165 DEBUG [JdbcTemplate] Executing prepared SQL query
07:41:35,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:41:35,168 DEBUG [JdbcTemplate] Executing prepared SQL query
07:41:35,168 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:41:35,169 DEBUG [JdbcTemplate] Executing prepared SQL query
07:41:35,169 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:41:35,170 DEBUG [JdbcTemplate] Executing prepared SQL query
07:41:35,171 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 = ? ]
07:41:35,173 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 27
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:42:12,297 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:42:12,298 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:42:12,298 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:42:12,312 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:42:35,163 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 28
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:42:35,164 DEBUG [JdbcTemplate] Executing prepared SQL query
07:42:35,164 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:42:35,166 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:42:35,166 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:42:35,166 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:42:35,168 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}
07:42:35,168 DEBUG [JdbcTemplate] Executing prepared SQL query
07:42:35,168 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:42:35,171 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:42:35,171 DEBUG [JdbcTemplate] Executing prepared SQL query
07:42:35,171 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:42:35,177 DEBUG [JdbcTemplate] Executing prepared SQL query
07:42:35,177 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:42:35,179 DEBUG [JdbcTemplate] Executing prepared SQL query
07:42:35,179 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:42:35,184 DEBUG [JdbcTemplate] Executing prepared SQL query
07:42:35,184 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 = ? ]
07:42:35,186 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 28
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:43:12,312 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:43:12,312 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:43:12,312 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:43:12,324 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:43:35,188 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 29
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:43:35,190 DEBUG [JdbcTemplate] Executing prepared SQL query
07:43:35,190 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:43:35,192 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:43:35,192 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:43:35,192 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:43:35,192 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}
07:43:35,193 DEBUG [JdbcTemplate] Executing prepared SQL query
07:43:35,193 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:43:35,195 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:43:35,195 DEBUG [JdbcTemplate] Executing prepared SQL query
07:43:35,195 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:43:35,198 DEBUG [JdbcTemplate] Executing prepared SQL query
07:43:35,198 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:43:35,199 DEBUG [JdbcTemplate] Executing prepared SQL query
07:43:35,199 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:43:35,201 DEBUG [JdbcTemplate] Executing prepared SQL query
07:43:35,201 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 = ? ]
07:43:35,203 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 29
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:44:12,324 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:44:12,324 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:44:12,325 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:44:12,346 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:44:35,185 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 30
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:44:35,186 DEBUG [JdbcTemplate] Executing prepared SQL query
07:44:35,187 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:44:35,189 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:44:35,189 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:44:35,189 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:44:35,190 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}
07:44:35,190 DEBUG [JdbcTemplate] Executing prepared SQL query
07:44:35,190 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:44:35,192 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:44:35,192 DEBUG [JdbcTemplate] Executing prepared SQL query
07:44:35,192 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:44:35,195 DEBUG [JdbcTemplate] Executing prepared SQL query
07:44:35,196 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:44:35,197 DEBUG [JdbcTemplate] Executing prepared SQL query
07:44:35,197 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:44:35,199 DEBUG [JdbcTemplate] Executing prepared SQL query
07:44:35,199 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 = ? ]
07:44:35,203 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 30
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:45:12,337 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:45:12,338 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:45:12,338 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:45:12,354 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:45:35,182 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 31
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:45:35,183 DEBUG [JdbcTemplate] Executing prepared SQL query
07:45:35,183 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:45:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:45:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:45:35,185 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:45:35,186 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}
07:45:35,186 DEBUG [JdbcTemplate] Executing prepared SQL query
07:45:35,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:45:35,189 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:45:35,189 DEBUG [JdbcTemplate] Executing prepared SQL query
07:45:35,190 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:45:35,194 DEBUG [JdbcTemplate] Executing prepared SQL query
07:45:35,194 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:45:35,196 DEBUG [JdbcTemplate] Executing prepared SQL query
07:45:35,196 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:45:35,198 DEBUG [JdbcTemplate] Executing prepared SQL query
07:45:35,198 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 = ? ]
07:45:35,201 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 31
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:46:12,354 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:46:12,355 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:46:12,355 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:46:12,374 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:46:35,152 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 32
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:46:35,189 DEBUG [JdbcTemplate] Executing prepared SQL query
07:46:35,189 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:46:35,192 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:46:35,193 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:46:35,193 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:46:35,194 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}
07:46:35,194 DEBUG [JdbcTemplate] Executing prepared SQL query
07:46:35,194 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:46:35,212 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:46:35,212 DEBUG [JdbcTemplate] Executing prepared SQL query
07:46:35,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:46:35,215 DEBUG [JdbcTemplate] Executing prepared SQL query
07:46:35,215 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:46:35,217 DEBUG [JdbcTemplate] Executing prepared SQL query
07:46:35,217 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:46:35,218 DEBUG [JdbcTemplate] Executing prepared SQL query
07:46:35,218 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 = ? ]
07:46:35,227 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 32
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:47:12,375 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:47:12,375 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:47:12,376 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:47:12,386 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:47:35,177 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 33
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:47:35,179 DEBUG [JdbcTemplate] Executing prepared SQL query
07:47:35,179 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:47:35,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:47:35,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:47:35,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:47:35,181 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}
07:47:35,182 DEBUG [JdbcTemplate] Executing prepared SQL query
07:47:35,182 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:47:35,186 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:47:35,186 DEBUG [JdbcTemplate] Executing prepared SQL query
07:47:35,186 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:47:35,189 DEBUG [JdbcTemplate] Executing prepared SQL query
07:47:35,189 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:47:35,191 DEBUG [JdbcTemplate] Executing prepared SQL query
07:47:35,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:47:35,196 DEBUG [JdbcTemplate] Executing prepared SQL query
07:47:35,196 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 = ? ]
07:47:35,198 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 33
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:48:12,387 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:48:12,387 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:48:12,387 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:48:12,407 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:48:35,158 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 34
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:48:35,160 DEBUG [JdbcTemplate] Executing prepared SQL query
07:48:35,160 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:48:35,162 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:48:35,162 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:48:35,162 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:48:35,162 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}
07:48:35,162 DEBUG [JdbcTemplate] Executing prepared SQL query
07:48:35,163 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:48:35,165 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:48:35,165 DEBUG [JdbcTemplate] Executing prepared SQL query
07:48:35,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:48:35,168 DEBUG [JdbcTemplate] Executing prepared SQL query
07:48:35,168 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:48:35,169 DEBUG [JdbcTemplate] Executing prepared SQL query
07:48:35,169 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:48:35,171 DEBUG [JdbcTemplate] Executing prepared SQL query
07:48:35,171 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 = ? ]
07:48:35,173 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 34
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:49:12,402 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:49:12,402 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:49:12,403 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:49:12,415 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:49:35,166 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 35
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:49:35,167 DEBUG [JdbcTemplate] Executing prepared SQL query
07:49:35,167 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:49:35,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:49:35,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:49:35,169 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:49:35,170 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}
07:49:35,170 DEBUG [JdbcTemplate] Executing prepared SQL query
07:49:35,170 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:49:35,176 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:49:35,176 DEBUG [JdbcTemplate] Executing prepared SQL query
07:49:35,176 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:49:35,189 DEBUG [JdbcTemplate] Executing prepared SQL query
07:49:35,189 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:49:35,190 DEBUG [JdbcTemplate] Executing prepared SQL query
07:49:35,190 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:49:35,192 DEBUG [JdbcTemplate] Executing prepared SQL query
07:49:35,192 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 = ? ]
07:49:35,195 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 35
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:50:12,416 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:50:12,416 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:50:12,416 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:50:12,432 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:50:35,161 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 36
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:50:35,162 DEBUG [JdbcTemplate] Executing prepared SQL query
07:50:35,162 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:50:35,164 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:50:35,164 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:50:35,164 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:50:35,165 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}
07:50:35,165 DEBUG [JdbcTemplate] Executing prepared SQL query
07:50:35,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:50:35,167 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:50:35,167 DEBUG [JdbcTemplate] Executing prepared SQL query
07:50:35,167 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:50:35,170 DEBUG [JdbcTemplate] Executing prepared SQL query
07:50:35,170 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:50:35,172 DEBUG [JdbcTemplate] Executing prepared SQL query
07:50:35,172 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:50:35,173 DEBUG [JdbcTemplate] Executing prepared SQL query
07:50:35,173 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 = ? ]
07:50:35,176 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 36
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:51:12,427 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:51:12,428 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:51:12,428 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:51:12,441 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:51:35,167 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 37
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:51:35,169 DEBUG [JdbcTemplate] Executing prepared SQL query
07:51:35,169 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:51:35,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:51:35,171 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:51:35,171 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:51:35,171 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}
07:51:35,172 DEBUG [JdbcTemplate] Executing prepared SQL query
07:51:35,172 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:51:35,174 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:51:35,174 DEBUG [JdbcTemplate] Executing prepared SQL query
07:51:35,174 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:51:35,176 DEBUG [JdbcTemplate] Executing prepared SQL query
07:51:35,176 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:51:35,178 DEBUG [JdbcTemplate] Executing prepared SQL query
07:51:35,178 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:51:35,180 DEBUG [JdbcTemplate] Executing prepared SQL query
07:51:35,180 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 = ? ]
07:51:35,183 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 37
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:52:12,441 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:52:12,441 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:52:12,441 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:52:12,452 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:52:35,167 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 38
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:52:35,169 DEBUG [JdbcTemplate] Executing prepared SQL query
07:52:35,169 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:52:35,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:52:35,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:52:35,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:52:35,171 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}
07:52:35,171 DEBUG [JdbcTemplate] Executing prepared SQL query
07:52:35,171 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:52:35,173 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:52:35,173 DEBUG [JdbcTemplate] Executing prepared SQL query
07:52:35,173 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:52:35,178 DEBUG [JdbcTemplate] Executing prepared SQL query
07:52:35,178 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:52:35,188 DEBUG [JdbcTemplate] Executing prepared SQL query
07:52:35,188 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:52:35,190 DEBUG [JdbcTemplate] Executing prepared SQL query
07:52:35,190 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 = ? ]
07:52:35,193 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 38
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:53:12,453 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:53:12,453 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:53:12,454 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:53:12,464 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:53:35,157 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 39
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:53:35,159 DEBUG [JdbcTemplate] Executing prepared SQL query
07:53:35,159 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:53:35,164 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:53:35,164 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:53:35,164 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:53:35,165 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}
07:53:35,165 DEBUG [JdbcTemplate] Executing prepared SQL query
07:53:35,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:53:35,167 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:53:35,167 DEBUG [JdbcTemplate] Executing prepared SQL query
07:53:35,167 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:53:35,170 DEBUG [JdbcTemplate] Executing prepared SQL query
07:53:35,171 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:53:35,172 DEBUG [JdbcTemplate] Executing prepared SQL query
07:53:35,172 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:53:35,175 DEBUG [JdbcTemplate] Executing prepared SQL query
07:53:35,175 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 = ? ]
07:53:35,177 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 39
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:54:12,464 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:54:12,465 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:54:12,465 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:54:12,477 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:54:35,154 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 40
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:54:35,156 DEBUG [JdbcTemplate] Executing prepared SQL query
07:54:35,156 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:54:35,158 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:54:35,158 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:54:35,159 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:54:35,159 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}
07:54:35,159 DEBUG [JdbcTemplate] Executing prepared SQL query
07:54:35,160 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:54:35,162 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:54:35,162 DEBUG [JdbcTemplate] Executing prepared SQL query
07:54:35,162 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:54:35,165 DEBUG [JdbcTemplate] Executing prepared SQL query
07:54:35,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:54:35,167 DEBUG [JdbcTemplate] Executing prepared SQL query
07:54:35,167 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:54:35,169 DEBUG [JdbcTemplate] Executing prepared SQL query
07:54:35,169 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 = ? ]
07:54:35,173 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 40
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>c167253a-7cb0-4873-aeec-d4a748dce0ce</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------