Tagged Questions

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)

0
votes
0answers
40 views

Why can't I permanently remove this vertex?

I'm correcting some data in ArcMap for import into another software. The export utility isn't liking some of the data, and the only difference I've noticed is extra vertices in the polylines. The data ...
0
votes
1answer
25 views

Is there a performance difference between SQL Server 2008 and 2008 R2?

We are currently hosting our ArcSDE geodatabase on SQL Server 2008 SP3. I was wondering if there'd be any type of performance boost if we jumped up to 2008 R2?
2
votes
0answers
56 views

Error with da.UpdateCursor and SDE feature classes

I am making my first attempt at editing an ArcSDE feature class with python through a da.UpdateCursor. I'm essentially taking code I've written for a file geodatabase feature class and applying it to ...
1
vote
1answer
35 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
0answers
22 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
1answer
35 views

Arcpy ListFeatureClasses in same workspace differs when run from ArcMap VS IDLE

This Works The following python script works when connecting to my dev ArcGIS server, from both the ArcMap python window and the IDLE python GUI/shell running on my dev workstation: import arcpy ...
1
vote
1answer
34 views

Change sde connection parameters with ArcPy

I know you can create a database connection with Arcpy using the CreateDatabaseConnection_management function. I am wondering if anyone knows a way in which to change the parameters of that file. ...
1
vote
0answers
41 views

Why do pgadmin III views show up as empty ArcSDE geodatabase tables in ArcCatalog? [closed]

I have an SDE geodatabase connection set up in a server with data stored in a postgres database. I have successfully created views using pgadmin III but they show up as empty tables in ArcCatalog ...
2
votes
1answer
63 views

Changes not persisting in ArcGIS server from ArcPy script

I have a ArcPy script (10.2) which connects to an ArcGIS server (10.0) versioned geodatabase, via an .sde connection file in the Database connections directory through direct connect on a Microsoft ...
1
vote
1answer
27 views

Make FeatureClass that has a FileGeodatabase data source editable?

I wasn't able to find any documentation on this, but is it possible to use the Editor widget in the Esri JS API to edit a FeatureLayer whose data source is that's stored in a FileGeodatabase? I've ...
1
vote
0answers
17 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 ...
2
votes
2answers
63 views

Get Coded Value Domains from a Oracle geodatabase using PLSQL

i'm trying to get all coded value domains from a Oracle geodatabase. I dont have access to arcmap. I only have access to oracle 10g database. SELECT I.NAME Domain, ...
1
vote
1answer
18 views

Multiple (seperate) Attachment Tables

Is it possible to have multiple attachment tables related to one feature class? The purpose is to only show specific attachments at certain times. We are trying to only show pertinent attached ...
2
votes
1answer
31 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
2
votes
1answer
43 views

How to add ST_GEOMETRY column to an exitsting table that already has X Y columns

I have created and Oracle 11g geospatial geodatabase and have create an arcsde connection. I have been connected using arcmap, as a simple user (not sde or schema-user), who has all the proper rights ...
1
vote
1answer
20 views

Syntax to view permissions on Oracle table

I want to be able to see what permissions have been granted on a specific object in my Oracle geodatabase. What would my script look like? Thank you.
0
votes
1answer
48 views

Integrate geodatabase with other nonspatial databases in oracle 11g using ArcGis for Desktop 10.2

I have an oracle database namely xe which I have spatially enabled. using the Create Enterprise Geodatabase geoprocessing tool. The application I am going to implement has an already created ...
0
votes
0answers
42 views

Error selecting geometry from Oracle DB

I'm trying to select a geometry column as well-known text from a feature class in an Oracle 11g/ArcSDE 10.1 geodatabase. (This is in a Python script using pypyodbc as a driver). This is my SQL: ...
1
vote
2answers
57 views

Create an enterprise geodatabase - Administrator username and password are required

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create ...
1
vote
1answer
28 views

Concurrency and lock challenge in Nonversioned editing in ArcMap

I use a non version SQLServer geodatabse with geometry type for spatial data storing.To do so,I have registered all layers in SDE repository and geodatabase and ArcMap shows all layers and edit them ...
2
votes
1answer
53 views

using arcpy to get all database names within a server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
2
votes
2answers
33 views

Using a selection tool will select everything

When I use the Selected Features tool and try to drag a box around a few small items it grabs everything. If i use the edit tool it will correctly select only features that are inside/intersect the ...
3
votes
0answers
62 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 ...
2
votes
2answers
178 views

How to connect QGIS to an Oracle DB (SDE)?

