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)

5
votes
0answers
192 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE ...
4
votes
0answers
61 views

ArcObjects : Out of Server Memory when reconciling a large edit session

One of our users has been periodically experiencing 'Out of Server Memory' errors with ArcSDE 10.0 when trying to reconcile a large edit session. VMware ESX Instance: Windows Server 2008 R2 ...
4
votes
0answers
348 views

Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase

I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
3
votes
0answers
70 views

ArcObjects Memory Leak with IWorkspaceEdit?

I have ArcGIS 10.1 installed. I have created a function for copying all of the features from one shapefile to another using IFeatureBuffer, now every time the function when it is called, it takes ...
3
votes
0answers
74 views

Pulling ArcSDE feature classes from current map to fieldmapping as DETable?

I'm working with SDE layers in arcmap. trying to avoid pointing to the sde file itself. I've tried workspace.Pathname, it was empty for sde remote workspace. I've also tried IName from workspace, ...
3
votes
0answers
56 views

Which edition of ArcGIS for Server and which capacity level?

I need to define the edition of ArcGIS for Server product to invest for a small scale oil & gas company. What we need is to be able to: Work on a geodatabase with 2-3 concurrent desktop users ...
3
votes
0answers
39 views

Looking for a QGIS solution to make aerial imagery ArcSDE compatiable

Would like to avoid having to use 3d Analyst and use free raster tools in QGIS or elsewhere to make aerial rasters ArcSDE compatible. This 18 page work flow is what I am trying to use. Any suggestions ...
3
votes
0answers
86 views

What are the pros/cons of using an MSSQL SDE Database rather than a File-gdb in ArcGIS Server

I have taken over an ArcSDE 9.3 Enterprise database setup which has around 80% of it´s vector data in an MSSQL SDE Database system and 20% in FileGDB on the application server. I am trying to ...
3
votes
0answers
189 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
3
votes
0answers
70 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
3
votes
0answers
142 views

How to repair Geometric Network in Versioned ArcSDE Geodatabase?

Our Versioned ArcSDE workflow has a feature dataset with Geometric Network in the parent (Default), which users derive in their own versions. It is now observed that in some versions, the geometric ...
3
votes
0answers
1k views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
0answers
102 views

How to split Relationship Class privileges between different users while maintaining referential integrity?

I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' ...
3
votes
0answers
178 views

ArcSDE Database Refactoring Tools?

We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas. But we also work with GIS applications using esri ...
2
votes
0answers
26 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
0answers
42 views

Arcpy cannot connect to SDE on PostgreSQL with 32-bit version

So I've been banging my head against a wall for awhile with this one. I recently setup an SDE database in Postgres, and all seemed good. I am able to connect to it from both ArcMap and ArcCatalog, ...
2
votes
0answers
34 views

ArcGIS Publisher PMF Version Compatibility

Does anyone know of version compatibility issues of creating a PMF? Or links to that documentation? I have not seen anything from Esri. I have asked Esri Support, and will update with their response. ...
2
votes
0answers
44 views

Update Existing Feature Class by Replacing Features with Updated Versions from a Shapefile

I have a feature class in a versioned ArcSDE geodatabase with archiving enabled. I receive regular updates for this data in shapefile format. I want to be able to replace any features that have ...
2
votes
0answers
96 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
0answers
111 views

Bulk insert into MS SQL Creating ObjectID's

I am running an ETL from a spatial view into publication database. The view has results in duplicate ObjectID's. I started working with the get_ids SP example from ESRI, but that seems to be built ...
2
votes
0answers
26 views

Shoehorning hierarchial data into MS SQL ArcGIS SDE

So, I've been tasked with creating a set of tables to store hierarchical data within an SDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
2
votes
0answers
76 views

Cannot Save Edits to File Geodatabase Replica in QGIS 2.2

When trying to edit a File Geodatabase Replica in QGIS 2.2, everything works as expected until the user saves their edits. When pressing save, all edits revert back to their original state with no ...
2
votes
0answers
139 views

Issues importing feature class to SDE SQL Server 2012

