topic Re: ERROR 000732 on executing TableToTable in Python Questions

ERROR 000732 on executing TableToTable

AndreasRuloffs1 — Sat, 11 Dec 2021 21:35:53 GMT

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\xxx\.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\xxx\.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

Re: ERROR 000732 on executing TableToTable

JoeBorgione — Sat, 11 Dec 2021 21:35:56 GMT

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

# yours :  import tempfileimport arcpy
import tempfileimport, arcpy   #note comma...

# yours:  arcpy.TableToTable_conversion("../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele",outLocation, "bkMassnahmenbkMassnahmenZiele.dbf")

arcpy.TableToTable_conversion(("../bamo.sde/bko.bkMassnahmenbkMassnahmenZiele",outLocation, "bkMassnahmenbkMassnahmenZiele.dbf"))  # note enclosing parentheses...


‍‍‍‍‍‍‍‍‍‍‍‍‍

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

Re: ERROR 000732 on executing TableToTable

AndreasRuloffs1 — Mon, 04 Jun 2018 15:46:08 GMT

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.

Re: ERROR 000732 on executing TableToTable

JoeBorgione — Sat, 11 Dec 2021 21:35:59 GMT

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:

import arcpy
from arcpy import env

arcpy.env.workspace = r'DriveLetter:\your\desired\path\to\output\directory'
out_ws = arcpy.env.workspace


# use a complete path to your sde connection and file name
# below is an example of one of mine

in_table = r'T:\GIS Documents\AddressPOC2017\AddIn\SLCOGIS_Joe.sde\SLCOGIS.GDB_ADD.DB2_StreetFile'

out_table = 'YourNameOfChoice.dbf'

arcpy.TableToTable_conversion(in_table,out_ws,out_table)


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: ERROR 000732 on executing TableToTable

JoshuaBixby — Mon, 04 Jun 2018 19:56:53 GMT

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.

Re: ERROR 000732 on executing TableToTable

AndreasRuloffs1 — Tue, 05 Jun 2018 07:54:49 GMT

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

Re: ERROR 000732 on executing TableToTable

JoshuaBixby — Tue, 05 Jun 2018 15:07:24 GMT

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.

Re: ERROR 000732 on executing TableToTable

AndreasRuloffs1 — Fri, 08 Jun 2018 09:56:50 GMT

Unfortunately this makes no difference.

Re: ERROR 000732 on executing TableToTable

AndreasRuloffs1 — Fri, 08 Jun 2018 09:58:09 GMT

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

Re: ERROR 000732 on executing TableToTable

AronSaylor — Mon, 04 Nov 2019 19:16:41 GMT

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

Re: ERROR 000732 on executing TableToTable

AndreasRuloffs1 — Tue, 05 Nov 2019 10:06:03 GMT

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

Re: ERROR 000732 on executing TableToTable

vshrinivasan_gispes — Mon, 13 May 2024 16:52:03 GMT

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)