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

load_business_locations.sql script is not running completely

    Details

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

      QA Env - SAPI 2.0.2 build 38
      UI 2.0.2 build 35
      Core 2.0.2 build 6
      BidMgr 2.0.2 build 5

    • Sprint:
      Sprint 3 - 2.0.2

      Description

      The latest load_business_locations.sql script is failing at line 63 with the following error message:

      ERROR 1062 (23000) at line 63: Duplicate entry '1' for key 'PRIMARY'

      I determined that the script is not getting beyond line 63 by modifying an entry in the budget_estimate.googleBudgetEstimateMap table, expecting it to be overwritten if the script would run past line 63 but it is failing to do so.

      This needs to be fixed in order for us to load any new locations into any test or production systems.

        Attachments

          Activity

            People

            • Assignee:
              muhammad.abbas Muhammad Abbas (Inactive)
              Reporter:
              jeff.brown Jeff Brown (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: