Hi,
I used Python 2.7 to develop a script to append data from a user's file geodatabase to a version of Enterprise SDE. The python script ran on the local machine without any issues and could show me the correct record number in SDE before and after appending by arcpy.AddMessage(). So I published it to our ArcGIS server and ran the service without any issues, but the record numbers in SDE before and after appending showed me the same and appending function didn't work. But there were no error messages. This is my appending code: arcpy.Append_management(GDBFull + "\\HWCS_CCTVConditions", os.path.join(SDEpath, "GISDEV2.HWADM.HWCS_CCTVConditions"),"NO_TEST").
Anyone has any idea why Python script worked but its service didn't work and there were no errors reported?
Thanks for your help,
Saili