Use this tag for questions about the ArcSDE (Spatial Database Engine) component of Esri's ArcGIS for Server that is one way to enable access to spatial data stored in a Relational Database Management Systems (RDBMS).

learn more… | top users | synonyms (1)

4
votes
3answers
777 views

ArcSDE command registration issues

I have an ArcSDE 10.0 enabled SQL Server 2008 R2 database on a development server. We are using TeamCity to run continual deployment to this development server, which runs through the following steps: ...
4
votes
1answer
171 views

Attribute Indexes ArcSDE 9.3.1 for Attribute Joins on GUID field types

I create my joins on primary/foreign keys that are guids...I don't seem to be able to create an index on this field in my target table. After joining to this table it takes 4 minutes to open the ...
4
votes
1answer
1k views

How to insert DateTime null using IRowBuffer

I am using IRowBuffer/IFeatureBuffer to insert fields to SQL Server 2008 DB. When inserting a field I am using: public void SetValue(IRowBuffer buffer, string field, object value) { int ...
4
votes
2answers
2k views

ArcSDE 10.0 giomgr Error During Post Install

I just installed ArcSDE 10.0 and ran the post install once to test the install and it ran great. Today I tried to run another post install to create another database and I get the error: "Parameter ...
4
votes
0answers
156 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
4
votes
3answers
132 views

Migrate datatypes from geometry to geography in MS SQL

I have three ESRI feature classes (POINT, LINE and POLYGON) that contain a geometry datatype column with data in a projected coordinate system. I'm looking for a way that I can convert & project ...
4
votes
0answers
68 views

Save edits before disconnecting users from enterprise geodatabase?

Is there any method that enables the Administrator to save the users edits before disconnecting them for an enterprise geodatabase. Because I am disconnecting users as shown in the screenshot, but ...
4
votes
0answers
116 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
4
votes
0answers
242 views

How to repair Geometric Network in Versioned ArcSDE Geodatabase?

Our Versioned ArcSDE workflow has a feature dataset with Geometric Network in the parent (Default), which users derive in their own versions. It is now observed that in some versions, the geometric ...
3
votes
3answers
567 views

Can ArcGIS Server be called ArcSDE? I'm confused about terminology

I'm confused about some ESRI terminology. If I have ArcGIS 10.1 Server installed and we use Enterprise geodatabases with versioning capabilities but we use direction connections does this have ...
3
votes
3answers
2k views

Tracking change with ArcSDE/Oracle

I'm looking for the simplest way to track changes ([delete, update, create] feature(s)) made to the DEFAULT version of a given feature class in ArcSDE(10) and Oracle(11g). Qualifier: I am not a dba ...
3
votes
2answers
155 views

Can feature classes have the same name in two different feature datasets?

I have an SDE Database called "Vector" which contains many feature datasets eg. Region_1, Region_2 etc. I have to reproject the feature classes inside these datasets. Instead of creating a new ...
3
votes
2answers
2k views

ListFeature classes in SDE

I have this code: def backSDE(ActiveSDE): arcpy.env.overwriteOutput = True arcpy.env.workspace = ActiveSDE fcs = arcpy.ListFeatureClasses() print fcs #Databases ActiveSDE = r"C:\...
3
votes
3answers
1k views

Cause of selected [ArcSDE 10] feature dataset does not contain any feature classes which can participate in topology?

When trying to create a topology for a polygon feature class in ArcSDE 10. I right click the feature dataset that the feature class resides and try to create a new topology. I get an error saying, "...
3
votes
3answers
975 views

Transfering a lot of features from geodatabases?

I'm having a problem where I need to export a large amount of content from 2 geodatabases of different nature (SDE -> File). I have three options: Spatial Select, a regular SQL select and the full ...
3
votes
2answers
433 views

Visualize feature class with many relationship classes?

I have a feature class in a geodatabase that I want to review. It has many relationship classes - possibly a hundred or more. If I load the feature class into ArcMap and identify one of the features,...
3
votes
1answer
2k views

ArcSDE desktop license

I am using the ArcGISDesktop student license. I want to work on versioning and geodatabase replication. Is it possible to set up ArcSDE with the same license and work on versioning and replication?
3
votes
2answers
709 views

ArcSDE database connection strings for ArcCatalog

Anyone know where the Database Connection strings are located in Program Files for ArcCatalog? I have all my Database Connection strings fixed and all my scripts use them. My computer went down and ...
3
votes
3answers
1k views

Repair/Check for empty geometry in ArcSDE?

I understand that the standard validation/repair tools are not for use with ArcSDE and that ESRI needs to fix this, but are there work-arounds for at least checking where there might be empty geometry ...
3
votes
2answers
752 views

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

I recently imported a feature class from a File Geodatabase to an Oracle SDE Geodatabase. The features of the two feature classes now look drastically different despite not having any edits made. ...
3
votes
1answer
2k views

How to get all the FeatureClasses from IWorkspace?

Well i create a Geodatabse in my SQL Server using ArcCatalog then i create 5 new FeatureClass, i want to get all the FeatureClasses in this GDB, this is my function to get all the FeatureClasses from ...
3
votes
1answer
354 views

How can I validate a table name on SDE with Oracle backend?

Second title: "Is arcpy.ValidateTableName broken on Oracle?" I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
3
votes
1answer
4k views

Where is connection file used to connect ArcMap to ArcSDE?

In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008? Some non administrative users are hooking up to SDE as the user 'sde' with db ...
3
votes
1answer
2k views

Using primary keys with ArcSDE (Oracle)?

Is it possible, more advisable to assign a primary key to the OBJECTID column in a featureclass in SDE. I am using Oracle and some of my flat tables (junction tables) need to SEE a primary key in the ...
3
votes
1answer
923 views

Schema locking logistics on ArcSDE for SQL Server?

I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks. I have a interpretable ...
3
votes
1answer
38 views

What are SRIDs like 30008 in an SDE geodatabase?

When I look at the SDE.ST_GEOMETRY_COLUMNS table of my SDE database I'm seeing mostly recognizable four-digit values, but a number of columns have SRIDs like 300006, 300008, and 300047. I can't find ...
3
votes
1answer
105 views

SQL Spatial select record where intersects another record

I have two tables - 'Tree' (point) and 'ServiceArea' (polygon) in the GIS database. Trying to select all Tree records that intersect a ServiceArea where the value in Tree.ServiceAreaNumber field ...
3
votes
2answers
370 views

How to get size of SDE geodatabase feature class

Is there a way in catalog or arcpy to determine the amount of hard drive space a SDE feature class takes up on disk? In catalog the 'size' column is blank and Esri help states: The size, ...
3
votes
3answers
2k views

How to connect QGIS to an Oracle DB (SDE)?

I want to access an Oracle Database (with SDE) from Qgis 2.4. I have tried many different options from within the window Create a new Oracle Connection but I always get an error message (ORA-12514: ...
3
votes
1answer
126 views

Reconciling vertex modification conflicts in Geodatabase Versioning?

Is it possible to edit the same feature in ArcSDE in two different versions ... and reconcile/post version A's edits to the parent, ... and then reconcile/post version B's edits of same feature, ...
3
votes
1answer
2k views

Creating empty feature class in file geodatabase based on schema of ArcSDE feature class?

I have 150+ feature classes in SDE for which I need to create an empty feature class in a file geodatabase. For these feature classes I need to import the attributes and the name of the feature class ...
3
votes
2answers
1k views

Creating Python script to reconcile/post geodatabase versions?

I’m trying to set up a python script so that I can schedule our rec/post to run on a server. I’ve created a model with the Reconcile Version tool, with the option to Post checked on. I then export ...
3
votes
1answer
1k views

Editing with ArcGIS API for Silveright?

I am using the ArcGIS Silverlight API to edit data in an ArcSDE SQL Server geodatabase. I have been told that any editable feature classes must be registered as versioned in ArcCatalog before they ...
3
votes
2answers
359 views

Transforming coordinate that lies outside a grid transform (e.g. NADCON)?

As I understand it, a datum transform (e.g. urn:ogc:def:coordinateOperation:EPSG::1241) based on a grid interpolation method, e.g. NADCON, is undefined outside of the grid of points. Therefore the lat/...
3
votes
1answer
69 views

Get the geometry type of an empty ArcSDE feature class

I'm trying to use raw SQL to get the geometry type (e.g. POINT, LINESTRING, POLYGON) of an Oracle ArcSDE feature class using the ST_Geometry spatial type. If I run SELECT SDE.ST_GeometryType(SHAPE) ...
3
votes
1answer
99 views

Deleting Oracle SDE features classes properly

I have got a few feature classes in an SDE connection. This is the situation: a) They are listed in ArcCatalog (10.1), but the open fails. The message says: 'Error opening feature class, DBMS table ...
3
votes
1answer
63 views

Incremental Network Loader failing with ArcSDE Geometric Network

I've been testing the Incremental Network Loader tool for loading new lines into a geometric network from an outside feature class. The tool worked perfectly on a File GeoDatabase copy of our SDE. ...
3
votes
1answer
65 views

Linking file geodatabase and ArcSDE?

My office does a lot of field work where we log points via the Collector app. Those points are then always exported to a geodatabase feature class for further editing and analysis. If edits and ...
3
votes
1answer
190 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
3
votes
2answers
135 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...
3
votes
1answer
305 views

Changes not persisting in ArcGIS server from ArcPy script

I have a ArcPy script (10.2) which connects to an ArcGIS server (10.0) versioned geodatabase, via an .sde connection file in the Database connections directory through direct connect on a Microsoft ...
3
votes
1answer
408 views

Moving Versioned Data between different geodatabases

Can you please let me know how to migrate feature class which is registered as version and archiving is enabled on it From: Database Environment: ArcSDE 9.3, RHEL 5, Oracle 11.2.0.2 To Database ...
3
votes
1answer
2k views

Change ArcSDE data source for mxds in specific folder using ArcPy?

I've searched all the forums and help and have made progess but recently got an error that has thrown me for a loop - also some mxds are not being changed at all! What I'd like my code to do: Iterate ...
3
votes
1answer
404 views

Synchronizing Changes From File Geodatabase to SDE Geodatabase

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
3
votes
1answer
653 views

Is it possible to undo and redo outside edit session in ArcObjects?

I would like to know if it is possible to undo and redo changes outside of an edit session? If yes, how can I do it in ArcObjects using .NET? I am working on an ArcSDE 10.1 versioned geodatabase?
3
votes
1answer
110 views

Are there any publicly available ArcSDE Servers I can use for developing client applications

I have been asked by our client if I can add the ability to connect to instances of ArcSDE servers from our desktop application. I am sure that we can do this a number of different ways, what I was ...
3
votes
3answers
498 views

Creating feature dataset by pgAdmin (PostgreSQL) that can be useD in ArcSDE connection?

How to create feature dataset in PostgreSQL (pgAdmin) that can by use in ArcSDE conection (ArcGIS)?
3
votes
1answer
809 views

Duplicate ObjectID in ArcSDE Table

After making a check in from an arcpad AXF file, i notice that there's duplicate ObjectID records. This ArcSDE PostgreSQL table is versioned and edited by Axf checkins and a .net engine application. ...
3
votes
1answer
589 views

Spatial Database Connection String

From MS Access, I'd like to create a link to the attribute table of an SDE feature class in a spatial database. For example, I have the following connection string which works for an OLE DB ...
3
votes
1answer
2k views

Can ArcPy test for availability of SDE Connection before trying to use it?

In a Python script that I use to publish ArcGIS 10.0 Geoprocessing Services I have some code: arcpy.AddMessage("If process hangs here, check for ArcSDE connections issue by trying to open " + mapFile ...