Hello Mike,
It is ArcGIS 10.1 Sp1 in Windows 2008 machine. I tried multiple times, the python code is not working, getting the same error. I verified the same with different fc.
import arcpy
# Local variables:
inputFC = "inputFC"
SchemaOwner_sdeFC = "Database Connections\\SchemaOwner.sde\\SchemaOwner.sdeFC"
# Process: Append
arcpy.Append_management("inputFC", SchemaOwner_sdeFC, "NO_TEST", "STATUS \"Status\" true true false 1 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,Status,-1,-1;SCORE \"Score\" true true false 2 Short 0 5 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,Score,-1,-1;MATCH_TYPE \"Match_type\" true true false 2 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,Match_type,-1,-1;SIDE \"Side\" true true false 1 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,Side,-1,-1;X \"X\" true true false 8 Double 8 38 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,X,-1,-1;Y \"Y\" true true false 8 Double 8 38 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,Y,-1,-1;MATCH_ADDR \"Match_addr\" true true false 135 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,Match_addr,-1,-1;BLOCKL \"BlockL\" true true false 15 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,BlockL,-1,-1;BLOCKR \"BlockR\" true true false 15 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,BlockR,-1,-1;ARC_STREET \"Street or Intersection\" true true false 60 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,ARC_Street,-1,-1;ARC_CITY \"City\" true true false 40 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,ARC_City,-1,-1;ARC_STATE \"State\" true true false 20 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,ARC_State,-1,-1;ARC_ZIP \"ZIP\" true true false 12 Text 0 0 ,First,#,E:\\ESRI\\work\\work.gdb\\inputFC,ARC_ZIP,-1,-1", "")
