topic Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t in Data Management Questions

[MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table

JoseSanchez — Thu, 20 Jun 2013 18:51:15 GMT

Hi all

How can I check the PolyErrors table in SDE?

Thanks

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

VinceAngelo — Thu, 20 Jun 2013 19:10:01 GMT

ArcSDE doesn't have a PolyErrors table.

Some other application may create one, but you may need to search in a forum
for that application for more information.

- V

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

JoseSanchez — Fri, 21 Jun 2013 13:26:23 GMT

Hi,

If the feature dataset has topology these are tables that store topology.

I copied the same feature dataset to a Personal Geodatabase, opened access and here they are the tables:
- T_1_DirtyAreas
- T_1_DirtyAreas_DirtyArea_Index
- T_1_LineErrors
- T_1_LineErrors_Shape_Index
- T_1_PointErrors
- T_1_PointErrors_Shape_Index
- T_1_PolyErrors
- T_1_PolyErrors_Shape_Index

The question is why ArcGIS 10.1 does not allow to delete these tables using the Model Builder or Python?

It works when using the same model builder or python in ArcGIS 10.0 or in ArcGIS 9.3.

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

VinceAngelo — Fri, 21 Jun 2013 18:21:10 GMT

What with the deprecation of ArcSDE at 10.2, we all need to start using current
terminology to keep things straight. You've got a 10.1 SP? geodatabase in
Oracle ??gR? (?.?.?.?), and you've got a model that operates on a topology,
and when you execute ? it generates an error.

Are you explicitly deleting tables in the model? Did the tables exist before
running the model? Do they still exist after the model is run? Is there anything
else done before the DROP requests are made which may be deleting the
ancillary tables?

At some point soon you'll probably need to talk to Tech Support about this.

- V

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

JoseSanchez — Mon, 24 Jun 2013 10:45:48 GMT

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

>>>

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

VinceAngelo — Mon, 24 Jun 2013 12:19:49 GMT

"11G" is not a release of Oracle, it is a family of releases. Heck, it's *two* families
of releases. When you post in the Forums, please provide the *exact* release, so
those who would help you know what you're working with (the extra question marks
were meant to be filled in with exact values).

Since this one topic is now spanning two threads, it's time to call Tech Support.

- V

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

JoseSanchez — Sun, 12 Dec 2021 02:01:55 GMT

Hi,

We are using: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 27 08:10:57 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

VinceAngelo — Thu, 27 Jun 2013 11:43:29 GMT

You seem to be using both 11.2.0.1 *and* 11.2.0.3. It's usually wise to keep
your client release at the same version of the server, or higher. Lagging behind
on the client can cause issues, though not related to the other problem.

- V

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

JoseSanchez — Fri, 28 Jun 2013 18:03:54 GMT

So you mean that we need to update the Oracle client software to the same release of Oracle server?

Regards

You seem to be using both 11.2.0.1 *and* 11.2.0.3. It's usually wise to keep
your client release at the same version of the server, or higher. Lagging behind
on the client can cause issues, though not related to the other problem.

- V

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

VinceAngelo — Fri, 28 Jun 2013 19:01:56 GMT

Yes, that would be best practice. You can generally upgrade the clients
before server, so a 11.2.0.3 client would be fine with a 11.2.0.1 server.

- V

Re: [MDC.T_1190_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: t

JoseSanchez — Sun, 12 Dec 2021 02:01:52 GMT

Trace shown by the Model builder that removes the feature dataset in 10.1

This same model builder works in ArcGIS 10.0 or ArcGIS 9.3. Also it works ArcGIs 10.1 when deleting forma file geodatabase or a personal geodatabase.

Could it be a bug in ArcGIS 10.1 when deleting a feature dataset with topology in SDE?

Executing (Delete): Delete "Database Connections\Dsde33 SDER.sde\SDER.PsBasin" FeatureDataset
Start Time: Fri Jun 21 12:44:23 2013
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_PointErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_PolyErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_LineErrors]] DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_PointErrors]] 
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_6_LineErrors]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_7_LineErrors]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_7_PointErrors]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_7_DirtyAreas]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_6_PolyErrors]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_7_PolyErrors]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_6_PointErrors]
Table not registered [ORA-00942: table or view does not exist
] [SDER.T_6_DirtyAreas]
Table not registered [ORA-00942: table or view does not exist
] [SDER.PSBasinWithoutVolumeCustomer]
Table not registered [ORA-00942: table or view does not exist
] [SDER.PumpStationBasin]
Table not registered [ORA-00942: table or view does not exist
] [SDER.PumpStationBasinOrig]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.PumpStationBasinOrig]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_PolyErrors]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_LineErrors]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_PointErrors]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_7_DirtyAreas]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_PolyErrors]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_LineErrors]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_PointErrors]]
DBMS table not found [DBMS table not found [ORA-00942: table or view does not exist
][SDER.T_6_DirtyAreas]]
The item was not found.
The item was not found.
Failed to execute (Delete).
Failed at Fri Jun 21 12:45:42 2013 (Elapsed Time: 1 minutes 19 seconds)