Questions tagged [enterprise-geodatabase]

Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.

292 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
0 answers
319 views

Attaching old archive table (_h) back to original feature class on re-enabling geodatabase archiving?

I'm trying to figure out a way to update the schema of an archived feature class. There was a lot of discussion about this from 2012 and prior. https://geonet.esri.com/message/115340#115340 < -- ...
user avatar
  • 61
6 votes
1 answer
8k views

Debugging ERROR 000464: Cannot get exclusive schema lock?

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
user avatar
4 votes
0 answers
842 views

How to hide system tables of oracle in sde connection?

I connected to oracle 11g r2 with ArcGIS 10.2 using SDE connection. The connection is ok but in the connection i see system tables of APEX_030200 and other schemas. Same question is in the Geonet ...
user avatar
  • 5,777
4 votes
0 answers
569 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
user avatar
  • 1,059
4 votes
0 answers
196 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 ...
user avatar
  • 41
3 votes
0 answers
74 views

Refreshing Enterprise geodatabase layers using Python in ArcGIS Pro

Environment: ArcGIS Pro 2.8 with SQL Server Enterprise Geodatabase Background: I'm working with ArcPy, and I've written a script tool that performs a few attribute edits. It does the edits to a ...
user avatar
3 votes
0 answers
61 views

Loading layer from ArcSDE for SQL Server Database using PyQGIS?

