Uploaded image for project: 'mod-data-export'
  1. mod-data-export
  2. MDEXP-473

CQL export fails when effective location is included in the cql statement

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • 4.2.2
    • None
    • Firebird Sprint 127
    • 2
    • Firebird
    • R3 2021 Bug Fix

    Description

      Overview:
      The export fails when triggered by CQL and the effective location is a part of the statement. If works fine if the location is not present

      Steps to Reproduce:

      #In Inventory app on the Instance tab select records based on their location and source

      1. Save cql statement by clicking in the Action menu on the *Save Instances CQL query *option
      2. Navigate to Data Export app and trigger the export using the default instance profile

      Expected Results:
      The records matching the query are exported

      Actual Results:
      Export immediately fails with the error:
      ERROR Error while reading from input file with uuids or file is empty

      Additional Information:
      If the cql statement does not contain location the export works as expected
      I was able to recreate it on the snapshot environment
      Attaching examples of queries from the kiwi bugfest environment
      URL:
      Interested parties:

      TestRail: Results

        Attachments

          1. cql-file-effective-location-which-fails.png
            cql-file-effective-location-which-fails.png
            1.02 MB
          2. DE-effective-location-id.png
            DE-effective-location-id.png
            177 kB
          3. failed_result.png
            failed_result.png
            966 kB
          4. inventory.png
            inventory.png
            1.16 MB
          5. inventory-kiwi.png
            inventory-kiwi.png
            1.61 MB
          6. job.png
            job.png
            970 kB
          7. no_matching_recods_query.cql
            0.1 kB
          8. result.png
            result.png
            946 kB
          9. result-kiwi.png
            result-kiwi.png
            1.34 MB

          Issue Links

            Activity

              People

                Charniak Siarhei Charniak
                magdaz Magda Zacharska
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases