why are this table's columns missing in 'sys_db_object' table?

phantom7
Giga Expert

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.

1 ACCEPTED SOLUTION

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.

View solution in original post

4 REPLIES 4

Alikutty A
Tera Sage

Hi,

When you navigate to sys_dictionary table, are you able to locate any columns for your table in it?

No I can't find any one of them.

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.

I see this is related to the same issue on your other post. Try restoring those entries as mentioned and it should fix them