[TSAApp@aml-qa7-core1 ~]$ tail -f /home/TSAApp/apps/jboss-5.1.0.GA/tsa_messaging_node_server.log
ID: 2601
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>874dc94b-1536-46b7-aa32-2401a8e9ad3f</customerID><domain>admaxlocal.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>2392</campaignID><businessAreaID>162636</businessAreaID><keywordListID>5552</keywordListID><businessLocationID>401012</businessLocationID><customLandingPage><destinationURL>http://admaxlocal.com</destinationURL><displayURL>admaxlocal.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>YahooJapan</distribution><localeName>ja_JP</localeName></campaignList><campaignList><campaignID>2395</campaignID><businessAreaID>162638</businessAreaID><keywordListID>5651</keywordListID><businessLocationID>401011</businessLocationID><customLandingPage><destinationURL>http://admaxlocal.com</destinationURL><displayURL>admaxlocal.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>YahooJapan</distribution><localeName>ja_JP</localeName></campaignList><campaignList><campaignID>2397</campaignID><businessAreaID>162547</businessAreaID><keywordListID>0</keywordListID><businessLocationID>401013</businessLocationID><deploymentStatus>Failure</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><distribution>YahooJapan</distribution><localeName>ja_JP</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:02:09,598 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:02:09,601 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:02:09,601 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:02:09,616 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:03:06,308 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2602
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=[462], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>YahooJapan</distribution><keywordListID>5382</keywordListID><businessLocationID>401014</businessLocationID><currencyCode>JPY</currencyCode><languageCode>ja</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
07:03:06,332 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:06,332 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=?]
07:03:06,340 INFO  [AuthChallengeProcessor] digest authentication scheme selected
07:03:06,360 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:06,362 INFO  [BudgetEstimateDAO] Query: SELECT yjlt.id, yjlt.description, yjlt.type, yjlt.code, yjbem.budgetEstimateMultiplier FROM mms_common.yahooJLocationTargets yjlt JOIN yahooJBudgetEstimateMap yjbem on yjbem.yahooJLocationTargetID = yjlt.id WHERE yjbem.businessLocationID=?
07:03:06,363 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:06,363 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT yjlt.id, yjlt.description, yjlt.type, yjlt.code, yjbem.budgetEstimateMultiplier FROM mms_common.yahooJLocationTargets yjlt JOIN yahooJBudgetEstimateMap yjbem on yjbem.yahooJLocationTargetID = yjlt.id WHERE yjbem.businessLocationID=?]
07:03:06,371 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 5382
07:03:06,371 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:06,371 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:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
07:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
07:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
07:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
07:03:06,389 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
07:03:06,390 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
07:03:06,395 DEBUG [KeywordServiceImpl] 50 keywords found for KL: 5382
07:03:06,395 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:06,395 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
07:03:06,397 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:06,397 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
07:03:06,399 DEBUG [KeywordServiceImpl] 50 keywords found for KL: 5382
07:03:06,422 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:06,424 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-10-31 02:50:00
07:03:06,425 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
07:03:06,425 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:06,425 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
07:03:06,428 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 0.0/32930.17
07:03:06,428 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 0.0
07:03:06,428 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 32930.17
07:03:06,428 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 32930.17
07:03:06,428 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 1002290.7
07:03:06,428 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
07:03:06,428 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 20
07:03:06,428 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2331.615
07:03:06,428 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 1002290.7
07:03:06,428 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
07:03:06,428 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1289.609
07:03:06,428 INFO  [BudgetEstimateServiceImpl] Request time: 116 millis
07:03:06,461 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2602
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>YahooJapan</distribution><keywordListID>5382</keywordListID><businessLocationID>401014</businessLocationID><currencyCode>JPY</currencyCode><languageCode>ja</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-05-12T10:37:18.000Z</lastUpdateTime><minimumPrice>2331.615</minimumPrice><maximumPrice>1002290.7</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>1289.609</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
07:03:08,880 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2603
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>874dc94b-1536-46b7-aa32-2401a8e9ad3f</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
07:03:08,883 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:08,883 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:03:08,886 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:03:08,886 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:03:08,886 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:03:08,887 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
07:03:08,887 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:08,887 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:03:08,889 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:03:08,889 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:03:08,889 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:03:08,890 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:03:08,895 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 2392: Deleted -> Deleted
07:03:08,895 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 2392 -> TERMINATED
07:03:08,898 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 2395: Deleted -> Deleted
07:03:08,898 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 2395 -> TERMINATED
07:03:08,901 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 2397 -> null
07:03:08,902 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:03:08,902 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:08,902 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:03:08,908 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:08,908 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:03:08,911 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:08,911 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:03:08,914 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:08,914 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:03:08,918 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2603
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>874dc94b-1536-46b7-aa32-2401a8e9ad3f</customerID><domain>admaxlocal.com</domain><deploymentStatus>failure</deploymentStatus><campaignList><campaignID>2392</campaignID><businessAreaID>162636</businessAreaID><keywordListID>5552</keywordListID><businessLocationID>401012</businessLocationID><customLandingPage><destinationURL>http://admaxlocal.com</destinationURL><displayURL>admaxlocal.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>YahooJapan</distribution><localeName>ja_JP</localeName></campaignList><campaignList><campaignID>2395</campaignID><businessAreaID>162638</businessAreaID><keywordListID>5651</keywordListID><businessLocationID>401011</businessLocationID><customLandingPage><destinationURL>http://admaxlocal.com</destinationURL><displayURL>admaxlocal.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>YahooJapan</distribution><localeName>ja_JP</localeName></campaignList><campaignList><campaignID>2397</campaignID><businessAreaID>162547</businessAreaID><keywordListID>0</keywordListID><businessLocationID>401013</businessLocationID><deploymentStatus>Failure</deploymentStatus><campaignStatus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/><distribution>YahooJapan</distribution><localeName>ja_JP</localeName></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
07:03:09,616 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:03:09,618 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:03:09,618 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:03:09,652 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:03:13,591 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2604
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=[462], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>YahooJapan</distribution><keywordListID>5382</keywordListID><businessLocationID>401014</businessLocationID><currencyCode>JPY</currencyCode><languageCode>ja</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
07:03:13,597 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:13,597 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=?]
07:03:13,604 INFO  [AuthChallengeProcessor] digest authentication scheme selected
07:03:13,627 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:13,630 INFO  [BudgetEstimateDAO] Query: SELECT yjlt.id, yjlt.description, yjlt.type, yjlt.code, yjbem.budgetEstimateMultiplier FROM mms_common.yahooJLocationTargets yjlt JOIN yahooJBudgetEstimateMap yjbem on yjbem.yahooJLocationTargetID = yjlt.id WHERE yjbem.businessLocationID=?
07:03:13,630 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:13,631 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT yjlt.id, yjlt.description, yjlt.type, yjlt.code, yjbem.budgetEstimateMultiplier FROM mms_common.yahooJLocationTargets yjlt JOIN yahooJBudgetEstimateMap yjbem on yjbem.yahooJLocationTargetID = yjlt.id WHERE yjbem.businessLocationID=?]
07:03:13,637 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 5382
07:03:13,637 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:13,638 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:03:13,640 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:03:13,640 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:03:13,640 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
07:03:13,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
07:03:13,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
07:03:13,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
07:03:13,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
07:03:13,641 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
07:03:13,647 DEBUG [KeywordServiceImpl] 50 keywords found for KL: 5382
07:03:13,647 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:13,647 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
07:03:13,648 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:13,649 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
07:03:13,650 DEBUG [KeywordServiceImpl] 50 keywords found for KL: 5382
07:03:13,668 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:13,670 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-10-31 02:50:00
07:03:13,671 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
07:03:13,671 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:13,671 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
07:03:13,673 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 0.0/32930.17
07:03:13,673 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 0.0
07:03:13,674 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 32930.17
07:03:13,674 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 32930.17
07:03:13,674 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 1002290.7
07:03:13,674 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
07:03:13,674 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 20
07:03:13,674 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2331.615
07:03:13,674 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 1002290.7
07:03:13,674 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
07:03:13,674 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1289.609
07:03:13,674 INFO  [BudgetEstimateServiceImpl] Request time: 79 millis
07:03:13,738 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2604
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>YahooJapan</distribution><keywordListID>5382</keywordListID><businessLocationID>401014</businessLocationID><currencyCode>JPY</currencyCode><languageCode>ja</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2016-05-12T10:37:18.000Z</lastUpdateTime><minimumPrice>2331.615</minimumPrice><maximumPrice>1002290.7</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>1289.609</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
07:03:41,280 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2605
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=[462], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 3.0.7], 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>YahooJapan</distribution><keywordListID>6422</keywordListID><businessLocationID>401014</businessLocationID><currencyCode>JPY</currencyCode><languageCode>ja</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
07:03:41,284 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:41,284 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=?]
07:03:41,292 INFO  [AuthChallengeProcessor] digest authentication scheme selected
07:03:41,312 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:41,315 INFO  [BudgetEstimateDAO] Query: SELECT yjlt.id, yjlt.description, yjlt.type, yjlt.code, yjbem.budgetEstimateMultiplier FROM mms_common.yahooJLocationTargets yjlt JOIN yahooJBudgetEstimateMap yjbem on yjbem.yahooJLocationTargetID = yjlt.id WHERE yjbem.businessLocationID=?
07:03:41,315 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:41,315 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT yjlt.id, yjlt.description, yjlt.type, yjlt.code, yjbem.budgetEstimateMultiplier FROM mms_common.yahooJLocationTargets yjlt JOIN yahooJBudgetEstimateMap yjbem on yjbem.yahooJLocationTargetID = yjlt.id WHERE yjbem.businessLocationID=?]
07:03:41,322 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 6422
07:03:41,323 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:41,323 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:03:41,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:03:41,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:03:41,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
07:03:41,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
07:03:41,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
07:03:41,340 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
07:03:41,340 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
07:03:41,340 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
07:03:41,345 DEBUG [KeywordServiceImpl] 51 keywords found for KL: 6422
07:03:41,345 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:41,345 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
07:03:41,347 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:41,347 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
07:03:41,349 DEBUG [KeywordServiceImpl] 51 keywords found for KL: 6422
07:03:41,367 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:41,369 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-05-17 06:59:33
07:03:41,369 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
07:03:41,369 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:41,370 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
07:03:41,372 INFO  [BudgetEstimateDAO] No cached budget estimates found
07:03:41,375 INFO  [AuthChallengeProcessor] digest authentication scheme selected
07:03:41,389 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:41,400 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:41,408 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:41,426 WARN  [HttpMethodBase] Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.
07:03:41,428 DEBUG [SearchEngineBudgetEstimateRetriever] Getting estimates for 1/??
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ▒o???????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: false isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ???? ????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ???? ????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ????????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ????????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ???? ????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ???? ????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ??????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,429 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ??????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?????????? MatchType: exact isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ???? ????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ???? ????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ???? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? ???? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ??? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ????? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,430 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ???? ????? MatchType: exact isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? ???? ????? MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ??? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,431 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ???? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ??? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,432 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,433 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,433 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,433 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,433 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,433 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: ?? MatchType: phrase isGeoModifiable: false isGeoModified: true isGeoTarget: true isMobile: true isNegative: true
07:03:41,433 DEBUG [YahooJTrafficEstimator] BES - YahooJTrafficEstimator ready to make call 1 to Y!J SS Keyword Estimator Service
07:03:42,805 ERROR [YahooJTrafficEstimator] BES - YahooJTrafficEstimator error(s) returned: [Ljp.yahooapis.ss.V5.Error;@61d695f1
07:03:42,805 DEBUG [YahooJTrafficEstimator] No traffic estimates were found.
07:03:42,805 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate
07:03:42,805 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
07:03:42,805 DEBUG [JdbcTemplate] Executing prepared SQL query
07:03:42,805 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM yahooJBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.yahooJLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? ORDER BY gbe.keywordListID, gbe.yahooJLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
07:03:42,808 INFO  [BudgetEstimateDAO] No cached budget estimates found
07:03:42,808 INFO  [BudgetEstimateServiceImpl] Request time: 1526 millis / SE API calls time: 1372 millis
07:03:42,959 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2605
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>failure</resultCode></result><budgetEstimateCriteria><distribution>YahooJapan</distribution><keywordListID>6422</keywordListID><businessLocationID>401014</businessLocationID><currencyCode>JPY</currencyCode><languageCode>ja</languageCode></budgetEstimateCriteria></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------