Latest Contributions by AnthonyRyanEQL

‎01-24-2024

This functionality for HANA has been removed in ArcGIS Pro 3.2

‎01-24-2024

Hi all, I'm using ArcGIS Pro 3.2.1 with Advanced licensing, ArcGIS Enterprise 11.1 with Advanced licensing and HANA 2 SP07 database. Our dba setup the 'sde' user with the permissions as defined in Privileges for geodatabases in SAP HANA—ArcGIS Pro | Documentation and I was able to enable the geodatabase successfully using the Enable Enterprise Geodatabase gp tool in Pro. To create the database user, I'm using the 'Create Database User' gp tool in Pro. The database connection for the tool is a sde file configured to connect as sde. I have successfully used this gp tool in ArcGIS Pro 3.1.3 to create db user in HANA before but this time I'm getting the following error from the go tool's messages 'Wrong column type [Success] ERROR: Failed to create HANA user UNOWNER (-114). Error: Wrong column type (-114)' Has anybody come across this error before? Thanks I uninstalled ArcGIS Pro 3.2.1 and installed ArcGIS Pro 3.1.3 and repeated the above and was successful in creating the database user. I used this user to create a feature class & data and all worked as expected.

‎01-16-2024

Hi there, In the webpage Ports used by Portal for ArcGIS it talks about the various ports required to communicate with Portal and Enterprise. When the requirement to use Windows Defender Firewall comes into play, what do most people do? Do you add a generic rules that allows any process to use the ports listed above or specify which application/process/service that is allowed to connect via these ports? If the application/process/service is specified, is it just the Portal for ArcGIS service (C:\Program Files\ArcGIS\Portal\framework\service\bin\ArcGISPortal.exe) that is listed or are other applications that need to be considered as well. Thanks

‎01-04-2024

Thanks for confirming this. We get a little worried when either the PSA or admin account is used to do the authentication and not sure what information is actually stored.

‎01-04-2024

Hi there, Is there a blog, document or something that has a list of tips, tricks & best practices when using Power Automate with Survey123? I'm finding some gotchas as I put my first flow together. Some of things I would like to know are: Should you use a built-in named user or enterprise user using an AD service account with SAML/SSO for the authentication in the Surevy123 connector? Appears only the owner of the survey can be used as the authentication in the connector to see it. The Portal permission/security model of content sharing, create webhooks, etc isn't being used when other built-in accounts have those permissions (similar to geoevent server). There would be plenty more but these 2 above define the landscape of how user access/permission is defined especially when having to pass this to cyber security teams, etc for endorsement.

‎12-19-2023

Hi there, As AWS Postgres Aurora works, is there any guidelines on the configuration of the min & max ACUs? I know this is subjective due to the number of service metrics, etc but as a guide based on the data disc space requirements "Allocate at least 100 GB of storage for enterprise GIS implementations with up to 1,000 ArcGIS web services. This provides enough storage space to monitor the implementation for a period of one year" but wondering what specs the postgres db would require to support this? It's roughly 1ACU is approx. 2Gb db RAM with CPU & networking Thanks for any help with this

‎12-13-2023

Simply it’s the model. When you publish the service set the Z default to 0 as per the doco and then you don’t have to worry about it. All you need to do is to ensure everything is separated enough in XY. good luck

‎12-13-2023

Hi @CashEddy , I did. The link in my post above is item 4 from that site. Is there something there I should read in particular?

‎12-13-2023

Hi there, I was wondering if there was any links to best practices/tips in managing subnetworks? Found this blog The Life Cycle of Subnetwork in Utility Network by Hussein Nasser which is a good starting pointing but I'm after something with more detailed information. The parts I'm looking for is around the renaming & deleting of a subnetwork when DEFAULT is protected. With renaming of a subnetwork, the subnetwork controller for that subnetwork would be modified (disabled first), changes made and then a new controller configured against (enable). What needs to be done next? The old subnetwork needs to be delete. Its old subnetwork controller is tagged for deleting in the subnetworks table (layer 500002). The export subnetwork rest api has the ack flag set as false by default and the gp tool doesn't this parameter exposed. Version differences in ArcGIS Pro doesn't show the changes done to subnetwork controllers but the changes are versioned managed. Are we meant to build out tools to query the subnetworks table (layer 500002) by version to detected and so on. It would be nice if something was documented in how all of this is really meant to work with the tools/framework provided by Esri Inc. I shall stop rambling on now. Thanks for any help with this

