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 [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.

1
vote
2answers
36 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 ...
1
vote
0answers
13 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 ...
1
vote
0answers
38 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. ...
0
votes
0answers
16 views

Using SDE versioned layers as inputs in FME

I am using the following FME script to compare the vertices between a line layer and a polygon layer (they should have the same vertices, but because of a resolution issue some areas have different ...
1
vote
0answers
50 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 ...
1
vote
0answers
51 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 ...
1
vote
0answers
33 views

How export geodatabase version differences in ArcPy?

With ArcObjects I have this code in C# to export the differences to a XML file: ESRI.ArcGIS.GeoDatabaseDistributed.IVersionDataChangesInit pVDataChgs; var pvTemp = new ESRI.ArcGIS....
0
votes
1answer
38 views

Do Postgresql sequences work with SDE versioning?

I am migrating data from an older GIS system into an SDE system with PostgreSQL as the database engine. The current system generates a unique tag for several layers, I want to re-create this behavior ...
0
votes
0answers
54 views

Setting Up SQL Trigger in ArcSDE

We are using 10.4 Geodatabase matching with ArcGIS release. Our goal is to setup a trigger on database side that will create a record for every time a record in deleted from the Default Version in SDE ...
0
votes
1answer
110 views

Access geodatabase simultaneously by several users

We have a requirement to edit a Geodatabase simultaneously by several users. We have several GIS specialists who are loading the data at the same time and each time we have to copy paste the data ...
0
votes
0answers
35 views

How to undelete from ArcGIS versioned table?

We have a versioned table of polygons and one of our users have deleted every geometries. With Oracle's SQL Developer, i can see the table still containing the missing data, along with its Axxxx and ...
0
votes
0answers
28 views

Versioning error when creating a Topology on a File GDB

Im having an issue with the 99999 Error. Im creating a Topology dataset for each of the featureclasses within a GDB. For some reason my script works for some feature classes and errors on others. I ...
2
votes
2answers
370 views

Spatial Data Version Control or Versioning Software [duplicate]

I have a lot of shapefile or fgdb feature classes that I am working with now and it gets updated almost every month. As of right now, I am just making the file name with extra name after '-' (i.e., ...
0
votes
0answers
86 views

Deleting ArcMap Versions using Arcpy

The versionName "JNMILLER" won't delete. Any idea why it's not finding the name? Terminal: ================= RESTART: C:\Users\jnmiller\Desktop\test.py ================= Found - "EGAS\JMEESE" ...
0
votes
1answer
84 views

Creating ArcMap Versions using Arcpy

Why doesn't the script break if the Version exists? Traceback (most recent call last): File "C:\Users\jnmiller\Desktop\Create User Version.py", line 30, in arcpy.CreateVersion_management(...
2
votes
1answer
65 views

Pasting features into a feature class doesn't honour subtypes

I'm encountering an issue where features that I'm copying from a feature class in a file geodatabase are all going to a single subtype when I paste them in the destination feature class in an ...
0
votes
1answer
157 views

Query for tables that are not registered with option to move edits to base

I have an Oracle enterprise geodatabase. In theory, all 500+ tables in the database should be registered as versioned, with the option to move edits to base. However, it has come to my attention that ...
2
votes
1answer
29 views

Visualize Polygon Changes

I've unfortunately experienced a version control issue between offices where one person was editing an older version of a polygon shapefile. Now I need to reconcile those edits into the current ...
4
votes
1answer
66 views

ArcGIS database feature class editor default version settings

I created an enterprise geodatabase with ArcCatalog 10.5 in my PostgreSQL database. And I created feature class in database. But when I add feature class in arcmap, I need to change the editor ...
4
votes
2answers
56 views

Keeping Default Version of Geodatabase protected?

I have a multiuser geodatabase with Oracle Enterprise RDBMS. The Version of the geodatabase is 10.4.1 and Oracle 11g. We have over 35 data editors with the flat version tree, each user having their ...
0
votes
1answer
79 views

Reason for a Data Loss While Making Schema Changes on SDE - Oracle DB [closed]

I am not an expert when it comes to Administering Multi-User Geodatabase. However, I refer to Esri's documentation for best practices and efficient workflows before putting on my GIS Admin's hat to ...
1
vote
0answers
135 views

Change Version Option Grayed out in ArcGIS Pro

I am experimenting with versioning data from an SDE database in ArcGIS Pro. I able able to create a new version, no problems, but when I go to change the version in the Data Source tab on the Contents ...
7
votes
2answers
371 views

How are unsaved/temporary edits stored during versioned editing?

In ArcGIS Desktop, I can edit versioned, Oracle tables. I generally edit the default version, and I've registered the tables as versioned with the option to move edits to base. I do things like: ...
2
votes
0answers
157 views

Using ArcGIS workspace defined as version in ArcPy?

I am trying to define my workspace as the current version that I am connected to. The Python tool that I am running utilizes the arcpy.da.Editor() function, and I used a workspace variable that is ...
1
vote
0answers
31 views

Checking which layer edited under specific version?

I have approx 100 feature class in SDE database. Out of this someone edited 10 in "test_1" version feature class(assumed). Now i want to know with script or manual which feature class is edited under "...
0
votes
0answers
213 views

DBMS table not found [ORA-04043: (Open Feature Class from Version)

I try to open feature class from default version using with ArcObjects. But it is showing DBMS Table not found error message. IWorkspace ws_default = VersionedArcSdeWorkspace("", txtInstance.Text, ...
6
votes
5answers
378 views

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

I'm considering switching some of my tables in an Oracle enterprise geodatabase from versioned to unversioned. The pros of having unversioned tables would be: Simpler, traditional database design ...
0
votes
1answer
87 views

Reconcile/POST version DB edits- only by selected USERS(last edited)

I have been reading a bunch of helpdocs/whitepapers from ESRI and could not find a solution. My Scenario: I have a multi-user DB and want child 1 edits concile/POST to parent 1 which then parent 1 All ...
0
votes
2answers
206 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......
1
vote
1answer
8k 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
40 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
43 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
96 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
288 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 “...
1
vote
2answers
180 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
47 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
526 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
252 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
31 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
232 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 ...
1
vote
1answer
126 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
738 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 ...
0
votes
0answers
43 views

Visual Studio and ArcSDE Oracle database not showing same reports (Accounts)

I am generating different reports using Visual Studio 2013. My database is Oracle 11g. The problem which I am facing is in ArcMap there are 203402 records but in reports it is coming 198201. My ...
4
votes
2answers
646 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
152 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
58 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
124 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
39 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 ...
4
votes
1answer
640 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
199 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 ...