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
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 < -- ...
- 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. ...
- 2,149
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 ...
- 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 ...
- 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 ...
- 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 ...
- 2,558
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('...
- 65
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 ...
- 75
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.
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 49
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 ...
- 91
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 ...
- 9,965
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 ...
- 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:
- ...
- 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 ...
- 43
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. ...
- 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 ...
- 61
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 29
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 ...
- 41
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 ...
- 68
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 ...
- 6,302
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 ...
- 115
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.
- 21
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 ...
- 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 ...
- 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 "...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 41
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 ...
- 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 ...
- 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 ...
- 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 ...
- 131
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 ...
- 3,107
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 ...
- 21
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. ...
- 21
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. ...
- 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 ...
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 ...
- 21
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 ...
- 525