Check Database 6.0: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 23: Line 23:
<li> [[Check coordinates distance and bearing 6.0 | Check coordinates distance and bearing]]
<li> [[Check coordinates distance and bearing 6.0 | Check coordinates distance and bearing]]
<li> Check if any items are missing row with [[Check Link Table Approval State NEW | ''approval_state'' NEW]] in ''link'' table
<li> Check if any items are missing row with [[Check Link Table Approval State NEW | ''approval_state'' NEW]] in ''link'' table
<li> Check if any Soft deleted did not effect with ''[[Check Link Table Deleted]]''
<li> Check if attachments are missing or mixed (i.e. attachments from '''another''' country)
<li> Check if attachments are missing or mixed (i.e. attachments from '''another''' country)
# compare number of in ''attachment'' table and ''C:\IMSMAng\server\attachments'' folder
# compare number of in ''attachment'' table and ''C:\IMSMAng\server\attachments'' folder
# [[Check Attachments | import the file names into a temporary table]] and compare with ''attachment'' table
# [[Check Attachments | import the file names into a temporary table]] and compare with ''attachment'' table
<li> Check if there is any [[Geospatial Orphans | geospatial orphans]]
<li> Check if there is any [[Geospatial Orphans | geospatial orphans]]
<li> Check Task CDFs [[CDF error NullPointerException]]
<li> Check enum category Work Item Status vs work item status and Task Status vs task status (lower case variations are not correct)
</ol>
</ol>


The importance of filled in values in the ''fieldreport'' table is covered on this '''[[Fieldreport Dates | page]]'''.
The importance of filled in values in the ''fieldreport'' table is covered on this '''[[Fieldreport ID and Dates | page]]'''.


If you need to check the ''Date of Information'' then there are a MySQL '''[[Missing Date of Information | page]]''' and a PostgreSQL '''[[Missing Date of Information PGSQL | page]]'''.
If you need to check the ''Date of Information'' then there are a MySQL '''[[Missing Date of Information | page]]''' and a PostgreSQL '''[[Missing Date of Information PGSQL | page]]'''.


If you need to check the ''Form ID/Item IDs'' then there are a MySQL '''[[Missing Local ID | page]]''' and a PostgreSQL '''[[Missing Local ID PGSQL | page]]'''.
If you need to check the ''Form ID/Item IDs'' then there are a MySQL '''[[Missing Local ID | page]]''' and a PostgreSQL '''[[Missing Local ID PGSQL | page]]'''.
If you need to check the ''Approval information'' then there are a MySQL '''[[Missing approval information | page]]''' and a PostgreSQL '''[[Missing approval information PGSQL | page]]'''.
{{NavBox Hub}}
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:NoPublic]]

Latest revision as of 06:49, 10 January 2019

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
  1. which version the country start using IMSMA with
  2. which upgrade scripts have been applied of both 5.x and 6.0
  3. if data has been imported and/or migrated
  4. what data corrections have been made with SQL
  5. 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
  6. how the DEFs are designed
  7. which coordinate system/format and type of coordinates (absolute or relative)
  8. 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
  2. Check coordinates distance and bearing
  3. Check if any items are missing row with approval_state NEW in link table
  4. Check if any Soft deleted did not effect with Check Link Table Deleted
  5. 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
  6. Check if there is any geospatial orphans
  7. Check Task CDFs CDF error NullPointerException
  8. 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

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Check_Database_6.0&oldid=24176"