topic Re: Deleting a SDE feature dataset with Python in 10.1 fails in Data Management Questions

Deleting a SDE feature dataset with Python in 10.1 fails

JoseSanchez — Sun, 12 Dec 2021 08:10:25 GMT

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).

>>>

Re: Deleting a SDE feature dataset with Python in 10.1 fails

EmadAl-Mousa — Sat, 22 Jun 2013 06:36:42 GMT

10.1 python modules will not work with 9.3 Geodatabase. Its better to upgrade your geodatabase to at least version 10.

Re: Deleting a SDE feature dataset with Python in 10.1 fails

JoseSanchez — Mon, 24 Jun 2013 10:30:50 GMT

Hi

I tested this module with a ArcSDE 9.3 and ArcSDE 10 geodatabases and it fails in both.

Re: Deleting a SDE feature dataset with Python in 10.1 fails

JoseSanchez — Mon, 01 Jul 2013 10:47:36 GMT

These error messages show when copying from ArcSDE 10.0 to another ArcSDe 10.0 or ArcSDE 93 in arcGIs 10.1.

The script runs fine when working with ArccSDe 9.3 instances only.

Re: Deleting a SDE feature dataset with Python in 10.1 fails

WilliamCraft — Wed, 03 Jul 2013 02:15:01 GMT

Since you are trying to delete from a 9.3 GDB, try loading the older module with your Python script rather than using the current version as you're doing now:

import arcgisscripting
gp = arcgisscripting.create(9.3)

Replace your "arcpy" functions with "gp" and see if that helps.

Re: Deleting a SDE feature dataset with Python in 10.1 fails

JoseSanchez — Wed, 03 Jul 2013 10:46:45 GMT

Hi,

I am copying from ArcSDE 9.3 to ArcSDE 10.0. But before copying a new feature dataset I delete it, and when I delete it, if it has topology it shows the error message when running the script in ArcGIS 10.1 only.

The script works fine in ArcGIS 10.0 or ArcGIS 9.3.

Thanks

Re: Deleting a SDE feature dataset with Python in 10.1 fails

NathanHeick — Fri, 13 Dec 2013 20:00:08 GMT

I am getting the same problem in ArcGIS 10.1 SP1 with the same version of ArcSDE. If I create a topology and delete it using the Delete tool in a model, I get the same error. The tables are created by the topology and are deleted by the tool, but an error is still raised.

Deleting topology C:\GIS\DatabaseConnections\SDEDEV\arc@SDEDEV.sde\ParcelFabricStaging\pfsCadastralCenterlineTopology...
Failed to delete topology C:\GIS\DatabaseConnections\SDEDEV\arc@SDEDEV.sde\ParcelFabricStaging\pfsCadastralCenterlineTopology.
Traceback (most recent call last):
File "C:\GIS\ETL\Python\DropTopology.py", line 34, in <module>
arcpy.management.Delete(topology)
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
][ARC.T_1_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][ARC.T_1_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][ARC.T_1_PointErrors]]
Failed to execute (Delete).

Re: Deleting a SDE feature dataset with Python in 10.1 fails

WilliamCraft — Fri, 13 Dec 2013 22:14:34 GMT

After re-reading through all of this thread, I'm wondering if the permissions here might be the problem. For the two posts showing the Oracle error, the message indicates that the tables can't be found. This is typically the case when the user account accessing the database can't "see" the tables because it does not have SELECT permissions on those tables or isn't assigned to a role that does either. This leads me to ask the question: which user account is embedded within your SDE connection files when connecting to the Oracle geodatabase via your script? Is it the SDE user, the schema owner (i.e., MDC or ARC), or some other user account? If it is not the schema owner that is attempting the delete operation, that could the the problem right there. Also, while the SDE user account should technically be able to see the tables, I don't think it would have rights to delete objects in another user-schema besides its own (unless the SDE user had a DROP ANY TABLE system privilege). So, could you check to see if the user account specified in your connection file is the data owner or something else?

Re: Deleting a SDE feature dataset with Python in 10.1 fails

JoseSanchez — Sun, 12 Dec 2021 08:10:28 GMT

In Pyhon version 10.1 you must check if the layer exits otherwise it gives you an error.

if arcpy.Exists ....

# Check for existence of data before deleting
#
if arcpy.Exists("roadbuffer"):
    arcpy.Delete_management("roadbuffer")

Re: Deleting a SDE feature dataset with Python in 10.1 fails

NathanHeick — Thu, 02 Jan 2014 21:21:08 GMT

Responding to the last two questions, the account being used to delete the topology is the data owner. Also, I had already checked to see if the topology existed before deleting it.

Thanks,
Nathan

Re: Deleting a SDE feature dataset with Python in 10.1 fails

NathanHeick — Thu, 02 Jan 2014 23:11:19 GMT

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.

Re: Deleting a SDE feature dataset with Python in 10.1 fails

NathanHeick — Thu, 02 Jan 2014 23:14:48 GMT

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.