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

How to compare two Geodatabases

I would like to compare the data of two geodatabases, in SDE or a file geodatabase, to detect the changes occured between them , i've tried to compare the Xml workspace document of both databases ...
5
votes
0answers
158 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
83 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' ...
4
votes
0answers
312 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
51 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
105 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
44 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
140 views

Checking current user privileges for an SDE dataset with Python/arcpy

I am managing data distribution via an ArcSDE Oracle gdb to a number of users (schemas?), each of which can only have read only access to datasets they have requested access to, and have then been ...
3
votes
0answers
77 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
706 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
131 views

How to enable SDE Archiving with python and the SDE api ArcGIS 10.0

I have a script that does some register as versioned and updating privileges. How would I call into the c api for ArcSDE to enable archiving with python? ...
3
votes
0answers
169 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
74 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
80 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
156 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
50 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
30 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
246 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
35 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
624 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
261 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
464 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
165 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
376 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
2k 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
64 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
206 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 ...
1
vote
0answers
17 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 ...
1
vote
0answers
60 views

Running python script outside of Arcmap's python console

My codes works fine in Arcmap's python windows. But when I try to run it in a command promt windows, It says that; ERROR 000837: The workspace is not the correct workspace type. But it works fine ...
1
vote
0answers
29 views

Multiuser Editing with ArcGIS through LAN

I am working on an ArcObjects application (C#), which is supposed to carry some customized editing operations, the database is ArcSDE based on Postgresql via (accessible via a LAN network). One ...
1
vote
0answers
68 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
1
vote
0answers
35 views

arcgis 10.2 spatial stored procedure in oracle throws pls-00707 compilation error

Package def: create or replace PACKAGE POSEIDON_PACK AS procedure tester; END POSEIDON_PACK; Body: create or replace PACKAGE BODY POSEIDON_PACK AS procedure tester as d number; begin ...
1
vote
0answers
44 views

How do I bypass class extensions when reading from ArcSDE with FME 2014?

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data. I am not able to set the Reader to bypass the class ...
1
vote
0answers
44 views

How to implement subtype functionality in Oracle Spatial?

I am planning to shift my entire database from arcgis to oracle. I will not be using ArcSDE services also. I need subtitutes for ESRI's functionalities like domain, subtype, relationships in oracle. ...
1
vote
0answers
40 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
1
vote
0answers
48 views

Problems with versioning

I have 5 PostgreSQL_PostGIS database in my company and i conneting on them through ArcSDE. Four of database work correctly, only with one i have i realy big problem. When i make two versions of ...
1
vote
0answers
186 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
0answers
72 views

Why might ArcPy, TableToTable, MakeQueryTable and ArcSDE have performance issue in IDLE?

I have written a Python script tool to do: Make Query Table Table To Table (with fieldmapping). The code is nothing more than arcpy.MakeQueryTable("table1;table2;table3", ...
1
vote
0answers
57 views

What is the relationship between Map Service Instances and SDE connections?

We have a GPS project based on ArcGIS Mobile 10.0. There are two web map services and each were kept as Nonpooled with Minimum instances 15 and maximum instances 60 by original developer. The database ...
1
vote
0answers
72 views

“Definition Query on a versioned Geodatabase”

I would like to implement Specific views to the SDE users, based on Definition Queries of common attributes , like Date created > = October 1. But on first look, the definition queries are for ...
1
vote
0answers
63 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
1
vote
0answers
76 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
1
vote
0answers
128 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
1
vote
0answers
174 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
1
vote
0answers
141 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
1
vote
0answers
72 views

SDE Connection raise exception

I am supporting a .NET code that is running on ArcGIS Server 10.1, and communicating with ArcSDE Application Server 9.3 There is part of the code that is doing long loop. And when it comes back to ...
1
vote
0answers
92 views

Extract an ArcSDE datasets (rasters/shape files) using python?

I would like to write a python script to extract/export a dataset (rasters/shape files) in ArcSDE. I saw this posts to connect to the server: Define Workspace for SDE Connection in Python But how ...
1
vote
0answers
129 views

How to run SDE view commands in Oracle DB?

I would like to create SDE view to compare two tables in my oracle spatial database. I already prepared the view commands. But I dont know where and how to run this? I unable to run this commands in ...
1
vote
0answers
156 views

Best practice for loading shapefiles into ArcSDE geodatabase using web application

We are developing a web GIS using Flexviewer and we want to allow users to upload a shp file and insert it into a ArcSDE geodatabase. I think there are two steps at least. upload the shp file (zip) ...
1
vote
0answers
58 views

sdequery.exe: When using functions as column names (-C parameter), how do you escape the comma for functions with parameters?

Using sdequery, I'm specifically trying to return sys_context('USERENV', 'SESSIONID'). user and sysdate work fine. Functions with single parameters work fine. But as soon as I use a function with ...