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)

3
votes
0answers
111 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 ...
0
votes
1answer
87 views

How to Import Metadata of feature classes with them into ArcSDE?

I have a database that has numerous feature classes of different types. None of these feature classes have metadata. I understand that when you import feature classes to a database, the metadata ...
1
vote
1answer
69 views

Error occured during Geodatabase compressing

When I am doing geodatabase administration in ArcSDE on an Oracle Database, the following error pops up when I run the compress tool ORA-00604: error occurred at recursive SQL level 1 ORA-01000: ...
1
vote
2answers
151 views

ArcSDE installation; “sdesetup: command not found”

I am trying to install ArcSDE component for postgresql database from A DVD file. I have copied files of following folders on the server : command_64 pg_64 in both of theses files there are ...
1
vote
1answer
181 views

enabling feature access without installing ArcSDE 10.1?

Is there any way to enable "feature access" when publishing a map using ArcGIS 10.1 server, without installing ArcSDE?
1
vote
0answers
68 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
0
votes
1answer
237 views

ArcGIS 10.1 Database Connection vs ArcSDE [duplicate]

I think one of the best capabilities of ArcGIS desktop 10.1 and 10.2 is Database Connection. Users can connect to every Database servers without using Middleware(ArcSDE) . You can Distribute, manage ...
3
votes
1answer
205 views

Triggers for delta tables

I have been facing an issue to capture the delta updates on SDE. We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
4
votes
1answer
302 views

How to Keep Database and Server Connections active

It seems like everyday I go to publish a service or connect to my SDE I get messages that I can't connect. It is particularly annoying when trying to publish a service to ArcServer. The connections ...
3
votes
2answers
60 views

arcgis desktop selection layer

I have Desktop 10.1 that is accessing data from sde geodatabase. I select some features on the map, and try to do "Create layer from selected feature" but nothing happen, and no error message. the ...
3
votes
1answer
900 views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
0
votes
0answers
146 views

Arcpy - change layer from sde connection to file geodatabase

We are copying data from our corporate office to field offices and we are creating a file geodatabase at these field offices. We are copying the layers that point to sde and they need to point to the ...
4
votes
1answer
182 views

Scheduled Task - calling python through BAT

I'm using ArcGIS 10.1 and setting up some scheduled tasks to run on our server. I am calling a python script in a .bat file. When it runs, the connection to our SDE database is "invalid" or do not ...
0
votes
2answers
418 views

connection from ArcMAP to Postgresql, Is ArcSDE required?

I wan to make a direct connection form Arcmap to Postgresql. I have ArcGIS for Desktop 10.1 on windows (64bit). So I need to put "pg_client_windows64" libraries in C:\Program Files ...
1
vote
0answers
102 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
1
vote
2answers
137 views

ArcReader 10.1 trouble (loading and printing is taking very long ime)

We've run into printing problems in ArcReader 10.1. Our trouble is with a particular floodplain feature class located in an SDE database. It simply takes forever to load! Then, when printing, it takes ...
0
votes
0answers
79 views

Error when deleting field in arcgis: “Table contails a column type not allowed in versioned views”

Something messy :) happened to my geodatabase. When I'm trying to delete a field in ArcMap I get this message: * "Failed to delete the selected field. Table contains a column type not allowed ...
0
votes
0answers
79 views

zonal statistics from mosaic dataset

I'm trying to to do the following: def calcZonalStatistics(raster): # Set environment settings arcpy.env.workspace = r"C:\MyFileGDB.gdb" # Set local variables inZoneData = "Database ...
1
vote
2answers
88 views

SQL: Select aggregated Bounding Box of multiple Features

I would like to calculate the aggregated bounding box of multiple features using OGC Simple Feature SQL or SQL API of ArcSDE. The following statement will only query the bounding box of each feature: ...
2
votes
0answers
33 views

How to know Who is reconciling the Version to DEFAULT(Parent) in Geodatabase

We have Public DEFAULT version and working Versions(Child) have been created directly from DEFAULT. We have also provided Reconcile-Post Option to group of Users placed at separate locations. Hence ...
0
votes
1answer
103 views

How to delete raster dataset from sde base programmatically

I use sde database, registered with ArcGis Server 10.1. Sde connection is direct. Database container is postgres. There is a raster dataset in this sde base. I can open this sde database ...
1
vote
2answers
971 views

ArcSDE 10: How to read/write to Oracle with ST_GEOMETRY using Java

I found the following in the deprecation plan of ArcGIS 10.2: ArcGIS 10.2 will be the last major release to support the ArcSDE SDK with the ArcSDE C and Java APIs. Today many other options are ...
3
votes
1answer
2k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
2
votes
2answers
371 views

How to Register a Spatial View when ArcSDE is direct connect only?

I have an ArcSDE 10.0 set up with MS SQL 2008 R2 Database, on direct connect. There is no service running, nor installed. I have created a spatial view built on a couple of tables. I have followed ...
0
votes
1answer
754 views

ArcGIS for Server 10.1 (including ArcSDE) and SQL Server 2012 problem with Create Enterprise-Geodatabase

i have the following server system: -Windows Server 2008R2 -SQL Server 2008 (SDE10 Enterprise Geodatabaees) and SQL Server 2012 on the the same machine -ArcSDE Application Server 10 First - Is that ...
1
vote
2answers
378 views

Create a One-to-Many Spatial View with ArcGIS 10.1

