Impossible to edit or delete the UC_CALENDAR_PERIOD.

Document ID : KB000087730
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
Error message: U0020286 Unknown data type 'T' for Variable object 'UC_CALENDAR_PERIOD'.

It is Impossible to edit or delete the UC_CALENDAR_PERIOD.
Cause:
Cause type:
Other
Root Cause: This could be a corrupted UC_CALENDAR_PERIOD.
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Additional Information:
Workaround :
- Execute the sql below and get the OH_Idnr. It should be 133. select * from OH where OH_Name='UC_CALENDAR_PERIOD';- Execute the sql below and check the column OVD_Type. it should be T. select * from OVD where OVD_OH_Idnr='133';- Now, to change the value of the column OVD_Type for the object UC_CALENDAR_PERIOD, you can run the sql below. It will change the type to time. update OVD set OVD_Type='TS' where OVD_OH_Idnr='133';