[MODEXPW-404] Bulk edit: jobs start_time and end_time in the database and the Export manager can be irrelevant for jobs IN_PROGRESS Created: 19/Sep/22  Updated: 05/May/23  Resolved: 05/May/23

Status: Closed
Project: mod-data-export-worker
Components: None
Affects versions: None
Fix versions: 3.1.0

Type: Bug Priority: P2
Reporter: Olga Kondratenko Assignee: Oleksandr Bozhko
Resolution: Done Votes: 0
Labels: PTF-Created, bulk-edit, bulk-edit-to-be-retested-after-arch-changes
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified
Environment:

https://ptf-rmb.int.aws.folio.org/(lcp2)


Attachments: PNG File BE_completed_Bulkoperations.png     PNG File BE_completed_worker.png     PNG File Export manager_upload.png     PNG File Logs_upload.png     PNG File chrome_pEZMQQ999s.png     PNG File image-2023-04-05-15-07-55-814.png     PNG File image-2023-04-05-15-09-00-653.png     PNG File pgAdmin4_3TyulLgVxr.png    
Issue links:
Defines
defines UXPROD-3900 Firebird - Poppy R2 2023 Enhancement... Closed
Sprint: Firebird - Sprint 164
Story Points: 2
Development Team: Firebird
Release: Poppy (R2 2023)
RCA Group: TBD

 Description   

Bulk edit: jobs start_time and end_time in the database and the Export manager can be irrelevant for jobs IN_PROGRESS.

Steps to Reproduce:

  1. Log into some FOLIO environment as a User
  2. Run bulk edit job ( example: 1000 item barcode records)
  3. Go to the Export manager or database to observe the job status. The status should be IN_PROGRESS

Expected Results:

We can observe the actual start_time displayed and null or empty field for end_time
Actual Results:

In the database, the start_time of the job is equal to the SQL query start time. On the Export manager page, start_time is equal to the last page refresh.

end_time is equal to the start_time.



 Comments   
Comment by Ann-Marie Breaux (Inactive) [ 19/Sep/22 ]

Hi Magda Zacharska There's no dev team on this bug. Should it be Firebird?

Comment by Magda Zacharska [ 25/Feb/23 ]

Yauheniya Kryshtafovich and Viachaslau Khandramai - is this still applicable after refactoring?

Comment by Viachaslau Khandramai (Inactive) [ 05/Apr/23 ]

Olga Kondratenko, is it still reproduced? I asked because we completely refactored bulk edit and move it to bulk operations.

Comment by Olga Kondratenko [ 05/Apr/23 ]

If you will run the query
select * from [tenant]_mod_bulk_operations.bulk_operation order by start_time desc limit 100

 

You will see time for all bulk edit operations to find records and update them.

In UI Export Manager we can observe only the time of the first part of the job(finding matched records).

Job type - "Bulk edit identifiers" for all of the bulk edit jobs.

Comment by Mikita Siadykh [ 28/Apr/23 ]

Magda Zacharska  Viachaslau Khandramai  I believe what Olga Kondratenko provided above is incorrect: end time in bulk operation shouldn't be equal with end time in Export manager as it is used only to generate file with records and not for whole bulk edit flow as it was before

 

Olga Kondratenko Yauheniya Kryshtafovich  please verify that Export manager job (not whole bulk operation) has right start-end values

 

cc Martin Tran 

Comment by Yauheniya Kryshtafovich [ 05/May/23 ]

Hi, Magda Zacharska and Oleksandr Bozhko verified on Snapshot env, works as expected:
1. User is on the "Bulk edit" landing page
2. Upload a .csv file with big number of users' UUIDs by dragging it on the "Drag & drop" area. And till Bulk edit job is In progress, go to the "Export manager" and pay attention to the "Start time" and "End time":

  • "Start time" is equal to the time job starts running
  • "End time" is empty till job in progress

    3. Check "Started" and "Ended" columns on the "Logs":
  • "Started" is equal to the time job starts running
  • "Ended" is empty till job in progress

    4. The "Preview of record matched" accordion shows a table populated with the records that related to the uploaded identifiers:
    From "Export manager" and "Logs" the "Start time" and "End time" are equal to the time job starts and ends running
    5. Complete Bulk edit =>
    From "Export manager":
  • "Start time" is equal to the time job starts running uploading identifiers
  • "End time" is equal to the time job ends running uploading identifiers

    From "Logs":
  • "Started" and "Ended" are equal to the time Bulk edit starts and Bulk edit ends
Generated at Thu Feb 08 22:30:47 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.