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

SMB DataLoader : Duplicate Entries in table when same file is moved twice to same staging area

    Details

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

      Description

      When same file is uploaded twice then it inserts duplicate entry in the table.

      Step 1: Click Local File tab, click browse and upload a Sample_business_location.csv file.
      Step 2: Click Load button.
      Step 3: Select Staging Area say Test and Move file from local to selected staging Area.
      Step 4: Open the database and execute following queries.
      > use Test;
      > Show tables;
      > Select count from businessLocations; # Get the count of number of rows.
      > Select * from businessLocations; # Displays the records.
      Step 5: Upload same file Sample_business_location.csv.
      Step 6: Click Load button.
      Step 7: Already Staging Area is selected Test, just Move file from local to staging Area.
      Step 8: Open the database and execute following queries.
      > use Test;
      > Show tables;
      > Select count from businessLocations; # Get the count of number of rows.
      > Select * from businessLocations; # Displays the records with duplicate entries.

      Actual Result
      Inserting Duplicate entries in the table.

      Expected Result
      No Duplicate entry should happen

      Please find attached file.

        Attachments

          Activity

            People

            • Assignee:
              brian.gaffey Brian Gaffey (Inactive)
              Reporter:
              anil.kumar Anil Kumar Halmadgi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: