Questions tagged [versioning]

In databases, an alternative state of the database that has an owner, a description, a permission (private, protected, or public), and a parent version.

Filter by
Sorted by
Tagged with
2
votes
1answer
168 views

GDB Compression Not Updating Base Tables

I'm having an issue when compressing a database the edits are not being posted to the base table immediately, this sometimes takes hours until I can see the edits. Right now the only way I can force ...
6
votes
3answers
914 views

Can primary keys and foreign keys be used in versioned geodatabases?

I've been brushing up on relational database design theory, and I keep coming across primary keys (PKs) and foreign keys (FKs). PKs and FKs are said to be pillars of relational database design and ...
4
votes
2answers
908 views

ArcPy save edits without stopping an edit session

I am editing a versioned SDE Feature class with arcpy (ArcGIS 10.2.1). I know that to edit versioned data you should use the arcpy.da.Editor, start editing, start operation, do your edits, stop ...
1
vote
1answer
209 views

Posting changes from public to protected version in ArcGIS?

Me [USER1] and my colleague [USER2] , have created the following ArcGIS 10.3.1 versioning workflow : Then each one of us started editing on his respective public version . He then reconciled with [...
0
votes
1answer
76 views

Inserting Versioned Features Limit

How many features can a user create in a single edit session (insert into versioned table)? is there a limit ? I tried inserting 6000 features, but I started getting an error at around 3500 and the ...
1
vote
1answer
156 views

Posting still running after nearly 4.5 days

I haven't reconciled and posted in about a month. I added a large amount of new data to our database on many different feature classes over this time. When I reconciled I believe there were around ...
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 ...
5
votes
1answer
899 views

What is Diffrent Between Version & Replica In ArcGIS Geodatabase

I know Versioning allows multiple editors to alter the same data in an enterprise or workgroup geodatabase without duplicating data and Geodatabase replica allows creates copies of data across two or ...
0
votes
1answer
262 views

Append New Records

I would like to append records from a view to a table to serve as a log. I tried using the ArcGIS Append tool but it creates duplicate records. Is there a way to append only those records from the ...
5
votes
2answers
310 views

Utilizing versioning with ArcGIS Collector

I have done a lot of research on the internet with this and I am unable to find a cut and dry answer. I am utilizing ArcMap 10.3.1. and PostgreSQL 9.3. I have been able to get everything set up ...
2
votes
1answer
361 views

Editing ArcFM ArcSDE table in version with ArcPy?

I am trying to edit data that is in an ArcSDE Oracle database with updates in a file geodatabase. I want to be able to make these changes on a separate version to isolate them. If I connect to a ...
0
votes
1answer
61 views

how to create the replica from a specific version?

I have a default version SDE and I want to make a QC versioning in 2 levels then to create a checkout/checkin Replica from the child version is that possible ?
3
votes
1answer
217 views

ESRI ArcMap 10.0 Not Compressing

We have ESRI ArcMap 10.0 (build 4400) ArcGIS Desktop 10 Service Pack 5. SQL Database 10.0.4000. We are trying to Compress our Versioned tables but for some reason it's not pulling the changed records ...
0
votes
1answer
551 views

Conflicts in ArcMap editing with multiple users

There are multiple users of ArcMap using their own versions for uploading edits to our Master database. We are not live editing, these edits are reconciled and posted each day, sometimes twice in one ...
1
vote
0answers
36 views

bring back column info in sde descendant version

I have a feature class registered as versioned in sde with editor tracking turned on. In my edit version, I was updating one field for all records but forgot to turn off the editor tracking before ...
1
vote
1answer
232 views

Querying Archive Class with REST API of ArcGIS Server?

I would like to know if there is a way to access the archive class through a Map Service of ArcGIS Server. I have a Map Service with feature class stored in a SDE GeoDatabase with Archiving and ...
2
votes
1answer
76 views

Is it possible to inherit a session in ArcGIS 10.0 through the Python window?

So, I'm still struggling with an ESRI 10.0 installation with an Oracle ArcSDE database. I'm nearing the end .... In trying to programmatically edit the versioned data. It needs to be done in an ...
1
vote
1answer
37 views

Oracle versioned geodatabase feature class field value update on multiple versions

I have an Oracle enterprise geodatabase with multiple versions. In one field value of one point feature class I need to change all features within all versions. I have more than 50 versions. Is ...
1
vote
1answer
80 views

Which Geodatabase version is holding how manyUNPOSTED outstanding Edits?

I have this generic versioned geodatabase question i.e.Which Geodatabase version is holding how many UNPOSTED outstanding Edits ?, which may be crucial to identify the query performance bottleneck in ...
1
vote
2answers
167 views

Changing ArcSDE version of *.mxd in ArcPy?

Is there a way to switch the version a .mxd data source is pointing at without using arcpy.mapping.findAndReplaceWorkspacePaths? I have a script that automates map book production that works very ...
1
vote
1answer
63 views

Displaying specific version of geodatabase on AxImapControl using ArcObjects in C#?

I am working on a sample ArcGIS Engine project which tries to map two versions difference on an AxImapControl i created two mapcontrol which first one loads the MXD file and for second one i make a ...
2
votes
1answer
2k views

Delta tables & base table

What is the difference between a delta table and a base table? I am confused by these two words. Delta tables The adds and deletes tables for a dataset are collectively referred to as the delta ...
2
votes
0answers
90 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 ...
3
votes
0answers
654 views

Offline Data Editing on Versioned Data?

I have registered my layer as "Registered as versioned" with the "Register the selected objects with the option to move edits to base". I can publish the the data the feature server with "Sync" ...
2
votes
0answers
53 views

How can I access to history service layer

I have set up a service which is provided by ArcGIS. I would like to have access to all the versions of the parcel layer which are created during the edits I applied earlier to be able to gather ...
1
vote
0answers
133 views

What is the recommended way for team coordination in GIS (ArcGIS, QGIS, etc.) [closed]

I am preparing a team of around 18 GIS analysts to work on 12h/12h work cycle to attain 24h/day work rate. This means two 9-person teams, one for each period. All analysts will have access to various ...
1
vote
0answers
275 views

Why does multi_user_mode have to be False in edit session on non-versioned dataset using ArcPy? [closed]

I'm in the process of implementing Mintx's answer to my question What would cause a geoprocessing service to say "Cannot Open 'FeatureClass' Failed to Execute"? However, I had ...
2
votes
1answer
129 views

Accessing information about ArcSDE historical markers via arcpy or SQL?

I would like to be able to access the list of historical markers that is presented in the "Change Version" dialog in ArcMap - https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/...
3
votes
0answers
119 views

Max number of versions allowed in SDE / weird behavior with large number of versions [closed]

Is there a maximum number of versions allowed in an enterprise geodatabase? I have an enterprise geodatabase with a default version that has about 70 child versions. I am experiencing weird behavior ...
2
votes
1answer
188 views

How to get specific version (renedered with) of a feature layer in arcpy

Is there any way to get version of a layer loaded using arcpy.MakeFeatureLayer_management in arcpy with mssql server connection. There are tools that be used for several types of version related tasks ...
1
vote
1answer
463 views

Undo option to 'move edits to base' ArcSDE

I have an ArcSDE Geodatabase where a number of layers are registered as versioned. Having spent some time troubleshooting an issue I'm having with syncing data on Collector, I have noticed that the ...
2
votes
2answers
850 views

Bulk selection by ObjectID using arcpy

Trying to bulk update versioned Feature Classes containing in excess of 30,000 records is causing issue due to the Reconcile/Post process taking too long and ending up with the notice saying that the ...
3
votes
1answer
189 views

Incremental Network Loader failing with ArcSDE Geometric Network

I've been testing the Incremental Network Loader tool for loading new lines into a geometric network from an outside feature class. The tool worked perfectly on a File GeoDatabase copy of our SDE. ...
0
votes
1answer
202 views

ReconcileVersions and “out_log”

I'm automating some sde geodatabase management. In the ReconcileVersions_management function there is an option create a log file of the result ("reconcileLog"). If the script runs five nights a ...
1
vote
1answer
83 views

Viewing list of data sets that have been edited under specific ArcSDE Version?

I'm wondering if it's possible to list all of the data sets (feature classes, tables, etc.) that have been edited under a particular version in ArcSDE. A tool that does this would be ideal (I see ...
5
votes
3answers
153 views

How to track alignment changes?

I work for a small company that designs alignments using ArcGIS. (To give you an idea of company size, we have about 50 employees; I am the only full-time GIS person, although we have 4 ArcMap ...
1
vote
1answer
603 views

SDE GDB Versioning - reconcile and post from DEFAULT to Child

I am relatively new to versioning and think I have made a mistake in my workflow. I am using a SDE geodatabase, with a DEFAULT and 'Field Editing' child version in ArcGIS 10.3. I received a lot of ...
2
votes
1answer
264 views

Using Reconcile in ArcGIS Versioning

When doing a reconcile in ArcGIS ArcMap (v10.2), you get the Reconcile window as shown in the screenshot. At the bottom it asks how you want to resolve conflicts (in favor of target or edit version). ...
3
votes
1answer
345 views

Visualizing a State Tree

I'm running ArcGIS 10.2.1 and I need a way to visualize the state tree for my versioned SQL 2012 database. I've previously used the GDBT tools but there isn't an option available from ESRI that will ...
1
vote
1answer
647 views

Viewing Edit Tracking History on Feature Service hosted at ArcGIS Online?

Is there a way to view the edit history of a specific feature service or feature? I have enabled edit tracking and have been doing fieldwork for 2 weeks now. I want to see how the data has changed ...
1
vote
1answer
757 views

How to change owner of a version in an enterprise geodatabase using ArcObjects?

I have ArcObjects/.NET code used to create few versions for workspace. Versions are created successfuly but their owner is who created them (the user connected to the workspace). I want to change the ...
1
vote
1answer
355 views

How to set a specific ArcSDE version for tabular reporting?

I have created a multiversioned view in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production. I can access a specific version using a SQL script in SQL Developer. However, using ...
1
vote
0answers
48 views

Does QGIS have anything like Geodatabase Versioning? [duplicate]

I am just wondering if QGIS has anything like Esri's geodatabase versioning?
3
votes
1answer
1k views

How to test for 'if arcpy.exists' with RemoveFeatureClassFromTopology stand-alone script?

I have some dataset topologies that I want to loop through, but I need to test for the assignment of feature classes so the scripts don't fail. (Using Win 7, ArcGIS 10.2, Python 2.7.5 and a file GDB) ...
0
votes
2answers
554 views

specified target version has no edit versions to reconcile with

I'm writing a script to automate post and reconcile a target and edit version. I consistently get the warning message "The reconcile process was not performed. The specified target version has no edit ...
2
votes
1answer
340 views

SDE State ID with Python

I have created a Python script which compresses an ArcSDE geodatabase and now I would like to view the State ID after the compress. Is there a way with Python I can get this info?
1
vote
3answers
966 views

Reading ArcSDE data of a specific version in Python

How can I read a version within Python? For example, let's say I set up a workspace which points to a .SDE file connection. Now how can I read the features from a version within Python? I have looked ...
0
votes
1answer
2k views

ArcMap 10.3.1 Crashes when trying to change the version

I'm using ArcMap 10.3.1 when I have a data connection to another user (For example change from Tom's version to Jim's version of the SDE) or default and attempt to change the version to my own ArcMap ...
1
vote
0answers
717 views

ArcGIS Versioning - Conflicts option greyed out / disabled

I'm relatively new to the world of Versioning and using SDE databases, and have come across a problem that I can't solve. Summed up - the Conflicts option/button is greyed out/disabled, and I know ...
1
vote
0answers
870 views

How to publish a service on ArcGIS Server using versioned data in ArcGIS 10.3?

Fairly new to GIS here, especially new to working with enterprise geodatabases. I am attempting to publish a service from arcmap to arcgis server using a version of the DEFAULT. I am using connection ...