Scheduled Import Records Automatically Deleting After 7 Days

rajibosss11
Tera Contributor

I have an Inbound Email Action that is used to insert new records into the u_test_data table. The records are inserted successfully, but they are getting automatically deleted after 7 days.

There are no Delete Business Rules, Script Includes, UI Actions, or Scheduled Jobs configured.

The Email Action script also does not contain any deletion logic.

How can I prevent these records from being deleted from this table?

6 REPLIES 6

JenniferRah
Mega Sage

Does that table extend sys_import_set_row? If so, tables extending sys_import_set_row are not meant for long term storage. There is a scheduled job that periodically cleans this table. To get around this, you will have to create a new table to use that does not extend the sys_import_set_row table.

Yes @JenniferRah, the table currently extends from the import set row table. So we need to replace it with a new table that does not extend from it, correct?"

Yes, unfortunately, you can't change the table it is extended from once it's created, so you have to re-create it from scratch. I had to do this with a couple that I created, too. Once I did that, though, the problem was resolved.

@JenniferRah  i tried to create new table but i am not able to use that table to import set source table .can you give info