search

DOI-USGS / gems-tools-arcmap

Tools for working with the GeMS geologic map database schema in ArcGIS
Creative Commons Zero v1.0 Universal
42 stars 21 forks source link

Validate database crash #72

Closed hsnellen closed 3 years ago

hsnellen commented 3 years ago

I've been running one of my databases through the tool and it was working, but I've since made edits to the database to correct the GeMS errors. Now when I run the same database through the tool, I get this error: image

I've downloaded the most up to date version of the tool, started with a fresh document, ran the tool through Catalog and same error. Any ideas?

ethoms-usgs commented 3 years ago

The code is trying to write out a warning about a GeoMaterial value that can't be found in GeoMaterialDict but the value contains a non-ASCII-set character that isn't being decoded correctly. Did you add a GeoMaterial to the DMU that isn't in the dictionary?

hsnellen commented 3 years ago

I just double checked and all terms that are in the GeoMaterials field in the DMU, are all present in the GeoMaterialDict.
Not sure if this would affect it, but for the headings in the DMU there is nothing filled out in the GeoMaterials column. Could that cause issues?

ethoms-usgs commented 3 years ago

Hmm, no, nulls are ok in that table. As far as I can tell, the character code reported in the message \u201c refers to "left double quotation mark". Were the values in that field copied over from outside of ArcMap?

hsnellen commented 3 years ago

Ah that was it. I wasn't the one who filled out that portion but there was one GeoMaterials term, ""Made" or human-engineered land" that had a faulty character within the quotation. Thanks for solving this! Just re-ran the tool and it's working again.

ethoms-usgs commented 3 years ago

Great! I will close this.