Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-1925

Yell Budgeting Tool: Database Primary Key conflicts

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Yell Budgeting Tool
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      3489

      Description

      Due to the synchronizer currently re-generating the hierarchy with each run, the
      internally-generated primary keys for the Yell tables will keep increasing, and
      at some point reach a maximum value. Simply resetting the keys will not fix
      this, as existing rows will cause duplicate exceptions.

      The correct fix is to change the synchronizer to not delete/re-generate rows,
      but only create new BT/BF/TL objects if necessary. The mapping table used to
      map parents/child relationships can still be cleared; it is completely wiped,
      and thus resetting the primary key index value to one will not have an adverse
      effect.

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Crane (Inactive)
              Reporter:
              patrick Patrick Crane (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: