NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
===Check if there are Dection / Sample / Sector / Vegetation removal tables (mandatory)===__NOEDITSECTION__
The upgrade scripts do not handle these tables well. This [[Check Detection Sample Sector VegetationRemoval | query]] checks if there are any records in the four tables. If there are records, export them to Excel.
===Delete Data quality queries?===__NOEDITSECTION__
If the country has added the SQL Saved searches developed by GICHD to the database you should '''delete''' them since:
* they are with MySQL syntax and will not work after upgrade
* confusing for the countries with both MySQL and PostgreSQL Saved searches
* the upgrade script will throw errors if MySQL and PostgreSQL Saved searches have the same names e.g. ''Accident Duplicate ID''.
If the country has reported that they have Saved searches that [[Delete Non-functional Saved Search | does not work]] and/or Saved searches that they cannot delete then it is recommended to do that before upgrade.
===Data quality queries - Duplicates===__NOEDITSECTION__
===Data quality queries - Mine Action quality===__NOEDITSECTION__
The upgrade script will add these [[SQL Saved search MA quality|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches. There are more Saved Searches than these mentioned here added to the database but they are referencing to tables/fields that do not exist in 5.08.04.
[[Category:NoPublic]]
{{NavBox Upgrade}}