Questions tagged [enterprise-geodatabase]
Use this tag for questions about the Enterprise Geodatabase (ArcSDE in earlier versions) component of ArcGIS for Server.
251
questions with no upvoted or accepted answers
5
votes
0answers
273 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 < -- ...
5
votes
1answer
5k 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. ...
4
votes
0answers
654 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 ...
4
votes
0answers
453 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 ...
4
votes
0answers
192 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
97 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 ...
3
votes
0answers
39 views
Limit users' editing privileges by attribute and role
I have a feature class in an Oracle 12c geodatabase.
The feature class has a type column. The column has a coded domain.
I would like to limit user's ability to edit the features based on the type ...
3
votes
0answers
711 views
arcpy.ListFeatureClasses returns empty list
I'm working with SDE connection and want to find if a layer exists on a server. Code sample is:
ws = r'Database Connections\Connection to sde-srv.sde'
# second option to access connection file, same ...
3
votes
0answers
57 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('...
3
votes
0answers
94 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 ...
3
votes
0answers
249 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.
3
votes
0answers
140 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 ...
3
votes
0answers
855 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 ...
3
votes
0answers
248 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 ...
3
votes
0answers
47 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 ...
3
votes
0answers
422 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
610 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 ...
3
votes
0answers
776 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:
- ...
3
votes
0answers
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 ...
3
votes
1answer
829 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. ...
3
votes
0answers
236 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 ...
3
votes
0answers
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 ...
2
votes
0answers
60 views
+50
Get midpoint of SDE.ST_GEOMETRY polylines?
I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1).
I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
2
votes
0answers
34 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 ...
2
votes
0answers
42 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 ...
2
votes
0answers
116 views
Exporting Query Layer (stand-alone table) to file geodatabase?
I'm using an SQL query (from MS SQL Server) on an enterprise DB connection, and am able to create a stand-alone table from the "Make Query Layer" tool.
After this table (stand-alone query table) is ...
2
votes
0answers
31 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 ...
2
votes
0answers
49 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 ...
2
votes
0answers
859 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 ...
2
votes
0answers
181 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 ...
2
votes
0answers
43 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 ...
2
votes
0answers
135 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 ...
2
votes
0answers
172 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 ...
2
votes
0answers
91 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 ...
2
votes
0answers
190 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 ...
2
votes
0answers
264 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 ...
2
votes
0answers
154 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. ...
2
votes
0answers
211 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. ...
2
votes
0answers
162 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, ...
2
votes
0answers
302 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 ...
2
votes
0answers
327 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 ...
2
votes
0answers
2k views
Update Existing Feature Class by Replacing Features with Updated Versions from a Shapefile
I have a feature class in a versioned ArcSDE geodatabase with archiving enabled. I receive regular updates for this data in shapefile format. I want to be able to replace any features that have ...
2
votes
0answers
335 views
Editing versioned view in ArcSDE 10.1 error
I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete ...
2
votes
0answers
899 views
Bulk insert into MS SQL Creating ObjectID's
I am running an ETL from a spatial view into publication database. The view has results in duplicate ObjectID's. I started working with the get_ids SP example from ESRI, but that seems to be built ...
2
votes
0answers
148 views
Cannot Save Edits to File Geodatabase Replica in QGIS 2.2
When trying to edit a File Geodatabase Replica in QGIS 2.2, everything works as expected until the user saves their edits. When pressing save, all edits revert back to their original state with no ...
2
votes
0answers
321 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
275 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
96 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
66 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
1k 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 ...
