how can append work with sde data?

Question

in a python script        ## THIS WORKS IN AN EDITING SESSION ON A FILE GEODATABASE FEATURE CLASS
       arcpy.Append_management(SourceData,TLyr,"NO_TEST")
       
       ## THIS DOES NOT WORK FOR AN SDE DATABASE FEATURECLASS
       arcpy.Append_management(SourceData,BLLyr,"NO_TEST")

the error returned is:
Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 000210: Cannot create output \propertyappraisal.DBO.PA_Basemap\propertyappraisal.DBO.basemap_arc Failed to execute (Append).

is there a way around this?

FrankVignati · Answer

well, it seems the workspace had to be set with the sde connection in order for it to write to the layer

this is how the workspace is set, does anyone know a less ugly way?       SDEInfo = BLLyr.serviceProperties 
       UserInfo = str(SDEInfo.get('UserName'))
       UserInfoSplt = UserInfo.split("\")
       User = UserQ.rstrip('"')
       User = User.lower()
       IWork = r"C:\Documents and Settings\%s\Application Data\ESRI\Desktop10.0\ArcCatalog\%s@propertyappraisal.vgisdb1.sde"%(User, User)
       arcpy.env.workspace = IWork

FrankVignati · Answer

our sde database is versioned, the layer i am trying to write to is from a database connection with rights to edit the data
can python write to sde versioned data if done within an editing session?

MathewCoyle · Answer

If you are getting a 210 error there is a problem with your write access to your target. I would test for a schema lock on your target feature class. Versioning might be an issue also depending on the setup of your database and your privileges.