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
173 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
132 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
379 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
72 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
43 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
451 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
42 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
979 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
529 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
223 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
547 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
4k 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
97 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
66 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
1answer
143 views

arcsde huge size file upload into Oracle spatial

I have 35million records (tomtom multinet) of file gdb file in my desktop machine. I need to upload this file into Oracle spatial as SDO_geometry file. I already tested the connection with small ...
2
votes
0answers
232 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
213 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
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
114 views

Update Attribute based on spatial location

I want to spatially (Spatial Join) update few fields, not all, from another feature class. Is there any way to select and update few fields instead of all the fields from the other layer and ...
1
vote
4answers
2k views

error in arcsde service

I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database SDE not Running on Server Then I Check the Service esri_sde it has ...
1
vote
2answers
155 views

Why do I have various *.sde files on my server?

I have an old pc at work which has been used to serve a large aerial Photo. I can only imagine that this was done due to lack of space. I have now found 5 other sde files on the server. I have no idea ...
1
vote
2answers
264 views

Why using multiversioned views?

I don't see the reason why multiversioned views exist. It's not possible to use joins like in normal views. And editing versions is possible by directly using the feature class itself. So when am I ...
1
vote
1answer
498 views

Where to download ArcSDE?

I have ArcSDE for SQL Server 2008 R2. I want to install ArcSDE for another version of SQL Server. I want to download the ArcSDE software but I cannot find it in search. Where can I find it?
1
vote
1answer
409 views

Copy features between file geodatabase and ArcSde by using ArcObjects

I want to transfer all contents of a table from file geodatabase (*.gdb) to a table in ArcSde. In fact the data is meant to be replaced, so I need also to clear the table in ArcSde. Both tables have ...
1
vote
1answer
300 views

Secure credentials for scheduled python script targeting ArcSDE 10.1 on AWS

I have a python script that will be used as a scheduled task. Our dba team is wanting the credentials to be as secure as possible. I would say that using the os security system as far as locking ...
1
vote
3answers
284 views

How to register as versioned using SDELayer?

This is the normal process using ArcCatalog : I want to automate this process using sdeLayer or any tools - does anybody have an idea as to how to do it? there is an application sdelayer ...
1
vote
1answer
318 views

ArcSDE for ArcGIS Desktop

I have ArcGIS desktop (info) license. I want to know if I can configure SDE, where in I can work with versioning of geodatabases.
1
vote
1answer
86 views

What is the maximum size supported for ArcGIS Server Workgroup?

I have a database with a size of 200 gb and expect to grow near of a 1 Tb in two years. It´s possible to install an ArcGIS Server Workgroup 10.2 with this size of information? I´m afraid not ...
1
vote
1answer
45 views

ArcGIS Server 10.1 GP Service non-functional after ArcSDE restart

every night, the Oracle/ArcSDE server gets restarted. As a result, some, but not all, map and GP services require a restart to be functional afterwards. Can others confirm this experience and share ...
1
vote
2answers
213 views

How is it possible to publish data with ArcGIS Server without creating ArcSDE service or using ArcSDE?

I am still relatively new to the ESRI server techologies. I have server1 which runs ArcGIS server 10.0 and when I look at which processes running on this server I see ArcSOM.exe, ArcSOCMON.exe and ...
1
vote
1answer
68 views

Should large Basemaps be stored in DBMS via ArcSDE?

As I understand it, the SDE Geodatabase provides the technology for Multiuser databases, Versioning, replication and other Geodatabase functionality. In my organisation, this could be useful for ...
1
vote
2answers
229 views

ArcSDE installation; “sdesetup: command not found”

I am trying to install ArcSDE component for postgresql database from A DVD file. I have copied files of following folders on the server : command_64 pg_64 in both of theses files there are ...
1
vote
1answer
300 views

Is there a way to change environment settings of a dataset without creating a new one?

I am trying to change the environment settings of an existing dataset. I found a workaround by first changing the environment settings in the SDE-database and then create a new dataset with now ...
1
vote
2answers
2k views

