Environment:
- ArcGIS 10.1 SP 1
- ArcSDE 9.3 or 10.0
- Model Builder, Python or VB.net
- Oracle 11G
I have a script that copies several feature datasets from one SDe instance to another SDE instance.
This is the process:
- delete feature datasets
- copy feature datasets from one SDE instance to anothr SDE instance.
Scenario ArcSDE database in 9.3 or 10.0 empty
- copy layers works
Scenario ArcSDE database in 9.3 or 10.0 with feature datasets
- delete feature datasets
- if the feature datasets does not have any topology it works
- if the feature dataset does have topology it fails
Same Python script runs fine in a workstation with ArcGIS 10.0.
Answers to your questions.
You've got a 10.1 SP?
Yes I am working with ArcGIs 10.1 SP 1
Geodatabase in Oracle ?
Yes it is Oracle 11G
A you've got a model that operates on a topology, and when you execute ? it generates an error.
It generates an error only when I try to delete the feature dataset that has topology. The copy works fine.
Are you explicitly deleting tables in the model?
No, I only delete feature datasets.
Did the tables exist before running the model?
When you copy a feature dataset with topology it creates all the associated tables listed above
Do they still exist after the model is run?
After the model it run, the feature dataset is not in SDE anymore, it looks like it deletes it, but it shows an error.
Is there anything else done before the DROP requests are made which may be deleting the ancillary tables?
No, nothing is done before.
This is the code I am testing:
# 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).
>>>
