Hi Team,
Our customer had faced the issue of having too many change logs and not being able to delete them in retention policy. Therefore, they would like to know the maximum number of records that can be deleted by retention policy to avoid a recurrence of this issue. Please consider putting that information out to the official docs to avoid this issue.
Comments
This is a bug.The standard retention policy fails because no more than 10,000 records can be deleted at once when using the standard job queue. The codeunit 3997 - Retention Policy JQ expects a confirmation with a simple "yes" or "no." However, no user interaction is possible. I believe the issue can be resolved by removing the confirmation (See green) , allowing the job queue to automatically proceed with deleting the next 10,000 records.Please check the code of the codeunit:if Confirm(confirmRerunMsg, true, MaxNumberOfRecordsToDelete()) then ContinueWithRerun := true;
Category: General
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team