Collection type variable is not found in the active table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2025 07:48 AM
Collection type field is not there in the active table(u_site_watcher_locations) . Any suggestions ? Please find the below screen shots. The table structure It shows as an extension of the base 'cmdb' table with missing fields. my overall goal here is to safely remove this table [inactivation or deletion] as it is not used or needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2025 07:46 PM
Hi @Manjula Saravan,
Have you tried the following steps to delete your custom table?
- Navigate to All > System Definition > Tables.
- Open the table (u_site_watcher_locations) to delete.
- Select Delete All Records
- Select Delete.
- In the confirmation dialog box, enter delete and click OK.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2025 11:09 PM
@James Chun Can you please sugesst why the collection field is missing ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2025 08:50 PM
strange
I don't think it should have any impact on deletion of table
Delete all records and then delete the table safely
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2025 11:10 PM
@Ankur Bawiskar Can you please suggest me why the collection field type is missing ??