- In the Inventory app, go to Item and search for all items with Item Status = Checked out. There are at least 1000 records.
- Go to the database and execute the following count statements:
select count from fs09000000_mod_inventory_storage.item;
select count from fs09000000_mod_inventory_storage.item where jsonb->'status'->>'name' = 'Available';
If nothing has changed in the DB the results for these should be the same, 8,933,578 records. This means that all records have status "Available", which is not the same as what the UI shows, and found.
- You can also look up a checked-out record found in the Inventory page in the database. The record in the database shows "Available". Again, this is a mismatch, inconsistent with what is seen on the UI.
Investigate why this problem happening. Is it because of the PTF environment or because of a bug somewhere in the system?