This app has been in service with no significant changes to the definition for several months.
People table is a record of employees. It is referenced to record the employee name when a row is added to the Inspections table. It is NOT referenced when a user makes a change to the Structure table.
Structures table is a record of all structures within our system. The user is to first, verify the information shown about the structure is correct prior to inspecting the condition of the structure. If any of the information shown about a structure is incorrect, the user should update the incorrect information before proceeding to the inspection.
Inspections table is a record of inspections of structures. The inspection is performed after verification of the structure information.
Within the Structure table is an Enum column type. Keep in mind, this app has been in use several months. When a user attempted to manually sync (after the app failed repeatedly to sync in the background) the user is presented with an error stating that a specific column in the Structure table, cannot be converted to type ‘Enum’.
We have recently had a change in staff. A new employee replaced a previous employee. This new employee will use the same email account/username as the previous employee. This required changing the employee name within the People table.
It turns out, the issue (cannot convert to Enum) is related to changing the employee name (not username/email) in the People table. I would not think this should have mattered because, when changing data within the Structure table, the People table is not referenced. Even if it were, the data type would be the same, Name. Of note, the employee name was changed in the back end and not through the app.
Does anyone have any insight as to why this would occur?