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
3answers
244 views

How to register as versioned using SDELayer?

This is the normal process using ArcCatalog : I want to automate this process using sdeLayer or any tools - does anybody have an idea as to how to do it? there is an application sdelayer ...
1
vote
1answer
310 views

ArcSDE for ArcGIS Desktop

I have ArcGIS desktop (info) license. I want to know if I can configure SDE, where in I can work with versioning of geodatabases.
1
vote
1answer
43 views

ArcGIS Server 10.1 GP Service non-functional after ArcSDE restart

every night, the Oracle/ArcSDE server gets restarted. As a result, some, but not all, map and GP services require a restart to be functional afterwards. Can others confirm this experience and share ...
1
vote
2answers
168 views

How is it possible to publish data with ArcGIS Server without creating ArcSDE service or using ArcSDE?

I am still relatively new to the ESRI server techologies. I have server1 which runs ArcGIS server 10.0 and when I look at which processes running on this server I see ArcSOM.exe, ArcSOCMON.exe and ...
1
vote
1answer
63 views

Should large Basemaps be stored in DBMS via ArcSDE?

As I understand it, the SDE Geodatabase provides the technology for Multiuser databases, Versioning, replication and other Geodatabase functionality. In my organisation, this could be useful for ...
1
vote
2answers
201 views

ArcSDE installation; “sdesetup: command not found”

I am trying to install ArcSDE component for postgresql database from A DVD file. I have copied files of following folders on the server : command_64 pg_64 in both of theses files there are ...
1
vote
2answers
2k views

How do I use Oracle Locator's mdsys.sdo_geometry with ArcSDE?

I'm using the Oracle Locator MDSYS.SDO_Geometry type to store my spatial information and then accessing it through ArcSDE. I'm confused about how the precision component of the metadata is used and ...
1
vote
1answer
113 views

ArcSDE cannot perform post installation

I have installed the following before I installed ArcSDE 10.2.1: ArcGIS for Desktop 10.2.1(standard) ArcGIS for server Enterprise 10.2.1(standard) MS SQL server 2008 create enterprise geodatabase ...
1
vote
2answers
76 views

Conversion to SDE changes names

I could not find anything on this topic already discussed. We converted our file-based system in ESRI to an SDE instance on Sql Server. We made changes in our code to open using the connection string ...
1
vote
1answer
183 views

Registering a SDE Service in 10.1 with Command Line

I am installing ArcSDE on a new development box. I have executed the setup.exe, created an Enterprise database called "GDB123" and created a new sde service called "sde_123". I need some ...
1
vote
3answers
709 views

Arcgis CopyFeatures tool extremely slow when exporting to SDE

I have about 10 points in a file gdb that I am attempting to copy over to an sde feature set. In arcpy and in model builder it takes about a minute to execute. Do you know of any tips to speed this ...
1
vote
1answer
225 views

Database Connections folder is empty when viewed with ArcGIS tool

I'm trying to create an ArcGIS tool which accepts an SDE connection file as an input. I made a new interface with an input parameter and set the type to Database Connections. When I open the tool and ...
1
vote
1answer
661 views

Using sdemon command of ArcSDE?

I am pretty new to ArcGIS for Server and ArcSDE but cannot find a solution in the Esri Documentation or Forums. I don not know how to use sdemon or even where to start this command line tool.
1
vote
1answer
528 views

Why does arcpy append from file geodatabase to SDE fail?

I'm trying to append a feature class from a file geodatabase to an Arcsde featureclass using this line of code: arcpy.Append_management("parcel_copy", sde_path+"parcel" ,"NO_TEST") This line works ...
1
vote
1answer
346 views

ArcMap - ODBC connection to SDE table shows an old version?

I use an ODBC connection to an SDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL SDE server and the connection info matches what I ...
1
vote
1answer
1k views

Trouble creating ArcSDE Connection File

I'm having trouble creating a ArcSDE Connection File. When I bring up the GP tool to do this, I enter the folder I was save the sde file to, enter an name for the file 'MySDEConnect.sde', enter the ...
1
vote
2answers
175 views

Associating data in a form with an SDE Layer

I was wondering if there was a way to associate/persist some data about an SDE featureclass when viewing via ArcCatalog. I know you can have metadata - but I don't want to use that, and I'm pretty ...
1
vote
3answers
1k views

