9:41:36,740 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 58
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>246</keywordListID><businessLocationID>3</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
09:41:36,744 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
09:41:36,747 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
09:41:36,747 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,747 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
09:41:36,755 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 59
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[452], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>246</keywordListID><businessLocationID>3</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
09:41:36,756 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 246
09:41:36,757 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,757 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
09:41:36,759 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,760 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:41:36,762 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:41:36,765 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
09:41:36,765 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,765 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
09:41:36,777 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 246
09:41:36,777 DEBUG [KeywordServiceImpl] 73 keywords found for KL: 246
09:41:36,777 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,777 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ]
09:41:36,782 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,782 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:41:36,784 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,784 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:41:36,784 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
09:41:36,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
09:41:36,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
09:41:36,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
09:41:36,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
09:41:36,785 DEBUG [KeywordServiceImpl] 73 keywords found for KL: 246
09:41:36,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
09:41:36,785 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
09:41:36,786 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
09:41:36,786 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2015-11-06 08:01:51
09:41:36,786 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
09:41:36,786 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,786 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
09:41:36,790 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 0.2573958/0.34955
09:41:36,790 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 0.2573958
09:41:36,790 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 0.34955
09:41:36,790 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 0.34955
09:41:36,790 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 10.639
09:41:36,790 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
09:41:36,790 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 31
09:41:36,791 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
09:41:36,791 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.834
09:41:36,791 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 10.639
09:41:36,791 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 0.773
09:41:36,791 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 0.945
09:41:36,791 INFO  [BudgetEstimateServiceImpl] Request time: 49 millis
09:41:36,796 DEBUG [KeywordServiceImpl] 73 keywords found for KL: 246
09:41:36,796 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,797 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
09:41:36,798 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,798 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
09:41:36,800 DEBUG [KeywordServiceImpl] 73 keywords found for KL: 246
09:41:36,800 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2015-11-06 08:01:51
09:41:36,800 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
09:41:36,800 DEBUG [JdbcTemplate] Executing prepared SQL query
09:41:36,800 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
09:41:36,803 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 0.2573958/0.34955
09:41:36,803 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 0.2573958
09:41:36,803 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 0.34955
09:41:36,803 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 0.34955
09:41:36,803 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 10.639
09:41:36,803 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
09:41:36,803 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 31
09:41:36,803 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
09:41:36,803 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 7.834
09:41:36,804 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 10.639
09:41:36,804 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 0.773
09:41:36,804 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 0.945
09:41:36,804 INFO  [BudgetEstimateServiceImpl] Request time: 47 millis
09:41:36,911 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 59
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>246</keywordListID><businessLocationID>3</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-11-30T07:40:01.000Z</lastUpdateTime><minimumPrice>7.834</minimumPrice><maximumPrice>10.639</maximumPrice><minimumClicks>0.773</minimumClicks><maximumClicks>0.945</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
09:41:36,913 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 58
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>246</keywordListID><businessLocationID>3</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2015-11-30T07:40:01.000Z</lastUpdateTime><minimumPrice>7.834</minimumPrice><maximumPrice>10.639</maximumPrice><minimumClicks>0.773</minimumClicks><maximumClicks>0.945</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------


09:41:47,048 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
09:41:47,048 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
09:41:47,049 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
09:41:47,061 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT