Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [enterprise-geodatabase]

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

2
votes
0answers
9 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 ...
0
votes
0answers
35 views

Why does opening SDE Workspace Factory ask for credentials again? ArcObjects C#

I'm trying to open SDE Workspace Factory using IWorkspaceFactory.Open I give the complete Property set in the code to open. ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS....
1
vote
0answers
23 views

Recovering accidental edits through ArcGIS Pro Version Changes window?

We have a situation with our ArcSDE where features were accidentally deleted inside a version and we would like to recover those changes. We cannot undo edits because they were saved in a previous ...
0
votes
1answer
36 views

How to import data (with schema) from MSSQL to PostgreSQL?

I have an ArcSDE enterprise geodatabase in MS SQL Server 2008. I want to replace MS SQL Server with PostgreSQL. I have setup and created the enterprise geodatabase in PostgreSQL and now want to ...
-1
votes
0answers
16 views

FME Geodatabase XML reader not reading relationship class [duplicate]

I am reading Geodatabase from XML and this xml has more then 30 feature classes and relationship classes. I want to convert this to an SDE Geodatabase. I am using ESRI SDE Writer. In Reader i have ...
0
votes
0answers
17 views

Importing XML to specific version of ArcSDE?

I am working in a distributed environment. I've got the data update for a specific version of enterprise geodatabase. Is there any way to import that XML in specific version? We have a province ...
0
votes
0answers
20 views

Foreign key value in destination table is nullified when origin feature is deleted from ArcGIS relationship - workaround?

I have an SDE geodatabase in which I have an origin feature class with relationship classes to several destination feature classes and tables. When a feature is deleted from the origin table, the ...
1
vote
0answers
17 views

Using primary key in ArcSDE Enterprise Geodatabase with MS SQL Server?

Does setting a primary key constraint in a field obstruct the compression of a versioned geodatabase? I read someone mentioning that the primary key in a versioned geo-database will cause problem ...
0
votes
0answers
26 views

Connecting ArcSDE geodatabse 10 from ArcSDE service Version 9.3

I have recently upgraded ArcSDE Geodatabse from 9.3 to 10.0. The applications were using SDE connection through ArcSDE Windows service V 9.3 Now when I tried starting the same ArcSDE windows service ...
2
votes
1answer
39 views

How to hide certain views from ArcCatalog?

I have users that connect to an enterprise geodatabase via OS authentication. They use a couple of methods: An .SDE connection in ArcMap A ODBC connection for MS Office The users need to be able to ...
0
votes
0answers
20 views

Creating geodatabase, that has all layers used in creating map from different geodatabses?

I have been working on creating a city map, that had layers sourced to different gdbs stored on my desktop, now my final product is ready after 3 months and I have to package the datasets and send ...
1
vote
0answers
51 views

Reading .sde connection file without Esri softwares?

I would like to be able to read connection properties from an sde file without any Esri dependencies such as Arcpy, ArcObjects etc. Is this possible?
0
votes
0answers
17 views

Exception while trying to sync SQLite to featureserver by Esri Android API after deleting and recreating mapService

I've developed a sample app which has a downloaded SQLite file from sync enabled feature server. for no reason, the feature server stopped and in the Android app, the user couldn't connect to feature ...
0
votes
0answers
37 views

One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
0
votes
1answer
36 views

Portal And ArcSDE Geodatabase: Feature Datasets or Not

We recently had a health check with an Esri representative, to look at our Portal system. After looking at our ArcSDE enterprise geodatabase she said it was organized very well with everything put ...
0
votes
0answers
23 views

Using OS authentication for users with period in name when editing PostgreSQL database from ArcMap?

I am trying to set up a PostgreSQL server to integrate our active directory credentials. I can edit the pg_hba.conf file to allow users with an internal IP to connect with OS authentication. host ...
1
vote
0answers
40 views

Understanding terminologies on Esri ArcSDE [closed]

I am new to ArcSDE. Can anyone help me understand the differences between versioning, replication, synchronization, archiving, editor tracking, and schema change? Their concepts are similar to me. ...
1
vote
1answer
62 views

