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
0answers
3 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 . ...
0
votes
0answers
21 views

Truncate and Load/append/copy data from Feature Dataset to Feature Dataset [on hold]

I have a SDE featuredataset which contain 20 layers updated every month and historic featuredataset which have the layers from the last month. it is not a big volumen of data, something like 10000 row ...
0
votes
0answers
13 views

Debugging insufficient memory available --error code was 2 offending plugin is 'xlsx'? [on hold]

I am using an Excel file and an ArcSDE geodatabase to detect the changes using change detector tool. The output is an excel file with the changes. The tool runs fine on the small excel file, but as ...
1
vote
0answers
34 views

Feature classes not visible to some ArcSDE users? [on hold]

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
0answers
16 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
14 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
30 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
23 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 ...
0
votes
0answers
23 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 ...
0
votes
0answers
11 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 ...
0
votes
0answers
14 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 ...
0
votes
1answer
44 views

Arcpy Slow to Read Datasets from Connection (.sde) File

I'm looking to automate publishing map services to ArcGIS Server, and in doing so I'm creating map documents that have only one layer; each layer is from a SQL Server 2014 database that I am accessing ...
0
votes
0answers
26 views

Updating old attribute values with new ones in enterprise geodatabase?

I want to update values of a field with a new value. For example, the old value is U13-1234 and I want to replace it with a new value of DT1-1453. I have around 500+ records and i want to update ...
0
votes
0answers
13 views

Aborted Reconcile, Negative FIDs

I have an ongoing project in the parcel fabric that has been in the works for near a month. I use a child version from the default and I have been reconciling and posting my edits at the end of each ...
2
votes
1answer
52 views

saving survey123 data programmatically using python

I'm recording data using the Survey123 app which logs data into a standard ESRI rest service, stored in my AGOL account. I would like to save this data an SDE dataset. Is it possible to do so using ...
1
vote
0answers
29 views

Why would ArcMap always crash (but not immediately) after Reconcile & Post?

I've been plagued over the past several months by a problem in which ArcMap (10.2.2, Advanced license) on Citrix (Receiver version 3.4) will crash at some point after reconciling and posting my edits ...
0
votes
0answers
20 views

Multiple UTM Zones in a geodatabase [duplicate]

I am currently setting up a geodatabase for the province of Alberta. What would be the best practices for implementing a provincial geodatabase (ArcSDE/SqlServer 2008 R2) that happens to fall within ...
0
votes
1answer
23 views

Oracle versioned geodatabase feature class field value update on multiple versions

I have an Oracle enterprise geodatabase with multiple versions. In one field value of one point feature class I need to change all features within all versions. I have more than 50 versions. Is ...
0
votes
1answer
109 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 ...
1
vote
2answers
61 views

Why can't I open this workspace?

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 solutions that ...
1
vote
1answer
41 views

Finding correct service for arcpy.createArcSDEconnectionFile_management in ArcPy?

I'm working on a toolbar for modifying an SDE database in acrmaps. My code works in a file geodatabase so I'm trying to use this function to make it work in an ArcSDE. I've gotten every other variable ...
0
votes
0answers
26 views

Is there an Esri ST_Geometry function to remove m-values?

I'd like to use SQL to select the WKT geometry of an ArcSDE feature class of the type POLYGON M. However, I'd also like to suppress the m-values as I read them. PostGIS has a function Force2D that can ...
1
vote
1answer
55 views

enable enterprise geodatabase error

I am trying to enable an enterprise database. I right click > enable and then navigate to our organizations keycode file. I get this error: Attribute Column Not found... (see screenshot) This ...
2
votes
0answers
35 views

Can shp2sde on ArcSDE 9.3 server operate with SDE 10.3 database?

We have 2 servers running ArcSDE 9.3, and one Oracle database at SDE 9.3. Only one of the ArcSDE 9.3 servers is to be upgraded to ArcSDE 10.3, and the Oracle SDE database will be migrated from SDE 9.3 ...
0
votes
1answer
58 views

Python Script to update all feature classes/datasets in gdb with search and update cursor?

I have two geodatabases, one is a production sde database, the other is a backup in a local file geodatabase. The script runs as a task once a month and is very resource intensive. I am using ArcGIS ...
1
vote
2answers
39 views

Iterate feature class by Date created to select recent shapefile

I would like to select only newly created shapefile (today's). Every time new shape file are created from trimble pathfinder office which i need to upload to Arcgis server feature class. Model below ...
1
vote
1answer
31 views

Which Geodatabase version is holding how manyUNPOSTED outstanding Edits?

I have this generic versioned geodatabase question i.e.Which Geodatabase version is holding how many UNPOSTED outstanding Edits ?, which may be crucial to identify the query performance bottleneck in ...
1
vote
0answers
51 views

One way Replica deleted feature not synchronizing when I synchronize

I have created one-way replicas from 50 geodatabases to one geodatabase (Arcsde. With PostgSQL 9.2) After that, I update my feature class in parent geodatabase, but when I synchronize the replica the ...
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
67 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) ...
4
votes
1answer
34 views

