Latest Contributions by DavidHoy

Just an update. I was able to move forward by temporarily enabling the initial administrator account and using the https://<FQDN>:7443/arcgis route to portal and the credentials for portaladmin. This worked ok for me. ... View more

If I understand you correctly - you tried to set the version as part of the view definition. That's not what I meant. Just create the new view in a SQL client (not using Pro GP tool) using something like:   CREATE VIEW new_view AS SELECT * FROM your_table_EV WHERE some_condition;   Once your new view is created, then use the set_version command before running a query against your view   ... View more

if you create a view that includes the _ev versioned view you don't define which version you are accessing in the view definition (as you say, without further action it will return records from the "DEFAULT" version) But, if you want to retrieve records from some other version, you need to run the  EXEC sde.set_current_version ' child_version' This will mean all queries (in that session) after you have run that set_current_version will retrieve from the version requested. That includes the SELECT statements on the versioned view that are part of your view definition So, your view of a view will do what I think you want, but you will need to set the version as an initial step in your SQL Script before you run SELECT statements against the "view of a view". ... View more

if you read that article carefully, you will see the example :   SELECT id, species, reporter FROM sightings_ev WHERE reporter = 'chuck';   the clue here is that the FROM clause is using the "Versioned View" that is already created in the geodatabase for any versioned class. SO, you don't need to create a view - it should be there already. It will be named <featureclassname>_ev If you want to use this _ev in your own view of a view - that should work (but won't be very fast and you won't be able to edit that view of a versioned view). ... View more

 I have an environment with  initial administrator account disabled and IWA authentication. Is there a way to provide the credentials in the config.ini file for the current windows user (that is an administrator in the Portal)? Similar question if SAML authentication is required. ... View more

Hi @GeoExplorer  it would be possible to have 2-way geodatabase replication using a geodata service running on the internal ArcGIS Server. This would only require 443 access through the internal firewall. The synchronisation would be triggered by a python script running on the Server in the DMZ. The python script would require a geodatabase connection (via Oracle client) to the DMZ Geodatabase but a geodata service connection to the "master"geodatabase within the secure network. ... View more

Hi Joshua, maybe you could consider creating a Materialized View (MV) in your SQL Server and register that as a feature class and use it in your map source? One potential problem with this approach may be that any update in your source tables may trigger a complete refresh of the entire MV and that would then result in a full upload to AGOL each time the MV was refreshed. ... View more

Hi Brian - the solution for your wish to decide where the data is stored is already there. If you choose to publish a Hosted Feature Service, then the data will be copied automatically tothe system managed Relational Data Store (as you have seen). If you wish to publish a non-Hosted Map Service (with Feature Access enabled) you have a couple of choices. check the "copy data" option in the "share" dialog this will force the source datasets to be copied to the selected ArcGIS Server site (in your case I think you only have a single ArcGIS acting as the Hosting Server role) This will make the system copy the source datasets to the arcgisserver\directories\arcgissystem\arcgisinput\<servicename>\extracted\p20 directory. This is not an generally an optimal practice - as the copied data does not get updated as your original source data changes. Register you Enterprise Geodatabase as a database type data store (See Manage registered data stores—ArcGIS Pro | Documentation) Since ArcGIS Enterprise 10.7.1 - when you register data store with ArcGIS Pro or via the Portal web page, the are created as items in your Portal - and you will see them in Server Manager, but not be able to a configure these from Server Manager. If you use Server Manager to register data store - they won't show as items in your Portal. Once you have a registered data store and your source data is in that location (it could be a fileshare or an Enterprise Geodatabase), if your Pro map sources the data from that location (and uses the same access details (common .sde connection file say), you can opt to "use Registered Location" when publishing a non-hosted map service. This will mean your data is not copied redundantly and the latest data will always be being served up by your service. another option, if you do want data to be copied to the Enterprise Geodatabase during publication - you could add a separate ArcGIS Server site, register the Geodatabase with that Server and configure that registered data store as the "managed database". This allows use of the "copy data" option while publishing to that Server, but the copied data will go to the managed database rather than to the Server's "arcgisinput" folder. See this post for further info: Solved: About managed database in Server - Esri Community ... View more

and Monitor will show what you configure it to retrieve from the available inputs ... View more

