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
328 views

Expecting ArcSDE service in Windows services?

I've been thrown into learning how ArcSDE and ArcGIS Server 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 ...
1
vote
1answer
634 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
230 views

How to replace corrupt representations stored in 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
730 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
927 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
175 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
191 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
963 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
617 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 ...
1
vote
2answers
2k views

How do I programmatically update/recreate an ArcSDE feature class from external sql data?

I have an ArcSDE feature class that contains project points based on xy data from an external SQL databaes. (Not a geodb). I am looking for the best way to "recreate" the ArcSDE feature class from the ...
1
vote
1answer
2k views

Product License not initialized error when trying to open an SDE connection in ArcObjects

I am trying to connect to create connection in using ArcObjects using the code below. IPropertySet propertySet = new PropertySet(); IWorkspaceFactory sdeWsFactory = new SdeWorkspaceFactory(); ...
1
vote
1answer
18 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
1answer
30 views

ArcSDE PostgreSQL configuration parameters for Spatial Index?

I wonder why there is not any configuration parameter (DEFAULT Keyword) for spatial indexes in Arcsde for postgres. In ArcSDE for Oracle we have S_STORAGE,S_INDEX_SP_FID,S_INDEX_ALL parameter for ...
1
vote
1answer
19 views

Converting ArcSDE to CAD using FME when blockreference involved?

I try to convert some lines from ArcSDE to cad by FME and I have set autocad_original_entity_type=autocad_lwpolyline and autocad_entity=autocad_line,I suppose they will be line but they have been ...
1
vote
1answer
39 views

Unable to execute a python script that was exported from ModelBuilder

I have a model that copies a single F.C form SDE geodatabase to a scratch geodatabase then copies it back with a new name to the same SDE geodatabase again. And this works perfectly form the model. ...
1
vote
1answer
67 views

ArcGIS Terminology and Data Types

What is the difference between a "Feature Class" and an "SDE Feature Class"? Or a "Table" and an "SDE Table"? When browsing data in ArcCatalog, hosted on the same enterprise gdb, I see these data ...
1
vote
1answer
69 views

How to change data source of table using arcobjects

Cross post from: https://geonet.esri.com/thread/125010 Does anyone know how to change the data source of a table using arcobjects? I know it can be done with arcpy, but I'm using C#. I've managed to ...
1
vote
1answer
115 views

Error Creating Feature Layer from Parcel Fabric, Error 000732

Currently I am writing a python script that creates a feature layer from our parcel fabric and then appends that data into a different SDE feature class. The problem is that when executing ...
1
vote
1answer
67 views

Connect to postgresql using ARCSDESQLExecute

I'm trying to connect to a postgresql database using ARCSDESQLExecute from ArcPy. When running my script as stand alone (debug from pyscripter) it works fine. When running my script as a tool from ...
1
vote
1answer
80 views

Using CURRENT_DATE function on ArcSDE SQL Server Database?

I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the ...
1
vote
1answer
792 views

Bulk insert with Python and cx_Oracle into st_geometry enabled table

I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE. I could do it with the method execute() of cx_Oracle but ...
1
vote
1answer
51 views

Multiple (seperate) Attachment Tables

Is it possible to have multiple attachment tables related to one feature class? The purpose is to only show specific attachments at certain times. We are trying to only show pertinent attached ...
1
vote
2answers
239 views

Create an enterprise geodatabase - Administrator username and password are required

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create ...
1
vote
1answer
67 views

Can adding of attribute table fields cause geoDB replica fail

We have a arcsde replica between 2 sql server geoDB, it is one way replica and our side is the child. Recently our scheduler to synchronize the replica failed. The parent side add fields in some ...
1
vote
1answer
47 views

Start session edit on a specific layer on the map?

I created a GIS using ArcObjects, my application needs to be connected with a geodatabase stored in SQL Server. I used ARCSDE to connect my application to the database and when the database is ...
1
vote
1answer
67 views

How to create a model which executes a SQL stored procedure with user-provided parameters?

How can I create an ArcToolbox that executes a SQL stored procedure and asks the user for two inputs? As it stands now, I have to log in to my SQL server and run an execute statement for the stored ...
1
vote
2answers
641 views

Exporting lists of Feature classes and fields from SDE

I'm using matt wilkies' arcplus module http://gis.stackexchange.com/a/5943/16793 to export a list of feature classes within an SDE database to a text file. I've also written a tool to write field ...
1
vote
1answer
318 views

How to connect to ArcSDE for using the ArcObjects Erase tool in C#?

I want to make use of geoprocessing via .NET ArcObjects, in this case of the "Erase" tool. This is easy once dealing with a local gdb file what I did for feasibility study. The issue occurs when I ...
1
vote
1answer
301 views

Merging Personal Geodatabase (MDB) data into ArcSDE using FME?

