Latest Contributions by JakeSkinner

@EdX1 , take a look at the following document. It contains a script that will compress your geodatabase and output a DeltaCounts.csv file showing the before and after counts of the A & D tables.

To maintain optimal performance for a traditionally versioned geodatabase, it's a best practice to compress your geodatabase on a regular basis. To achieve a full compress to state 0, it's necessary to remove all locks from the geodatabase. Locks can be created from users accessing the geodatabase in desktop applications, such as ArcGIS Pro, and from ArcGIS Server services that are referencing data from the geodatabase. This script will stop ArcGIS Server services that are currently running, disconnect all users from the geodatabase, block further connections to the geodatabase, reconcile/post all versions, and compress the geodatabase. After the geodatabase is compressed, the script will rebuild indexes and recalculate stats on versioned feature classes, and then finally restart the previous running services. Additionally, the script will output a CSV file showing the before and after counts of the A & D tables, also known as the Delta tables. This will allow you to easily see if the versioned feature classes have been compressed. Also, the script will report the before and after state id of the geodatabase. Some optional parameters within the script include sending e-mail notifications. If the script executes successfully, an e-mail will be sent attaching the CSV file of the delta table counts, and a message of the before and after state id. If an error occurs, an e-mail will be sent including a log file reporting the error and the line within the script that caused the error. A quick note, all geodatabase replicas should be synced before this script is executed Video of workflow:

Hi @Sven_Harpering, You can use the report property: https://developers.arcgis.com/python/guide/administering-your-gis/#:~:text=Pandas%20DataFrame%20table-,pro_license.report,-Entitlement

@SallyBickel @Chase_RSO what IDE are you using to execute the script? Try running the IDE as an Administrator (i.e. right-click on IDE > Run As Administrator). Do you still receive the same error?

@RaenaBallantyne_DeMaris that may be the case. You can add a try/except to bypass this error. Ex: # Iterate through fruit list for fruit in fruitList: with arcpy.da.SearchCursor(farmLocations, ["LocCode"], f"Fruits LIKE '%{fruit}%'") as cursor: for row in cursor: # Create CSV file for each fruit csvOutput = fr'{csvDirectory}\{fruit}.csv' output_file = open(csvOutput, 'w') header = 'LocCode, ProjName\n' output_file.write(header) try: for project in projectsDict[row[0]]: output = f'{row[0]}, {project}\n' output_file.write(output) except KeyError: pass del cursor

@BlakeTerhune I believe the documentation states that it's not required when using it within a with statement, but I've found there can still be locks when I do not explicitly remove the cursor using del cursor.

Hi @RaenaBallantyne_DeMaris , Try the following: import arcpy # Variables farmLocations = r"c:\projects\GeoNET\GeoNET.gdb\FarmLocations" projects = r"c:\projects\GeoNET\GeoNET.gdb\Project" csvDirectory = r"c:\projects\GeoNET" # List of frutis fruitList = ['Apples', 'Walnuts', 'Hazelnuts', 'Cherries', 'Apricots', 'Pecans', 'Pears', 'Peaches', 'Plums'] # Create Projects Dictionary projectsDict = {} with arcpy.da.SearchCursor(projects, ["LocCode", "ProjName"]) as cursor: for row in cursor: projectsDict.setdefault(row[0], []) projectsDict[row[0]].append(row[1]) del cursor # Iterate through fruit list for fruit in fruitList: with arcpy.da.SearchCursor(farmLocations, ["LocCode"], f"Fruits LIKE '%{fruit}%'") as cursor: for row in cursor: # Create CSV file for each fruit csvOutput = fr'{csvDirectory}\{fruit}.csv' output_file = open(csvOutput, 'w') header = 'LocCode, ProjName\n' output_file.write(header) for project in projectsDict[row[0]]: output = f'{row[0]}, {project}\n' output_file.write(output) del cursor output_file.close()

Re: Assign User Category with Python API

Hi @zrobinson_agolpublic , What version of the API are you running?

@Chase_RSO @SallyBickel what version of Pro are you running?

I would verify the feature classes' A&D tables are cleared after the compress. If there is a lock on the feature class, the compress will skip over the feature class. If your database is SQL Server you can find the correct A&D table with the following: query the sde.sde_table_registry table to get the registration_id. Ex: select registration_id from dbo.SDE_table_registry where table_name = 'Airports' This will return the registration_id: This will indicate which A&D tables to query. Ex:

Hi @EdX1, Is your feature class registered as versioned? If it is, has your geodatabase been compressed recently? The compress will clear the A&D (delta) tables, which will improve performance of the feature class. You will want to make sure there are no locks on the feature class when performing the compress. For example, make sure all services are stopped, and all users are disconnected.

@ErikNelson1 can you test the below code on another machine that has ArcGIS Pro installed: from arcgis.gis import GIS gis = GIS(url="https://gis.organization.com/portal", username="username", password="password", verify_cert=False)

@Chase_RSO try deleting the scratch folder at C:\Users\<useraccount>\appdata\local\temp. Recreate this directory, and then add Full Control to your account to the scratch folder by right-clicking on the folder > Properties > Security.

@ErikNelson1 , 1. Are you able to sign into Portal with the credentials you are providing in the script? 2. Do you have any reverse proxies in place? 3. Is there another built-in admin account you can try?

Hi @AudraPayne1, is this occurring for all hosted feature services, or just this particular one?

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by JakeSkinner

Re: How to improve arcpy.da.UpdateCursor / InsertCursor performance?

Compress Geodatabase

Re: Query the maximum number of User Types that exist in an ArcGIS Online subscription

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Use Items in List as SQL Where Clause in "for Loop"; write identified rows to CSV

Re: Use Items in List as SQL Where Clause in "for Loop"; write identified rows to CSV

Re: Use Items in List as SQL Where Clause in "for Loop"; write identified rows to CSV

Re: Assign User Category with Python API

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: How to improve arcpy.da.UpdateCursor / InsertCursor performance?

Re: How to improve arcpy.da.UpdateCursor / InsertCursor performance?

Re: Migrate Built-In Named User accounts to Enterprise Named User accounts (Active Directory/SAML) in ArcGIS Enterprise/ArcGIS Online

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Migrate Built-In Named User accounts to Enterprise Named User accounts (Active Directory/SAML) in ArcGIS Enterprise/ArcGIS Online

Re: Database error has occured - feature layer in portal

Re: Use Items in List as SQL Where Clause in "for ...

Re: Use Items in List as SQL Where Clause in "for ...

Re: How to improve arcpy.da.UpdateCursor / InsertC...

Re: How to improve arcpy.da.UpdateCursor / InsertC...

Re: layer.attachments.download doesn't work for su...

Web AppBuilder Custom Widgets

PA GIS Professionals Association - Pilot Group