Details

    • 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:

      {content-type=[text/xml;charset=UTF-8], connection=[Keep-Alive], host=[aq-demo-jboss1:8443], Content-Length=[654], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache-HttpClient/4.1.1 (java 1.5)], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]}

      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:

      {http://schemas.xmlsoap.org/soap/envelope/}

      Server
      faultSubcode:
      faultString: [RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]
      faultActor:
      faultNode:
      faultDetail:

      {https://adwords.google.com/api/adwords/o/v201206}

      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:

      {http://schemas.xmlsoap.org/soap/envelope/}

      Server
      faultSubcode:
      faultString: [RequiredError.REQUIRED @ selector.campaignEstimateRequests[0].adGroupEstimateRequests[0].keywordEstimateR]
      faultActor:
      faultNode:
      faultDetail:

      {https://adwords.google.com/api/adwords/o/v201206}

      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>
      --------------------------------------

        Attachments

          Activity

            People

            • Assignee:
              indika Indika Rajakaruna (Inactive)
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: