NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
|}
===Missing Date of Information (mandatory)===__NOEDITSECTION__
Date of Information (stored in table ''fieldreport'') is used when {{IMSMANG}} calculates the Summary (former Current view). If this data is missing then the result may not be as the expected when the Summary is updated. Note that ''Last updated'' gets updated e.g. when templates are switched and should not be used for setting Date of Information [[Missing Date of Information|(query)]].
===Missing Local ID (mandatory)===__NOEDITSECTION__
In some database also Form ID and the items' local ID have been missing. The [[Missing Local ID|queries]] do not include Country structure, Organisation, Place, Task and WorkItem.
Some countries have many published templates that have never been used which makes it difficult to know which template to update etc. It is also good to know which templates that have been used for data entry in case you need to update or switch them [[SQL Templates|(queries)]].
===DIM categories (mandatory)===__NOEDITSECTION__
If categories have been deleted there will be errors when the upgrade script is applied. As a quick indication if there will be errors, numbers of categories may be used. There should be at least 52 categories.
|}
===Number of enumeration categories and values (mandatory)===__NOEDITSECTION__
If the country has deleted standard enums from the table ''imsmaenum'' then upgrade scripts will not give the expected result which will create a lot of problems. As a quick indication if there will be errors, numbers of categories and values may be used. There should be at least 117 categories and 978 values in the result set of these [[Enum categories and values|queries]].
===Number of translations (mandatory)===__NOEDITSECTION__
If the country has deleted standard translations from the table ''translation'' then upgrade scripts will not give the expected result which will create a lot of problems. The result of this [[Translations|query]] should be at least 1269 (English) translations.
===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 created unnecessary many rows in the table ''cdfvalue'' and makes it impossible to delete CDFs that actually never have been used for data entry[[Empty CDF|(query)]].
===Duplicated values in allow_value_set(mandatory)===__NOEDITSECTION__Duplicates may have been by migration and import mistakes[[Duplicate allow value|(query)]].
===Invalid date in link table (mandatory)===__NOEDITSECTION__
The date value 0000-00-00 00:00:00 is invalid and has been found in the table link.
===Attachment table (mandatory)===__NOEDITSECTION__
One country had changed the name of the column ''Filedescription''. Note it has to be capital F.