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
1answer
111 views

Reconcile and post with c#

I am trying to understand Esri example of reconciling and post with C#. Could someone give me some hints or point me in the right direction. The reconcile and post in Arcmap toolbox has edit version ...
2
votes
1answer
103 views

Image cache on network drive vs. SDE/Oracle

We currently have all of our image data loaded into ArcGIS SDE/Oracle 9.3. There is a proposal to not load our 2015 orthoimagery into SDE/Oracle in order to save time and place it in a tile cache or ...
1
vote
0answers
88 views

Registering database to ArcGIS for Server gives null error?

I'm trying to register a database to ArcGIS for Server 10.2.0 from the web server manager using sde file from ArcMap. The connection works fine in ArcMap. But when registering I'm only getting a "...
0
votes
0answers
35 views

Copying ArcSDE environment from LIVE to TEST with SQL Server?

I was looking for some advice on how best to go about migrating a copy of our LIVE sde environment across to our TEST sde environment which are on two separate servers - both running MS SQL 2012. I ...
1
vote
2answers
239 views

Using Python to backup ArcSDE geodatabase on SQL Server Express?

Is it possible to use Python to do a backup of ArcSDE databases stored in SQL Server Express? I have been using a custom executable that uses Arcobjects IDataServerManagerAdmin.BackupGeodatabase() ...
0
votes
0answers
52 views

Same script works in ArcMap Python window and fails when executed on different computer?

