Hi there, I am facing a strange Problem. In the following Script two Tables in an sql-Server Database should be exported. The first one works, the second one not (I am sure it is spelled right). import tempfile import arcpyout Location = tempfile . mkdtemp ( ) arcpy . TableToTable_conversion ( "../bamo.sde/bko.bkEingriffart" , outLocation , "bkEingriffart.dbf" ) arcpy . TableToTable_conversion ( "../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele" , outLocation , "bkMassnahmenbkMassnahmenZiele.dbf" ) I got the Error: Traceback ( most recent call last ) : File "C:\Users\xyz\.p2\pool\plugins\org.python.pydev_5.7.0.201704111357\pysrc\pydevd.py" , line 1546 , in module > globals = debugger . run ( setup [ 'file' ] , None , None , is_module ) File "C:\Users\xyz\.p2\pool\plugins\org.python.pydev_5.7.0.201704111357\pysrc\pydevd.py" , line 982 , in run pydev_imports . execfile ( file , globals , locals ) # execute the script File "C:\Repositories\Python\bkonline2-deploy\gp-services\bko\exportSHP.py" , line 13 , in module > arcpy . TableToTable_conversion ( "../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele" , outLocation , "bkMassnahmenbkMassnahmenZiele.dbf" ) File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\conversion.py" , line 2133 , in TableToTable raise earcgisscripting . ExecuteError : Failed to execute . Parameters are not valid . ERROR 000732 : Input Rows : Dataset . . / bamo . sde / bko . bkMassnahmenbkMassnahmenZiele does not exist or is not supportedFailed to execute ( TableToTable ) . I use ArcGIS 10.3.1 for develpoing, but the error also occurs when using ArcGIS 10.5.1. Later the Script shell run as a geoprocessing Task on an ArcGIS for server. Has anybody an idea? Best Regard, Andreas

Hi Aron, unfortunately, it was not really solved, the Problem seemed to be that the table had not a simple key but a Composite one. I solved it by adding a view to the database that joined both of the tables. Then I was able to use TableToTable on the view. I hope this is an Option for you too. Best regards, Andreas

I am having issues similar to this. Was your issues ever resolved?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ERROR 000732 on executing TableToTable

AndreasRuloffs2

Hi there,

I am facing a strange Problem. In the following Script two Tables in an sql-Server Database should be exported.

The first one works, the second one not (I am sure it is spelled right).

<SPAN class="keyword token">import</SPAN> tempfile
<SPAN class="keyword token">import</SPAN> arcpyout

Location <SPAN class="operator token">=</SPAN> tempfile<SPAN class="punctuation token">.</SPAN>mkdtemp<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"../bamo.sde/bko.bkEingriffart"</SPAN><SPAN class="punctuation token">,</SPAN>outLocation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"bkEingriffart.dbf"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele"</SPAN><SPAN class="punctuation token">,</SPAN>outLocation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"bkMassnahmenbkMassnahmenZiele.dbf"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

