Latest Contributions by DavidColey

‎05-07-2023

In my experience this is a Server error, not a Datastore error or Portal error. Something is preventing Server from communicating with datastore. For example, whenever something interrupts an overwrite of a hosted feature service via the arcpy sharing module, I will see this exact behavior. The hosted feature still appears in portal, the service still appears in the Hosted directory in Manager, and still shows in the Rest. Yet accessing the layer in the Portal data tab will display 'There was an error'. You say the federated site validates with portal, but does the relational datastore validate with server? For Server Manager>Site>DataStores : if the relational datastore validates with server - have you been able to overwrite any of the services? If you can, then you could just try overwriting the services. If the overwrites don't work, can you write new layers to the datastore? Time consuming of course. If the relational datastore does not validate with Server I would try re-running the Server install. Regardless, this to me that says some type of communication loss happened during the Server upgrade and corrupted the configs.

‎05-07-2023

Thanks for the suggestions @JalesM , but at this point I will just manage the logs at the root location as I'm updating to 11.1. If this site were to remain at 10.9.1 I'd go through restore attempts, but everything is working fine, there are no other issues. Monitor shows the 2 federated site machines remain balanced in soc count, memory use, cpu etc.

‎05-05-2023

Yeah unfortunately no help with the reboots. The json reads what I have set in my server admin - i.e. { "logDir": "C:\\arcgisserver\\logs\\", "logLevel": "WARNING", .....} Thanks for that.... It certainly is possible something corrupted with an image service (or other map service) at the moment I removed the runtime but there is no indication of that in any other way - they've all been authored in Pro long ago. Like I said above, when I did remove the runtime I found 30 - 40 thousand name-truncated logfiles dumped out to the root. So, you know? I can tell you I would have NEVER removed the runtime early (early meaning I wanted to remove the runtime before I run the upgrade from 10.9.1 to 11.1on this site) if I knew that that this would happen - - No one would. Yet another unexpected behavior. I'm probably going to have to set up a net stop "ArcGIS Server" and a net start as bat files to stop and start the arcgis server windows service until I can upgrade in 12 days. @ChrisUnderwood

‎05-05-2023

I don't know - I'm going to try a full server reboot at the lunch hour, see if that helps

‎05-05-2023

Thanks for the reply @JalesM - it's not the log message itself, that is fine. I get error messages all the time about the image services from this federated server site - request size exceeds, stuff like that - usually related to users in Pro or Map trying to make large plots with the image services. It's that after I removed the ArcMap runtime, these log files are being written to both the C:\ root directory and to the defined C:\arcgisserver\logs\ directory on each server. I can tell you that the log file name I listed above, now found at the C:\ root: .-20230505.100807-15284-10624.0.log is a truncated name of a log file like this: SC2022.ImageServer-20230505.102653-11952-4324.0.log that is found in the proper directory in C:\arcgisserver\logs\ at: C:\arcgisserver\logs\FullyQualifiedMachineName\services\ImageServices\SC2022.ImageServer That did not happen until the ArcMap runtime was removed. So again, it's the location at the C:\ root of a name-truncated log name.... @ChrisUnderwood

‎05-05-2023

If I stop the ArcGIS Server service I can read and delete the files, but otherwise they are locked and access is denied.

‎05-05-2023

Sure @ChrisUnderwood - they all are named similar to this: .-20230505.100807-15284-10624.0.log (date.time - some index number.log) and all seem to be related to the ImageServer role: <?xml version="1.0" encoding="utf-8" ?> <Msg time='2023-05-05T10:21:59,894' type='WARNING' code='80020' target='(null).(null)' methodName='ImageServerIP' machine='FullyQualifiedMachineName' process='16012' thread='7656' requestId='4ddde4e9-dc7a-4921-96ee-ece22a381a59'>Calling SOAP on REST service</Msg> <Msg time='2023-05-05T10:22:00,573' type='WARNING' code='80020' target='(null).(null)' methodName='ImageServerIP' machine='FullyQualifiedMachineName' process='16012' thread='7656' requestId='4ddde4e9-dc7a-4921-96ee-ece22a381a59'>Calling SOAP on REST service</Msg>

‎05-05-2023

Hello - in prep for upgrade of our federated server site to 11.1 from 10.9.1, I removed the ArcMap based runtime after finally being able to remove my remaining ArcMap authored services. When I did this, like 30K + log files got dumped to the C:\ root. I deleted the log files, restarted arcgis server service, went into server admin, re-edited the log output location (even though this did not change) to C:\arcgisserver\logs\ Now, on both machines, I am seeing .log files being written to-added to the C:\ root Why is this happening? What can I do? There is nothing in this help step that says this will happen: https://enterprise.arcgis.com/en/server/10.9.1/administer/windows/disable-arcmap-runtime.htm @ChristopherCounsell @VinceAngelo Thanks, David

‎05-03-2023

This is very helpful @GeoJosh - thanks very much for this. To me, this: "By default, only clients running on the same machine as the PostgreSQL database cluster can connect to it." is just not clear that 'clients' is referring to the Monitor Server. I also would have preferred to name the db differently as you have, but the help example names the db the same as the owner, which as a SQL Server admin I would never do. But I don't know/didn't know that/if Monitor Server is expecting the database to be named 'agm' - so it looks like it can be....

