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)

1
vote
1answer
65 views

Feature class to feature class code

I have some code that will take a ArcGIS 10.2.2 feature class and post a copy of it in a different geodatabase. My code is set up so the end user can pick the feature class they want the model to ...
4
votes
0answers
104 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
2
votes
2answers
61 views

How to use IDatabaseConnectionInfo3 Interface ArcObjects!

I try to retrive the connected users from an entreprise geodatabase using ArcObjects . first I tried to cast My workspace to IDatabaseConnectionInfo3 but it throws ClassCastException ...
1
vote
1answer
65 views

How to change owner of a version in an enterprise geodatabase using ArcObjects?

I have ArcObjects/.NET code used to create few versions for workspace. Versions are created successfuly but their owner is who created them (the user connected to the workspace). I want to change the ...
0
votes
1answer
74 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 ...
1
vote
1answer
55 views

How to set a specific ArcSDE version for tabular reporting?

I have created a multiversioned view in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production. I can access a specific version using a SQL script in SQL Developer. However, using ...
2
votes
1answer
57 views

Determine if ArcSDE service or direct connect

Does anybody knows if there is the ability to check a layers datasource, if it is an direct connect to a database or if an ArcSDE service is used? For both the esriDataSourcesGDB.SdeWorkspaceFactory ...
0
votes
1answer
71 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
64 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
49 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
32 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
112 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() ...
1
vote
1answer
77 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
88 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
50 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 ...
3
votes
3answers
79 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
72 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
69 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
61 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
1answer
503 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
73 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
59 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
285 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 ...
1
vote
1answer
152 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
12 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
39 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
22 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
81 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
59 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
226 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 ...
1
vote
0answers
47 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
48 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
112 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
113 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
123 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
1answer
65 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
107 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 ...
1
vote
1answer
147 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
91 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 ...
0
votes
0answers
101 views

Establishing direct connection to ESRI geodatabase on Oracle hangs while not in debug mode

Recently I have been trying to establish direct connection to oracle geodatabase using Java API. The problem is, that when I execute the code, the connection works fine only in debug mode when I ...
2
votes
0answers
56 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
56 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
31 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
79 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
55 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
71 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
83 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
40 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
63 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 ...