|
POST
|
Samuel, Trust me, I don't want to be messing with the sde tables in SQL Server, I'm just looking for solutions. The child versions are the SYNC_SENDs as highlighted in above screenshot. Is the only was to remove those by unregistering the replica? Is there a way to automate this process? For example, at the end of the day I'd like to be able to fire off a script that would reconcile and post any edits from a disconnected version and delete it after the edits are posted so the next day is a fresh start, however I haven't been able to find a way to unregister a replica, unless there's a tool I'm missing...? Perhaps there's a better workflow that I'm not considering? Are there recommended workflows for disconnected editing and reconciling and posted any edits? We have a nightly script that will reconcile, post, and compress our production sde gdb and I'm wondering if the disconnected editing mode can be rolled into that process, but having the child versions hanging out there without unregistering the replica is a hang-up.
... View more
05-13-2015
03:06 PM
|
2
|
0
|
2737
|
|
POST
|
We are testing out disconnected mode with Collector and it seems to work well except for one issue. The version that gets created when downloading for disconnected mode will not delete when running the reconcile versions tool. We will continually get an error that says the version can't be deleted because it has dependent child versions. In order to delete the version, I either have to manually delete the version through the Geodatabase Administration or remove the affected rows in the sde_versions table. A few notes... 1) When I run the reconcile versions tool, I'm using our admin account which can delete any version 2) This is a simple setup, with only the DEFAULT version and the disconnected version as a child off DEFAULT, see screenshot below. 3) Below is a screenshot of the sde_versions table after data has been synced at the end of the day and the downloaded data has been removed from the device. I'm curious how to resolve this issue or if anyone has encountered the same problem...? Is there some step I'm missing that should be part of our end-of-day workflow to weed out the disconnected version from being a parent to syncs? Do I have to manually un-register the replica that gets created as part of the disconnected mode process? Any ideas / thoughts / suggestions are appreciated! Thanks!
... View more
05-13-2015
02:19 PM
|
0
|
7
|
6852
|
|
POST
|
Todd, I haven't found what I'm really after...which is a database driven method for assigning an identifier separate from the OBJECTID. I'm not a DBA and don't want to be, so I'm not researching advanced methods with the DBMS. We have recently updated our DB server to SQL Server 2014 which can use sequences, but again, that's out of my realm of understanding. We have found a work-around that is ArcMap driven. By using the Attribute Assistant tools, we can create GenerateId rules which will sequential number features in a feature class and/or table. The Attribute Assistant is part of the Water Utility Network Editing tools. There are several other ways the Attribute Assistant tools can be used, are really are very handy, but they are only available inside an ArcMap session.
... View more
04-09-2015
11:27 AM
|
0
|
0
|
2354
|
|
IDEA
|
-->
I think it would be useful to have a toolbox for ArcGIS Server administrative functions, similar to the Geodatabase Administration toolbox that was added for managing enterprise gdbs. Example tools: Add users Remove users Add role Remove role Add folder Edit folder security Edit service properties Query logs Export usage reports
... View more
04-01-2015
01:49 PM
|
5
|
1
|
917
|