NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
===Records with empty values in table cdfvalue===__NOEDITSECTION__
The next level of check is to check if the value ‘ ‘ have been stored AND if all different data types are NULL. An old bug created empty strings for specially Auxiliary data CDFs. This bug creates created unnecessary many rows in the table ''cdfvalue'' and makes it impossible to delete CDFs that actually never have been used for data entry.
===Duplicated values in allow_value_set===__NOEDITSECTION__
Duplicates may have been by migration and import mistakes.
===Number of translationsInvalid date in link table===__NOEDITSECTION__The date value 0000-00-00 00:00:00 is invalid and has been found in the table link.
===Number of translationsAttachment table===__NOEDITSECTION__One country had changed the name of the column ''Filedescription''. Note it has to be capital F.
===Number of translationsOrphans in Country Structure===__NOEDITSECTION__ ===Number of translations===__NOEDITSECTION__If there are orphans in the country structure there will be problems e.g. with creating a staging area database.
===Duplicates in the Country Structure===__NOEDITSECTION__
Having duplicates on name (on the same level/node) in the country structure e.g. two villages called “Berg” in the one municipality creates a lot of problems when importing data and statistics. Note that the duplicates are not shown in the GUI.
[[Category:NoPublic]]