We have two datasets: parcels and owners. This is a many-to-many relationship, where a parcel can have multiple owners and there may be multiple properties on a single parcel (also with multiple ...
6
votes
1answer
378 views

Is this possible with ArcGIS using replication?

I work for a telecom company dealing with fiber management. We have a sister company south of us who we share some fiber and fiber equipment with. Both of us will be using ArcSDE databases. We want ...
0
votes
1answer
126 views

Is there a way to change environment settings of a dataset without creating a new one?

I am trying to change the environment settings of an existing dataset. I found a workaround by first changing the environment settings in the SDE-database and then create a new dataset with now ...
5
votes
2answers
1k views

How to copy an SDE geodatabase to a file geodatabase using Python?

I would like to make an exact copy (domains, feature datasets, feature classes, etc.) of an SDE database to a file geodatabase. I have tried several possibilities, including: using the Copy (Data ...
1
vote
1answer
355 views

Feature Access ArcGIS 10.1 Registered Database Publishing Error

I created a feature class from an XY table in ArcCatalog, and I am trying to publish a feature access enabled map to my server. When I try, I keep getting a 00090 error which is "feature service ...
0
votes
1answer
86 views

How to Avoid Object ID conflicts in Versioned geodatabase

We have just implemented a versioned Geodatabase and our schema has few feature classes and relationship classes. We do not Reconcile and Post to the parent ( Default) version, as we need some ...
1
vote
0answers
206 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
1
vote
1answer
284 views

Has anyone experienced problems editing between ArcGIS 10.1 and an older ArcSDE geodatabase 9.3.1?

We are unable to edit feature classes in an ArcSDE 9.3.1 Versioned GDB using an ArcGIS 10.1 .mxd map. The feature classes are part of a geometric network. Previously we were able to edit feature ...
1
vote
1answer
164 views

updating a feature class from an EXCEL spreadsheet

I created feature classes that only contains the data from an EXCEL file. I did this to enable the search function to search the data in these tables. The FCs also have relationships between ...
0
votes
0answers
125 views

Why does Append on large annotation layer give WARNING 000594: Input feature falls outside of output geometry domains?

I am trying to Append about 3,000,000 records in an annotation layer to another, empty annotation layer. I'm using ArcCatalog and I get the following error messages: WARNING 000594: Input feature ...
2
votes
1answer
209 views

How can you tell if a RDBMS is an ArcSDE Geodatabase?

I want to know if there is any way I can query the RDBMS to determine whether it is an ArcSDE Geodatabase, or if I have to do it through ArcObjects. I am wondering if it would be enough to check if ...
1
vote
1answer
114 views

SDE Versioned Data Editing Problem

ArcMap is telling our users that data from a certain feature dataset needs to be registered as versioned to edit. ArcCatalog is showing us that the feature dataset in the SDE is not registered as ...
0
votes
2answers
165 views

Cannot register a Feature dataset

I am having an issue trying to register a dataset, and being able to edit a featureclass within it. I am new to SDE so please bear with my explanation. I read online you cannot register a feature ...
0
votes
0answers
113 views

While Exporting from SDE, null geometry features attack?

I'm working on a layer in an SDE Database (ArcMap 10.1 SP1 for desktop (Build 3143)), I just export to a local working database on my workstation the layer I want to work on and load it back when ...
2
votes
1answer
1k views

What is the difference between ArcSDE and ArcGIS Server?

I have been working with ArcGIS Desktop where I use ArcMap for doing GIS work. Can anyone please explain to me in simple words What is ArcSDE and ArcGIS server? These can be independent dedicated ...
2
votes
1answer
121 views

Renaming shapefiles with prefix while running arcpy.FeatureClassToGeodatabase?

I'm fairly new to the arcpy world. I am trying to create a script in 10.0 that will load a dataset (file geodatabase) into ArcSDE and rename the feature classes with a prefix, i.e. San_Diego_Bay -> ...
1
vote
1answer
174 views

How to Change the schema of SDE dataset in Connected environment

We continuously use to receive changes in Schema ( field +/-, domain changes etc ) for our Utility dataset.. Since we have swicthed to a multiuser Geodatabase ( ArcSDE on Oracle ) , we would like to ...
0
votes
0answers
87 views

SDE Replication works through ArcMap but not through ArcCatalog

I'm running 10.1 on a 10.0 SDE database. We're trying to replicate our database (one-way parent to child) to a file geodatabase. Ideally I'd like to have this automated using python or .bat files but ...
3
votes
1answer
110 views

How to get any changes happened in the current SDE version?

How to get any change done on the map in the current version of sde. using arcObjects e.g. if i had a line on the map. and in the current sde version i changed the length of that line. how to get this ...
1
vote
0answers
92 views

How to display labels from many-to-many relationship in ArcGIS 10 using VB.NET?

I have two tables in a geodatabase: parcel; and person 1 or + parcel, can have 1 or + person (relationship is many-to-many) Using VB.NET I can display all the parcel labelled with the ...
3
votes
1answer
649 views

Python: Change SDE data source for mxds in specific folder

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 ...
2
votes
2answers
329 views

Understanding ArcGIS Server connection types

Being relatively new to ESRI ArcGIS Server I have a question regarding the storage of ESRI SDE Databases - AGS 10.0 Enterprise and ArcSDE 9.3. Firstly the naming of the whole structure gets ...
1
vote
1answer
137 views

arcpy update cursor: can't connect to a database table

I am using updateCursor to retrieve some rows from a non spatial table using a connection of type "Spatial Database Connection" (That creates a .sde file) from ArcCatalog. However, it doesn't work, ...
3
votes
3answers
239 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: ...
0
votes
0answers
167 views

Export From PGDB to ArcSde Using C#

I need help exporting a personal geodatabase Feature Class to an ArcSDE geodatabase using C# ArcObjects with ArcGIS 9.3. I just want to replicate the tool Feature Class to Feature Class ...