Deleting a SDE feature dataset with Python in 10.1 fails

[JoseSanchez]

Hi all

I am working in ArcGIs 10.1.

Deleting with python 10.1 or Model Builder 10.1  a SDE feature dataset that has features classes and topology fails with the following error. 

The feature dataset is in a SDE 9.3 geodatabase.

If I delete the same feature dataset with a python script in 9.3 it works fine.

# Import arcpy module
import arcpy


# Local variables:
MDC_TPDistrict = "Database Connections\\Dsde3 MAIN.SDE\\MAIN.TPDistrict"

# Process: Delete
arcpy.Delete_management(MDC_TPDistrict, "FeatureDataset")



=========================================== TRACE


traceback (most recent call last):
  File "C:\Workspace\Delete.py", line 17, in <module>
    arcpy.Delete_management(MDC_TPDistrict, "FeatureDataset")
  File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 3658, in Delete
    raise e
ExecuteError: DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1190_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1190_PointErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1192_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1192_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1192_PointErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1191_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1191_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][MDC.T_1191_PointErrors]] 
Failed to execute (Delete).

>>>

[NathanHeick]

I did some more testing using SDEINTERCEPT.  If I delete the topology using a right-click context menu and review the intercept files, the tables in question do exist, are accessed, deleted, and then additional attempts to access them are made at the end of the process.  Still, there is no apparent failure.  With the GP tool, with Python or in ArcCatalog, something similar happens, but the GP tool fails in response to the Oracle errors.  Is anyone able to build a topology in ArcSDE and ArcGIS 10.2 and then delete it successfully using the Delete tool?  I am wondering if this is a known issue with 10.1.  It feels like a bug to me.

[NathanHeick]

I tried creating a topology in ArcSDE 9.3.1 from ArcGIS 10.1 SP1.  I received an error regarding empty geometry.  I then created it directly from ArcGIS 9.3.1.  When I deleted it, I still had errors, but found new messages regarding parcel fabric tables.  When I looked at the SDEINTERCEPT logs, after it deleted this tables it seemed to be going through tables in GDB_ITEMS.  I remember seeing some parcel fabric tables then too.  It's trying to do something after it deletes these topology tables, but I'm not clear what.