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

[peter_repan]

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

[nehruvj]

Please refer the SQL query where all the date time related sys fields are missing. this is due to the change in the date time / locale system property.

When I change the property, I lost all the date time related system fields.

That is the reason I provided the extract from the incident which may help you.

[peter_repan]

Hmm interesting, but in my case I miss not only datetime fields, but also fields like sys_class_name, sys_mod_count, sys_created an so on.

Was this also your case?

[nehruvj]

No, for me only the date time fields which were missing across the instance.

Please let me know if this is your PROD instance, else you can export the XML of table (from the tables view) from your DEV/TEST instance and import into the current instance. which will fix the issue.

[nehruvj]

Try with this xml which may help you.