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
0
votes
2answers
340 views

Workspace Error type- 000301 for reconcile version

I have a arcpy script to reconcile and post edits from 1 child to 1 parent 9the parent is not the default version). my code: import arcpy print "Preparing to begin Water Version Reconile and POST......
2
votes
1answer
15k views

Python Script to generate log files with time and date and output events and error messages to the log files [closed]

I am writing a python script to reconcile and post my user version edits to a QA/QC version and then finally to the SDE database, the script will also go further to compress, analyze and index the ...
1
vote
0answers
45 views

Cannot connect to current version of enterprise database (PostgreSQL) through PHP

Very new to PHP, and working on a simple edit page. I'm connecting to multiversioned Postgresql database that I set up in ArcMap using a PHP/HTML file. I'm using the pg_connect command with host/...
0
votes
1answer
45 views

Enterprise Database Workflow with Online Mapping

We bought a trimble units for our operators to collect data out in the field using Collector. We currently have ArcGIS Server 10.3.1 with SQL Server 2012 setup on one of our servers. Our server ...
3
votes
1answer
190 views

arcpy.mapping.ListLayers returns inconsistent dataSource properties

ArcMap 10.3.1 It seems that the layer object returned by arcpy.mapping.ListLayers will have a full .dataSource property only in a brand new MXD. After changing the target version in the TOC, the same ...
-1
votes
1answer
608 views

Unable to post edits to the default database when default version access is “protected”

Users unable to post edits to the default database when set the default version access is “protected”. In the past the default version was publicly accessed, and users can easily the users can use “...
0
votes
2answers
305 views

Python Script updating default version and child version simultaneously

I am writing a script to auto update attributes for several FCs in my enterprise SDE. I am testing the script and there are no processing bugs however there is strange behavior. When the script ...
0
votes
0answers
50 views

View number of edits made in an Enterprise GDB?

I would like to see the total number of edits made in my Default.SDE before the reconcile/post/compress process. I know you can view the number of edits made in versions with the Version Changes tool ...
1
vote
1answer
891 views

Using arcpy.da.Editor?

I am working with copies of feature Datasets that come from a versioned SDE. The copies are in an un-versioned 'development' SDE. I am attempting to do a field calculation on a single feature class ...
0
votes
1answer
438 views

Managing Conflicts in Scripted ArcGIS Reconcile of Versions?

We have some integration between our Assets system and our ArcGIS 10.3.1 system. The ArcGIS SDE is versioned. The assets system uses its own version (lets call it 'Assets'), and there is another ...
0
votes
1answer
33 views

Change Version icon doesn't appear

I created an ArcSDE geodatabase via create enterprise database tool. I used MSSQL Server. But normally there has to be an icon which is exactly the same one left side of "SLK sql to sa.sde" text ...
1
vote
0answers
557 views

Understanding ArcSDE versioning tables? [closed]

I have studied about ArcSDE schema and SDE tables in Oracle, MSSQL and also PostgreSQL. But after my research I still have many questions that I haven't been able to find out. Initially I want you to ...
2
votes
1answer
187 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 ...
8
votes
3answers
1k 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
1k 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
215 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
86 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
167 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
44 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
1k 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
289 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
346 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
404 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
65 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
259 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
597 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
37 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
281 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
85 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
180 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
65 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
92 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
697 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
54 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
135 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
298 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
147 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
124 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
198 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
528 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
1k 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
205 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
208 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
85 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
161 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
674 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
280 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). ...