DOI-USGS / gems-tools-pro

GeMS Tools for ArcGIS Pro
Creative Commons Zero v1.0 Universal
45 stars 15 forks source link

Validate Database "Parameters are not valid" error and Project Map Data To Cross Section suggestions #87

Open hmangum opened 10 months ago

hmangum commented 10 months ago

Hi all,

I downloaded the 2.12.8 version of the GeMS toolbox to try validating a geodatabase, and I’m running into a “Parameters are not valid” error with the Validate Database tool. Specifically errors 000622 and 000628. I tested it out on two different project geodatabases and ran it on a different machine and I got the same errors. I’ve attached a screenshot of the error message. I’m working in ArcPro version 2.8.8. Is this possibly a versioning error?

Additionally, a few of us at the Virginia Survey have tried to run the Project Map Data To Cross Section tool, and we discovered that the tool is utilizing the 3D Analyst extension. Many of us don’t have 3D Analyst and we are working to get it now, but we are wondering if the Spatial Analyst extension could be used instead?

Also relating to cross sections, we would like to suggest that the following feature classes be included when the Create New Database tool creates a cross section feature dataset: CSxCartographicLines CSxAnnotations CSxFaultDecorations CSxBoreholeLines Currently it builds CSxContactsAndFaults, CSxMapUnitPolys, and CSxOrientationPoints within a cross section feature dataset, but we have found the need to add these additional feature classes to store things like the bounding box, profile line, and annotations of our cross sections. Let us know if this is possible!

Thank you in advance for any guidance!

~Holly Mangum

Screenshot 2023-10-23 134438

ethoms-usgs commented 10 months ago

I can't reproduce that error. Try closing Pro completely and running the tool again. If you still get an error, can you send me the gdb?

ethoms-usgs commented 10 months ago

About cross sections. It looks like Project to Cross Section calls two 3D Analyst tools. I am not sure if the code can be rewritten to not use them, but I will take a look.

Someone else recently asked about adding the functionality of plotting boreholes, which I would like to work on, so that may be coming soon.

If there is a feature class listed in the A La Carte tool, such as CartographicLines, you could add what you need after running the Create Database tool and rename the feature class as necessary, but I think I will avoid suggesting too much to go into a cross section feature dataset since it might come off as overly-proscriptive.

hmangum commented 10 months ago

I tried closing Pro entirely and test ran the tool again but got the same errors. I'll send you my gdb.

Thanks for looking into the 3D Analyst situation. And I'll test out using the A La Carte tool to add the features we may need. I wasn't sure what other surveys were needing in their cross sections, but it makes sense to keep it more general in the main tool.

Thanks for the quick response!

hmangum commented 10 months ago

Hi Evan,

Thanks for the response! I'm going to send you my gdb through our large file transfer system.

Thank you,

Holly Mangum

she/her

Geologist: Scientist 2

Virginia Energy

Geology and Mineral Resources Program

900 Natural Resources Drive, Suite 500 Charlottesville, Virginia 22903

Office: (434)-951-6364

Email: @.**@.>

[cid:73c8d803-3cbc-4fce-a528-33516227713a]


From: Evan Thoms @.> Sent: Monday, October 23, 2023 4:42 PM To: DOI-USGS/gems-tools-pro @.> Cc: Mangum, Holly (Energy) @.>; Author @.> Subject: Re: [DOI-USGS/gems-tools-pro] Validate Database "Parameters are not valid" error and Project Map Data To Cross Section suggestions (Issue #87)

About cross sections. It looks like Project to Cross Section calls two 3D Analyst tools. I am not sure if the code can be rewritten to not use them, but I will take a look.

Someone else recently asked about adding the functionality of plotting boreholes, which I would like to work on, so that may be coming soon.

If there is a feature class listed in the A La Carte tool, such as CartographicLines, you could add what you need after running the Create Database tool and rename the feature class as necessary, but I think I will avoid suggesting too much to go into a cross section feature dataset since it might come off as overly-proscriptive.

— Reply to this email directly, view it on GitHubhttps://github.com/DOI-USGS/gems-tools-pro/issues/87#issuecomment-1775987174, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCNNKCDSAHFTCDIRAZMTAWTYA3JBRAVCNFSM6AAAAAA6MRBRSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZVHE4DOMJXGQ. You are receiving this because you authored the thread.Message ID: @.***>

ethoms-usgs commented 10 months ago

I still don't see that error. Try these two things one at a time:

  1. Move or copy the toolbox to a different folder than what you have previously used and try from there
  2. A full computer restart
hmangum commented 10 months ago

I moved the toolbox to a new folder on my desktop and also restarted by computer and still got the same error. The tool gave me a text file listing all of the primary key errors as well this time. R_Retreat_GeMS.gdb.txt

ethoms-usgs commented 10 months ago

Ok, I apologize. I first thought the error was just a weird memory glitch I have been seeing, but it's something else. Where the tool is failing is in trying to create a feature dataset in a scratch gdb used for validating topology. Please try this manually:

  1. Open the Create Feature Dataset tool.
  2. Browse to the Topology.gdb the tool is making (the location is shown on the line in the messages starting with 'Creating geodatabase for topology)
  3. Name the new feature dataset whatever you like
  4. Import the Coordinate System from the GeologicMap feature dataset in the original gdb

image

The tool is doing these steps programmatically but throwing an error about not being able to create a spatial reference for the new feature dataset. Except it only happens for you, not me.

hmangum commented 10 months ago

It appears to be dependent on the version of ArcPro that's used. Our GIS administrator was able to run validation without error in 3.1.3, and when I got updated to 2.9.5 it works as well. So it seems that there's something with version 2.8.8 and possibly older versions that are not compatible with the tool, although I'm still not entirely sure what it is. What version of Pro are you using?

ethoms-usgs commented 9 months ago

Sorry I missed your comment. I am using 3.1.3

hmangum commented 9 months ago

That's alright! It's working great now that we've upgraded to 3.0.

Thank you,

Holly Mangum

she/her

Geologist: Scientist 2

Virginia Energy

Geology and Mineral Resources Program

900 Natural Resources Drive, Suite 500 Charlottesville, Virginia 22903

Office: (434)-951-6364

Email: @.**@.>

[cid:90423841-62ee-45e5-a4cd-651950fe5cf0]


From: Evan Thoms @.> Sent: Tuesday, December 5, 2023 1:37 PM To: DOI-USGS/gems-tools-pro @.> Cc: Mangum, Holly (Energy) @.>; Author @.> Subject: Re: [DOI-USGS/gems-tools-pro] Validate Database "Parameters are not valid" error and Project Map Data To Cross Section suggestions (Issue #87)

Sorry I missed your comment. I am using 3.1.3

— Reply to this email directly, view it on GitHubhttps://github.com/DOI-USGS/gems-tools-pro/issues/87#issuecomment-1841392229, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCNNKCCLRKEGNEFQ677OOQLYH5SWHAVCNFSM6AAAAAA6MRBRSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBRGM4TEMRSHE. You are receiving this because you authored the thread.Message ID: @.***>