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.