Unable to delete import table in servicenow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 10:39 PM
1.After deleting the imported set table, it will be recreated after a while with the same import set table created by "system."
How to delete permanent import set table ?
Can you help me in this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 10:51 PM - edited 08-02-2023 10:51 PM
Hi @Community Alums ,
Please make sure you dont have any transform map active for that table!!
And, to delete the table use CleanUp option. Follow the steps below:
- Navigate to All > System Import Sets > Import Set Tables > Cleanup.
- Move the tables you want to delete from Available tables for deletion to Delete these tables. Deleting any table deletes all records and removes the table.
- Select the Delete related transform maps check box to delete the selected import set tables and their related transform maps. All records and all associated transform maps are removed. Deselect the check box if you don't want to delete the related transform maps.
- Select the Delete data only (preserve table structure) check box to delete the data only from the selected import set tables and preserve the table structure. All records are removed, but the tables remain intact. Deselect the check box if you want to delete the selected import set tables as well as the data in those tables.
- Click Cleanup.
Thanks and Regards,
Rahul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 11:25 PM - edited 08-02-2023 11:35 PM
@Rahul Talreja I have tired my pdi it's also cleaned up the records not deleting the import set table
In my PDI, I can delete manually, but in my client instance, even if I delete manually, import set table is created after some time