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)

0
votes
2answers
13 views

findAndReplaceWorkspacePath ValueError: Layer: Unexpected error

Here is my code to replace the old SDE connection file with the new one. I am getting an error due to grouped layers, that I know. I have been trying to fix this but regardless of what I try I keep ...
4
votes
1answer
27 views

Restricting edits for specific fields in a feature class for particular users

How to restrict edits for specific fields in a feature class for particular users in ArcSDE. For example, there is a feature class called “Tower”. It has 20 Fields. Out of 20 fields, 10 are updated ...
0
votes
1answer
26 views

Create table that is not registered with a SDE Geodatabase

I am doing some testing that requires having a table in a Oracle 11g/SDE 10.3.1 database that is not registered with the geodatabase. For instance, Adding an Incrementing ID Field can only be ...
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 ...
0
votes
0answers
165 views

SDE Replication works through ArcMap but not through ArcCatalog [on hold]

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 ...
2
votes
1answer
56 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 ...
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
10 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","...
0
votes
0answers
13 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
64 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
321 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
87 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
17 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
9 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
282 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
35 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
60 views

Create enterprise geodatabase errors [on hold]

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
187 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
53 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
35 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
44 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
528 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
195 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
666 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
109 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
269 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
466 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
311 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
1k 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
152 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
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
22 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
37 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
211 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
25 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
155 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
582 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 ...