NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
===Invalid / space coordinates(mandatory)===__NOEDITSECTION__
__FORCETOC__
{{TOC right}}
It was not possible to upgrade to V5.08.04 if there are invalid coordinates in the database. Please run this SQL [[Coordinate display rules|query]] anyhow because importing may overrun application rules. If you get any rows here, you have more SQL queries that will identify which object has the invalid coordinates in “Invalid_coordinates_ver2.doc” on PI.
===MGRS coordinates(mandatory)===__NOEDITSECTION__
In V5.xxx it was possible to enter MGRS with wrong format. The first [[MGRS coordinates|query]] checks for coordinates written with lower-case letters e.g. 4qfj12345678 and the second query checks for blanks e.g. 4 QFJ 1234 5678.
If you get length 0, 1 or 2 I recommend to look into the values of Point ID [[Point ID Length|(query)]].
===Missing approval information(mandatory)===__NOEDITSECTION__
Due to changed behaviour of migration/import scripts in version 5.08.02 and a bug in 5.08.04 approval information may be missing. Note that ''Last updated'' gets updated e.g. when templates are switched and should not be used for setting Approved Date. If the Data Entry Form that misses Approved Date is an Activity or Education then you might be able to use End date [[Missing approval information|(query)]].
|}
===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. If the Data Entry Form that misses Date of Information is an Activity or Education then you might be able to use End date.
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.
===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.
===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 number of (English) translations should be at least 1269.
===CDF display format(mandatory)===__NOEDITSECTION__
The combination of cdf_datatype in table ''customdefinedfield'' and fieldtype in table ''field'' must be correct. When data type has been changed directly in table ''customdefinedfield'' or data has been migrated these combination might be wrong.
|}
===CDF missing in table field(mandatory)===__NOEDITSECTION__
We have had a few cases where CDFs have been missing in the table ''field'' or in the table ''customdefinedfield''.
===Duplicate CDFs(mandatory)===__NOEDITSECTION__
In 5.08.04 it was allowed that CDFs had the same name if they had different data type.
Duplicates may have been by migration and import mistakes.
===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.
===Orphans in Country Structure(mandatory)===__NOEDITSECTION__
If there are orphans in the country structure there will be problems e.g. with creating a staging area database.