It has been observed that when the OpenSpecimen database is upgraded to versions v6.2 or higher, both the API and UI display blank values for some fields of the collection and received events. This issue is observed largely on legacy databases (i.e. databases upgraded from caTissue or OpenSpecimen v1.1) using Oracle. These databases have managedTables=false for the system events like collection event, received event, disposal event, and transfer event. When managedTables=false, it means the table schema will be managed by the DE/custom forms library. As a result, when we changed the field types of collection container/procedure to the PV driven fancy controls, DE added new table columns to capture the data of these fields. This is wrong.
For all system events, the corresponding form metadata should have managedForms = true. This will let DE know that the table schema will be managed by the host application (OpenSpecimen). DE will be responsible for storing and retrieving data from these tables.
To fix the problem, follow the below steps:
...