Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Duplicate
-
Affects Version/s: Fuji
-
Fix Version/s: Fuji
-
Component/s: None
-
Labels:None
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.