‎05-02-2023

Hi @AndrewSakowicz , @Anonymous User - I was able to muddle my way through setting up postgreSQL version 14.6 (the latest version on MyEsri) and was able to create the 'agm' user database per the help doc above using the pgAdmin gui. However, do either of you have a practical example of steps 3 and 4? Configure the database to allow connections By default, only clients running on the same machine as the PostgreSQL database cluster can connect to it. To allow remote clients to connect to the database cluster, alter the PostgreSQL pg_hba.conf configuration file. The entries you place in the pg_hba.conf file vary depending on your security policies and configurations. Complete the following steps to allow remote connections from clients to the PostgreSQL server: Make a backup copy of the pg_hba.conf file before you alter it. Open the pg_hba.conf file in a text editor. Add the Monitor Server IP address, designate the database that it can connect to, and specify the authentication methods used for connections using the following example: # TYPE DATABASE USER ADDRESS METHOD host <monitor_db> <db_user> <monitor_server_ip>/<ip/mask> <auth_method> For more information, refer to the PostgreSQL documentation. Reload server configuration settings using a PostgreSQL function such as pg_ctl reload or SELECT pg_reload_conf(). Thanks in advance for anything you can provide . . . David

‎05-02-2023

Hi @KjellTimalm, @shikhar_deep - we are looking to proceed with ArcGIS Notebook Server Standard on Windows Server 2022 VM using Mirantis and Windows containers. At this time, 2 users will primarily use notebook server for content, item and user management, but do anticipate running some image analyst and deep learning notebooks, for say rooftop extraction from image services. Typically we spec out a new ArcGIS Server Advanced windows vm with 8 cores, 32Gb ram, and a standard 250 Gb C drive. Do either of you have any suggestion as to number of cores, memory or disk space different from what I listed here? Thanks in advance - David

‎05-02-2023

@GeoJosh , your link 'is not found'

‎04-21-2023

Well, for me all I do is make sure my directory holding my .py files is shared and then I just have task scheduler run python.exe as the Action: C:\Users\yourname\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\python.exe and for the argument supply the python file using the UNC path \\MyComputerName\BatchDBTasksAE\SqlUnScripts\BatchSqlUN_SewerStructJunction.py. The python snippet above is configured for the IDLE, not Notebook, so you can just change the GIS param to match your portal and change the sd file location to your directory location and it will run no problem in the IDLE. When the above works for you, please mark it as correct thanks!

‎04-21-2023

Agreed. I'd have to dig back into old geomatics class work to find my spherical trig, and it has been a while that is for sure. But, for those out there working in any east-west extent state plane coord systems, your algorithm works well. Only need to make the adjustments as you indicate. In the meantime @TomNeer , I'd say that you have done half of Esri's work for them (as far as state plane conversions go.

‎04-21-2023

I would say that if you look at this: https://developers.arcgis.com/python/api-reference/arcgis.features.managers.html#arcgis.features.managers.FeatureLayerCollectionManager.overwrite In part, it reads "The data file used to overwrite should be of the same format and filename as the original that was used to publish the layer". So basically you need to create service definition file from your sde layer first. The feature layer is then created from that sd file, and when the sd file is overwritten, both the sd file and feature layer are updated. I prefer to use the sharing module in Pro to create the staging definition (sddraft) and service definition files (sd). Then, instead of jumping over to the api to do the overwrite, just continue to use sharing module in pro. However, it might look something like this from arcgis.gis import GIS from arcgis.features import FeatureLayerCollection gis = GIS("https://yourdomain/yourportal", "username_portal", "user_pw") try: portItems = gis.content.search(query="owner:username_portal", item_type="Feature Layer", sort_field="title", sort_order="asc", max_items=5000) #Service Definition Feature Layer for portItem in portItems: if (portItem.title == "YourFeatureLayer"): portFL = FeatureLayerCollection.fromitem(portItem) print (portItem.title) portFL.manager.overwrite('C:/ArcProProjects3x/YourSDFile.sd') #portFL.manager.refresh() print(portFL.properties) message = message + "\n" + (portItem.title) except Exception: # If an error occurred, print line number and error message import traceback, sys tb = sys.exc_info()[2] e = sys.exc_info()

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by DavidColey

Re: Missing Hosted Feature Classes after upgrading to 11.1

Re: Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Re: Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Re: Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Re: Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Re: Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Re: Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Removal of ArcMap based runtime from ArcGIS Server now leaves .log files at root of C

Re: Monitor 2023 DB installation question

Re: Monitor 2023 DB installation question

Re: Testing ArcGIS Notebook Server with Windows Containers beta release

Re: Windows Host Component Reboot Metric

Re: Overwriting Hosted Feature Service from Postgres Feature Class

Re: Arcade projectAs Geometry Function

Re: Overwriting Hosted Feature Service from Postgres Feature Class

Re: Members no longer showing in their assigned me...

Re: Experience Builder>Filter>Is any of filter typ...

Re: Get an Early Look at What's Next in ArcGIS Onl...

Re: Validate Network Topology Fails ArcGIS Pro 3.7...

Re: ArcGIS Data Store upgrade 11.5 to 12.1 fails

Experience Builder Custom Widgets

Experience Builder Tips and Tricks

Web AppBuilder Custom Widgets

ArcGIS Server with JavaScript API