MakeTableView_management causes an exception when outside of ArcMap

[SteveLong]

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

[MathewCoyle]

Have you set your overwriteoutput in your code?

env.overwriteOutput = True

[SteveLong]

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

Steve

[MathewCoyle]

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.

[SteveLong]

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

[MathewCoyle]

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.

[SteveLong]

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