I have an issue where the Recycle Bin is not showing all records, but the "Total" still shows correct. Additionally, when deleting items from the Recycle Bin, not all the rows show up as they should (ex, expecting 500 and only showing 458, 498, or another number). As a result, the Recycle Bin has many blank pages. After 30 days, the older items do "fall off" as expected, but there are currently 11,032 items in the bin, 48 of which can be seen over 23 pages.
The background:
I'm working through an issue with a 3rd party software creating errors on the Promotion Management for backups. Due to this issue we have to clean out the Promotion Management frequently which fills up the Recycle Bin (about 20 pages of 500 records each day).
These items are deleted from Promotion Management and go to the Recycle Bin. When cleaning the Recycle Bin, there are "gaps" of multiple pages (at 50 per page) where there are not 50 on a page or are blank.
In the process of clearing the records, I discovered that the Recycle Bin pages do not populate the "Maximum number of objects per page" from the "Preferences." I have mine set to 500 per page, but any number of records show (ex, 500, 498, 458, etc). As a result, these objects are not deleted. When paging through the Recycle Bin, it's as if these items do reflect in the paging and the "Total".
Currently, there are 11,032 objects in the Recycle Bin, 23 pages (at 500 per page), and only 48 objects show on those pages (13 pages have nothing on them). Roughly 375 items are "hidden" each day of the approximately 10,000 Promotion Management objects deleted.
Using QueryBuilder (query below), I can see the individual records. I do not see any difference between a record that is visible and a record that does not display.
SELECT TOP 20000 SI_NAME, SI_CREATION_TIME
FROM CI_INFOOBJECTS
WHERE SI_KIND='recyclebin'
While these items do fall off after 30 days, it makes it difficult to identify and restore actual files that are relevant. We get a request to restore something roughly every other week. Because of this, we can't use the "Empty Recycle Bin" option to see if that clears the backlog. Even if it does clear, the "hidden" records likely will still display until our base issue is corrected.
Is there a way to ensure that the Recycle Bin displays the full 500 per page? I have tried many different approaches to deleting records, but this still continues to happen. Additionally, the page shows the same amount of records even with a refresh and logging out and navigating to the page.
Is there a way to resolve the 10,984 "missing" records?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.