‎11-26-2023

It's only 1 way comms from Utility Network to PowerFactory. It's a 3rd party tool we purchased from Similix (Esri Partner). Basically, there are 2 parts, the Designer (CIM mappings) and the Adaptor. Designer - You build your mappings from your UtilityNetwork Model. This can be a lot of work depending on how custom your UNM is. In my case, our UNM is totally custom as the North American electrical model of UNM doesn't meet the needs here in Australia. Adaptor - Runs as a service connecting to your UtilityNetwork. It uses OOTB REST API calls to the UN to extract the subnetwork information and maps it accordingly to your CIM mapping file into the standard XML format to be consumed into PowerFactory. Sorry I can't tell you how it works inside of PowerFactory.

‎11-23-2023

We are using a CIM adaptor for Utility Network to PowerFactory

Re: Maintaining database users symbology · ‎11-13-2023

There are a few different options. lyrx file like Dan mentioned. Create a pro package file and share in portal for users to download which contains your sde connections, maps, symbology, etc

‎11-07-2023

I found Copy & Paste doesn't work between two Enterprise geodatabases. Maybe it was due to a few invalid records (eg. orphaned/duplicated associations) that prevented it from working. I have migrated an Electric & Telco UN using the asset package method. It had approx. 14M assets with 24M associations. It was from AWS SQL Server 2017 RDS to HANA 2 SP05. As @JohnAlsup mentioned above, the network data/information needs to be in good shape before it can be loaded using this method

‎11-07-2023

Matthew, This is definitely feasible. As you iterate over each record, you are extracting the last 4 characters from the 'DISTRICT' field and then updating the 'YR_INST' field with that data. You may need to typecast the year value to a number if the datatype of the 'YR_INST' field isn't a string. Good luck

‎10-18-2023

Hi there, Does anybody know how many threads are being used by a map while panning, zooming, etc when retrieving features from the available services defined in the content page for the map? basically I’m trying to see how many ArcSOCs/instances I need to define when publishing a service. My example is with the Utility Network that has 2 domains and when configured in the content pane using subtype layers, a single pan in the map generates 27 rest calls to the service. If the map utilises 2 threads (14 parallel calls made) with 10 concurrent users, I’ll need 20 instances/socs for the service to minimise any wait times, etc for the user. thanks for any help with this

Online Status	Offline
Date Last Visited	‎11-11-2025 07:08 PM

My Ideas

Latest Contributions by AnthonyRyanEQL

Re: HANA Geodatabase - Create Database User Error: Wrong column type (-114)

HANA Geodatabase - Create Database User Error: Wrong column type (-114)

Ports used by Portal for ArcGIS and Windows Defender Firewall

Re: Power Automate Tips, Tricks & Best Practices

Power Automate Tips, Tricks & Best Practices

AWS Postgres Aurora ACU guidelines

Re: Why z values are mandatory while creating the domain network

Re: Subnetwork Management - Are they best practices/tips for this?

Subnetwork Management - Are they best practices/tips for this?

Re: How to integrate between Gis data and power factory ?

Re: How to integrate between Gis data and power factory ?

Re: Maintaining database users symbology

Re: export Utility Network options (XML or Asset Package or Copy & Paste)

Re: Using custom Python to identify & pull data from one Attribute Field to populate another

ArcGIS Pro 3.1.x - How many threads are running for map interactions (eg. pan, zoom)

Portal Item usage with per named user breakdown fo...

Have association type/role as a configuration to a...

ArcGIS 11.1 Security 2025 Update 3 removes arcgis#...

feature service schema validation during form publ...

Re: Installing minimum dependencies for use with A...

Python Snippets

Admin Tools for ArcGIS Online & Portal

Python AddIns

Admin Tools

LIDAR Resources