Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: sprint 13: 11-28-2012, Aquidneck
-
Fix Version/s: 2.0.0, sprint 14: 12-05-2012, Aquidneck
-
Component/s: Budget Estimate Service
-
Labels:None
-
Environment:
UI- http://optus.aq-demo-tomcat1:8080/reseller
jboss- aq-demo-jboss1
-
Sprint:Sprint 13, Sprint 14
Description
In the UI, you get an error 500 when you select a BA/BL combo of Property Management and the whole US.
I did the same request in soap and here is the result:
Soap request:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:core="http://thesearchagency.com/smb/core/">
<soapenv:Header/>
<soapenv:Body>
<core:getBudgetEstimatesRequest>
<!-1 or more repetitions:->
<budgetEstimateCriteriaList>
<businessAreaID>10915</businessAreaID>
<businessLocationID>1</businessLocationID>
<currencyID>1</currencyID>
<!-Optional:->
<preferSearchEngineOrigin>?</preferSearchEngineOrigin>
</budgetEstimateCriteriaList>
</core:getBudgetEstimatesRequest>
</soapenv:Body>
</soapenv:Envelope>
Response:
<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>
<businessAreaID>10915</businessAreaID>
<businessLocationID>1</businessLocationID>
<currencyID>1</currencyID>
</budgetEstimateCriteria>
</budgetEstimateResultList>
</ns2:getBudgetEstimatesResponse>
</soap:Body>
</soap:Envelope>
Jboss Log when submitting soap request:
----------------------------
ID: 1286
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml;charset=UTF-8
Headers:
Payload: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:core="http://thesearchagency.com/smb/core/">
<soapenv:Header/>
<soapenv:Body>
<core:getBudgetEstimatesRequest>
<!-1 or more repetitions:->
<budgetEstimateCriteriaList>
<businessAreaID>10915</businessAreaID>
<businessLocationID>1</businessLocationID>
<currencyID>1</currencyID>
<!-Optional:->
<preferSearchEngineOrigin>?</preferSearchEngineOrigin>
</budgetEstimateCriteriaList>
</core:getBudgetEstimatesRequest>
</soapenv:Body>
</soapenv:Envelope>
--------------------------------------
2012-11-19 15:51:46,845 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:46,845 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=?]
2012-11-19 15:51:46,850 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:46,850 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
2012-11-19 15:51:46,852 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) 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=?
2012-11-19 15:51:46,852 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:46,852 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) 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=?]
2012-11-19 15:51:46,862 DEBUG [com.thesearchagency.core.smb.service.keyword.service.impl.KeywordServiceImpl] (http-0.0.0.0-8443-1) Getting keywords for BF: 10915
2012-11-19 15:51:46,862 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:46,862 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) 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 l.businessFunctionID = ? 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,'(|[[:>:]])')) ]
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'id' to property 'ID' of type int
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'keywordListID' to property 'keywordListID' of type int
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'keyword' to property 'keyword' of type class java.lang.String
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'isMobile' to property 'isMobile' of type boolean
2012-11-19 15:51:46,868 DEBUG [org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper] (http-0.0.0.0-8443-1) Mapping column 'isNegative' to property 'isNegative' of type boolean
2012-11-19 15:51:46,872 DEBUG [com.thesearchagency.core.smb.service.keyword.service.impl.KeywordServiceImpl] (http-0.0.0.0-8443-1) 75 keywords found for BF: 10915
2012-11-19 15:51:46,872 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:46,872 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?]
2012-11-19 15:51:46,873 DEBUG [com.thesearchagency.core.smb.service.keyword.service.impl.KeywordServiceImpl] (http-0.0.0.0-8443-1) 75 keywords found for BF: 10915
2012-11-19 15:51:46,874 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) Requesting most recent demand map later than 2012-11-14 18:51:50
2012-11-19 15:51:46,874 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) Query: SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.time DESC LIMIT 1
2012-11-19 15:51:46,874 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:46,874 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL statement [SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.time DESC LIMIT 1]
2012-11-19 15:51:46,876 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) No cached demand maps found
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Getting estimates for 52/United States
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: apartment property management MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: commercial property management MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: commercial property manager MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: commercial property managers MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,881 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: home property management MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: manage properties MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: manage property MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: management for properties MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: management for property MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: management properties MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: management property MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: managing properties MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: managing property MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,882 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: properties management MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property management MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property management co MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property management companies MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property management company MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property management firms MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property management services MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property manager MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property manager companies MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property managers MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property managing MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,883 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: property managment MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: real property management MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: false
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: become MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: becoming MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: career MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: careers MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: certification MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: courses MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: degree MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: diploma MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,884 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: earnings MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: exam MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: how can MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: how do MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: how to MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: job MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: jobs MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: pay MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: salary MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: tax MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: training MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,885 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: university MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,886 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: what are MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,886 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever] (http-0.0.0.0-8443-1) Keyword: what is MatchType: phrase isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true
2012-11-19 15:51:46,886 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.searchengine.api.trafficestimator.GoogleTrafficEstimator] (http-0.0.0.0-8443-1) DEBUG: totalCampaigns = 1; totalKeywords = 49
2012-11-19 15:51:47,287 DEBUG [com.thesearchagency.core.smb.budgetestimate.impl.searchengine.api.trafficestimator.GoogleTrafficEstimator] (Thread-7332) Exception found on TrafficEstimatorThread 0
AxisFault
faultCode:
Server
faultSubcode:
faultString: [RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]
faultActor:
faultNode:
faultDetail:
ApiExceptionFault:<ns2:message>[RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]</ns2:message><ns2:ApplicationException.Type>ApiException</ns2:ApplicationException.Type><ns2:errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:RequiredError"><ns2:fieldPath>selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateRequests.keyword[0].text</ns2:fieldPath><ns2:trigger/><ns2:errorString>RequiredError.REQUIRED</ns2:errorString><ns2:ApiError.Type>RequiredError</ns2:ApiError.Type><ns2:reason>REQUIRED</ns2:reason></ns2:errors>
[RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:104)
at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:90)
at com.google.api.adwords.v201206.cm.ApiException.getDeserializer(ApiException.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154)
at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84)
at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464)
at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547)
at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.google.api.adwords.v201206.o.TrafficEstimatorServiceSoapBindingStub.get(TrafficEstimatorServiceSoapBindingStub.java:904)
at com.thesearchagency.core.smb.budgetestimate.impl.searchengine.api.trafficestimator.GoogleTrafficEstimator$TrafficEstimatorThread.run(GoogleTrafficEstimator.java:588)
2012-11-19 15:51:47,288 WARN [com.thesearchagency.core.smb.utilities.AlertUtils] (http-0.0.0.0-8443-1) sendAlert: executing command: [/home/tsaapp/send_alarm.sh, WARNING, APSD, AdMax_BudgetEstimateService: Communication - Could not retrieve budget estimates]
2012-11-19 15:51:47,290 ERROR [com.thesearchagency.core.smb.utilities.AlertUtils] (http-0.0.0.0-8443-1) sendAlert: Error executing [/home/tsaapp/send_alarm.sh, WARNING, APSD, AdMax_BudgetEstimateService: Communication - Could not retrieve budget estimates]
java.io.IOException: Cannot run program "/home/tsaapp/send_alarm.sh": java.io.IOException: error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
at com.thesearchagency.core.smb.utilities.AlertUtils.sendAlert(AlertUtils.java:57)
at com.thesearchagency.core.smb.budgetestimate.impl.searchengine.api.trafficestimator.GoogleTrafficEstimator.getTrafficEstimates(GoogleTrafficEstimator.java:353)
at com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever.retrieveEstimates(SearchEngineBudgetEstimateRetriever.java:152)
at com.thesearchagency.core.smb.budgetestimate.impl.retriever.SearchEngineBudgetEstimateRetriever.retrieveBudgetEstimates(SearchEngineBudgetEstimateRetriever.java:66)
at com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl.retrieveDemandMaps(BudgetEstimateServiceImpl.java:350)
at com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl.provideDemandMaps(BudgetEstimateServiceImpl.java:139)
at com.thesearchagency.core.smb.budgetestimate.BudgetEstimateService.getBudgetEstimates(BudgetEstimateService.java:46)
at sun.reflect.GeneratedMethodAccessor630.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
at sun.reflect.GeneratedMethodAccessor434.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1960425409.invoke(InvocationContextInterceptor_z_fillMethod_1960425409.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1960425409.invoke(InvocationContextInterceptor_z_setup_1960425409.java)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176)
at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216)
at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)
at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)
at $Proxy941.getBudgetEstimates(Unknown Source)
at com.thesearchagency.core.smb.budgetestimate.binding.BudgetEstimateWS.getBudgetEstimates(BudgetEstimateWS.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:129)
at org.jboss.wsf.stack.cxf.AbstractInvoker._invokeInternal(AbstractInvoker.java:164)
at org.jboss.wsf.stack.cxf.AbstractInvoker.invoke(AbstractInvoker.java:112)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:97)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:461)
at org.jboss.wsf.stack.cxf.ServletControllerExt.invoke(ServletControllerExt.java:172)
at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:57)
at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:162)
at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:90)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:103)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.io.IOException: java.io.IOException: error=2, No such file or directory
at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
at java.lang.ProcessImpl.start(ProcessImpl.java:65)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
... 102 more
2012-11-19 15:51:47,294 WARN [com.thesearchagency.core.smb.budgetestimate.impl.searchengine.api.trafficestimator.GoogleTrafficEstimator] (http-0.0.0.0-8443-1) Budget estimate retrieval failed:
AxisFault
faultCode:
Server
faultSubcode:
faultString: [RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]
faultActor:
faultNode:
faultDetail:
ApiExceptionFault:<ns2:message>[RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]</ns2:message><ns2:ApplicationException.Type>ApiException</ns2:ApplicationException.Type><ns2:errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:RequiredError"><ns2:fieldPath>selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateRequests.keyword[0].text</ns2:fieldPath><ns2:trigger/><ns2:errorString>RequiredError.REQUIRED</ns2:errorString><ns2:ApiError.Type>RequiredError</ns2:ApiError.Type><ns2:reason>REQUIRED</ns2:reason></ns2:errors>
[RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at java.lang.Class.newInstance0(Class.java:355)
at java.lang.Class.newInstance(Class.java:308)
at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:104)
at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:90)
at com.google.api.adwords.v201206.cm.ApiException.getDeserializer(ApiException.java:142)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154)
at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84)
at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464)
at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547)
at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157)
at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035)
at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.google.api.adwords.v201206.o.TrafficEstimatorServiceSoapBindingStub.get(TrafficEstimatorServiceSoapBindingStub.java:904)
at com.thesearchagency.core.smb.budgetestimate.impl.searchengine.api.trafficestimator.GoogleTrafficEstimator$TrafficEstimatorThread.run(GoogleTrafficEstimator.java:588)
2012-11-19 15:51:47,296 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) Requesting most recent demand map
2012-11-19 15:51:47,296 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) Query: SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.time DESC LIMIT 1
2012-11-19 15:51:47,296 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL query
2012-11-19 15:51:47,296 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-1) Executing prepared SQL statement [SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.time DESC LIMIT 1]
2012-11-19 15:51:47,298 INFO [com.thesearchagency.core.smb.dao.budgetestimate.BudgetEstimateDAO] (http-0.0.0.0-8443-1) No cached demand maps found
2012-11-19 15:51:47,299 INFO [com.thesearchagency.core.smb.budgetestimate.impl.BudgetEstimateServiceImpl] (http-0.0.0.0-8443-1) Request time: 533 millis / Google API call time: 410 millis
2012-11-19 15:51:47,322 INFO [org.apache.cxf.interceptor.LoggingInInterceptor] (http-0.0.0.0-8443-1) Outbound Message
---------------------------
ID: 1286
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><businessAreaID>10915</businessAreaID><businessLocationID>1</businessLocationID><currencyID>1</currencyID></budgetEstimateCriteria></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------