DeleteRows_management and Append_management problems

Question

I'm trying to update a layer that is in an Oracle sde feature class. I create the feature class in a file geodatabase and then delete the features in the sde feature class and append the features from the file geodatabase layer.

I was having trouble getting it to work until I switched from a 64-bit IDE to a 32-bit one. Do DeleteRows_management and Append_management only work in a 32-bit environment?

MarkBinder · Answer

I only have one feature in the feature class that I'm deleting so switching to TruncateTable_management might not make any difference. I also create temporary sde connections in my script and then delete them at the end.

JamesCrandall · Answer

I don't know what could be the issue, but I'd think TruncateTable_management would be the better option if you are simply deleting all features/rows and then appending (no recovery of deleted features though!).  Also, be sure to correctly implement arcpy.ClearWorkspaceCache_management since you are working in an enterprise environment and this should help to eliminate connections.

I've not done much with Append and typically rely on arcpy.da cursor to perform appends, updates and deletes.

MarkBinder · Answer

When I run DeleteRows_management nothing happens if I use the 64-bit IDE but it works with the 32-bit IDE. No error messages, not versioned, no edit session.

I run DeleteRows_management on the sde feature class to clear the existing features and then run Append_management to load the new ones.