Data Migration for sys_email table for HR cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2024 11:23 PM
Hi Everyone, I need to migrate the records of the sys_email table from one instance to another, but for sys_email table there is a data rotation that's active which purges the email records after a certain interval, does anyone know about any other table that stores the emails for an indefinite period?
Thanks in advance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2024 11:41 PM
If you're lucky: ar_sys_email
Check this link as well. If they aren't there, I am afraid you won't be able to get them back. I do think you need to think if it is really necessary to move this kind of old data. Anything that was ever processed, is still in the records it created/updated.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2024 11:45 PM
Hello @Simanta27 ,
You can use the "ar_sys_email" table. this table contains records from the Email [sys_email] table when they exceed the archive rule time limit. So you need to query the required records and need to restore those records and then you can use them again from sys_email table for data migration.
Check some support/community article for bulk restoration of record:
Unable to bulk re-archive restored records
We need to be able to mass restore archived records...is that possible? If so, how?
Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.
Regards,
Siddhesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2024 11:50 PM
"ar_sys_email" - No table as such present in the instance. 🙂
Can you please provide a screenshot for the same? Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2024 12:18 AM
Just search "archive" in your navigator, you should be able to see "archive email" option. Still not, then I am suspecting the Data archiving "com.glide.auxdb" plugin is not installed in your instance.
So now unfortunately, you cannot use this way, you need to check another way solving this.
You may use sys_email_log table, which may different rentetion policies than sys_email table and if you are lucky you will find the required records for migration.
Regards,
Siddhesh