Latest Contributions by RussellBrennan

‎10-20-2014

Hi Clara, Are you working with hosted feature services, either ArcGIS online or Portal for ArcGIS (with datastore)? Russell

‎10-16-2014

The Rebuild Indexes tool will rebuild indexes on two different 'types' of tables in your geodatabase. In the case of the rebuild indexes tool we have separated the tables into 'data tables' and 'system tables'. Data tables are the tables that you get returned when you run any of the list functions (like what you are doing in your script). System tables are those used by the geodatabase internally (states, state_lineages table for example). Within the tool there is a parameter 'include_system' with options 'SYSTEM' and 'NO_SYSTEM'. When you choose 'SYSTEM' you need to be connected as the geodatabase administrator, because only the geodatabase administrator has privileges to update indexes on these tables. In some cases you may want to only update the system table indexes. You can do this by running the tool and providing the 'SYSTEM' parameter and NOT providing any other datasets in the in_datasets list. If you try to run the tool using 'NO_SYSTEM' and NOT providing any other datasets in the in_datasets list the tool will fail. It appears that since you are using the SYSTEM parameter the tool is executing properly. Through Python we do not find all of the datasets that your user owns and automatically update indexes, you need to provide the list. To answer your side question, when using geoprocessing/python the permissions are coming from the .sde connection file. In the case that you are using Operating System Authentication in your .sde connection file the permissions will then come from the OS user who is running the script.

‎08-25-2014

You do not need to be working in an enterprise (SDE) geodatabase to schedule scripts to run. This can be accomplished via the windows task scheduler on Windows or a cron job on Linux. Below are two links for how to do this on Windows. Skip to 44:30 in this video to see how to use the task scheduler to call a python script: Administer Your Enterprise Geodatabase through Python | Esri Video‌ Also, there is a blog post on this here: Scheduling a Python script or model to run at a prescribed time | ArcGIS Blog

‎08-25-2014

Geodatabases on the SQL Express platform were traditionally managed solely through ArcCatalog. This was done to provide an easy user experience to the geodatabase admin. Through ArcCatalog there were options for adding users, backing up and restoring the database. There were also options for viewing and managing user privileges. We provided what we felt was a few (suitable and easy to understand for SQL Express admins/users) roles that admins could use to administer privileges. These are the roles that you were asking about. We did not however, provide an option for creating new roles. With enterprise geodatabases on SQL Server we do not limit what roles you want to use and do not make any assumptions about the roles you want to create. This gives more flexibility to admins who want more discreet or more general roles for their organization. These admins typically configure and manage their geodatabases using a combination of SQL Server Management Studio as well as ArcCatalog.

‎08-22-2014

These roles should be created when using SQL Express workgroup or desktop geodatabases. However if you are using enterprise geodatabases these roles are not created. Types of geodatabases: Geodatabase | Multiuser Geodatabase‌

‎08-20-2014

William's answer is correct. We use the same codepath with Copy_management as we do with right-click 'Copy' - right click 'Paste' (or control+C, control+V). This maintains things like domains/relationships etc, it is actually making a copy of the data and its other related data and pasting it. Feature class to feature class is essentially an export of the data. This only copies what you specify in the tool. Copy preserves geodatabase maintained values such as OID or GlobalID while exporting data will not maintain these values.

‎08-13-2014

My first impression is that this appears to be a software bug or a data issue. I would be interested to know: Are you are able to run the Synchronize Changes GP tool outside of python? Are you able to run the SynchronizeChanges_management function in a python script if your hardcode all your parameters? Are you able to sync using the replica manager tools? There does not appear to be anything in the script that should cause this type of failure.

‎07-30-2014

Daniel, Have you installed the SQL Server native client on your server machine? This might be the reason you are not able to connect to the database. Try installing the native client and then rerunning the script.

‎07-30-2014

James, Yes, you need to ensure that SQL Server native client is available on the client machine. We use this to connect to the database instance to create your geodatabase. Russell