Are ESRI spatial views regenerated whenever they are queried?

If a spatial view contains data "joined" from multiple tables, will all the tables be queried whenever a query is executed against the spatial view? We have some spatial views and whenever we run a ...
4
votes
1answer
84 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 ...
1
vote
1answer
51 views

Deleting features with arcpy on ArcGis SDE 10.0 SP5

I am new to ArcGIS and arcpy and am learning largely through trial and error. Anyway, the overall task is to delete, edit and add rows to feature classes. I thought it would be good to start with ...
0
votes
0answers
36 views

Create additional 'fields' in GDB domain system table (GDB_items)?

Is it possible to create additional 'fields' in the geodatabase domain system table (GDB_items) in SDE 10.3/Oracle? It would be handy to store additional information in domains. For example: CODE [...
3
votes
1answer
41 views

Does the version admin workflow change when all users edit the SDE.DEFAULT version?

An esri blog article (5 Best Practices SDE Maintenance) states, when discussing updating statistics for an ArcSDE, "... in situations where all users are editing just the SDE.DEFAULT version [this is ...
1
vote
2answers
73 views

Migrating data from ArcSDE to SQL Server Spatial Database

I am looking for a process or a tool that would allow me to migrate data from an ESRI SDE Database to a SQL Spatial Database. This would include converting the ESRI geometry to SQL geometry types, as ...
1
vote
0answers
18 views

What are “DR$XMLDOCIX1” tables in ArcSDE? [closed]

I was wondering if anyone knows what these tables are in SDE? I'm working in an ArcGIS 10.1 environment, Oracle 11gR2 database.
2
votes
0answers
43 views

Unable to add feature class based on database view in ArcMap

To solve Rendering features based on relationships using ArcGIS for Server?, we created a view in the database that joins the two tables together. That works fine. I see the feature class in ...
1
vote
0answers
36 views

Versioning in ArcGis? [closed]

I create 2 replica by tool CreateReplica_management. This tool return 2 mdb: A.mdb with feature class FC1, FC2. B.mdb with feature class FC1, FC2. First user edit FC1 from A.mdb Second user edit FC2 ...
5
votes
1answer
51 views

Can ArcGis accept SQL field names with spaces?

Im working on an integration project that is providing data from our billing system to ArcGis. Field names can include spaces which are acceptable in SQL Server if enclosed in brackets eg: [Street ...
0
votes
0answers
70 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. The error message reads: ...
1
vote
0answers
13 views

Connect to certain timestamp for child version

In ArcMap you can connect either to a historical marker or to a specified timespan by changing the version within the subtab Historic. I am however not quite sure on which parent-version this new ...
1
vote
2answers
40 views

Changing ArcSDE version of *.mxd in ArcPy?

Is there a way to switch the version a .mxd data source is pointing at without using arcpy.mapping.findAndReplaceWorkspacePaths? I have a script that automates map book production that works very ...
3
votes
1answer
71 views

Get domain descriptions for multiple fields using SQL (ArcSDE 10.3/Oracle back-end)

How can I get domain descriptions for multiple fields using SQL (ArcSDE 10.3/Oracle back-end)? I have successfully used the Oracle SQL in the ESRI document: Resolving domain codes to description ...
0
votes
0answers
13 views

How can I create a definition query to show the next 5 years of data, based on a text field with the year on a joined table in SDE?

I need to show the next 5 years of construction data, but I want it to automatically update what is shown based on a text field called ConYearStartNbr that shows when the construction is set to start ...
5
votes
1answer
40 views

Auto-generated field in ArcSDE for end user

The objective: Create a process where a coworker can open an .MXD, start editing, add a feature to represent a complaint, then add records in a related table to represent an inspection. Along the way, ...
0
votes
0answers
51 views

Export from SDE to Shapefile Bug

I'm exporting data from a large-ish SDE feature class (888,628 features) to a shapefile. I'm using the ArcMap GUI export process (add the SDE feature class as a layer, right click >> Data >> Export ...
0
votes
0answers
132 views

Receiving Error ORA-0094 B Invalid identifier when try to reconcile versioning in ArcSDE for Oracle?

I have one Edit child version and one default parent SDE version. When I try to reconcile from Edit version to SDE default version this error is coming. Error ORA-0094 B Invalid identifier I am ...
1
vote
0answers
40 views

Feature linked annotations not updating when editing attributes in features?

I am using ArcGIS 9.3. I have a copy of an original SDE database with feature classes, annotations, and relationship classes for those annotations. The copied geodatabase is an exact replica of an ...
0
votes
0answers
11 views

Date Query 10.3 SQL SDE vs FGDC

I have a date field "FIRE_DSCR_DT" that I want to query for a specific month(s). For example,I want to get all of the records where the month = January. This query did not work in SDE, but it did ...