How do I use Oracle Locator's mdsys.sdo_geometry with ArcSDE?

I'm using the Oracle Locator MDSYS.SDO_Geometry type to store my spatial information and then accessing it through ArcSDE. I'm confused about how the precision component of the metadata is used and ...
1
vote
2answers
77 views

Is it possible to consume ArcGIS Hosted Table into local or ArcSDE geodatabase?

I would like to publish a table to our ArcGIS Online (AGOL) organization account. Is it possible to consume hosted features in AGOL to a local db or ArcSDE database connection? By consume I mean ...
1
vote
1answer
53 views

migrate to Enterprise GIS

We have basemap with shape file, now we have purchased ArcGIS 10.2 with server and ArcSDE and Oracle. we want to establish Enterprise level so that multiple users can edit without overwrite the source ...
1
vote
1answer
34 views

What is the proj4 for World Behrmann (54017)?

I have this in an old SDE database: ...
1
vote
2answers
401 views

Debugging 'module' object has no attribute 'SdeWorkspaceFactory'?

I am new to python, am debugging one of existing python code, where am facing an error "'module' object has no attribute 'SdeWorkspaceFactory". Earlier this code was working fine but suddenly does not ...
1
vote
1answer
223 views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with non-spatial Oracle tables. These tables have a field named 'objectid' because were created originally for inserting/updating records by using ArcGIS instead, not ...
1
vote
1answer
194 views

ArcSDE cannot perform post installation

I have installed the following before I installed ArcSDE 10.2.1: ArcGIS for Desktop 10.2.1(standard) ArcGIS for server Enterprise 10.2.1(standard) MS SQL server 2008 create enterprise geodatabase ...
1
vote
2answers
88 views

Conversion to SDE changes names

I could not find anything on this topic already discussed. We converted our file-based system in ESRI to an SDE instance on Sql Server. We made changes in our code to open using the connection string ...
1
vote
1answer
220 views

Registering a SDE Service in 10.1 with Command Line

I am installing ArcSDE on a new development box. I have executed the setup.exe, created an Enterprise database called "GDB123" and created a new sde service called "sde_123". I need some ...
1
vote
3answers
984 views

ArcGIS Copy Features tool extremely slow when exporting to ArcSDE?

I have about 10 points in a file gdb that I am attempting to copy over to an sde feature set. In arcpy and in model builder it takes about a minute to execute. Do you know of any tips to speed this ...
1
vote
1answer
272 views

Database Connections folder is empty when viewed with ArcGIS tool

I'm trying to create an ArcGIS tool which accepts an SDE connection file as an input. I made a new interface with an input parameter and set the type to Database Connections. When I open the tool and ...
1
vote
1answer
787 views

Using sdemon command of ArcSDE?

I am pretty new to ArcGIS for Server and ArcSDE but cannot find a solution in the Esri Documentation or Forums. I don not know how to use sdemon or even where to start this command line tool.
1
vote
1answer
606 views

Why does arcpy append from file geodatabase to SDE fail?

I'm trying to append a feature class from a file geodatabase to an Arcsde featureclass using this line of code: arcpy.Append_management("parcel_copy", sde_path+"parcel" ,"NO_TEST") This line works ...
1
vote
1answer
381 views

ODBC connection to ArcSDE table shows old version in ArcMap?

I use an ODBC connection to an ArcSDE table to return a current list of features for reporting purposes. The connection is pointed at a Microsoft SQL ArcSDE server and the connection info matches ...
1
vote
1answer
2k views

Trouble creating ArcSDE Connection File

I'm having trouble creating a ArcSDE Connection File. When I bring up the GP tool to do this, I enter the folder I was save the sde file to, enter an name for the file 'MySDEConnect.sde', enter the ...
1
vote
2answers
176 views

Associating data in a form with an SDE Layer

I was wondering if there was a way to associate/persist some data about an SDE featureclass when viewing via ArcCatalog. I know you can have metadata - but I don't want to use that, and I'm pretty ...
1
vote
3answers
1k views

Is the “sdetable” command available with ArcGIS Workgroup

Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition? We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from ...