Hi Mark, layer level stats are captured if the client requested at that level rather than at the service level. So, for requests at layer level for a feature enabled map service, the calls are captured in the server logs. The other trap is that, because Hosted Services are not serviced by an ArcSOC.exe, they do not get logged in the ArcGIS Server logs. To get stats for Hosted Services, you need to query the Web Adaptor or Load Balancer/Reverse Proxy logs ... View more

Hi Anthony, it is certainly possible to use other tools that achieve the same outcomes as SLP.  It gathers information from the Server logs either by making repeated calls to the REST endpoints or by directly reading the log files themselves. The magic is in how the raw information is turned into useful statistics. I would say it is not reasonable to ask for the source code for how this is done. You would need to gather log start transaction and end transaction records grouped by transaction-id and do the maths for the duration. Then collate a table/dictionary of all transactions and retrieve the various statistics - time of day, duration, success/error codes, etc then use this dictionary to create useful reports. or, you could write code that calls SLP.exe  to gather the stats and report with your dashboard tool - that's how ArcGIS Monitor does it Good luck in your endeavour ... View more

Yes - this is one of the possible ways to setup the administrative paths. But if setting up an internal Load Balancer is onerous, it is possible to just use the public load balancer addresses via :443 i.e .PrivatePortalURL same as webContextURL and Server Admin URL same as the Server Services URL But, this does mean: - Admin Access must be enabled in the Server Web Adaptor - The Public Load Balancer must be accessible from the Portal and Server VMs - (this isn't always the case when the Public ALB is in a DMZ) ... View more

@SaurabhUpadhyaya wrote: Thanks @DavidHoy. for explanation.  I am using web adapter(ArcGIS) for both servers, and it is linked to load balancer(https://sla.com/arcgis). Now the requirement is to add Portal in same environment to take the portal benefits. As per my understanding load balancer of ArcGIS Server can be federate with Portal. Services URL(https://sla.com/arcgis) will be load balancer url and Administration URL (https://sla.com/arcgis) and user name password will be primary site administrator url @DavidHoy can you please verify my approach if required any changed please suggest    ....reference esri url (https://enterprise.arcgis.com/en/portal/latest/administer/linux/federate-an-arcgis-server-site-with-your-portal.htm) @SaurabhUpadhyaya wrote: Thanks @DavidHoy. for explanation.  I am using web adapter(ArcGIS) for both servers, and it is linked to load balancer(https://sla.com/arcgis). Now the requirement is to add Portal in same environment to take the portal benefits. As per my understanding load balancer of ArcGIS Server can be federate with Portal. Services URL(https://sla.com/arcgis) will be load balancer url and Administration URL (https://sla.com/arcgis) and user name password will be primary site administrator url @DavidHoy can you please verify my approach if required any changed please suggest    ....reference esri url (https://enterprise.arcgis.com/en/portal/latest/administer/linux/federate-an-arcgis-server-site-with-your-portal.htm) Sorry I have been away from my desk for a few days. You diagram is not quite correct:  It is a common misunderstanding that the Server is "behind" the Portal, this is not the case. The endpoint for your Portal and your ArcGIS Server site is the Load Balancer. All calls from the clients go to the Load Balancer and are then distributed as required either to the Portal or the AGS machines. The federation between Portal and Server site also uses the Load Balancer path. You have described this correctly in your text. The Portal communicates with the Server site via the <LB>/arcgis and the Servers communicate with the Portal via the <LB>/portal. (This should happen automatically when you make the federation - this is why the Portal needs to have its webContextURL property set correctly to the LB/portal address before you federate) - you can check in the AGS site's server/admin/security/config page after federation - it should show both a "portalURL" and "privatePortalUrl" with the LB/portal address. Here is an altered diagram. I have added a fileshare because I presume you must have always had this for shared Server Config and System Directories to make your 2 machine ArcGIS Server site work in the past. I also drew in an ArcGIS Data Store - you haven't mentioned this, and it is not 100% required, but to take full advantage of ArcGIS Enterprise, you will need to establish at least a Relational Data Store and register it with your Server Site to allow it to act as a "Hosting Server" to hold system managed data created by Portal Users. ... View more

But…. Before federating - Be sure you have your Portal and Server site configured correctly to use the Load Balancer - with webContextURL set in system properties for each.  Otherwise you may find you get redirects you don’t expect  ... View more