Latest Contributions by JoseSanchez

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> ... View more

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

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

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

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. ... View more

Found this solution: http://forums.arcgis.com/threads/86402-Desktop-Console-Applicaiton-does-not-close-window-in-10.1 ... View more

Thank you for your answer Domenico.  But how do you fix the problem of the Console Window that does not close when running the application as a stand alone .exe with STA instead of MTA?  Is there a solution using STA in 10.1 or is it a bug? Regards But remember that: In the Single-Threaded Apartment (STA), a single thread is dedicated to execute the methods of the object. In such an arrangement, method calls from threads outside of the apartment are marshalled and automatically queued by the system (via a standard Windows message queue). Thus, the COM run-time provides automatic synchronization to ensure that each method call of an object is always executed to completion before another is invoked. The developer therefore does not need to worry about thread locking or race conditions. In the Multiple Threaded Apartment (MTA), the COM run-time provides no synchronization, and multiple threads are allowed to call COM objects simultaneously. COM objects therefore need to perform their own synchronization to prevent simultaneous access from multiple threads from causing a race condition. Calls to an MTA object from a thread in an STA are also marshaled. and model ArcObjects threading model: http://resources.esri.com/help/9.3/arcgisengine/dotnet/2c2d2655-a208-4902-bf4d-b37a1de120de.htm As an ArcObjects developer, this means that if your application is not initialized as a single threaded application, the .NET framework will create a special single threaded apartment (STA) thread for all ArcObjects since they are marked as STA. This will cause a thread switch to this thread on each call from the application to ArcObjects. In turn, this forces the ArcObjects components to marshall each call, and eventually it may be about 50 times slower for a call to the COM component. Fortunately, this can be avoided by simply marking the main function as [STAThread]. ... View more

Changing the type of thread in the source code from STAThread  to MTAthread worked. http://support.microsoft.com/kb/828988 ... View more

http://resources.arcgis.com/en/help/arcobjects-net/conceptualhelp/index.html#//0001000002ns000000 ... View more

Hi all It looks like this code does not work in 10.1, at least it does nto close the console window when running a program created withVS 21010, ArcGIS 10.1 and .Net 3.5. [C#] namespace ConsoleApplication1 {   class Program   {     [STAThread]     static void Main(string[] args)     {        // ...     }   } } ... View more

It is a bug: http://connect.microsoft.com/VisualStudio/feedback/details/570166/visual-studio-2010-keeps-enabling-client-application-services-for-my-project ... View more