Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-3199

BES is not triggered after adding keyword and invoke validateUpdatedKeywordLists through JMX

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: Fuji
    • Fix Version/s: Fuji
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      In Google environment, BES is not triggered when we invoke the validateUpdatedKeywordLists Mbean, its says " BES: No keywords available".

      Steps to reproduce
      1. Add the new keyword to the csv.
      2. From the JMX console invoke importKeywords Mbean and keyword imported successfully.
      3. From the JMX console invoke validateUpdatedKeywordLists

      Expected Result: BES should be triggered for newly added keyword.

      Actual Result: BES is not triggered its says " BES: No keywords available" Error and Mbean return false.

      Snippet of the log
      14:33:29,657 INFO [KeywordAdminServiceImpl] Number of Business Functions with updated keywordLists: 3
      14:33:29,657 INFO [KeywordAdminServiceImpl] Business Functions with updated keywordLists: 11432 11947 11187
      14:33:29,658 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,658 DEBUG [JdbcTemplate] 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 business
      LocationTypes blt on blt.id = bl.businessLocationTypeID where bl.status=? limit ?]
      14:33:29,661 INFO [KeywordAdminServiceImpl] Validating updated keyword lists by running Budget Estimate requests for location(s): Location: ID: 1 Description: United States Short Description: United States Status: active Type: Country ParentBusinessLocationID: 0 Use SE Defined Targets: true Use Point Radius Targets: false Is Sellable: true
      14:33:29,685 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,685 DEBUG [JdbcTemplate] 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=?]
      14:33:29,687 INFO [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
      14:33:29,687 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,687 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
      14:33:29,693 ERROR [BudgetEstimateServiceImpl] BES: No keywords available.
      14:33:29,695 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,695 DEBUG [JdbcTemplate] 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=?]
      14:33:29,696 INFO [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
      14:33:29,696 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,696 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
      14:33:29,700 ERROR [BudgetEstimateServiceImpl] BES: No keywords available.
      14:33:29,702 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,702 DEBUG [JdbcTemplate] 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=?]
      14:33:29,704 INFO [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
      14:33:29,704 DEBUG [JdbcTemplate] Executing prepared SQL query
      14:33:29,704 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
      14:33:29,707 ERROR [BudgetEstimateServiceImpl] BES: No keywords available.
      14:33:29,708 INFO [BudgetEstimateServiceImpl] Request time: 46 millis
      14:33:29,708 ERROR [KeywordAdminServiceImpl] 0 out of 3 Budget Estimates ok.
      14:33:29,708 ERROR [KeywordAdminService] Updated keyword list validation failed.

        Attachments

          Activity

            People

            • Assignee:
              jeff.brown Jeff Brown (Inactive)
              Reporter:
              sharath.tn Sharath TN (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: