- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2019 07:26 AM
Hello,
I have a table that has around 38 custom fields. I can open it just fine using mytablename.list, I can also click the gear in the top left (edit personalied list) and find all my custom fields there. I can add the columns and create records using them. The problem is whenever I go to 'sys_db_object', I find the table, but there is nothing underneath Table columns. it is completely empty. It was not like this before. all the fields were visible. I have Admin rights btw. Can anyone help me with this weird problem? why are the fields missing 'sys_db_object'?
The reason I am asking this because it is creating a problem where I can't select this table as 'target table' when I create a transform map because servicenow thinks that there are no columns in the table.
Thank you.
Solved! Go to Solution.
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2019 07:46 AM
Can you check in the sys_metadata_delete table to see if those entries exist in this table? If yes please restore them.
The columns entries are actually missing in the table. Maybe someone deleted them or you could raise a HI ticket for further investigation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2019 07:31 AM
Hi,
When you navigate to sys_dictionary table, are you able to locate any columns for your table in it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2019 07:40 AM
No I can't find any one of them.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2019 07:46 AM
Can you check in the sys_metadata_delete table to see if those entries exist in this table? If yes please restore them.
The columns entries are actually missing in the table. Maybe someone deleted them or you could raise a HI ticket for further investigation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2019 07:52 AM
I see this is related to the same issue on your other post. Try restoring those entries as mentioned and it should fix them