topic Re: MakeTableView_management causes an exception when outside of ArcMap in Python Questions

MakeTableView_management causes an exception when outside of ArcMap

SteveLong — Mon, 04 Jun 2012 16:55:43 GMT

Hello,
I'm trying to script the process of creating a replica in a stand alone python script. The geodatabase I'm creating the replica for, (CHECK_OUT type), includes business table I that want in the file geodatabase. If I execute the following line of code in ArcMap in the python window it works well and ArcMap adds the view to the current map. And, it persists from session to session.

arcpy.MakeTableView_management("VegetationMgmt.owner.Actions", "Actions", "AID > 0")

However, when I execute it in a stand alone script after setting up the workspace:
env.workspace = "...\SpatialVegMgmt_NT38.sde"

it produces an error of VegetationMgmt.owner.Actions already exists.

Can anyone help on why it works inside ArcMap but not outside?

Steve

Re: MakeTableView_management causes an exception when outside of ArcMap

MathewCoyle — Sun, 12 Dec 2021 03:03:14 GMT

Have you set your overwriteoutput in your code?

env.overwriteOutput = True

Re: MakeTableView_management causes an exception when outside of ArcMap

SteveLong — Mon, 04 Jun 2012 17:01:35 GMT

Hmmm, no I have not. That would not overwrite the original table would it?

Steve

Re: MakeTableView_management causes an exception when outside of ArcMap

MathewCoyle — Mon, 04 Jun 2012 17:09:32 GMT

Yes, that is what you are doing in your code by setting your workspace to SDE and creating the tableview with the same name as the source.

Re: MakeTableView_management causes an exception when outside of ArcMap

SteveLong — Mon, 04 Jun 2012 17:15:16 GMT

Hmm,
when I execute that line of code in ArcMap, in the python window, it creates a tableView "Actions". The source table is VegetationMgmt.owner.Actions and it doesn't overwrite that source table.

Forgive my ignorance but I'm really new to this...

Thanks
Steve

Re: MakeTableView_management causes an exception when outside of ArcMap

MathewCoyle — Tue, 05 Jun 2012 12:10:59 GMT

I would suspect it is because you are using the default workspace in ArcMap and setting SDE as your workspace in your stand-alone script.

Re: MakeTableView_management causes an exception when outside of ArcMap

SteveLong — Tue, 05 Jun 2012 16:25:33 GMT

Thanks for your replies Mathew. That did the trick. I changed the workspace to sde.DEFAULT and the maketableview executed without a hitch. Now I'm getting another error when I try to create the replica but I'll re-post as it's a different topic.

Steve