topic Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592 in ArcGIS Pro Questions

Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

Anonymous User — Wed, 14 Jul 2021 17:17:08 GMT

I have a script that performs a truncate and append on a feature class in an enterprise gdb. The feature class is not in a feature dataset, it is not versioned, and it is not open in any map/catalog session. It does feed a map service hosted on Portal. I stop the map service before attempting the truncate.

The error "160592: Truncation not allowed while editing." is thrown when running the script (python 3.7) or when running truncate table within ArcGIS Pro. This error does not occur when running in ArcMap (I have not tried in a stand alone script python 2.7). I have tried using the Editor class to start and stop and edit session before running the truncate, thinking it might do the trick, but no luck.

I have a hunch this is caused by ArcGIS Pro's "always in an edit session" feature. Has anyone else experienced this, found a work around, or have any ideas of other things to check/try? Thanks!

Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

DanPatterson — Wed, 14 Jul 2021 17:27:27 GMT

No known solution .... from here

160592: Truncation not allowed while editing.—ArcGIS Pro | Documentation

Other errors on Tech Support around Truncate Table suggest to use Delete rows instead.

Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

Anonymous User — Wed, 14 Jul 2021 17:29:15 GMT

I've reverted to delete rows for now, but truncate would be preferred for speed.

Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

DanPatterson — Wed, 14 Jul 2021 17:38:24 GMT

While you are waiting, you should file a bug report

Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

Anonymous User — Tue, 20 Jul 2021 19:19:04 GMT

Esri just confirmed truncate table does not work with feature class that participate in a composite relationship class and therefore, it also does not work with feature classes that have attachments enabled (by default, enabling attachments creates a composite relationship class). Simple relationship classes are supported.

Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

DavidTillberg_community — Wed, 13 Oct 2021 19:36:31 GMT

This actually is supported. When Feature Class contains attachments, you need to use an arcpy.ad.Editor to do certain edit operations (even if it is not versioned). So to have this work:

edit = arcpy.da.Editor(SDE_workspace)

edit.startEditing(False, True) # (or whatever scenario you are comfortable with)

arcpy.TruncateTable_management(feature_class)

edit.stopEditing(True)

# and it works!

Re: Truncate Table/Non-versioned FC/stand alone script and in Pro ERROR 160592

James_Whitacre_PGC — Wed, 21 Jan 2026 15:38:16 GMT

This workaround does not work with File Geodatabases...