[[Image:DistBear Case1B wrong.png|800px|center]]
<div align="center">
'' How to see if Case 1B exists: It is not possible to open Geospatial tab in the Summary window and the DEF looks like this ''
</div>
Run this query (''DistBear Missing FromPoint Point2'') to check if you have any points that falls under Case 1B. This query is '''NOT''' tested with MGRS.
==Case 2 Coordinates entered with 5.x and upgraded to 6.0==
[[Image:DistBear Case1B Case2 wrong.png|800px|center]]
<div align="center">
'' How to see if Case 2 exists: It is not possible to open Geospatial tab in the Summary window and the DEF looks like this ''
=== Case 4A One/few points of a polygon are missing frompoint_guid and user_entered===
[[Image:DistBear Case2 wrong.png|800px|center]]
<div align="center">
'' How to see if Case 4A exists: It is not possible to open Geospatial tab in the Summary window and the DEF looks like this ''
</div>
Run this query (''DistBear Check user_entered2'') to check if you have any points that falls under Case 4A. This query is '''NOT''' tested with MGRS.
<pre>
=== Case 4C length(frompoint_guid) = 0===
[[Image:DistBear Case4C wrong.png|500px|center]]
<div align="center">
'' Difference between length = 0 and NULL''
</div>
These records are likely to be the same as found for Case 4B and could as well be orphans.
Run this query (''DistBear Check length FromPointGUID'') to check if you have any points that falls under Case 4C. This query is '''NOT''' tested with MGRS.