Execute Oracle stored procedure from ArcSDESQLExecute

I'm attempting to execute an Oracle 12c stored procedure using ArcSDESQLExecute: import arcpy egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\con1.sde") sql = '''execute update_sle (...
0
votes
1answer
34 views

Why shouldn't you edit in a replicated database

Say you replicate a database to another database. Are there any reasons you wouldn't want to edit your replicated data other than having different data in the replica database than in the database you ...
0
votes
1answer
37 views

ArcSDE Enterprise geodatabase compress error

My organisation has ArcSDE enterprise geodatabase(ArcGIS 9.2) with MS SQL Server 2008 as DBMS. When I compress the geodatabase I am getting the follwoing error Failed to compress the database. ...
0
votes
0answers
22 views

Does the geodatabase administrator login rebuild indexes for datasets not owned by the login?

According to the ESRI documentation, the Rebuild Indexes tool is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In ...
1
vote
0answers
28 views

Add spatial index to versioned feature class

I try to add spatial index to versioned feature class (Oracle SDE) using toolbox "Add Spatial Index" in ArcGIS 10.6 . When I try it as Data owner I have error message -"Tool must be run as owner of ...
1
vote
0answers
34 views

Setting PostgreSQL privileges for ArcGIS?

I'm migrating from SQL Server and setting up my first PostgreSQL server for use with ArcGIS. I've followed esri tutorials and related how-tos. I'll be using a versioned editing environment, as I ...
0
votes
0answers
11 views

Deleting users and roles on ArcSDE for PostgreSQL geodatabase?

I can easily create users and assign them to roles using the context menus in ArcCatalog or the geoprocessing tools, but how do I delete users and roles? Do I have to go into pgAdmin?
1
vote
0answers
24 views

Considerations for projecting enterprise database to a new coordinate system

I currently maintain an enterprise geodatabase where the data is projected in a state plane coordinate system. Recently the data has extended past state boundaries. The data units are in feet and ...
0
votes
0answers
26 views

AddRastersToMosaicDataset_management performs slow

I have an enterprise Geodatabase (SQL Server) on my ArcGIS server machine. I perform my computations on several rasters on another machine (80 *.tif s with mean size of 50kb). When I want to add the ...
1
vote
0answers
37 views

Appending polygon features from file geodatabase table to SDE table?

I am facing an issue while appending the feature class to ArcSDE feature class. All the I am trying to append the gdb feature classs data, I can see that the geometry is either changed and some cases ...
0
votes
2answers
73 views

Connect QGIS to Esri geodatabase hosted on RDBMS (PostgreSQL)

I have an ArcGIS 10.5.1 enterprise geodatabase hosted on PostgreSQL 9.4 (non-PostGIS enabled, but with SDE.ST_Geometry support). I'd like to add some feature classes as layers in QGIS. How can I do ...
2
votes
0answers
28 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 ...
0
votes
1answer
37 views

Updating/modifying Network Dataset roads source in Enterprise Geodatabase (ArcSDE) using ArcPy?

I am trying to create a Python script that automate the update of roads source used in a network dataset stored in a Enterprise Geodatabase (SDE). In short, I want to truncate the roads feature class ...
1
vote
0answers
65 views

How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned?

How can I create a trigger to capture when a field is changed from one value to another if my data is versioned? I am not able to run an UPDATE trigger and grab ':new' and ':old' values because with ...
0
votes
0answers
26 views

Working with a small spatial extent from a large dataset in ArcMap

I am currently working with large amounts of forest data where surveyors and ecologists measure and assess the quality of the vegetation in the field and send the result as CAD files on a daily basis ...
-1
votes
2answers
44 views

Field mappings remove field from arcpyTable to Table conversion

I want to export a table but would like to remove one of the fields before doing so using arcpy. I'm trying to use field mappings but am missing something: fields = arcpy.ListFields("some_table") ...
1
vote
0answers
45 views

Import ArcSDE db to Postgres/PostGIS

Is it possible to import an ArcSDE db in PostGIS? I don't have experience with ArcSDE and then I don't have any idea to what is the data exportation format of this software. A customer asked me to ...
1
vote
0answers
31 views

Where is XSD file for XML found in Gdb_Items table?

I would like to be able to deserialize the xml in Gdb_items table using .NET. The xml in an sde geodatabase appears to be the same as the xml returned using the File GDB API. I tried using xsd.exe ...
0
votes
0answers
40 views

Invalid column value

I've been working on a script that corrects some links in a few feature classes in an enterprise database I have. The script works fine for the most part. When it gets to a certain feature class my ...
1
vote
1answer
28 views

Schema Locks Starting As Soon As User is Disconnected

I am having continual issues with scheme locks on our ArcSDE database, as soon as users are disconnected schema locks start appearing. We have 20 or so feature classes and it will show anywhere from ...
0
votes
1answer
39 views

Syncing database with ArcMap and ArcSDE?

I am using SQL in Oracle to fill and empty feature class table, basically something like this: INSERT INTO DAMO_W.BRUG (OBJECTID,CODE,NAAM,GLOBALID,SHAPE,CREATED_USER,CREATED_DATE,LAST_EDITED_DATE,...
1
vote
0answers
53 views

ArcPy not seeing ArcSDE datasets from IDLE or PyScripter? [duplicate]

I tested the code below from ArcCatalog 10.5's python console and IDLE+PyScripter. While in ArcCatalog everything works correctly(code is supposed to list available datasets and feature layers), in ...
1
vote
1answer
171 views

Multi client (QGIS.ArcGIS Desktop)/ multi-user editing environment [duplicate]

I'm using ArcGIS Desktop 10.6.1 with PostgreSQL 10.3/PostGIS 2.4 and would like to edit PostgreSQL polygon features regardless of client (QGIS/ArcGIS desktop) without having to create an ArcGIS ...
1
vote
1answer
41 views

Stop ArcGIS 'Geodatabase Adminstration' Reporting Connection as 'DBO' Instead of My Username?

We are running ArcGIS 10.5.1 and MS SQL Server, and using an SDE connection file which is configured to use 'Operating System' credentials. When most users connect, the 'Geodatabase Administration' ...
1
vote
0answers
39 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 ...
2
votes
1answer
44 views

Read SDE Feature Attributes without Arcpy

I've been building some software that reads/writes spatial and non-spatial data out of our SQL SDEs dynamically when called. As I've pointed out before Time Delay in Importing ArcPy , ArcPy takes ...
0
votes
0answers
89 views

Is it possible to connect Alteryx to feature classes in an Oracle based SDE?

I am using Alteryx Designer x64 with Spatial. I would like to connect feature classes from our enterprise database in the same way that I do with ArcSDE. I know that connecting to a file GDB, personal ...
0
votes
1answer
145 views

“Runtime error: cannot open workspace” after creating a connection file and changing the version [duplicate]

I'm trying to run an update cursor. Usually if I have an issue with databases with enterprise connections, making a connection file clears it up. This time when I tried to execute my code I just get a ...
1
vote
1answer
58 views

Creating Relationship Class- Adding new records to table

I am creating a relationship class inside an SDE Environment (SQL Server 2016). I have a point feature class and a related table. I am trying to add rows to the currently empty table based off ...
0
votes
0answers
113 views

ERROR 000582 - Create a checkout to a file GDB

We are encountering "Error 000582: Error occurred during execution" while executing a Python script creating a checkout replica. We were able to create the checkout replica successfully from ArcMap ...
0
votes
0answers
46 views

ArcMap PostgreSQL unique sequence

I have connected my ArcMap to my PostgreSQL db using the Create Enterprise Geodatabase tool in ArcMap. I have multiple feature classes and the relevant relationships between them loaded into the db ...
1
vote
0answers
50 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.
1
vote
0answers
30 views

Cannot Create Topology in SDE

I am trying create a topology for a zoning dataset in my SDE feature dataset. I've run into a few issues. First off was an issue with versioning that this questions resolved: How to solve "Cannot ...