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

SMB DataLoader : Staging Area Content is deleted while trying to select another 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:
    • Environment:

      Description

      While switching from one staging area to another then the tables from current staging area is deleted.

      Steps to reproduce

      Step 1: Create a Staging Area "Optus".[Staging Area smb_Optus is created]
      step 2: Create a Staging Area "Location".[Staging Area smb_Location is created]
      Step 3: Select Staging Area as Optus.
      Step 4: Upload Optusid.csv file and click move to staging Area button.[Creates table optusResellerID and populates data into it]
      Step 5: Upload Location.csv file and click move to staging Area button.[Creates table businessLocations and populates data into it]
      Step 6: Go to smb_Optus database and type command show tables; then it displays
      ----------------------------------

      Tables_in_smb_location

      -----------------------------------

      businessLocations
      optusResellerID

      -----------------------------------
      Step 7: Now Select Location Staging Area from dropdown and click Select Staging Area then it shows "Select Staging Area Failed".
      Step 8: Go to smb_Optus database and type command show tables; then it displays
      -----------------------------------

      Tables_in_smb_location

      -----------------------------------

      businessLocations

      -----------------------------------
      It deleted the optusResellerID table from the database.

      Actual Result
      Shows the following error "Select Staging Area Failed" and deleting the content from existing Staging Area.

      Expected Result
      Should switch to selected Staging Area.

        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: