Check Database 6.0

This pages outlines what to check in databases even after they have been upgraded to 6.0 and have been used by the country with 6.0.

All databases are different due to which version the country start using IMSMA with which upgrade scripts have been applied of both 5.x and 6.0 if data has been imported and/or migrated what data corrections have been made with SQL how data has been added by the country manually, import of xml (variation 1,2,3) one-by-one or mass approval in the workbench how the DEFs are designed which coordinate system/format and type of coordinates (absolute or relative) which parts of IMSMA the country are using

1. Check that what should have been fixed before, during and after upgrade to 6.0 was actually done
   • before
   • during and after
2. Check coordinates distance and bearing
3. Check if any items are missing row with approval_state NEW in link table
4. Check if attachments are missing or mixed (i.e. attachments from another country)
   1. compare number of in attachment table and C:\IMSMAng\server\attachments folder
   2. import the file names into a temporary table and compare with attachment table
5. Check if there is any geospatial orphans
6. Check Task CDFs CDF error NullPointerException
7. Check enum category Work Item Status vs work item status and Task Status vs task status (lower case variations are not correct)

The importance of filled in values in the fieldreport table is covered on this page.

If you need to check the Date of Information then there are a MySQL page and a PostgreSQL page.

If you need to check the Form ID/Item IDs then there are a MySQL page and a PostgreSQL page.

If you need to check the Approval information then there are a MySQL page and a PostgreSQL page. Template:NavBox Hub