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

Keyword rows to add/delete displaying negative

    Details

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

      Build 383

    • Story Points:
      5
    • Sprint:
      Sprint 11

      Description

      Sometimes when loading -> staging -> attempting to push keywords it will display a negative number for rows to add and delete.
      This seems to happen for certain files when you stage a file that already has pre-existing data in the Target DB.
      Managed to reproduce this error by pushing files to Target DB and then re-staging the same files later

      Files that cause this are displayed in Target as having -1 additions, 1 change, -1 deletions (with no changes made)
      Adding rows increase the add count from -1, deleting rows increases delete count from -1.
      Making a change (ex. change subgroup ID from 0 to 1) in one row seems to change add to -3, change to 4, delete to -3 for some reason.

      Doesn't seem to have many setbacks aside from confusing numbers (only tested using unmodified files but it could throw off the displayed amount by quite a bit). The "Move to Target DB" and "Push" buttons are enabled and can be used. Clicking "Push" pushes all data in the Staging Area to the Target DB, but if there is no new data then nothing is changed.

      Some EN keywords that cause this:
      keywords-banks-10111 (-1 add, 1 change, -1 delete)
      keywords-cell_phones-10289 (-4 add, 4 change, -4 delete)
      keywords-car_service-11125 (-2 add, 2 change, -2 delete)

      My guess is that the case where no modifications to the file are made, add and delete are 0 and change is returning a positive non-zero number for some reason.

      Full list of keyword files that cause this (so far) in file Negative keywords.txt

      Doesn't seem to happen with Ads. If it does happen with ads, it is not reproduced using the same steps as keywords.

        Attachments

          Activity

            People

            • Assignee:
              dylan.kirby Dylan Kirby (Inactive)
              Reporter:
              endy.nicol Endy Nicol (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: