Latest Contributions by RandyKreuziger

‎02-22-2019

What type of performance are you seeing between the local installs of ArcGIS and files on One Drive?

‎02-19-2019

I agree with Mateo. Adding a removing feature classes from a replica without the having to program it in ArcObjects is needed. I have 3 feature classes out of 40 in a replica that got corrupted so it would be nice to remove them from the replica, replace originals and replicate got those feature classes without blowing away the replicas.

‎01-17-2019

I'm having a problem finding it. The original data is onprem with the replica up on AWS. The sync is run as a scheduled task up on AWS owned by me but run using an shared AD service type account for use running scheduled jobs. The ReplicaLog.dat under my C:\Users\<user_name>\AppData\Local\ESRI folder is completely empty size 0KB and there is no ReplicaLog.dat file in the service account folder. I made sure that file explorer is set to show hidden items.

‎01-17-2019

Which SDE/GDB tables contain the replication logs? I'd like to write a job to verify that the replication is taking place daily and that it's successful, if not, send out an email alert. Has anyone done this already? Thanks. Env: SQL Server 2012, SDE 10.4

‎05-25-2018

I put in an enhancement request several years ago on this one but it's gone nowhere. The use case we had for years is this. We have people who collaborate on MXDs but not all users are running the same version of ArcMap. It would be extremely helpful if ArcMap could be setup to save an MXD back to it's version so that the MXD can be modified by users running a newer version of ArcMap and not create an MXD that can't be opened by the author. Where this really comes into play is when running a script to update SDE datasources on all MXDs recursively. I ran into an issue earlier this year when the script I had written was run using 10.4.1. A handful of our users are still at 10.2 but there was no way programmatically to determine that so I saved everything out at 10.4 version. That left MXDs at the wrong version for users of 10.2.

‎04-19-2018

When we make our Open Data site public this week I noticed a problem with the dates associated with each entry. Most are displaying 4/1/2018 which is off by a couple of weeks. Another entry, shown in the attached file, is off by almost a year showing a 4/23/2017 date even though the data was registered only last month. Basically, they are all wrong in Open Data but all correct in AGOL Where does this Open Data date come from? Here's our work flow: Publish a single map service with 8 Big Game Hunting boundary layers. Register each of the 8 layers separately in AGOL. Load the metadata entry in AGOL using an exported XML file. Share to Open Data. Last night I updated all 8 layers in SDE doing a truncate append and reloaded the metadata in AGOL. This updated the date in AGOL showing yesterday's date but has had no affect on the date shown in Open Data.

‎02-08-2018

On our current data download site we have several ZIP files that contain more than just data. For example, some may contain a geodabase along with layer files, mxds and ArcMap Addin all in that single ZIP file. As we ready our new Open Data site I thought I could make this data available by registering it with ArcGIS Online as an "Item from the Web" of type "Document." I shared it to Open Data and all looked good until I noticed that every time I clicked on the item in OD the ZIP file was downloading in the background instead of just downloading it when clicking on the Open button. In other cases the ZIP file contains several feature classes in a fgdb but the whole zip file is getting recreated one a month as a automated process. Anyone downloading the data really needs all the individual feature classes in the fgdb to insure they use the data correctly. Is there a way to have an entry in Open Data that points to the ZIP files stored on the Internet elsewhere for the two use cases mentioned above? Thanks

‎01-30-2018

Will these two files work with 10.4.1?

‎01-17-2018

Were you in an edit session? I copy paste a couple of times a day from SDE to fgdbs without any issues. Copy paste doesn't do anything to the source so there is something else going on. You don't even need edit permissions in SDE for a copy paste. Personally, I always use ArcCatalog for this and use a readonly account on the source SDE database when both the source and target are SDE.

‎01-16-2018

Hi Heena, A domain you're trying to delete can't be deleted as long as it is a domain still in use. You'll have to identify which feature class and/or table fields are set to use that domain. Then delete that association before you run the delete.

‎12-04-2017

George, I must not have been clear in my original post but, yes, I did do the compress after the reconcile posts. That did not move the stale records out of the A and D tables.

‎12-04-2017

Madan, I restored the database to DEV so there were no users to disconnect. The only thing I didn't do was check the SDE_State_ID field. It was only after deleting the versions that the remaining records were moved from the Add tables and Delete tables to the base tables.

‎11-30-2017

We have a versioned SDE 10.2 geodatabase in SQL Server 2012 with users running ArcMap 10.4.1. There are a dozen versions directly off the default with no child versions. Users reconcile, post, reconcile before the database is compressed once a week. One of the users was looking at the data via the Microsoft SQL Server Management Studio and noticed that records were missing from some of the business tables. After looking into it I discovered that in some cases there are over 3000 records in a couple of the A tables going back to December of 2016. I restored a copy of the most recent version of the database to development and went through reconcile / post / compress on all the versions. a handful of records moved to the business tables but most of those in the A tables remained in the A tables. Only after deleting all the versions were the remaining records moved from the A tables to the business tables. After deleting all the versions the record counts are all correct and the A / D tables are now empty. Anyone ideas on why the versions would have to be deleted for those records to finally move? Thanks

‎10-09-2017

Hi Micah, Yes, it did. I'm loving it!

‎09-13-2017

I found a way to change ownership at least in Microsoft SQL Server using the SET statement with a modify function. In the example below, I change the domain owner of the 'DATA QUALITY CODE_3' to the user 'SDE', but it could be set to any user account regardless of the owner. At that point I was able to login as SDE and edit the domain as well as delete it. I was able to figure this out using ESRI's tech article "How To: Return information on coded value domains using ArcSDE 10.x for SQL Server." UPDATE [GeoLib].[sde].[GDB_ITEMS] SET [Definition].modify(' replace value of (/GPCodedValueDomain2/Owner/text())[1] with ("SDE")') WHERE TYPE in ('8C368B12-A12E-4C7E-9638-C9C64E69E98F','C29DA988-8C3E-45F7-8B5C-18E51EE7BEB4') AND PhysicalName = 'DATA QUALITY CODE_3' ‍‍‍‍‍‍‍‍

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by RandyKreuziger

Re: Connecting to OneDrive in ArcGIS Pro

Re: Add a Feature Class to an existing Replica

Re: Which SDE tables contain the Distributed Geodatabase Replica Logs

Which SDE tables contain the Distributed Geodatabase Replica Logs

Re: Show version of ArcGIS required to open LYR, MXD, or Layer package

Dates in Open Data entries are wrong! Where do they come from?

How to register ZIP files with Open Data already stored on our agency's website

Re: axtiveX error warning

Re: SQL sde. Issues

Re: Delete Unused Domains

Re: Why does it take deleting a version to move some records from the A and D table to the business table

Re: Why does it take deleting a version to move some records from the A and D table to the business table

Why does it take deleting a version to move some records from the A and D table to the business table

Re: Finding Orphaned Domains in a Geodatabase

Re: Deleting Domains Owned by Others in SQL/SDE Geodatabases

Copy_management brings along Relationship Classes ...

Re: Publish raster dataset as image service with a...

Data Deduplication on the File System

Labels not showing up in published map service

Re: Connecting to OneDrive in ArcGIS Pro