Do you know how long [import_log] is stored?

bonsai
Mega Sage

The [import_log] table was not defined with table rotation or [sys_auto_flush].

However, this table data appears to have been deleted.

What process caused the data to disappear?

1 ACCEPTED SOLUTION

Chaitanya ILCR
Kilo Patron

Hi @bonsai ,

OOB there is a scheduled job which deletes the import set and related data which is  older than 7 days

 

ChaitanyaILCR_0-1753927522072.png

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

View solution in original post

5 REPLIES 5

Chaitanya ILCR
Kilo Patron

Hi @bonsai ,

OOB there is a scheduled job which deletes the import set and related data which is  older than 7 days

 

ChaitanyaILCR_0-1753927522072.png

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

SANDEEP DUTTA
Tera Patron
Tera Patron

Hi @bonsai ,

import_log table doesn't have any jobs running , the "import_set_table" has the job which deletes records older than 7 days.

So can you check if you have a filter applied on the list view of the table while you were cheking , something like "Created today"? Else share a screenshot here.

 

Thanks,
Sandeep Dutta

Please mark the answer correct & Helpful, if i could help you.

Hi @bonsai ,

 

yes, Import_log is not one of the related tables which gets deleted with that scheduled job 

 

try to see there is any other source like table cleaner or any other scheduled job or a flow or archiving enabled on that table

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

Swapna Abburi
Mega Sage
Mega Sage

Hi @bonsai 

import_log is an extension of syslog table which follows table rotation and retention policies. syslog default rotation set to 7 days with 8 rotations, meaning approx. 42 days of data is present in the system and old data will be removed.

import log also follows the same policy as it is an extension of syslog table.