Missing out-of-the-box fields (sys_created, sys_created_on...) on table

peter_repan · ‎11-10-2015

Hi all,

we are facing curious issue: for some reason we are missing out of the box fields like sys_created, sys_created_by, sys_updated, sys_updated_by (+ other "sys_"... fields) on table alm_hardware.

Don't know where they gone. On wiki is "Base system fields cannot be deleted. Additionally, any missing base system fields are recreated when the instance is upgraded."

My question is - does anyone idea what could happened or how to fix it (without waiting for a upgrade)?

Thank you

Vladimir Kobeti · ‎11-11-2015

I guess the issue was with Read ACLs alm_asset.* of the parent table. They forbid the admin to read the parent table, so that the record on child table could be read only partially.

View solution in original post

Community Alums · ‎11-10-2015

They are pretty well protected and are inherited. What makes you think they are missing instead of just not being visible?

peter_repan · ‎11-10-2015

They are not visible with "Show XML" action and also I cannot see them in table (Personalize table) or as dictionary records on that table.

Mike Allen · ‎11-10-2015

alm_hardware extends alm_asset. These fields come from that table.

peter_repan · ‎11-10-2015

But I assume every table should have this sys_ fields, no matter if table is extended or not.