Appending from file geodatabase to ArcSDE fails using ArcPy?

Question

I'm trying to append a feature class from a file geodatabase to an Arcsde featureclass using this line of code:

arcpy.Append_management("parcel_copy", sde_path+"parcel" ,"NO_TEST")

This line works under Python console in ArcMap , but when I execute it under Pyscripter IDE, all the code works fine except the append statement, and it does not return an error.

---

I have tried to isolate the append statements in a little script, and it worked, but i still don't understand why it has not worked.

i wonder if i have not deleted a featurelayer refering to a featureclass in SDE, that locks this featureclass, so i cannot append to it.

any explanation?

Answer 1

"parcel_copy" appears to be a layer in the Table of Contents of your map, so will be found when you run the script from ArcMap.

However, in order to let the script (when run outside of ArcMap) know where the data that layer is based on can be found, you will need to either issue MakeFeatureLayer before the Append, or more simply reference the path to the dataset in place of the layer name of the Append.