I am use this code to load a layer from ArcSDE SQL Server database, but it only loads a table. uri = QgsDataSourceURI() uri.setConnection("localhost","", "arcsde", "sa", "****") uri.setDataSource('...
user avatar
3 votes
0 answers
104 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
user avatar
3 votes
0 answers
431 views

Where do field aliases reside in an SDE database?

If I want to get field aliases for an SDE table through pure SQL, what table do I query? My geodatabase was created with ArcGIS 10.1 in an Oracle database.
user avatar
  • 1,059
3 votes
1 answer
118 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 ...
user avatar
  • 123
3 votes
0 answers
165 views

Any way to speed up an append of data to SDE database while it is still versioned?

My group works on a database and about once a month I receive data that must be appended. This process has required me to reconcile and post all versions to default. I then pull down the database ...
user avatar
  • 113
3 votes
0 answers
1k 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 ...
user avatar
  • 786
3 votes
0 answers
251 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 ...
user avatar
3 votes
0 answers
51 views

Shoehorning hierarchial data into ArcSDE for MS SQL Server?

I've been tasked with creating a set of tables to store hierarchical data within an ArcSDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
user avatar
3 votes
0 answers
501 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 ...
user avatar
3 votes
0 answers
680 views

Geodatabase Connection to Oracle Active Data Guard Standby

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 Oracle Database 11g R2 ArcSDE for Oracle 11g 9.3.1 ...
user avatar
  • 289
3 votes
0 answers
782 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: - ...
user avatar
  • 415
3 votes
0 answers
2k 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 two layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
user avatar
3 votes
1 answer
964 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. ...
user avatar
  • 31
3 votes
0 answers
249 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 ...
user avatar
3 votes
0 answers
1k 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 ...
user avatar
  • 1,993
2 votes
0 answers
96 views

Disconnect users who are creating locks on specific feature classes

I have a nightly Python script which updates some domains in a geodatabase. The domain owner is "AMIS". In addition to the AMIS schema in the geodatabase, there are other schemas. In order ...
user avatar
  • 21.2k
2 votes
1 answer
292 views

FME - Cannot load versions in ArcSDE Geodb Writer

I'm attempting to write to a version in a 10.6.1 ArcGIS Enterprise Geodatabase with a SQL Server 2017 Backend. I have created a version in the database and I want FME to write directly to it. I'm ...
user avatar
  • 21.2k
2 votes
0 answers
563 views

Duplicate Global IDs within same feature class

I received a geodatabase from a contractor and I observed there are multiple feature classes with column of Global ID type. These Global ID type columns, when I checked data i realized there are ...
user avatar
  • 1,027
2 votes
0 answers
53 views

ArcMap replication tool does not synchronize changes made in versioned view from SQL Developer!

I am trying to replicate a feature class from Oracle to MSSQL Server using one-way replication(parent-child) replication. The replication works when edits are made from ArcMap,since I have to insert ...
user avatar
  • 418
2 votes
0 answers
619 views

Arcpy 'Append_management' much slower than ArcMap Tool?

Basically I have a script that grabs data from a web service, parses it, stores it in an intermediary local fgdb, then appends that data to the feature class in the enterprise gdb. The portion of the ...
user avatar
2 votes
0 answers
281 views

Describe FeatureClass shape type, can't get past error (object has no attribute 'shapeType')

My code: import arcpy, csv, os # Create a Describe object gdb = r"Database Connections\GISUSER.sde" desc = arcpy.Describe(gdb) full_path = False # Specify whether dataset name should be full or ...
user avatar
2 votes
0 answers
60 views

Editing Parcel Fabric in Versioned Geodatabase

We keep our parcel fabric in a SDE database with an intermediate staging version that multiple users post changes to from their own personal edit versions. We're able to edit the parcel fabric ...
user avatar
2 votes
0 answers
96 views

ArcMap Date values lose precision after copying feature class from fGDB to SDE GDB

I have some data in a file geodatabase feature class including some date fields. The precision on the date fields is to milliseconds and this is important. When I copythe feature class from the fGDB ...
user avatar
2 votes
0 answers
141 views

ArcGIS PostgreSQL Trigger

I currently have a trigger defined in my database which executes when my edits in ArcMap are saved using the AFTER INSERT ON method. Is there anyway to execute this trigger without having to select ...
user avatar
2 votes
0 answers
64 views

Editing Spatial View in ArcMap?

Can spatial views be edited via ArcMap and, if it is possible, then how do I do it? I do have my Enterprise Geodatabase on Oracle.
user avatar
2 votes
0 answers
343 views

Layers from a PostgreSQL/ArcSDE database connection are not showing in ArcGIS

We have a PostgreSQL/PostGIS SDE enabled database, but lately there is a strange issue when adding layers from this database to ArcMap or ArcGIS Pro. We can connect to the database without any issues ...
user avatar
  • 409
2 votes
1 answer
107 views

Selecting polygon feature classes with one record in Oracle geodatabase using SQL query?

I have an Oracle Enterprise geodatabase with many feature classes. I would like a SQL query to find all the polygon feature classes with only one record in its table. So far, I can only query all the ...
user avatar
  • 21
2 votes
1 answer
699 views

Enterprise geodatabase on PostgreSQL backup and restore

windows 7, PostgreSQL 9.4/ArcSDE/PostGIS backend database that I am transferring to another computer. My backup command is as follows. host 5433 pg_dumpall -h localhost -p 5433 -U postgres -c -f "...
user avatar
  • 4,065
2 votes
0 answers
444 views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running PostgreSQL and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
user avatar
  • 59
2 votes
0 answers
1k views

SQL Server 2014 Failure to access the DBMS server 08S01

After upgrading our esri sde database from SQL Server 2008 to 2014 I am experiencing issues when overwriting some of our larger datasets. After some amount of time the overwriting process abruptly ...
user avatar
  • 45
2 votes
0 answers
247 views

Importing raster dataset in ArcSDE/PostgreSQL/Postgis database useable in QGIS and ArcGIS?

I want to import a raster dataset in my database (PostgreSQL 9.4, Postgis 2.1), the catch is that I also want the raster to be viewed in QGIS via a Postgis connection. Importing feature classes in ...
user avatar
  • 409
2 votes
0 answers
50 views

No data found error when reconciling version in sde

I got an error when reconciling a version in the sde database and it seems sde cannot find the data in one table with a specific STATE_ID (for example STATE_ID = 12345 for table abc). In the delta ...
user avatar
  • 119
2 votes
0 answers
2k views

Unable to perform applyEdits in Feature Service

I am facing two issues with applyEdits through JavaScript API. 1. Unable to perform applyEdits When I perform ApplyEdits on feature service, I get the error "Unable to complete operation". When ...
user avatar
2 votes
0 answers
80 views

Geodatabase configuration keywords

I am trying to insert a new polyline dataset within my Oracle server database. The dataset in question is located within a local GDB, and is currently c420mb in size. It is taking hours and hours to ...
user avatar
  • 2,261
2 votes
0 answers
160 views

Can shp2sde on ArcSDE 9.3 server operate with SDE 10.3 database?

We have 2 servers running ArcSDE 9.3, and one Oracle database at SDE 9.3. Only one of the ArcSDE 9.3 servers is to be upgraded to ArcSDE 10.3, and the Oracle SDE database will be migrated from SDE 9.3 ...
user avatar
  • 121
2 votes
0 answers
227 views

Esri ST_Geometry function to make line from points

I'm attempting to write a SQL statement that joins two point feature classes, both in an Oracle ArcSDE geodatabase using ST_Geometry, and selects a line geometry connecting the points of each ...
user avatar
  • 1,059
2 votes
0 answers
98 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 ...
user avatar
2 votes
0 answers
226 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...
user avatar
2 votes
0 answers
475 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 ...
user avatar
2 votes
0 answers
198 views

Autonumbering using ArcGIS Web AppBuilder?

I work for a water utility division and we are using ArcMap 10.1 with attribute assistant. I used the AutoNumber method to auto increment and populate a field with the next highest integer. ...
user avatar
2 votes
0 answers
253 views

Different SRID problem

I have two geodatabases and I import a large number of tables from one to another by using ArcCatalog (ArcGIS 10.2). However the tables and indexes created on them are imported with different srid. ...
user avatar
  • 23
2 votes
0 answers
356 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 ...
user avatar
2 votes
0 answers
54 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 ...
user avatar
2 votes
0 answers
345 views

Layers are not visible after restarting 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 ...
user avatar
  • 525

1
2 3 4 5 6