2
votes
1answer
109 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, ...
1
vote
1answer
287 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 ...
5
votes
2answers
464 views

What does it mean to QI and how is it done?

I'm new to Esri's Arc* interfaces, and trying to figure out how to register an existing table using the ArcObjects API. The following question answers this to some extent: Is there any way to write a ...
13
votes
2answers
262 views

Is there a good way to get a diff between an old and a new version of an SDE database?

Is there a tool or a process that can reveal changes made to the schema of an SDE database when comparing two versions of the same database hosted on different servers? I have an old database that ...
15
votes
8answers
4k views

Versioning with ArcSDE - Is it possible to cancel or reject edits once they've been posted?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
2
votes
3answers
796 views

Transfering a lot of features from geodatabases

I'm having a problem where I need to export a large amount of content from 2 geodatabases of different nature (SDE -> File). I have three options: Spatial Select, a regular SQL select and the full ...
3
votes
1answer
952 views

how to grant permission in SDE geoDB,when layers are inside a geometric network

When I use sdetable command to grant pemission to a table that located in a SDE SQL server geodatabase it works properly,this table is a non-spatial table which is in geodatabase immediately,I mean ...
2
votes
2answers
425 views

Edits in SDE not showing up in AGS GeoData Service

I've got an ArcGIS Server GeoData service against an SDE MSSql database. When changes are made to the source data, the edits don't appear to show up in the GeoData service. If I restart the ...
10
votes
5answers
5k views

ArcSDE connection limit exceeded

We routinely exceed ArcSDE's connection limit, about once a week. Many of the "connections" are nothing but orphaned records in the SDE.PROCESS_INFORMATION table. Is there any way to clean up these ...
3
votes
2answers
307 views

How does ESRI, and how should anyone, transform a coordinate that lies outside a grid transform (e.g. NADCON)?

As I understand it, a datum transform (e.g. urn:ogc:def:coordinateOperation:EPSG::1241) based on a grid interpolation method, e.g. NADCON, is undefined outside of the grid of points. Therefore the ...
2
votes
2answers
1k views

How do I access versioned spatial data in SDE with SQL queries?

We're running SDE and have several featuresets with versioning turned on. When I query those layers via ArcGIS Engine or ArcGIS Server, all expected features are returned. We have numerous non-GIS ...
0
votes
1answer
126 views

How can I retrieve an attribute's domain using ArcIMS ActiveX Connector?

I have an ArcIMS Image Service that's consuming data stored in an ArcSDE database (both v9.3.1). Many of the layers have attribute columns that use coded value domains defined in the SDE database, ...
17
votes
3answers
4k views

What is the difference between ESRI's SDE and Geospatial dbs?

When would you want to use ESRI SDE (I think it is called Server but I forget the level - please feel free to edit) versus a spatially enabled database. What are the trade-offs on either side? What ...