‍‍‍‍‍‍‍
I got the Error:

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; 
File <SPAN class="string token">"C:\Users\xyz\.p2\pool\plugins\org.python.pydev_5.7.0.201704111357\pysrc\pydevd.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1546</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>&nbsp;&nbsp;&nbsp; 
globals <SPAN class="operator token">=</SPAN> debugger<SPAN class="punctuation token">.</SPAN>run<SPAN class="punctuation token">(</SPAN>setup<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'file'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> is_module<SPAN class="punctuation token">)</SPAN>&nbsp; 
File <SPAN class="string token">"C:\Users\xyz\.p2\pool\plugins\org.python.pydev_5.7.0.201704111357\pysrc\pydevd.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">982</SPAN><SPAN class="punctuation token">,</SPAN> 
<SPAN class="keyword token">in</SPAN> run&nbsp;&nbsp;&nbsp; pydev_imports<SPAN class="punctuation token">.</SPAN>execfile<SPAN class="punctuation token">(</SPAN>file<SPAN class="punctuation token">,</SPAN> globals<SPAN class="punctuation token">,</SPAN> locals<SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># execute the script&nbsp; </SPAN>
File <SPAN class="string token">"C:\Repositories\Python\bkonline2-deploy\gp-services\bko\exportSHP.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">13</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele"</SPAN><SPAN class="punctuation token">,</SPAN>outLocation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"bkMassnahmenbkMassnahmenZiele.dbf"</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\conversion.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">2133</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> TableToTable&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">raise</SPAN> earcgisscripting<SPAN class="punctuation token">.</SPAN>ExecuteError<SPAN class="punctuation token">:</SPAN> Failed to execute<SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000732</SPAN><SPAN class="punctuation token">:</SPAN> Input Rows<SPAN class="punctuation token">:</SPAN> Dataset <SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="operator token">/</SPAN>bamo<SPAN class="punctuation token">.</SPAN>sde<SPAN class="operator token">/</SPAN>bko<SPAN class="punctuation token">.</SPAN>bkMassnahmenbkMassnahmenZiele does <SPAN class="operator token">not</SPAN> exist <SPAN class="operator token">or</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> supportedFailed to execute <SPAN class="punctuation token">(</SPAN>TableToTable<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I use ArcGIS 10.3.1 for develpoing, but the error also occurs when using ArcGIS 10.5.1.

Later the Script shell run as a geoprocessing Task on an ArcGIS for server.

Has anybody an idea?

Best Regard,

Andreas

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

vshrinivasan_gispes

I am having similar issues while converting a pandas dataframe to gdb table as well.

See coed below. It did run the first time I ran but has bee failing since. I have tried running it by changing workspace as well.

gdb_path = r"Z:\Shared\SMS GIS\Long_Term_Projects\Development_Environmental_Tracker_GIS\Project_Packet_DataUpload_FINAL.gdb"
table_name = "Dev_Portfolio"

arcpy.env.workspace = r"Z:\Shared\SMS GIS\Long_Term_Projects\Development_Environmental_Tracker_GIS\Project_Packet_DataUpload_FINAL.gdb"
out_ws = arcpy.env.workspace

# # Convert the DataFrame to a gdb table
# arcpy.TableToTable_conversion(df, gdb_path, table_name)

try:
# Convert the DataFrame to a gdb table
arcpy.TableToTable_conversion(df, out_ws, table_name)
print(f"DataFrame converted to gdb table: {table_name}")
except arcpy.ExecuteError as ee:
print("ArcPy ExecuteError occurred:")
print(ee)
except Exception as e:
print("An error occurred:")
print(e)

AndreasRuloffs2

bkEingriffart is just a simple table, bkMassnahmenbkMassnahmenZiele is a table to resolve an m to n relationship. Therefor it has a composite primary key.

AndreasRuloffs2

Unfortunately this makes no difference.

bixb0012

How is bkMassnahmenbkMassnahmenZiele different than bkEingriffart in terms of structure, e.g., is one a feature class and the other one a table?

If both are just tables, my money is on permissions. If the T2T tools can't open the table to read it, it will report it does not exist or is not supported.

AndreasRuloffs2

If I comment out the first T2T conversion, then the second one fails anyway.

bixb0012

What if you comment out the first table conversion, does the second one (now the first) err out? It is good to isolate whether it is the call itself or calling something successively that is causing an issue.

JoeBorgione

My apologies Andreas- when I first read your post I thought I saw that you were using the output of a second TableToTable function as input to a first TableToTable function. Your use of relative paths may be problematic as well.

I'm not familiar with the use of tempfile, so my approach would be to set the out put workspace as an arcpy env variable:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'DriveLetter:\your\desired\path\to\output\directory'</SPAN>
out_ws <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace


<SPAN class="comment token"># use a complete path to your sde connection and file name</SPAN>
<SPAN class="comment token"># below is an example of one of mine</SPAN>

in_table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'T:\GIS Documents\AddressPOC2017\AddIn\SLCOGIS_Joe.sde\SLCOGIS.GDB_ADD.DB2_StreetFile'</SPAN>

out_table <SPAN class="operator token">=</SPAN> <SPAN class="string token">'YourNameOfChoice.dbf'</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN>out_ws<SPAN class="punctuation token">,</SPAN>out_table<SPAN class="punctuation token">)</SPAN>


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

AndreasRuloffs2

Thank you Joe,

some new Lines got missing, I correct that.

I do not understand the part with the parantheses TableToTable_conversion works with a single Table.<BR />

JoeBorgione

To me it looks like you are missing a comma and some parentheses

<SPAN class="comment token"># yours :&nbsp; import tempfileimport arcpy</SPAN>
<SPAN class="keyword token">import</SPAN> tempfileimport<SPAN class="punctuation token">,</SPAN> arcpy&nbsp;&nbsp; <SPAN class="comment token">#note comma...</SPAN>

<SPAN class="comment token"># yours:&nbsp; arcpy.TableToTable_conversion("../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele",outLocation, "bkMassnahmenbkMassnahmenZiele.dbf")</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele"</SPAN><SPAN class="punctuation token">,</SPAN>outLocation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"bkMassnahmenbkMassnahmenZiele.dbf"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># note enclosing parentheses...</SPAN>


‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Just a WAG (wild a$$ guess...)

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.