Im a novice in FME and I have a MDB file that i want to write/insert to an SDE database using FME. I created a simple translation that generally reads the data from the MDB file and writes it to the ...
1
vote
1answer
298 views

Backup several SDE database connections

This question stems from my previous question on how to list databases based on SDE. Now I want to copy them and have it written as a function so I can list out each database connection below it so ...
1
vote
1answer
82 views

Query SDE to display records created for 'X' date/time

I am looking to query our SDE to display feature classes modified beginning from January 1, 2013 to today. I am using Microsoft SQL Server Management Studio, and as it stands searching through dbo ...
1
vote
1answer
776 views

Why does copying ArcSDE datasets and features in Python give ERROR 000732 & 000735?

I keep getting a kick back that says this: ERROR 000732: Input Features: Dataset 'Database Connections\Wyoming.sde\Supporting_MT_DBO_Geology' does not exist or is not supported Failed to execute ...
1
vote
1answer
380 views

Why does FeatureClassToFeatureClass field mapping create shapefile with no attribute values on local machine from ArcSDE?

I have inherited taking over and supporting and ArcSDE GIS database. We have a process that we must do every 6 months to export certain features from the ArcSDE database into shape files so that they ...
1
vote
1answer
873 views

ArcGIS: Versioning, Post & Reconcile, Compressing, and Lost in Space

Alright guys, I'm in a bad way here. Here is the short version, and I'll post the long detailed version below. I'm needing to figure out an easier way to post changes to the data on our SDE ...
1
vote
1answer
93 views

Error in GUID fields using “Simple Data Loader”

I have a replicated table in my SQL Server (PE_AMB_ANP), that table has a field named "rowguid" (rowguid is auto generated) When I try yo load data, the field appear matched with 'none', but when the ...
1
vote
1answer
128 views

Matching sde database port to FME Reader?

I had been trying to connect a MSSQL Server/SDE 9.3 to an FME (2013) Reader for 2 days until I noticed from an earlier fme project that each sde Database has a unique port number. I thought the sde ...
1
vote
1answer
1k views

Failure to Access DBMS Server Error - ArcGIS/Postgres

If connected to an SDE enabled Postgres database via ArcGIS (10.1) for a long period of time, maybe an hour +, I will often receive an error from ArcGIS stating "Failure to access the DBMS Server[my ...
1
vote
1answer
324 views

How can I use a sub-query in where statement of a query in ArcGIS 10.2 Map service?

I'm migrating my ArcGIS map services from version 10.0 to 10.2. It uses ArcSDE to manage spatial data in a SQL Server database. I was able to create the map service and everything seems OK. However ...
1
vote
1answer
130 views

Error occured during Geodatabase compressing

When I am doing geodatabase administration in ArcSDE on an Oracle Database, the following error pops up when I run the compress tool ORA-00604: error occurred at recursive SQL level 1 ORA-01000: ...
1
vote
1answer
295 views

enabling feature access without installing ArcSDE 10.1?

Is there any way to enable "feature access" when publishing a map using ArcGIS 10.1 server, without installing ArcSDE?
1
vote
2answers
210 views

ArcReader 10.1 trouble (loading and printing is taking very long ime)

We've run into printing problems in ArcReader 10.1. Our trouble is with a particular floodplain feature class located in an SDE database. It simply takes forever to load! Then, when printing, it takes ...
1
vote
1answer
260 views

updating a feature class from an EXCEL spreadsheet

I created feature classes that only contains the data from an EXCEL file. I did this to enable the search function to search the data in these tables. The FCs also have relationships between ...
1
vote
1answer
197 views

arcpy update cursor: can't connect to a database table

I am using updateCursor to retrieve some rows from a non spatial table using a connection of type "Spatial Database Connection" (That creates a .sde file) from ArcCatalog. However, it doesn't work, ...
1
vote
1answer
996 views

Trigger a python script to run after a row is added to the feature class

I have a Python script which runs on a SDE feature class daily (as a scheduled task). I would actually like this script to run whenever a new row is added to the feature class (data is captured in the ...
1
vote
1answer
86 views

Migrating Lines to ArcGIS polyline

I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase. and some data will cause the error. Its says not enough points for feature class, but when I look ...
1
vote
1answer
430 views

Can one edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned. I really had it in my head that you can, as long as the objectid column is included in ...
1
vote
1answer
383 views

How to add a column to table with sdelayer command?

I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
1
vote
1answer
197 views

“SDE error 6” when publishing GeoServer layer

I have successfully created an ArcSDE datastore in GeoServer 2.2.4. When I try to publish a feature class in the SDE database, the "Compute from data" link returns nothing, and the "Compute from ...
1
vote
2answers
1k views

arcsde - index LOADING/FAILED/UNUSABLE

I have a problem with import data with fme and arcsde. I have a loop of import data in the same arcsde table. I have a problem with index : Error while executing stream insert operation for table ...