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
0answers
232 views

ArcObjects .NET 9.3 upgrade to 10 breaks IRasterDataset.Copy(…) code

I have to upgrade an application from ArcObjects 9.3 (C# .NET) to 10. Unfortunately, there seems to be some incompatibility regarding the IRasterDataset.Copy method. The following code worked fine in ...
2
votes
0answers
162 views

How can I upload an annotation featureclass to ArcSDE using C#?

I can upload the shape files to ArcSDE database successfully,but I fail to upload annotation featureclass.
1
vote
0answers
14 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
1
vote
0answers
29 views

Why would ArcMap always crash (but not immediately) after Reconcile & Post?

I've been plagued over the past several months by a problem in which ArcMap (10.2.2, Advanced license) on Citrix (Receiver version 3.4) will crash at some point after reconciling and posting my edits ...
1
vote
0answers
51 views

One way Replica deleted feature not synchronizing when I synchronize

I have created one-way replicas from 50 geodatabases to one geodatabase (Arcsde. With PostgSQL 9.2) After that, I update my feature class in parent geodatabase, but when I synchronize the replica the ...
1
vote
0answers
13 views

Connect to certain timestamp for child version

In ArcMap you can connect either to a historical marker or to a specified timespan by changing the version within the subtab Historic. I am however not quite sure on which parent-version this new ...
1
vote
0answers
41 views

Feature linked annotations not updating when editing attributes in features?

I am using ArcGIS 9.3. I have a copy of an original SDE database with feature classes, annotations, and relationship classes for those annotations. The copied geodatabase is an exact replica of an ...
1
vote
0answers
24 views

Successfully added a Database Server but nothing inside (ArcCatalog)

I'm just a newbie in using ArcGIS. I'm trying to create a Web editing application in ArcGIS Server Manager like this post does here, but after added a Database Server i realize that there is nothing ...
1
vote
0answers
27 views

Adding rasters to mosaic dataset?

I'm working with an ArcSDE geodatabase v 10.0 in SQL Server 2008R2. I added more than a dozen of rasters w/o problem. Server: WIN 2008R2 12GB RAM SPACE: 1TB Created a mosaic dataset (empty) w/o ...
1
vote
0answers
36 views

ArcSDE In a version geodatabase, snap tool does not work on a database feature class

I am setting up a series of tasks for technicians to complete. To finish the map template they will be working from, I must snap leak points to gas mains using the snap tool. However, after running ...
1
vote
0answers
45 views

Arcpy - Why does multi_user_mode have to be False in an edit session on non-versioned dataset?

I'm in the process of implementing Mintx's answer to my question What would cause a geoprocessing service to say "Cannot Open 'FeatureClass' Failed to Execute"? However, I had ...
1
vote
0answers
104 views

'sdetable' is not recognized as an internal or external command

I try use arcpy.JoinField_management(inFeatures, inField, joinTable, joinField, fieldList) to join SQL server database tables to shapefiles directly, using an ArcSDE connection. The database ...
1
vote
0answers
99 views

Releasing all schema locks in ArcGIS GDB

We use ArcGIS 10.3 products (Server, Desktop) with Oracle database. Our problem is we can not make any schema changes because of shared schema locks unless we stop all services and kill all database ...
1
vote
0answers
49 views

FME: floating point precision issues (ArcSDE / FGDB)

I am working on a (generic) FME Workbench that clips and exports data from ArcSDE database into the File Geodatabase (FGDB) format. The SDE features are clipped using an AOI, that arrives in the ...
1
vote
0answers
34 views

Geoserver not displaying ArcSDE versioned table data as it is updated

Has anybody managed to get GeoServer 2.8 with the ArcSDE plugin (ArcSDE 10.0) to retrieve updates to data as soon as they are made when data is retrieved from a SDE view? The SDE view is in Oracle 11....
1
vote
0answers
38 views

ArcSDE post installation error?

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then when I ...
1
vote
0answers
82 views

Registering database to ArcGIS for Server gives null error?

I'm trying to register a database to ArcGIS for Server 10.2.0 from the web server manager using sde file from ArcMap. The connection works fine in ArcMap. But when registering I'm only getting a "...
1
vote
0answers
108 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
0answers
65 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 ...
1
vote
0answers
81 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 ...
1
vote
0answers
73 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 ...
1
vote
0answers
89 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 ...
1
vote
0answers
27 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 ...
1
vote
0answers
90 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 ...
1
vote
0answers
100 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. ...
1
vote
0answers
50 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 ...
1
vote
0answers
39 views

In ArcSDE, SQL Studio Manager 2012, How to get pixel data using a point layer?

I was using 'where' and 'ST_Intersects' with polygon data to get values 'under' my point layer. Example: Select rd.[FORESTNAME] as Forest, Count(Distinct morel.[OBJECTID]) AS Observations From [dbo]...
1
vote
0answers
117 views

FME Writing metadata to ArcGIS Online

I am trying to figure out how to write metadata to ArcGIS Online Feature Service from ORACLE SDE and how to update the existing Feature Service metadata, using FME or other tools. I am able to read ...
1
vote
0answers
196 views

Exporting data from ArcSDE gdb atribute table to file or personal geodatabase?

I'm currently learning GIS and I'm working on a project, I'm doing my own research and trying to accomplish the following with or without Python: Export data from an ArcSDE geodatabase attribute ...
1
vote
0answers
69 views

Importing XML workspace file without losing z and m parameters?

I am attempting to import an XML Workspace document (database schema) from a file geodatabase into an SDE geodatabase sitting on top of Postgres. The steps I am taking are: In ArcCatalog - right-...
1
vote
0answers
303 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
1
vote
0answers
385 views

Need to connect ArcSDE dataset using QGIS Desktop and Oracle database

I am working in GIS domain using ESRI technology. I want to use QGIS desktop to access ArcSDE dataset from a local machine. I have already installed Oracle Client 10g and QGIS Desktop 2.8.1 through ...
1
vote
0answers
59 views

How to recover from deleting the symbolid of a arcgis annotation feature class?

I have arcgis 10.1 (arcinfo license) and I am using a versionned database (arcsde) with SQL Server. I have accidentally deleted the symbolid of one of my annotation feature classes. All annotations ...
1
vote
0answers
130 views

ArcSDESQLExecute to query and update from multiple SDE Databases

I am trying to use ArcSDESQLExecute to return the results of a join and then write the return query into a Feature Class located in a different database. Using Microsoft SQL Server and Arc10.2.2 Is ...
1
vote
0answers
96 views

Using FME, Is there a way to transfer Metadata from an SDE FeatureClass to a Shapefile (shp.xml)

Is there a way to transfer, using FME, the metadata from an SDE featureclass to a shapefile?
1
vote
0answers
99 views

Get Feature Count

My situation is as below, Database 1 : SDE database.Topo Feature Class : 170 Database 2 : SDE database.AOI Feature Class : 1 I want to get feature count of 170 feature classes base on selected AOI ...
1
vote
0answers
44 views

Verify Geodatabase Integrity?

I'm regularly backing up an ArcSDE Geodatabase. The backup is done by using arcpy.Copy_management to copy datasets from SDE to a local File GeoDatabase. How can I verify the integrity of the back up ...
1
vote
0answers
37 views

Using REST Services acquiring limited data from DataBase like LayerDefinition

I am working with ArcGIS Server 10.2 and MS SQL DB. I have a requirement in which i need to retrieve limited data using a query from a bulk data using the same Map Service REST URL which can give me ...
1
vote
0answers
122 views

get the ogr_SDE.dll from the MapServer

can please some one give help to get the ogr_SDE.dll from http://www.maptools.org/ms4w/index.phtml?page=home.html I will connect the ArcSDE to my QGis, like that intruction https://hub.qgis.org/wiki/...
1
vote
0answers
79 views

Can SDEMON command be used on ArcGIS Desktop?

Working on ArcSDE I need to use SDEMON to monitor or stop users, so that I can do my updates. Can SDEMON command be used on ArcGIS 10.2 for Desktop?
1
vote
0answers
248 views

How to correctly uncompress and re-compress an msd file using 7zip from command line

I am trying to uncompress and recompress both the msd and sd file so as to tweak some things I want. In fact I want to get inside the layers folder and for each layer.xml file to string replace the ...
1
vote
0answers
133 views

'OutofMemoryException' whilst data trasnfer

I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer ...
1
vote
0answers
49 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...
1
vote
0answers
111 views

My layers are not visible after restart geoserver

I have ArcSDE connection on Geoserver. In order to make geoserver faster I have restarted it. After restarting my published layers (datas) are not visible. When I publish this layer again, geoserver ...
1
vote
0answers
145 views

How to extract xy coordinates to featuretable using ArcGIS web map/app to create points?

I have an ArcGIS online web app to collect points using the services served on our server. The featurelayer exists in our SDE server. How can I extract and update the xy (lat/long) coordinates ...
1
vote
0answers
311 views

SQL Prefix for arcpy.da.SearchCursor

Does the sql prefix - DISTINCT work well on SDE tables? http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000011000000 Syntax: SearchCursor (in_table, field_names, {where_clause}, {...
1
vote
0answers
36 views

Can I install GIS Software on RSS (informix server) running 11.7.fc6

I currently use ArcGIS Server 10.0 and consume data through a db2 database. I recently installed an RSS informix server and was hoping to pull data from this since it is updated real-time versus the ...
1
vote
0answers
81 views

ora-01747: user.table.column, table.column or column description is invalid

everyone. I created a table in oracle with a sde.st_geometry column. I followed the instructions of ArcGIS help to register the table into geodatabase. However, when I try to load data into this ...
1
vote
0answers
189 views

Renaming Feature Class within versioned Feature Dataset

I am working in ArcSDE. I have several feature datasets within an Oracle Enterprise Geodatabase. When I try to rename one of the feature classes that is within a feature dataset it "falls out" of the ...
1
vote
0answers
195 views

Editing versioned view in ArcSDE 10.1 error

I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete ...