Trouble Creating Tables

[jkopera]

Hi All,

First off, thank you for all of your great work on this.

More often than not, and apparently when I run any of the tools in the Toolbox, I get an ERROR 000210:

File "\psf\Home\Documents\OMSG\Active_Projects\Cross-Section-master\GeologicCrossSectionTbx\scripts\points2XsecView.py", line 251, in arcpy.InterpolateShape_3d(dem, ptLayer, zPts)

<class 'arcgisscripting.ExecuteError'>: ERROR 000210: Cannot create output c:\ArcGIS10_DefaultGDB\Default.gdb\XS_str300-2_z The table name is invalid. The table was not found. [XS_str300-2_z] Failed to execute (InterpolateShape).

Traceback (most recent call last): File "\psf\Home\Documents\OMSG\Active_Projects\Cross-Section-master\GeologicCrossSectionTbx\scripts\points2XsecView.py", line 413, in raise SystemError SystemError

Failed to execute (points2XsecView).

Permissions are set for read/write on all files and folders, including said default gdb, and everything is in the same projection, and the source files are all in the same geodatabase.

Any tips?

[acroskrey]

Hi jkopera,

I am having the same issue with getting Error 000210 while trying out the "Line intersections to cross-section features" tool.

Executing: lineintersects SF_line elev_snap250 northwest "Extent Polygons and Lines\ku_b_e_extent_line" points 20 C:\GIS\cross_section_creation\usgs_tool\raster_extend_polygons\ku_b_e_extent_pt_lineF.shp # # Layers Start Time: Mon Nov 24 13:59:42 2014 Running script lineintersects... Getting elevation values for cross-section line in SF_line File "O:\WSC\IWT\GIS_PM_tool\cross_section_tool\Cross-Section-master\GeologicCrossSectionTbx\scripts\lineintersect.py", line 343, in arcpy.InterpolateShape_3d(dem, xsecLayer, zLine)

<class 'arcgisscripting.ExecuteError'>: ERROR 000210: Cannot create output C:\Users\acroskre\Documents\ArcGIS\Default.gdb\SF_line.shp_z The table name is invalid. The table was not found. [SF_line.shp_z] Failed to execute (InterpolateShape).

Traceback (most recent call last): File "O:\WSC\IWT\GIS_PM_tool\cross_section_tool\Cross-Section-master\GeologicCrossSectionTbx\scripts\lineintersect.py", line 440, in raise SystemError SystemError

Failed to execute (lineintersects).

Failed at Mon Nov 24 13:59:44 2014 (Elapsed Time: 2.32 seconds)

I was able to get around that error by changing the Workspace settings for the environments of the tool but then I got Error 000732 which I haven't been able to get around.

Executing: lineintersects SF_line elev_snap250 northwest "Extent Polygons and Lines\ku_b_e_extent_line" points 20 C:\GIS\cross_section_creation\usgs_tool\raster_extend_polygons\ku_b_e_extent_pt_lineF.shp # # Layers Start Time: Mon Nov 24 14:03:51 2014 Running script lineintersects... Getting elevation values for cross-section line in SF_line SF_line.shp_z written to C:\GIS\cross_section_creation Measuring the length of the line in SF_line.shp_z File "O:\WSC\IWT\GIS_PM_tool\cross_section_tool\Cross-Section-master\GeologicCrossSectionTbx\scripts\lineintersect.py", line 349, in arcpy.CreateRoutes_lr(zLine, 'ORIG_FID', zmLine, 'LENGTH', '#', '#', cp)

<class 'arcgisscripting.ExecuteError'>: Failed to execute. Parameters are not valid. ERROR 000732: Input Line Features: Dataset SF_line.shp_z does not exist or is not supported WARNING 000725: Output Route Feature Class: Dataset C:\GIS\cross_section_creation\SF_line.shp already exists. Failed to execute (CreateRoutes).

Traceback (most recent call last): File "O:\WSC\IWT\GIS_PM_tool\cross_section_tool\Cross-Section-master\GeologicCrossSectionTbx\scripts\lineintersect.py", line 440, in raise SystemError SystemError

Failed to execute (lineintersects).

Failed at Mon Nov 24 14:03:52 2014 (Elapsed Time: 1.10 seconds)

Not sure if that will provide much assistance with troubleshooting but I thought it was worth posting. Cheers, Andrea

[ethoms-usgs]

Hello Joe and Andrea, GDB objects (tables, feature classe, etc) cannot be named using special characters, such as a hyphen. The only non-alphanumeric characer allowed is the underscore. So, Joe, I think your error is coming from using the output name XS_str300-2_z.

Andrea, you are getting the same error because Arc is trying to write out to SF_line.shp_z.In that case, the script is getting an input parameter of 'SF_line.shp'. I guess you are adding the layer name to the tool form through the browse button to the right of the field? I can write some code to catch that particular error and present the user with a prompt reminding them to look for special characters in the name (or strip them out), but in the meantime, if you add the shapefile to your map first so that it shows up in the table of contents, it is then made available to the form in the dropdown to the right of the field and the layer name does not have the .shp extension.

Hope that helps! Evan

[acroskrey]

Thanks for the quick reply Evan!

I double checked and picked the cross section line from the drop down and the field doesn't have ".shp" in it but the same error message came up including the "The table was not found. [SF_Line.shp_z]" bit. Here is a screen shot on how I filled out the tool:

[ethoms-usgs]

Ok, I see how I can write some code around this. I haven't been testing with shapefiles, can you move your data into a file geodatabase?

[acroskrey]

We tend to work in shapefiles for compatibility with various GIS users but for testing this it is no problem ☺

From: evanthoms [mailto:notifications@github.com] Sent: Monday, November 24, 2014 4:06 PM To: evanthoms/Cross-Section Cc: Andrea Croskrey Subject: Re: [Cross-Section] Trouble Creating Tables (#1)

Ok, I see how I can write some code around this. I haven't been testing with shapefiles, can you move your data into a file geodatabase?

— Reply to this email directly or view it on GitHubhttps://github.com/evanthoms/Cross-Section/issues/1#issuecomment-64273632.

[acroskrey]

Yep! The tool ran with the features in a geodatabase. Thanks for the advice!

[ethoms-usgs]

Great. I will close this for now, but will consider adding support for shapefiles as I upgrade.