Latest Contributions by George_Thompson

To add to what Dan has documented: A note about the use of UML for geodatabase design—ArcGIS Help | ArcGIS for Desktop  there is a 3rd party tool called Sparx Enterprise Architect: ArcGIS Geodatabase Design | UML | Enterprise Architect  ... View more

ArcGIS Online​ ... View more

John - I tested Jake's Python on an Oracle enterprise geodatabase and it worked by just changing out the .sde connection information that Jake mentioned. ... View more

Hi Sam, You need to re-sync the users in the instance to the geodatabase in SQL Server. Here is an example: USE [database_name] GO EXEC sp_change_users_login 'Update_One', 'sde', 'sde' GO **Repeat EXEC for each data owner** EXEC sp_change_users_login 'Update_One', 'GIS', 'GIS' GO How To: Re-synch SQL Server logins or users after restoring a database from backup Restore a Database Backup Using SSMS  ... View more

HI Chris, You may want to move this to a more appropriate location on GeoNet, like Geodatabase​, to get more visibility. ... View more

Does the user that is running the tool have permission to create a role in SQL Server? Which user is creating the role, geodatabase admin or another user? Privileges for geodatabases in SQL Server—Help | ArcGIS for Desktop ... View more

Hi Alessandro, I would not modify (delete/truncate/remove) and of the records from the _DIRTYAREAS table. That is a system table for the network dataset and could cause corruption. It looks like that table is tracking all edits to ND data. Is there an issue related to that table having data, besides the copy time? Is there a performance issue with the ND? As for the compress, it only would possibly impact the delta and base tables for versioned data. Geodatabase compression—Help | ArcGIS for Desktop -George ... View more

Exporting a model to Python is not a "replacement" for coding in Python. It was designed as a tool to learn Python. Here is a good blog and the recent documentation on this: Considerations when exporting a model to a Python script | ArcGIS Blog Exporting a model to a Python script—Help | ArcGIS for Desktop As for the import part, I could see it causing a bunch of issue if you customize the script (add iterators, in-line variable substitution, etc.) If you create a model in a toolbox, there is a way to call that model via Python. I have seen this be very useful for calling a model that only works in ArcGIS and not as a stand-alone Python script. ImportToolbox—Help | ArcGIS for Desktop Python​ Learn ArcGIS​ ... View more

Nope, it looks good. I would imagine that it would be using more memory than that. Other than that I am out of ideas. ... View more

That is up to your DBA and how they wish to manage the Oracle DB. If you leave it all in the USERS tablespace, it may get really large and have data from other DB users in it also. This is a way to configure your tablespaces for data.This is really up to the DBA on how to manage. Oracle configuration parameters—Help | ArcGIS for Desktop Hope this helps. ... View more

I have seen the error before, usually has to do with something on the SQL Server side and not the ArcGIS side. This would fall under tuning of the RDBMS. How much memory is the SQL Server service using? You mention that you have set the MAX limit for SQL Server to 8GB and the service is using 60% of the overall memory. That service may be out of memory and needs to be increased in the SQL Server settings. Can you provide similar screenshots? ... View more

Hi Aaron, What is the memory limits that you have set within SQL Server? What is the memory utilization of the machine that SQL Server is installed on? Is ArcGIS for Server also on the same machine as SQL Server? How much memory on the Win2012 machine? Is it a VM or physical machine? ... View more

Hi Muqit, Here some documentation that talks about the differences of DBO vs. SDE geodatabases: A comparison of geodatabase owners in SQL Server—Help | ArcGIS for Desktop ... View more

I do not have an example for a query for extracting the XML tag that you are looking for. ... View more