I want to access an Oracle Database (with SDE) from Qgis 2.4. I have tried many different options from within the window Create a new Oracle Connection but I always get an error message (ORA-12514: ...
2
votes
2answers
44 views

connect ArcGIS server with different instances of oracle database

Is it possible for a development team to have personal oracle database instances, for testing purposes, connected with the same GIS server? In other words I want every user to work with his own data, ...
1
vote
1answer
6 views

Generate Statistics from check-out GDB While performing Check-in

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. How to generate statistics of the edits performed on the check-out GDB, before check-in. for example: i want to have ...
1
vote
1answer
19 views

Can adding of attribute table fields cause geoDB replica fail

We have a arcsde replica between 2 sql server geoDB, it is one way replica and our side is the child. Recently our scheduler to synchronize the replica failed. The parent side add fields in some ...
1
vote
2answers
39 views

Differences between ArcSDE 9.3 and 10.0?

I am curious that what is differences between ArcSDE 9.3 and ArcSDE 10? Is there ArcSDE 10 to use it? Or ArcSDE 10 is coming with ArcGIS for Servers? Can anyone explain me?
1
vote
0answers
18 views

Updated features from GDB after Check-out Replica created from ArcSDE GDB [closed]

I have created Check-out Replica from the main ArcSDE GDB. I have below questions. If GDB Admin update few things (Attribute or Spatial) after version was created, will it be reflected in the child ...
2
votes
1answer
51 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
1
vote
1answer
37 views

Using ArcGIS for Server and ArcSDE for importing shapefiles?

Is there a way to use ArcGIS Server web services to perform the task below? I have .NET ArcObjects code to import shapefiles to Spatial DB which works on ArcGIS for Desktop. This code used ArcSDE to ...
0
votes
1answer
82 views

How to explain why a particular ArcSDE state does not compress?

I am maintaining an ArcSDE database and would like to avoid killing connections to ArcSDE in order to run the compress operation. Our versioning workflow is very simple. Everyone edits the DEFAULT ...
1
vote
1answer
70 views

Why does arcpy.TableToDomain_management require exclusive schema lock?

I'm talking about arcpy.TableToDomain_management, ArcGIS Server 10.2 It seems that this function requires exclusive SDE database schema lock. Something that we can't accept. We have ESRI domains but ...
4
votes
2answers
84 views

Benefit of using GlobalIDs in ArcSDE geodatabase?

This may be somewhere, but I can't find a clear answer on exactly the benefit of GlobalIDs are in a database. What are the benefits of using these in an organization that has about 6 people editing ...
1
vote
0answers
30 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
1answer
42 views

Replicate Geodatabase and append to main SDE database

I have my ArcSDE GDB on SQL Server 2005. This we are maintaining at our end at head office. Now we have installed ArcGIS editor license to regional offices. GIS technicians at regional offices can't ...
0
votes
1answer
34 views

arcmap replica error number and description list

We have a replica between our sql server geoDB and another sql server geoDB. It is a one-way replica and our geoDB is the child. Recently an error occurs (error 000582). I searched for the cause of ...
4
votes
2answers
89 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
3
votes
0answers
73 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, ...
0
votes
0answers
33 views

What is the most efficient method for deleting row/features from a versioned FC in python?

I'm trying to delete all records from a feature class in SDE and then append new data using python. My dataset is versioned in SDE. I've tried Truncate Table (doesn't work with versioned tables), ...
1
vote
0answers
64 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}, ...
3
votes
1answer
51 views

How do versioned views work with multiple editors?

I understand that in the database environment, by executing version_util.set_current_version('version1') Editor1 is able to write SQL statements against [table_name]_vw views to edit the data at ...
1
vote
1answer
60 views

Can't select geometry from Oracle DB using SQL

I'm trying to select the geometry field from an ArcSDE feature class in an Oracle 11g database (inside of a Python script via PyODBC). This is my query: SELECT SHAPE FROM USR.FEAT_CLASS This is ...
3
votes
1answer
41 views

File GDB to SDE Database using FME

I'm currently stuck in my FME Workspace script. Ideally, I'm reading from a file geodatabase and will update the SDE database in SQL server. I have CRC calculators to check for the changes in the ...
1
vote
0answers
49 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 ...
0
votes
1answer
26 views

arcsde topology register issue

I am in trouble with the topology in a sde database. I create a topology in a dataset from arccatalog, after managing to register it as aversion, I try to validate it from arccatalog, it tells me ...
1
vote
1answer
64 views

Invalid SQL-Statement error when querying file-geodatabase table date field with arcobjects

I want to query a DateTime Field in a table in a file-geodatabase and I keep on getting the error "invalid sql statement" (Error Code: -2147220985) while that sql statement does not give me an error ...
1
vote
0answers
48 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
1answer
48 views

Cannot Register Database

I want to publish a database to ArcGIS Server. When I try and register the database, I get this error: Can anyone help me? I am using ArcGIS Server and Desktop 10.2 with Microsoft SQL Server 2008. ...
2
votes
1answer
65 views

Python script fails on stand alone but works in ArcMap as a toolbox

I have a fresh install of ArcGIS Server and ArcGIS for Desktop both 10.2, latest patches applied. The data is served in this application from a PostgresSQL enterprise geodatabase. The problem is that ...