ERROR 001333: Unregister as versioned is not supported for a dataset in a feature dataset

Question

Hello - I created an Arcpy script that will unregister a table as versioned, truncate the data, register the data as versioned and then cleans up the data. The data is not stored in a feature dataset nor does one exist in the geodatabase. The script runs fine in Pyscripter but when I add it to a Script Tool in ArcCatalog I get the following error when I run it:

Does anyone have an idea what could be happening? I have searched around but I haven't been able to find anything about this error happening to others.

Thanks,

Vince

vlegendre · Answer

I forgot to mention that I have another version of the script that uses the Delete tool and that does not cause an error but it takes a very long time to complete since the table has 318K records and it is growly quickly. I was trying speed the deleting process so I thought I would try Truncate. The script is below. I currently don't have any parameters and have hard coded the workspace in the code. Thanks.

# Import arcpy module
import arcpy, datetime, pymssql
#from arcpy.da import SearchCursor

#connection to the SDE databse
workspace = arcpy.env.workspace = "Database Connections\AutoAssign_Test.sde"

print "Unregister MVIEW as versioned"
arcpy.AddMessage("Unregister MVIEW as versioned")
arcpy.UnregisterAsVersioned_management("dbo.MVIEW", "NO_KEEP_EDIT", "NO_COMPRESS_DEFAULT")
print "Truncate MVIEW"
arcpy.AddMessage("Truncate MVIEW")
arcpy.TruncateTable_management("dbo.MVIEW")
print "Register MVIEW as versioned"
arcpy.AddMessage("Register MVIEW as versioned")
arcpy.RegisterAsVersioned_management("dbo.MVIEW", "EDITS_TO_BASE")

KevinDunlop · Answer

You are right.  For versioned tables use the Delete Rows tool.

Asrujit_SenGupta · Answer

Versioned data is not supported for the Truncate tool:

Truncate Table—Help | ArcGIS Desktop

Versioned data is not supported as input. Data must be unregistered as versioned before the tool will execute successfully.