How to update data retention of table chat_queue_entry?

[Pablo Sanz]

We have identified that the records in the chat_queue_entry table are deleted after 3 months, I have found the following in the deleted records:

There is no record in the "Auto Flushes | sys_auto_flush" table, so you should not delete those records.

I have not found more information on how to update that time, if anyone knows where it can be updated so that instead of 3 months it is, for example, 8 months or 12 months, it would be of great help.

Thanks!

[nagydanR]

This happened to me also. I see a Table Cleaner definition for the "sys_cs_collab_chat" and this has "Cascade Delete" checked, so maybe this has cause the deletion tzunami?

[Brian O_Donnell · Accepted solution]

In the sys_auto_flush table, there is a record for live_group_profile with cascading deletes enabled. This is the record that is deleting the chat_queue_entry records. We had the same issue...