Is the “sdetable” command available with ArcGIS Workgroup

Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition? We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from ...
1
vote
1answer
122 views

How to configure ST_GEOMETRY Access for Oracle 64 bit?

I'm trying to configure the Oracle extproc to access the geodatabase with SQL, using the documentation here. This is a Windows 2008 R2 server with 64 bit, and the Oracle server is also 64 bit. I'm ...
1
vote
1answer
58 views

Using ArcGIS for Server and ArcSDE for importing shapefiles?

Is there a way to use ArcGIS Server web services to perform the task below? I have .NET ArcObjects code to import shapefiles to Spatial DB which works on ArcGIS for Desktop. This code used ArcSDE to ...
1
vote
1answer
114 views

Why does arcpy.TableToDomain_management require exclusive schema lock?

I'm talking about arcpy.TableToDomain_management, ArcGIS Server 10.2 It seems that this function requires exclusive SDE database schema lock. Something that we can't accept. We have ESRI domains but ...
1
vote
1answer
59 views

Replicate Geodatabase and append to main SDE database

I have my ArcSDE GDB on SQL Server 2005. This we are maintaining at our end at head office. Now we have installed ArcGIS editor license to regional offices. GIS technicians at regional offices can't ...
1
vote
1answer
116 views

Can't select geometry from Oracle DB using SQL

I'm trying to select the geometry field from an ArcSDE feature class in an Oracle 11g database (inside of a Python script via PyODBC). This is my query: SELECT SHAPE FROM USR.FEAT_CLASS This is ...
1
vote
1answer
139 views

Invalid SQL-Statement error when querying file-geodatabase table date field with arcobjects

I want to query a DateTime Field in a table in a file-geodatabase and I keep on getting the error "invalid sql statement" (Error Code: -2147220985) while that sql statement does not give me an error ...
1
vote
1answer
82 views

Model Builder or a python script for pulling SDE data in a single GDB file

Would like to know if Model Builder or a Python Script would be better for pulling dozens of fc from ArcSDE into a single .gdb file ? The tool will need to be run on a regular basis.
1
vote
1answer
161 views

arcgis geodatabase replica between different versions

We have 2 geodatabase corresponding to 2 systems. There is a replica between these 2 geodatabase all use version 10. Recently there is a version upgrade in the parent geodatabase. It will be upgraded ...
1
vote
1answer
275 views

Converting file geodatabase with coded domains to PostgreSQL / PostGIS?

We have several file gdb's and would like to convert these to Postgres / PostGIS. We've used ogr2ogr to transfer these files; however, some of the fields are stored as coded domains and the fields are ...
1
vote
1answer
81 views

ArcSDE register with gdb vs register as versioned

When wanting to update tables within a sde gdb, is there a difference between registering as versioned vs registering with the gdb vs registering with sde? I've read the question below and it hints ...
1
vote
1answer
156 views

ArcSDE/SQL Server Permissions

I have an enterprise geodatabase with about 20 users. Each user has a corresponding schema. When in Arc Catalog, if only the owned schema box is checked in SQL Management studio I receive a ...
1
vote
1answer
114 views

Rebuilding Indexes in SDE Database throws “Could not get a lock.” error

While trying to do some maintenance on our SDE database but i am always getting a "Could not get a lock." error on the details section of the process. Do i need to setup something for me to ...
1
vote
1answer
192 views

Not enough memory in the file group “Primary”: SDE Database error with MSSQL

I got this error message whilst trying to load data into a raster in ArcMap 10.0. Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Eine neue Seite für die sde-Datenbank konnte nicht ...
1
vote
1answer
64 views

Analyze Datasets (Data Management) - what is the output?

I recently completed a Analyze Datasets procedure on my ArcGIS 10.1 SDE. However, I could not find a tangible output to review. Does anyone know where I can find the output?
1
vote
2answers
310 views

Update license for enterprise geodatabase with GP/Python?

I am attaching dozens of database files to a SQL Server instance and then I have to run sdesetup command to update the geodatabase license by pointing to my ArcGIS Server license. I am trying to find ...
1
vote
1answer
341 views

Arcsde and Oracle on same machine but while creating a Enterprise Geodatabase giving TNS Error