I have a simple python window script: mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd)[0] sr = df.spatialReference arcpy.FeatureOutlineMasks_cartography("someLyrName",...
1
vote
1answer
113 views

Creating geodatabase administrator account other than SDE?

I need to create another account other than SDE and make it geodatabase administrator. Is it possible? I have already created another account and have given SUPERUSER priviledge. However I cannot do ...
0
votes
0answers
167 views

Changing alias of ArcSDE feature class?

I have a feature class. I want to edit the alias. When I go into the Properties of the FC and try to edit the alias, nothing happens. The field will not accept focus and changes are not allowed. How ...
2
votes
1answer
83 views

Select by attributes for Arabic fonts in SDE/ file geodatabases?

I have a layer with names of electrical substations in Arabic language. there is no any problem when searching any Field names in English language whether from the SDE of file goedatabase I got the ...
4
votes
3answers
137 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 ...
1
vote
1answer
187 views

ArcGIS Tool to Delete only Geodatabase content (feature classes, tables, etc)?

Situation: Need to add a Tool to my ModelBuider to Delete only the content from an Enterprise (SDE) Geodatabase (containing features classes, tables, relationship classes). Tool "Delete" (from ...
0
votes
1answer
140 views

Copy shapefile to SDE feature class using arcpy

Is it possible to copy shapefiles to SDE geodatabases using ArcPy? I have tried using Copy_management, but it says that it cannot copy between different workspaces. Is there a different function that ...
0
votes
1answer
134 views

How do I set the domain extents to default?

I have a feature class that seems to be cutting off geometry. I looked around to see if there is a bounding box applied and found the Domain, Resolution and Tolerance tab in the Feature Class ...
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 ...
1
vote
0answers
113 views

Issues creating ArcSDE sde_logfile for certain users (username begins with a numeral)

I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication ...
1
vote
1answer
83 views

How do I keep my python loop going if there is an error with an SDE workspace?

I have a folder with several .SDE connections. I want my Python code to execute various SDE maintenance procedures (such as compress) on each of these databases. If there is a bad/corrupt/not ...
0
votes
1answer
561 views

arcpy.env.overwriteOutput = True not working for one dataset

I am doing a basic copy from sde database to file geodatabase. I have a loop going through each feature dataset in the sde database, this loop is really basic it just uses arcpy.Copy_Management to ...
2
votes
1answer
460 views

ArcGIS Online related table not displaying correctly in popup

I have an ArcGIS Online Map composed of three spatial feature classes and a table. All three feature layers are related to the table and all the layers and table are housed within the same SDE. I ...
0
votes
0answers
33 views

Changing names of versions that have a child

Is it possible to change the name of a version that currently has a child associated with it?
0
votes
1answer
14 views

TableSet Imported to Table of Contents

If I have a SDE table view between two Feature Classes am I able to drag and drop into ToC or will I have to create a feature class of the tableset? The files are in a SDE database. I would also like ...
0
votes
1answer
55 views

Error: Failed to convert: Database Connections… when trying to export to shape file

I have created a table with some derived data in SDE using sql server. The following is an example row of the table: T_OBJECTID T_GEOID T_STATE T_COUNTY T_TRACT T_NAME T_LSAD T_CENSUSAREA ...
0
votes
0answers
26 views

How to edit ArcGIS archive layer?

I am working in the ArcGIS enterprise Geo database environment. all feature data sets are enabled for archiving. When I was editing the default feature data set some important data was deleted by a ...
2
votes
1answer
112 views

SDE State ID with Python

I have created a Python script which compresses an ArcSDE geodatabase and now I would like to view the State ID after the compress. Is there a way with Python I can get this info?
1
vote
1answer
63 views

Is Create Spatial Type necessary

When I enable an enterprise geodatabase for a database in postgresql, the st_geometry type get installed with it. So Is it necessary to use "Create Spatial Type" tool to create st_geometry type in ...
1
vote
1answer
632 views

Database connection fails when using db authentication, succeeds using OS

When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get "Connection was attempted with an older ...
2
votes
0answers
59 views

Autonumbering using ArcGIS Web AppBuilder?

I work for a water utility division and we are using ArcMap 10.1 with attribute assistant. I used the AutoNumber method to auto increment and populate a field with the next highest integer. ...
1
vote
0answers
69 views

How to reconnect Arc GIS Schematics diagrams to GIS data in another oracle/SDE

My problem: An Arc GIS Schematics diagram export with versioned oracle/sde GIS features can't be reconnected to GIS data on another oracle/sde instance. I'm working on a project where in the first ...
0
votes
3answers
256 views

Reading Arcsde Data of a specific version in python

how can i read a version within python. for example lets say I set up a workspace which points to a .SDE file connection. Now how can I read the features from a version within python? I have looked ...
3
votes
1answer
208 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
137 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 ...
1
vote
2answers
92 views

Where are Object class extension GUIDs stored in Oracle?

Where are the GUIDs for object class and workspace extensions stored in SDE for Oracle? I've looked through GDB.ITEMS but can't seem to find it. I think SQL Server stores it in an .xml column but I ...
1
vote
2answers
143 views

AddIndex_Management throws maximum open cursors exceeded

The following script is run to create indexes across all the feature classes within a particular dataset: import arcpy import os.path def listFcsInGDB(): for fds in arcpy.ListDatasets("FRED.GS*",...
1
vote
1answer
249 views

Upgrading from sde 9.2/oracle10g to sde 10.2/oracle11g

I have an old geodatabase created using Arcsde 9.2 on Oracle 10g. Now, I'm trying to update it to new system using ArcSDE 10.2 on Oracle 11g r2. Because SDE 9.2 schema and SDE 10.2 are not ...
0
votes
1answer
104 views

Implementing ArcSDE cost effectively using PostgreSQL?

I wish to implement an ArcSDE environment without breaking the bank. I would be wanting SQL databases. If I use PostgreSQL what are the limitations and or the requirements to make it work? We have ...
2
votes
0answers
70 views

Loading feature linked annotation to existing sde Database

I have feature linked annotation (composite) in sde Databese and i need to add / load annotation from another Database FGDB, is there a way to do this? or i need to make all the prosses again (Lable ...
1
vote
0answers
88 views

What tools are avialble to help keep DEV, UAT, and PROD environments in sync?

Recently, I was doing some development work against our DEV environment. It seems logical at the time. When nearly complete, and after much face palming, I found the DEV environment was way out of ...
0
votes
1answer
43 views

Failure of non existant SQL statement after executing statements from a file with ArcSDESQLExecute object

As you see in my code I iterate and execute all the sql statements in an sql file using ArcSDESQLExecute object. It does work but when all statements have been executed the object returns 'None' (...
0
votes
0answers
126 views

Using Arcpy to Update Data Source Does Not Update Related Tables

I have a python script that updates the data source of mxd's from staging to production. Here is an example of the code: import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Project\MyMap.mxd") for lyr ...
0
votes
2answers
59 views

Learning about Editing on ArcSDE?

I am looking for some information about Editing in ArcSDE in a PDF or online that I would like to read about. I came to the USDA's Forest Service from the USDA NRCS and NRCS does not have ArcSDE. The ...
1
vote
0answers
73 views

Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases

So here's the situation - at the moment I am having a problem where the more feature classes I load into a ArcGIS 10.2 enterprise geodatabase in PostgreSQL, the slower the connection time becomes. I ...
0
votes
1answer
109 views

Definition Query to find next date value in ArcSDE attribute table?

I have an ArcSDE feature class that contains a date field called "SALE_DATE". This sale date represents the bid date for ALberta crown mineral rights sales. A sale occurs about twice per month (one ...
3
votes
1answer
43 views

What are the options to auto populate metadata for data received from external sources?

We receive quite a many spatial data from various sources and export to our enterprise database (Esri). But no metadata is available in Description table. I am looking for a tool or method to get all ...
1
vote
0answers
95 views

User Permissions on ArcSDE Geodatabase in SQL Server 2012

We set up an enterprise geodatabase in SQL Server 2012; Is it possible to set user permissions at a feature class/table level to only view certain attribute types? For example, a pipe layer has ...
0
votes
0answers
70 views

Troubles setting correct projection in SDE

I have to transformate data and change the coordinate system but have troubles to set it correct programmatically. I have: ArcGIS 10.2 / MS SQL-Server 10.0.5520 / sde 10.2.2 My steps: 1) Some ...
0
votes
0answers
278 views

ArcGIS Versioning - Conflicts option greyed out / disabled

I'm relatively new to the world of Versioning and using SDE databases, and have come across a problem that I can't solve. Summed up - the Conflicts option/button is greyed out/disabled, and I know ...
0
votes
1answer
161 views

Error when enabling ArcGIS geodatabase

We're trying to enable enterprise geodatabase functionality in an existing PostgreSQL database. We've already created the sde user (set as superuser) & sde schema. We get the following error: ...
1
vote
2answers
86 views

Database Server Node vs. Database Connection Node

What are the main differences between the Server Node and the Connection Node? The only difference I have been able to find is that the Server Node is intended for administrative tasks while the ...
1
vote
0answers
28 views

ArcSDE Enterprise Geodatabase - XML and Tolerance Issue

I set up an ArcSDE Enterprise Geodatabase in SQL Server 2012. I imported the XML file from the Utility and Pipeline Data Model without any modifications. I am now running into an issue: the XY ...
0
votes
1answer
378 views

Cannot add database connection using windows authetication SQL Server and ArcSDE 10.3

We can't seem to add a database connection from ArcSDE to sql server 2008 using ArcCatalog 10.3.1 from a specific computer with a specific username. When trying to add a database connection using this ...
1
vote
0answers
96 views

LOX table shows up instead of an address locator in SDE geodatabase on SQL server 2012

Tried to copy an address locator from a network share to an SDE database, that worked. Tried the same thing on another database and it shows up in the target geodatabase as an SDE table with LOX in ...