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)

2
votes
1answer
752 views

Creating ArcSDE Geodatabase without post installation?

Is there any way to create an ArcSDE SQL Server 2008 geodatabase without : SDE post-installation execution on the server having sde service running on the server and using : execution of some ...
2
votes
3answers
2k views

Table to Table script fails when copying to SDE

Since TBL2SDE no longer exists (we're running a 64-bit server and ArcGIS 10 doesn't include that executable on a 64-bit installation) I've been using the Table to Table script in ArcToolbox to copy ...
2
votes
2answers
565 views

Big IRowBuffer problem

I have a small software that connects to a database (SQLServer) reads a few values and transfers them to a SDE Oracle instance (11g). The problem is: I have over half million records that I need to ...
2
votes
1answer
74 views

Repoint feature layers from one SDE to another

I am trying to repoint layer (.lyr) files to a new SDE connection. In a test project folder I have two test layer files. When using lyr.findAndReplaceWorkspacePath() the script runs with no errors, ...
2
votes
1answer
183 views

ArcSDE reconcile versions and keep edit version in its current state

Reconciling versions makes both target and source(s) point to the same state. I have an arcpy script that essentially will create a version from a parent of the db - in a state that is empty - adds ...
2
votes
1answer
857 views

ERROR 999999: Error executing function - Failed to execute (CopyRaster)

ERROR 999999: Error executing function Unexpected operation No spatial reference exists This is a fragment from my log report: ERROR 999999: Error executing function. Database user ...
2
votes
1answer
179 views

Database connection times - PostGreSQL vs Oracle (ArcSDE)

I have 2 SDE instances. Both have the same amount of data (2000 datasets both raster and vector). One is PostGreSQL 9.2 with ArcSDE 10.2.1 One is Oracle 11g with ArcSDE 10.2.1 So basically the ...
2
votes
1answer
31 views

Create field on open ArcGIS map - not saved

I am using ArcGIS desktop with an SDE feature layer with enterprise data that I do not have rights to edit. The data changes weekly but I need a field that is sum of 2 current fields without creating ...
2
votes
1answer
215 views

SQLServer Shapefile Export won't load in MongoDB due to self intersection

I am having an issue loading a handful of GeoJSON files that were created from a shapefile export from SQLServer into MongoDB. This polygon will not load in MongoDB because of two duplicate vertices ...
2
votes
2answers
111 views

replaceDataSource for Tables from one SDE server to another server

I found the code that works to change the layers in my mxd from one SDE workspace to the other SDE worksspace. The script runs, but does not change the tables to the new SDE workspace. I replaced lyr ...
2
votes
1answer
786 views

Edit default version table view using SQL Server

I have a ArcSDE (10.3) geodatabase setup which is versioned as we have a few people working concurrently on the data. However, I want to run some background scripts in SQL Server to update the default ...
2
votes
1answer
250 views

How can I create custom offline maps for Collector on an ipad without SDE?

ESRI has informed me that you can only create custom offline maps for collector units if you have an SDE set up with your GIS server. They said SDE is the only way to publish maps up to the ...
2
votes
1answer
3k 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 ...
2
votes
1answer
1k views

Database connection (SDE) failed after database was renamed

I created an enterprise geodatabase in SQL Server 2008 R2 with ArcCatalog (10.2). It was connected via an sde file in ArcCatalog then. Then I had to rename the database from SQL Server Management ...
2
votes
1answer
211 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
2
votes
2answers
73 views

Using a selection tool will select everything

When I use the Selected Features tool and try to drag a box around a few small items it grabs everything. If i use the edit tool it will correctly select only features that are inside/intersect the ...
2
votes
2answers
142 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
2
votes
1answer
424 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
2
votes
1answer
463 views

Python script fails on stand alone but works in ArcMap as a toolbox

I have a fresh install of ArcGIS Server and ArcGIS for Desktop both 10.2, latest patches applied. The data is served in this application from a PostgresSQL enterprise geodatabase. The problem is that ...
2
votes
1answer
373 views

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
2
votes
1answer
51 views

How to enable sde Reader in fme2014

I have windows 7 64bit running ArcGIS Desktop 10.0 and fme 2014. On another server I have ArcSDE9.3. I want to create an SDE Reader in FME but am unsure about how to connect. At the moment SDE ...
2
votes
1answer
2k views

Create feature task could not be completed because coordinates or measures are out of bounds?

I'm trying to create a layer based on a feature class, in ArcMap (I've created a geodatabase from ArcCatalog and linked it to PostgreSQL). The feature class that I've created is registered as ...
2
votes
1answer
103 views

Can you run GIS Squirrel next to SDE?

My company has SDE to run our webmapping system. We want our arcbasic license users to be able to edit this data without dropping 30k for 6 users on upgrading to standard. Can we run squirrel next ...
2
votes
1answer
524 views

Feature service requires registered database error?

I am working on ArcGIS Server 10.2 and SQL Server 2008. when I want to publish the service, I get this error "Feature service requires a registered database" that's error happen when I read (List By ...
2
votes
2answers
348 views

Is there a way to do a python batch script for Analyze and Compress on SDE Databases?

I created and modified python scripts based off of ERSI's example (http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000v7000000), however, what would be great is to be able to batch ...
2
votes
1answer
762 views

how do you manage columns in an ArcSDE/Oracle feature class?

