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.
252
questions
0
votes
0
answers
22
views
Importing fmeobjects module into python script
I've tried doing doing what this post suggests but still get errors.
This code:
import sys
sys.path.append(r"C:\\Program Files\\FME\\fmeobjects\\python37")
sys.path.append(r"C:\\...
- 103
0
votes
1
answer
55
views
Branch version editing in ArcGIS Online
I'm trying to figure out if you can publish a particular version for users to edit on an ArcGIS Online map in a branch versioned environment. It doesn't look like there is a way to select the version ...
- 31
0
votes
0
answers
26
views
named_version is not deleted using ReconcileVersions function
I am using below function to enter rows in table (branch versioning). My idea is to create a named version, submit the changes, reconcile and post it. After posting, named_version should be deleted.
...
- 11
0
votes
1
answer
43
views
Export/print version differences between child version and default version from ArcGIS Pro to an Excel spreadsheet or .csv file
How to export/print version differences between child version and default version from ArcGIS Pro to an Excel spreadsheet or .csv file?
When I have a version other than the default, and click on ...
- 13
0
votes
1
answer
76
views
Trying to use UpdateCursor on Branch versioned layer - RuntimeError: cannot open workspace
I have a branch versioned service layer on ArcGIS Portal. I want editors to use ArcGIS Pro to open a map in a ArcGIS Pro project and use their respective versions of this layer to create new features ...
- 1,525
1
vote
1
answer
51
views
TypeError: cannot update branch versioned table
I have several editors making edits to a branch versioned, sde referenced layer on ArcGIS Portal. As part of the work flow, I want editors to open their ArcGIS Project saved with their edit version of ...
- 1,525
1
vote
0
answers
29
views
Moving points to new coordinates (arcpy.data.editor)
I have a versioned enterprise geodatabase. I need to move some points to new locations, which are in the attribute table. This script runs, but it doesn't seem to actually move any of the points.
...
- 11
0
votes
1
answer
301
views
Extracting data shown in Version Changes on Branch-Versioned feature service before reconcile/post process using ArcGIS Pro [closed]
Currently there is no way to export version changes on feature service in ArcGIS Pro as a change report. Preferably a Python script to extract the details about version changes on a branch-versioned ...
- 1
0
votes
0
answers
152
views
Branch versioning in ArcMap
We have a people that only use ArcMap. We have a project created in ArcGIS Pro, which obviously supports branch versioning.
How can we allow those using ArcMap to edit the ArcGIS Pro project ...
1
vote
0
answers
201
views
Publish Reconcile branch version using ArcPy as web tool return editing error result
The return message is shown below:
Starting reconcile.
Reconciling version USER.MyVersion with SDE.DEFAULT.
Warning: Error starting editing on version USER.MyVersion.
1 of 1 versions finished.
...
- 11
0
votes
0
answers
279
views
ERROR 000837: The workspace is not the correct workspace type. in arcpy.management.CreateVersion
I am trying to create version in branch versioning enabled feature service.
But my simple code is failing.
# Import system modules
import arcpy
# Set local variables
inWorkspace = "https://&...
- 613
0
votes
1
answer
206
views
Manage data versions using JavaScript for ArcGIS Enterprise
I developed a small web application that contains a Map view, and is loaded with features that were published. So I have (FeatureServer, VersionManagementServer).
I decided to to add the functionality ...
- 614
0
votes
1
answer
352
views
Python Script not working on versioned Feature Class
I have a geoprocessing script that worked great, until moving the data source to a feature dataset where it must be versioned.
when this script is pointing to the layer outside the feature dataset, it ...
- 51
0
votes
1
answer
47
views
Setting version of ArcMap
I am trying to set the version of SDE by using following code :
SET SERVEROUTPUT ON;
declare q varchar2(100);
ver varchar(10);
BEGIN
DBMS_OUTPUT.PUT_LINE('HI');
ver := 'PQ_358';
...
- 19
0
votes
0
answers
59
views
Versioned view does not reflect the delta changes
I am adding some data using session manager to layer, and saving them. Those changes are visible in delta table in SDE also. But, when I query to count the base table and versioned view result count, ...
- 19
1
vote
0
answers
104
views
Review and revert edits in default version
We have feature class in a versioned enterprise geodatabase. Unfortunately some unwanted edits were done directly in DEFAULT version.
The database was not compressed yet, base table is unaffected by ...
- 9,566
0
votes
0
answers
89
views
Wrong Workspace Type Error with arcpy.ChangeVersion
When using arcpy.ChangeVersion_management() on a feature class inside of a feature dataset, I get ERROR 000301: Workspace is of the wrong type.
Posts addressing the same error stemming from arcpy....
- 53
0
votes
0
answers
58
views
Combine SDE Versions in a SQL View
I have two versions, from same base table, with only one feature class in both that I want to combine in a database view for a presentation. Version feature classes differ both with attributes and ...
- 440
0
votes
1
answer
412
views
How to use calculate geometry on non versioned data?
Every time I attempt to use calculate the geometry of some shapefiles I receive this message: ERROR 130051: Input feature class is not registered as versioned.
I did not understand why a mathematical ...
- 13
0
votes
1
answer
47
views
What happens in the DB when a user updates a record in a versioned table?
ArcGIS Desktop 10.7.1/Oracle 18c.
In a table that is versioned (with the option to move edits to base):
What happens in the database when a user updates a record?
It would be helpful to know what ...
- 1,114
0
votes
0
answers
66
views
Prevent deletes in a versioned FC at the application level
In Prevent deletes in a versioned FC at the database level (a related question), we determined that it's not possible to prevent deletes from a versioned FC via functionality in the database.
As an ...
- 1,114
0
votes
1
answer
84
views
Under what circumstances would the _DELETE trigger get called? (_EVW)
Oracle 18c/10.7.1 geodatabase:
When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created:
V000001_DELETE
V000001_INSERT
V000001_UPDATE
...
- 1,114
2
votes
2
answers
133
views
Prevent deletes in a versioned table at the database level
I have a table in an Oracle 18c/10.7.1 geodatabase. The table is versioned with the option to move edits to base.
As far as I can tell, it's not possible to prevent ArcGIS Desktop users from deleting ...
- 1,114
1
vote
0
answers
118
views
Missing 'Expression' option in 'Random Points in Polygon' tool
I am running QGIS Desktop version 3.8.2
I need to use the 'Random Points in Polygon' tool as part of a process.
The number of points per polygon is defined by one of the fields so I simply add that ...
- 11
2
votes
0
answers
592
views
Are there any examples or tutorials showing Branch Version editing with ArcGIS Server JavaScript API?
I am trying to implement branch versioning in an application that I'm building using the ArcGIS Server JavaScript API.
I found a blog post showing how to edit branch-versioned data in ArcGIS Pro, and ...
- 21k
1
vote
0
answers
276
views
ArcSDE version status stuck in 33554433
One of our ArcSDE versions (esri v10.1 and oracle 11g) in SDE.Versions table shows a 'status' field value of 33554433 instead of the usual 0, 1, 2 for private, public, protected. I understand this is ...
- 61
2
votes
1
answer
37
views
How store feature changes with geotools?
I stored a vector layer in postgis and I can add, remove or update featues successfully. Now I want to store feature change log(This means if a feature property changed, we can access new and old ...
- 988
-1
votes
2
answers
64
views
Cannot figure out what is wrong with my code [closed]
I am trying to create a code that will make a new version of a feature class and then geoprocesses some stuff per feature layer. However something in my code is going wrong and I can't figure out for ...
- 81
0
votes
1
answer
317
views
Do feature classes need to be versioned for editing with ArcGIS Collector/feature service?
I have an Oracle 18c/10.7.1 geodatabase with feature classes that have the following properties:
Unversioned
SDO_GEOMETRY datatype
Registered with the GDB
My organization plans to serve up the ...
- 1,114
2
votes
1
answer
328
views
Listlayers, but exclude group names/feature dataset names with Arcpy
I am looking for a way to loop through all the feature classes (feature layers) within a mxd, to then use some geoprocessing tools on them. Before I run these geoproccesses, the script needs to change ...
- 81
1
vote
0
answers
1k
views
Getting "Workspace Already in Transaction Mode" Error when trying to use updateCursor on versioned sde
There are are numerous post on this error, but I can't seem to find a solution for myself. We have a versioned sde and need to add new fields to some of our feature classes and populate them with an ...
- 43
1
vote
0
answers
61
views
Updating field from table used as source in network dataset
I have a Feature Dataset that contains a Network Dataset and a Feature Class (as a source of Network Dataset) in enterprise geodatabase (PostgreSQL). The Feature Dataset is versioned because we want ...
- 11
0
votes
0
answers
27
views
Database Population in wrong Authentication Type
I've populated a database while connected to it as an editor with an Operating System Authentication Type. I should have populated it while connected to the Database as the GIS administrator with a ...
- 1
1
vote
0
answers
178
views
Feature Class Update Trigger with Archiving
We are deploying Collector in our institution and for offline work on unversioned data we need to enable archiving.
The feature class needs some updates when the user enters new records using the ...
- 123
1
vote
0
answers
243
views
Backup of ArcSDE version
Is there any way how to backup particular version in ArcSDE geodatabase?
I want to delete some versions from our geodatabase, but it would be great if I can create backup first and restore version ...
1
vote
2
answers
369
views
Why do arcpy.GetCount_management and arcpy.ArcSDESQLExecute yield different row counts?
I was benchmarking which method was faster for counting the number of rows in a table, when something curious happened:
import arcpy
import os
import time
test_tuple = ("path\to\connection", "...
- 415
1
vote
2
answers
291
views
Prevent row deletion in versioned tables using database privileges
I have versioned tables in an Oracle geodatabase (versioned with the option to move edits to base).
I would like to prevent users from deleting rows from the tables when using ArcGIS Desktop.
(With ...
- 1,114
2
votes
1
answer
411
views
File Geodatabase and Versioning
I'm trying to setup a versioned database to a small office and was wondering whether ESRI's File Geodatabase has that type of capabilities?
Researching the topic I found conflicting data from ESRI's ...
- 420
1
vote
0
answers
99
views
How to transfer data from a version to default version in ArcMap? [closed]
I have lost all data from default version and also from the base tables in Oracle. But luckily, there is a version that has all the data in it. I have reconciled and posted that version to default but ...
- 428
1
vote
0
answers
55
views
Geodatabse Compression does not make changes in Base Tables [closed]
This question has been asked here GDB Compression Not Updating Base Tables, but the solution provided is not what I am looking for.
I have registered a feature class and made some edits in that ...
- 428
2
votes
2
answers
548
views
How to make ArcMap aware of the changes that are made in base table? [duplicate]
I am using ArcMap One-way replication tool to synchronize feature classes from Oracle to MS SQL Server (once a day), but replication only works for the versioned data with move edits to base option as ...
- 428
1
vote
0
answers
236
views
Versioning in PostGIS on PostgreSQL database [duplicate]
I have a cadastral database which requires multi-user editing/updating on daily basis.
I am trying to migrate from Esri enterprise geodatabase to PostGIS/PostgreSQL. I am not sure PostGIS offers ...
- 51
2
votes
0
answers
85
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
1
vote
0
answers
2k
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 ...
- 415
0
votes
1
answer
682
views
Changing version with arcpy
I am looking to change versions of an .sde through Arcpy to then afterwards, run a few geoprocesses on it. I do not want it to automatically update after that.
So far I have managed to create a ...
- 81
1
vote
2
answers
301
views
Refreshing Versioned Feature Class using ArcObjects?
I have a FeatureClass A.
This Feature Class is Versioned.
User X has a tool open, that reads records from this Feature Class, by clicking a refresh button. The refresh button code is basically a ...
- 614
1
vote
0
answers
100
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 ...
- 51
1
vote
0
answers
95
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.
...
- 11
1
vote
0
answers
552
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 ...
- 43
2
votes
0
answers
114
views
Versioning with Oracle Workspace Manager in QGIS?
I'm working with a workspace enabled oracle database. Through the database connection properties in QGIS meanwhile it is possible to set the workspace or version. So I can edit my spatial data in a ...
- 21