‎07-30-2014

Erik, If you enable attachments prior to creating the replica the attachments will sync up when you perform your synchronization. If you enable attachments after the replica is created the best option is likely to unregister your replica and then register using the 'register existing data only' option. The register existing option would look something like this: a) Copy delete the feature class on the relative replica and copy the class (with attachments) to the relative replica. Ensure you have globalIDs before copying). b) Sync the existing replica to make sure each side has all pending changes. c) Create a new replica that includes the changed class with attachments enabled using the “Register Existing data only” option. This will take only a few seconds to complete as the data already exists on both sides. d) Assuming no additional edits had been done b/w steps b & c, unregister the old replica. (if edits had been done, just make sure to sync the old replica before unregistering) e) Now move forward with the new replica.

‎07-29-2014

Syed, The tool should work against all spatial types. Is this occurring with all your feature classes? Are you connected as the data owner? When you rebuild indexes with Oracle PL/SQL are you connected as the data owner? What options are you using when you run the tool? Does the tool stop responding immediately? How long are you waiting? How many tables are owned by the same data owner?

‎07-29-2014

Mar, Take a look at this topic, it describes how to perform the validation you are looking for. Customizing Script tool behavior‌ The first example on this page shows you what you need to do in the updateParameters method: def updateParameters(self): # If the option to use a weights file is selected (the user chose # "Get Spatial Weights From File"), enable the parameter for specifying # the file, otherwise disable it # if self.params[3].value == "Get Spatial Weights From File": self.params[8].enabled = 1 else: self.params[8].enabled = 0 You will want to change this slightly for your workflow.

‎07-21-2014

Antonio, You should be able to export to shapefile. The error you are getting may indicate that you have attachments on your data, but even if that is the case it *should* work. I was able to successfully export on my feature services with attachments directly to shapefile without issue. I right clicked on my layer in my TOC and chose data -> export data. I would suggest contacting Esri Technical Support to get it sorted out if that does not work for you.

‎07-21-2014

Hani, If you connect using an 'admin' connection in ArcMap/ArcCatalog you will only see the map service. If you connect using a 'user' connection you will see both the feature service and map service. Take a look at the 3 links at the top of this page for more info: http://resources.arcgis.com/en/help/main/10.1/index.html#//006600000450000000

‎07-14-2014

David, The functionality you are describing is available through editor tracking (no scripting necessary). Check out this link for more information: Editor Tracking You can either enable it manually: Enable Editor Tracking Or use GP tools to do this: using GP In your case you could just enable Editor and Edit Date, you don't need to enable everything. The bonus of doing this vs a script is that it will also work in ArcGIS Server and if you are in an enterprise geodatabase it will not cause conflicts. Hope this helps, Russell

Online Status	Offline
Date Last Visited	‎01-24-2024 01:35 AM

My Ideas

Latest Contributions by RussellBrennan

Re: possible to assign ownership before enabling editor tracking/ownership based control?

Re: Rebuild Indexes -- What happens with no in_datasets passed?

Re: Getting Pythons to run at certain times

Re: Geodatabase Roles

Re: Geodatabase Roles

Re: Copy_management brings along Relationship Classes and Tables

Re: Need help on an error i get when trying to synchronize changes between two arcsde databases via python script

Re: Simple Python Script Runs on Desktop but Not Server

Re: Is MS SQL Server 2008/2012 Native Client provided in ArcGIS Desktop 10.1 / 0.2 or does it need to installed separately on the client machine ?

Re: attachments and replications

Re: rebuild index

Re: How to disable a parameter in Python script tool window?

Re: Feature Service Feature Class to Shapefile

Re: Show Feature Service in Catalog

Re: Python: automate field based on editor and edit date

Re: Combing Multiple Models

Re: Copy_management brings along Relationship Clas...

Re: Automate Locks Management

Re: Feature services are not supported with a DB2 ...

Re: Geodatabase Roles