I have received an error indicating there could be issues with my geometry when attempting to import a feature class into SDE. I ran the check geometry tool. No issues. I have removed all fields ...
2
votes
0answers
107 views

Data loss after compressing geodatabase in ArcSDE

I suffer sometimes from data loss after compressing ArcSDE geodatabase, this geodatabase contains versioned feature classes, so the compressing script reconciles and compress the geodatabase: # ...
2
votes
0answers
288 views

ArcGIS 10.1 & SQL Server 2012

We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012. Here are the things that we tried to fix the issue: - ...
2
votes
0answers
69 views

Can .Net version of ArcGIS Server expose Oracle spatial data without ArcSDE, or is this limited to Java version?

I'm planning a new deployment of ArcGIS Server and I want to avoid using ArcSDE if possible. My vendor requires that we store our spatial data in Oracle and we prefer to use Microsoft server ...
2
votes
0answers
38 views

How to know Who is reconciling the Version to DEFAULT(Parent) in Geodatabase

We have Public DEFAULT version and working Versions(Child) have been created directly from DEFAULT. We have also provided Reconcile-Post Option to group of Users placed at separate locations. Hence ...
2
votes
0answers
354 views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
2
votes
0answers
40 views

Is it possible to re-point operational layers ArcGIS Mobile projects v.3.0

We have an ArcGIS mobile project with two operational layers for data collection. The layers source from a GIS server on the cloud, running on top of an SDE. The database has a feature dataset, and ...
2
votes
0answers
846 views

What is fastest way to copy feature dataset from ArcSDE to File Geodatabase in ModelBuilder?

What geoprocessing tool is the fastest for copying feature datasets from SDE to fgdb? I want to make a model in ModelBuilder that copies an entire featuredataset from my SDE database to a file ...
2
votes
0answers
295 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
2
votes
0answers
510 views

View in ArcSDE 10.1 Problem

I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In ...
2
votes
0answers
199 views

How to compress enterprise geodatabase with stored procedure?

I'm looking for a stored procedure in ArcSDE for SQL Server which performs geodatabase compression to include it in our daily maintenance plan. Is there any such thing in ArcSDE 10.0?
2
votes
0answers
459 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
3k views

ArcSDE error: “Maximum number of connections to instance exceeded ”

I have an ArcSDE error: " *Failed to connect to database. Maximum number of connections to instance exceeded " Did what ESRI recommended :" Check the value set for the CONNECTIONS parameter in ...
2
votes
0answers
92 views

Storing Shapes in database

What is more effective? Storing Shapes as shape column (http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/topology_basics.htm) in database? Or maybe store shapes in seperate tables ...
2
votes
0answers
65 views

ArcSDE Feature View in a GeoDatabase other than the Feature's Database

here is the problem I have been struggling with: We have our spatial features in an SDE enabled DB (call it DB1) and have a client DB which is SDE enabled as well (meaning geo-DB call it DB2) and ...
2
votes
0answers
225 views

Importing Rasters to ArcSDE 9.3.1 using sderaster

OK, I am trying to import a raster to 11g using the sderaster command. It is a stand alone jpg with a world file associated, and pyramids. Am I right in assuming I cannot import a JPG, I can only ...
2
votes
0answers
206 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 ...
1
vote
0answers
28 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
22 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
31 views

Are there naming rules for direct connections from ArcGIS to PostgreSQL?

I don't have problem direct connecting arcgis to postgresql if my database name contains only letters, but when the name contains dashes or underscore e.g:"gisdb-dev", I receive an error when setting ...
1
vote
0answers
23 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
38 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
74 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
67 views

arcpy geoprocessing service with sde database produces no output url

I'm trying to use a geoprocessing script to clip some data and return to the user (via url) the path to a zip file with the results of the clip. I also need to connect to an sde database. I can get ...
1
vote
0answers
50 views

ArcGIS Error 999999: Feature Compare Tool

I'm running the ArcGIS feature compare tool against 2 point feature class layers. I'm comparing 9.1 SDE layer against a 10.1 SDE layer. In the feature compare tool one of the input options is ...
1
vote
0answers
27 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
37 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
39 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 ...