I have Installed Arcgis Desktop 10.2 and Oracle 11G and Arcsde 10.2 and oracle Client When I am Creating a Enterprise Geodatabase it is giving me this error: ORA-12154: TNS:could not resolve the ...
1
vote
1answer
383 views

Error during reconcile: "The version could not be reconciled. Invalid network element id : Field is not editable

While reconciling a child version with the parent version, in a dataset containing Geometric network, the following error was noticed. Error during reconcile: "The version could not be reconciled. ...
1
vote
1answer
324 views

Has anyone experienced problems editing between ArcGIS 10.1 and an older ArcSDE geodatabase 9.3.1?

We are unable to edit feature classes in an ArcSDE 9.3.1 Versioned GDB using an ArcGIS 10.1 .mxd map. The feature classes are part of a geometric network. Previously we were able to edit feature ...
1
vote
1answer
177 views

SDE Versioned Data Editing Problem

ArcMap is telling our users that data from a certain feature dataset needs to be registered as versioned to edit. ArcCatalog is showing us that the feature dataset in the SDE is not registered as ...
1
vote
1answer
224 views

ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?

In the system I'm building, we've got a facility that can be represented as either a point, or a point within a polygon (the point in the polygon may or may not be the polygon's centroid). I'm using ...
1
vote
1answer
2k views

How to manage user privilege on layers to Arcgis 10 Desktop?

Problem: I am a Computer Analyst on a town hall. Here we have the sector A and B. Both work in ArcGIS 10 Desktop. The sector A has granted to access/edit everything. The sector A has all the ...
1
vote
1answer
266 views

Why don't I see ArcSDE service in the Windows services?

I've been thrown into learning how ArcSDE and ArcServer work. I'm trying to start a service using the default esri_sde on port 5151. I put it in both the ArcSDE and windows service files. When I go ...
1
vote
1answer
550 views

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
1
vote
1answer
232 views

Geodata Service in ArcGIS Java script api (3.1)

Can I use Geodata service in ArcGIS JavaScript API 3.1 ??? Background : I have simple map service and the all attribute data is stored in Sql Server database. I want to perform query operation on map ...
1
vote
1answer
211 views

How to replace corrupt representations stored in a geodatabase using symbology from layer file?

I have a lyr file with symbology that I want to store in the database. Symbolology is already stored in the geodatabase but the symbology levels has been corrupted migrating from 9.3 to 10. Thus, I ...
1
vote
3answers
651 views

Convert Oracle schema to GeoDatabase using Direct Connect only

Either this is a gap in the documentation or I'm really missing something! I know that I can direct connect to an SDE GeoDatabase without needing ArcSDE to be installed on the database server, but I ...
1
vote
1answer
691 views

How to drop ArcSDE connection using Python scripting?

I want to be able to control connections to ArcSDE via python. Here is my script so far using ESRI's example. import arcpy from arcpy import env env.workspace = r"SDEConnection" fcList = ...
1
vote
1answer
163 views

Multiple-machine deployment scenario. Solutions?

I have a virtual machine (let's call it machine no.1) on which I have installed Microsoft SQL Express 2008 R+ ArcSDE 10.0+ ArcGIS Desktop 10.0 +ArcGIS Server 10.0. Everything is connected and works ...
1
vote
1answer
184 views

Versioning geodatabases

I am trying to reconcile and post the edits. I would like to know if I can post the versions to two different parents. Could some one help me with c# coding on how to do this.
1
vote
1answer
769 views

Delta tables for versioning

I am doing versioning of sde. I have done this using the ArcMap. I want to look at the delta tables in sql server. In sql, I don't see the delta tables. I just see few tables named as a144. How do I ...
1
vote
1answer
568 views

Specifying which ArcSDE feature class Geoprocessing Service is to update?

I want to have a geoprocessing service update sde. I am getting an I/O Error saying data doesn't exist. I imagine because the connection file (copied from my ArcCatalog folder) I placed next to the ...
1
vote
2answers
2k views

How can I insert new records to an ArcSDE feature class from a view in ArcSDE

I am wondering how I can both insert new records from a view to a feature class and update data that may be newer in the view than in the feature class. I have been fumbling around in modelbuilder and ...