Our enterprise has a long history with Oracle and ArcSDE. And lots of tension between the Oracle people and GIS people. Oracle folk often don't like the requirement of using expensive 'nonstandard' ...
2
votes
1answer
2k 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 ...
2
votes
2answers
1k views

Create a One-to-Many Spatial View with ArcGIS 10.1

We have two datasets: parcels and owners. This is a many-to-many relationship, where a parcel can have multiple owners and there may be multiple properties on a single parcel (also with multiple ...
2
votes
1answer
130 views

Add features to main SDE Table with geotools

Sorry for my english, I hope you can understand ;) I'am using geotools 8.4 version. I try to copy all features from SDE Table(TEST.DBO.MM_SOURCE) to another SDE Table(TEST.DBO.MM_TEST). All features ...
2
votes
1answer
180 views

Strange ArcSDE error inserting null into state_locks?

I'm working with a heavily customized version of ArcMap 9.3.1. It's heavily customized, but it mostly uses class extensions and special validations. Environment: ArcSDE installed in: linux, ...
2
votes
3answers
282 views

Arcsde - FME - import data

I have a problem with the import of data with FME 2012 and ArcSDE 10. After import, my data are not visibles in ArcMap or ArcCatalog. My layers are registered in ArcSDE. I found a solution: After ...
2
votes
1answer
295 views

How can I copy archive data from one server to another?

I have an SDE 10.0 server and an SDE 10.1 server and I am trying to migrate the layers from 10.0 to 10.1. (On a side note the 10.0 server is running SQL Server 2005 and the 10.1 server is running SQL ...
2
votes
2answers
210 views

Finding the Default version in a large linage tree

I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
2
votes
1answer
626 views

Can a spatial View in ArcSDE be viewed in ArcCatalog?

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table? I have a feature class table and an attribute table ...
2
votes
1answer
1k views

How to solve an “Error found when retrieving conflicts.” error in ArcMap?

I uncovered this error when testing ArcMap 10 SP2 for a customer: This occurs when the conflict is detected--ArcMap is attempting to show the conflicts window but fails. I get this error on all ...
2
votes
1answer
189 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...
2
votes
1answer
301 views

arcgis10: export eventlayer (from querylayer) to ArcSDE

I am not using arcmap but I am creating a arcgis desktop console app. I am pulling an external SQL table in as a querylayer. This table has lat & long so I created an eventlayer (or ...
2
votes
2answers
1k views

Using Flex to display single rasters from raster catalog in ArcSDE/ArcGIS server?

One of the front end develoeprs here is having issues displaying, or working out how to display a single raster held in a raster catalog in ArcSDE using the Flex 2.2 API the Raster Catalog holds ...
2
votes
1answer
566 views

Filter features with multi-table joins in ESRI Silverlight/REST API

We have a rather involved data warehouse (SDE 9.3.1 / Oracle 11g) that contains a single related point feature class. Our (analytical) application should allow users to construct complex, ad hoc ...
2
votes
1answer
485 views

Oracle tracing, bind variables, and ArcSDE

Oracle tracing with TKPROF is the recommended way to troubleshoot data access performance problems with SDE/Oracle. Unfortunately, queries that differ in any way are considered "different" and ...
2
votes
1answer
773 views

ArcSDE: connecting via LDAP Authentication

I was wondering if anyone has a sample connection string for SQLPlus using LDAP Authentication. I am also trying to specify in the connection string the database I wish to use. Thanks, CDB
2
votes
1answer
743 views

Is there any way to perform spatial filter on multiple layers together?

I have a scenario where a featureclass[Child Version] is queried for some overlapping features on [SDE.DEFAULT] Version using ISpatialFilter, After getting few result, these features are looped and ...
2
votes
1answer
395 views

Has anyone successfully made a FeatureLayer from a view in DB2 and ArcSDE 10?

Lately it seems like every new ESRI feature fails for me - I must be cursed. I'm testing the use of a FeatureLayer to see if helps display and query features using the JavaScript API 2.0. This layer ...
2
votes
0answers
26 views

Unable to add feature class based on database view in ArcMap

To solve this problem (earlier question), we created a view in the database that joins the two tables together. That works fine. I see the feature class in ArcCatalog and can view the features in the ...
2
votes
0answers
46 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
2
votes
0answers
45 views

How to convert the BLOB value for the features geometry of type st_geometry kept in ArcGIS databse on Oracle [closed]

I am using ArcGIS Oracle database and I am trying to access feature geometry points as string. But the problem is that the points are kept as blobs and I cant convert to meaningful string. select ...
2
votes
0answers
29 views

Where do field aliases reside in an SDE database?

If I want to get field aliases for an SDE table through pure SQL, what table do I query? My geodatabase was created with ArcGIS 10.1 in an Oracle database.
2
votes
0answers
60 views

Locking geometry of ArcSDE feature class from ArcGIS for Desktop?

I am using ArcGIS 10.2. Does anyone know how I can allow editors to select features and update attributes of an ArcSDE feature class but prevent accidental edits (shifts/deletions) to the geometry? ...
2
votes
0answers
71 views

Geodatabase performance and Archiving [closed]

We have SDE (10.3) running on SQL Server (SQL Server 2012 on Windows Server 2012 R2) Over time we've noticed our GIS performance degrade, and can have good days and bad days. We run versioned ...
2
votes
0answers
37 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...