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

Failed jobs listed always on top of the queue when completeDate is missing

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Done
    • None
    • 4.2.0
    • None
    • Firebird Sprint 120
    • 3
    • Firebird

    Description

      Overview:

      In some cases when the job finishes with status Failed the completedDate is not populated.  This happens when the job fails due to connectivity issue  for example and the job stays on top of the queue, and the provided Ended Running date is always set to the current date even if the export occurred in the past.   Here is the example from the bugfest environment.

      Request:
      GET https://okapi-bugfest-iris.folio.ebsco.com/data-export/job-executions?query=status=(COMPLETED OR COMPLETED_WITH_ERRORS OR FAIL) sortBy completedDate/sort.descending&limit=25
       
      Response:

      "jobExecutions" : [ {
       "id" : "c3db0f60-195e-43c1-a59e-e7020ac2b4e5",
       "hrId" : 5117,
       "exportedFiles" : [ {
       "fileId" : "79f70f01-1c85-4412-af0c-13ca309a3e8d",
       "fileName" : "invalid-uuids-5117.mrc"
       } ],
       "jobProfileId" : "6f7f3cd7-9f24-42eb-ae91-91af1cd54d0a",
       "jobProfileName" : "Default job profile",
       "progress" : {
       "exported" : 0,
       "failed" : 250,
       "total" : 269
       },
       "lastUpdatedDate" : "2021-03-31T13:04:44.716+00:00",
       "startedDate" : "2021-03-31T13:04:42.950+00:00",
       "runBy" : {
       "firstName" : "Jaime",
       "lastName" : "Taylor"
       },
       "status" : "FAIL"
       }, {
       "id" : "2f3b7cc9-7533-4348-bcc4-dab86bd8240b",
       "hrId" : 6238,
       "exportedFiles" : [ {
       "fileId" : "cf3cfc47-0a9f-4f43-951a-f8dd0e4e08f8",
       "fileName" : "quick-export-6238.mrc"
       } ],
       "jobProfileId" : "6f7f3cd7-9f24-42eb-ae91-91af1cd54d0a",
       "jobProfileName" : "Default job profile",
       "progress" : {
       "exported" : 1,
       "failed" : 0,
       "total" : 1
       },
       "completedDate" : "2021-05-17T17:19:24.902+00:00",
       "lastUpdatedDate" : "2021-05-17T17:19:22.088+00:00",
       "startedDate" : "2021-05-17T17:19:21.827+00:00",
       "runBy" : {
       "firstName" : "admin",
       "lastName" : "folio"
       },
       "status" : "COMPLETED"
       }

      Note that the record listed in the position 0 does not have completedDate.

       
      As a result the only way to delete the job seems to be by removing it directly from the database.
       
       
       

      TestRail: Results

        Attachments

          1. fail_3_2.csv
            0.1 kB
          2. run_job.PNG
            run_job.PNG
            68 kB

          Issue Links

            Activity

              People

                Harbuz Aliaksei Harbuz
                magdaz Magda Zacharska
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases