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)

6
votes
3answers
353 views

How do I retrieve a feature outside of ArcSDE into an IFeature in ArcObjects?

I would like to be able to use Entity Framework with a repository pattern for non-spatial querying of my SDE Sql Server database. I was hoping to reverse code-first engineer the database with the ...
0
votes
0answers
8 views

Custom editor tracking field not in select list

We have a versioned sde database in ArcGIS 10.3.1 and Oracle on the back end. And we have features with editor tracking turned on based on customized editor tracking fields, such as "CREATEDWHO","...
2
votes
0answers
49 views

ESRI ArcMap 10.0 Not Compressing

We have ESRI ArcMap 10.0 (build 4400) ArcGIS Desktop 10 Service Pack 5. SQL Database 10.0.4000. We are trying to Compress our Versioned tables but for some reason it's not pulling the changed records ...
0
votes
0answers
10 views

Loading Data into a Versioned SDE Environment

Our set-up: Database connections: Sde.sde – gdb admin Gis.sde – data owner User1.sde – data user User2.sde – data user User3.sde – data user We have a versioned environment Our current Version ...
0
votes
1answer
61 views

How to update coordinates in a geodatabase with FME?

I have an excel file of points which are resurveyed with updated Coordinates.Now I want to update my existing arcsde geodatabase. How can i update only coordinates in FME?
2
votes
1answer
116 views

Running GISquirrel next to ArcSDE?

My company has ArcSDE to run our webmapping system. We want our ArcGIS for Desktop Basic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can ...
5
votes
1answer
53 views

Finding SDE permissions on feature class using ArcPy?

I am writing an arcpy script where an SDE feature class is removed then recreated. I need to set permissions on the recreated feature class that match the permissions before it was removed. Is there ...
1
vote
1answer
317 views

How to disable spatial index creation by ArcSDE for Oracle Spatial

Working with arcsde 10.1 and oracle spatial 11g. I set the feature class in load_only_io before loading shape files. I am using geoprocessing tool (append) in arcgis to load shape file to ...
0
votes
0answers
86 views

Unable to save edits. The requested operation is invalid on a closed state [State_id=3411]. Arcgis 10.4 oracle 11g

Recently updated our system from Arcgis 10.3 to 10.4 (both client and server side). When trying to edit my versioned arcsde oracle database following error appears: Unable to save edits. The ...
0
votes
0answers
16 views

Date Field Changes When Uploaded to ArcServer then ArcGIS Online

I have a feature class in my SDE, that is archive enabled, and has Object ID's. I also has a field within it (fieldtype=DATE, fieldname=ProjectedDate), that is configured (mm/dd/yyyy). When I ...
0
votes
0answers
8 views

Feature layer issue in Portal for Arcgis

Recently I installed Portal for ArcGIS 10.2.1 with web adapter. And after publishing a map service to my ArcGIS server and then adding it as a layer in my Portal's content, I cannot edit this layer ...
2
votes
1answer
279 views

Table doesn't match base table schema in Geodatabase Versioning?

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 sde....
0
votes
0answers
34 views

ReplaceDataSource of SDE layers in map documents (mxd) with old feature classes newly organized under feature datasets in the same ArcSDE

I need some help to replace the data source of old SDE layers in the map documents. The replaceDataSource method in the code below is not working properly resulting in a broken link of the target ...
-4
votes
0answers
57 views

Create enterprise geodatabase errors

When I Create Enterprise Geodatabase using toolbox in ArcCatalog it errors below. also I create database in SQL server then I add geodatabase connection to arccatalog but when I enable enterprise ...
1
vote
1answer
185 views

Using ArcPy to query ArcSDE geodatabase?

I have three variables: view_name, column_name, and column_content. column_name contains id, name, address, etc. column_content contains 123, John, 200 King st, etc. user specifies the column_name ...
0
votes
1answer
42 views

Conflicts in ArcMap editing with multiple users

There are multiple users of ArcMap using their own versions for uploading edits to our Master database. We are not live editing, these edits are reconciled and posted each day, sometimes twice in one ...
-3
votes
1answer
52 views

Code Works in Python Window but not Script

This code successfully completes inside the ArcMap Python window but fails as a script with identical code in a toolbox. The source data is a collection of feature classes directly inside an ...
1
vote
1answer
31 views

Using non-unique names for attribute indexes of file/ArcSDE geodatabases?

I am using ArcGIS 10.2.2 for Desktop. Within a file geodatabase does an attribute index name need to be unique? I thought that it did, but I have not been able to find any documentation to say ...
3
votes
1answer
32 views

SQL for spatial view of line start/end points (Oracle ST_GEOMETRY)

How do I create a spatial view that generates dynamic point geometry of the start point and end point of a line feature class? The environment is Oracle, SDE 10.3.1. I have successfully made a ...
0
votes
1answer
43 views

Automate the un-registering of replica

I'm working on an arcpy script that removes a feature class and then recreates it. The feature class is part of a replica, and I need to recreate the replica as part of the script, however you cannot ...
0
votes
1answer
524 views

Direct connection from geotools to arcgis 10.3

Is it possible to direcly connect to ESRI 10.3 database using geotools ? I use geotools 13.0 and have ESRI database set up on oracle. Previously I was able to connect to SDE using gt-arcsde-plugin ...
0
votes
1answer
191 views

How do I find out when a shapefile was created?

I am working on a project at an agency with a large amount of prior data stored in a shared database connection .sde folder to which I have access. While this is incredibly helpful, I would like to ...
3
votes
1answer
663 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?
24
votes
8answers
8k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
4
votes
1answer
107 views

Error when using arcpy.ArcSDESQLExecute() to connect to SQL Server - ArcGIS 10.4

I am able to connect to a MS SQL Server 2012 geodatabase with the arcpy.ArcSDESQLExecute() when using the .sde connection file pre-created in ArcGIS. I am not able to connect to a MS SQL Server 2012 ...
7
votes
0answers
268 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE 9....
1
vote
1answer
31 views

I can not add geodatabase connection from another PC to SQL server 2014

I have a problem. I can not solve it. I did everything what I think. I install SQl server 2014 and create Test1 database on My PC. Now I want to add Geodatabase connection in Arccatalog on Another PC. ...
6
votes
1answer
465 views

Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase

I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
2
votes
1answer
309 views

How to re-register a one way replica geodatabase

Long story short. Arcmap crashed during one of my regular synchronizations of a replica geodatabase created through one-way replication checkout. Upon reloading it seems to have unregistered the ...
1
vote
1answer
999 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
0
votes
1answer
146 views

How so I solve FDO error: 0? How do I get code that worked in a file geodatabase to work in an SDE version?

I used python add in to make a tool bar in Arcmap that edits features on a map. It works on a file geodatabase, but not on an ArcSDE version one. I've been getting an FDO error: 0. The potential ...
0
votes
0answers
6 views

Error found while retrieving conflicts ArcMap 10.3

I have a problem when trying to review Conflicts in ArcMap 10.3 I have found a similar question ,and in the solution there was a link to download ArcSDE service pack , but the link was invalid . ...
1
vote
1answer
17 views

ArcCatelog 9.3 feature classes with annotation relationships allowed in a geometric network

I have a gas utility dataset that we are working on getting converted into a geometric network for easier analysis. The feature classes are part of an ArcSDE and have a ton of relationship classes ...
1
vote
1answer
430 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
1
vote
0answers
43 views

Feature classes not visible to some ArcSDE users? [closed]

Some of my organization's data (several SDE databases) has been migrated to a new server and we have recently upgraded from ArcGIS 10.2 for Server to ArcGIS 10.4 for Server and SQL Server 2005 to SQL ...
0
votes
2answers
1k views

Error connecting to SDE 10.3.1 on Oracle 12c from 10.1 client

We are currently planning an server migration. We have our current server on SDE 10.1 on Oracle 11 Currently our editors are on ArcGIS 10.1 with Oracle client 11.2 Our new server is setup and ready ...
0
votes
0answers
17 views

Updating ArcSDE Database using VB.Net?

I have a master feature in a SDE Database. This Master file contains the records of all "inspections" being undertaken. I have a second feature, which contains a "live" dataset of current inspections....
1
vote
0answers
20 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
0
votes
0answers
35 views

HRESULT EXCEPTION error - Arcmap Geoprocessing .net

I am writing a script / Add-in for Arcmap and am coming unstuck with an error when I am trying to "delete identical" records in an SDE Geodatabase. Running through the process. I have a SDE ...
0
votes
0answers
25 views

bring back column info in sde descendant version

I have a feature class registered as versioned in sde with editor tracking turned on. In my edit version, I was updating one field for all records but forgot to turn off the editor tracking before ...
1
vote
2answers
209 views

Using CURRENT_DATE function on ArcSDE SQL Server Database?

I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the ...
0
votes
0answers
24 views

Querying Archive Class with REST API of ArcGIS Server?

I would like to know if there is a way to access the archive class through a Map Service of ArcGIS Server. I have a Map Service with feature class stored in a SDE GeoDatabase with Archiving and ...
10
votes
3answers
150 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
0
votes
0answers
12 views

Uploading Photos to SDE

We have several users using Collector for ArcGIS and the majority of them take pictures/videos. Once the database has been downloaded from ArcGIS Online, we’d like to load this data, including the ...
2
votes
1answer
575 views

RuntimeError: Field is not editable when using InsertCursor on ArcSDE geodatabase with ArcFM installed?

We are running ArcGIS Desktop 10.1 SP1, and also have ArcFM installed. I have this simple code: workspace = "C:\\my.sde" arcpy.env.workspace = workspace edit = arcpy.da.Editor(arcpy.env.workspace) ...
1
vote
3answers
38 views

Layer File data source

I have saved group of layers which are reading from SDE DB as layer file. When I open the layer file in any other MXD it takes the same SDE data source. How can I make the layer file without a data ...
5
votes
3answers
5k views

Error 001359 when publishing map service to ArcGIS server?

I encountered this error when trying to publish a map service to an ArcGIS Server 10.1 (installed on linux). --------------------------- Service Publishing Result --------------------------- ...
0
votes
3answers
2k views

Enabling SQL Server 2008 database to access it as Esri geodatabase via ArcSDE using ArcGIS 10.0?

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is). I'd like to convert them to geodatabases, first that 'MS SQL Server 2008', then Oracle. So, leave Oracle for a ...
0
votes
0answers
20 views

Selection anchor when selecting features programatically

In an edit session, I am using code to select multiple features from an SDE polygon layer. After the selection is performed, the user can then use the rotate tool to adjust the features to their ...
8
votes
1answer
305 views

Performing Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...