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
27 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
26 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
23 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
32 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
31 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
32 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
48 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 ...
0
votes
1answer
25 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
20 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
10 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
32 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
15 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
35 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
38 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 ...
0
votes
0answers
47 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 the lovely "Connection was attempted with an ...
1
vote
0answers
29 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
20 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
54 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
46 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 ...
0
votes
0answers
44 views

ArcCatalog Unable to Connect to Database (Invalid object name SDE_table_registry)

Trying to make a database connection in ArcCatalog The ArcServer is on a separate vm than the SQL Server vm. When I attempt to connect to the database using integrated security I get the error: ...
3
votes
2answers
113 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
34 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
58 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
46 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
66 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
51 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
38 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
34 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
0answers
53 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
49 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
67 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
52 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 ...
2
votes
1answer
27 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
28 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
29 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
60 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
54 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
32 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 ...
0
votes
0answers
28 views

How to get metadata about Esri Geodatabase Replica synchronization

I'm using ArcObjects for .NET to create an one-way replica from my geodata-service (master) to an ArcSDE geodatabase (slave). During synchronization I do need metadata about the incoming changes to ...
0
votes
0answers
35 views

Unable to create multiple geodatabases in ArcSDE?

I am trying to create multiple instances in arcsde 10.3. Able to create and run the first instance. But, when I tried to run the second instance it throws error(attached) in create/enable geodatabase ...
1
vote
0answers
24 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
120 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
63 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 ...
0
votes
0answers
32 views

Multiple editors

I am trying to have multiple editors editing the same layer at the same time. I am running ArcInfo v10.2 and have set up a SDE connection using sqlexpress. I have created a geodatabase on my personal ...
0
votes
0answers
29 views

Reviewing version conflicts - over 600!

I'm fairly new to working with versioned geodatabases and have found that one of my versions has over 600 conflicts which require review and replacing. I suspect that all objects will need to be ...
1
vote
0answers
60 views

Migrating ArcSDE data to Oracle Spatial?

We've got all the geospatial information of our company within an ArcSDE Database (over oracle Server): points lines polygons We consume these data with ArcGIS Desktop and with ArcGIS Server. ...
0
votes
1answer
68 views

Foreign Key is not added to destination table after the creation of a relationship class

Let's say I have two tables A and B. The relationship between these two tables is as follows : A (1,*) <---- (1,1) B Now when I try to add a relationship class for these two tables on Arcatalog, ...
1
vote
1answer
32 views

ArcSDE feature class prefix issue

I believe this issue is is part of a bigger problem causing an issue with an arcpy script that I am trying to have run periodically to load data into ArcSDE feature classes using Append_management. I ...
1
vote
0answers
34 views

Can privileges be set to allow certain users read/write access to a protected version?

I have multiple versions of a database (some protected and some public). Would it be possible to allow some of the database users read/write access to the protected versions? I have read of protected ...
0
votes
0answers
59 views

Can't create address locator in SQL Express GDB

I am working out of a SQL Express ArcSDE geodatabase with ArcGIS 10.3.0 Standard and would like to create a composite address locator based on streets and parcels. I can copy and rebuild a streets ...