Latest Contributions by FraserHand

Hi there, We just tried to upgrade to 2023.3 and the database connection dropped. In ArcGIS Monitor db admin we had this:   clicking on the configure just returned a 500 error (db connection error in the json), so I had to clear the db settings in the .env file to get the software to allow a db connection to be registered. On trying to reregister the db we had the same error described here: https://community.esri.com/t5/arcgis-monitor-questions/error-connecting-to-monitor-database/td-p/1257740 with the Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? error. This looks to be something in node.js so I tried updating to 2023.3.1 to see if that cleared it. I now get a timeout trying to reregister the db E_SERVER_TIMEOUT: Request timed out after 60000 ms and then this if I reattempt RuntimeException: Migrations are locked. Make sure you are not multiple migration scripts or delete `agm_schema_lock` table manually Dropping the table and rerunning the db register just returns to E_SERVER_TIMEOUT: Request timed out after 60000 ms The connection to the db is fine as I've tested via pgadminb / heidi etc. Restarting services does not help. Is there a way to clear this and reregister the db? Many thanks Fraser       ... View more

Hi there, As well as ArcGIS Enterprise we have a standalone GIS server site. I have added the 2 hosts to ArcGIS Monitor (2023.2) but do not have a full suite of metrics. I have the base mectrics but do not have the arcsoc memory and cpu usage for each service (like I do in the enterprise GIS servers). I just have the base metrics like this: in the metrics observer log I have this: ["Get-CimInstance -CimSession $Session -Class Win32_PerfFormattedData_PerfProc_Process | Where-Object {@(18436,25968,33024,35380,5780,26260,3420,9064,11936,29776,25080,9292,22172,2332,25792,25424,17424,9328,12872,31932,9248,8484,28384,23144,31680,13716,31140,1932,32504,5568,8968,31628,32188,36040,6672,23792,21884,11132,24420,37216,32360,16460,8956,19688,31824,17868,31632,23992,31868,28260,5220,36776,27764,24680,29952,35952,13976,28420,7356,4428,2508,37424,9336,5544,18260,27792,25964,16180,6768,19052,16796,9936,25420,32856,28868,25128,33632,31544,21896,30228,29756,34820,11356,28608,16564,31908,17584,18468,19924,22256,6388) -contains $_.IdProcess} | Select-Object IdProcess,WorkingSetPrivate,PercentProcessorTime | ConvertTo-Json -Compress","Get-CimInstance : Not enough memory resources are available to complete this operation. At line:1 char:1 + Get-CimInstance -CimSession $Session -Class Win32_PerfFormattedData_P ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ResourceBusy: (root\\cimv2:Win3...erfProc_Process:String) [Get-CimInstance], CimException + FullyQualifiedErrorId : HRESULT 0x8007000e,Microsoft.Management.Infrastructure.CimCmdlets.GetCimInstanceCommand + PSComputerName : 10.51.43.23",null] is this a wmi configuration issue? Has anyone seen this before?   Many thanks Fraser ... View more

Hi, I've got some components in an unknown state - they still appear to be collecting but are in an unknown state - what causes this - is there any way to bump them back to nominal. Thanks ... View more

Hi there, I've got several collections that look at particular ArcGIS Servers and have the host metrics, services and associated GIS server, so I get all the metrics populating on the overview  page. What I'm seeing is these are in an error state due to some of the metrics on the host component being in the error state. These seem to be  metrics on a service that has been deleted / removed. Looking at a filter "status is error" most of these appear to be arcsoc.exe metrics. Can I remove these from the metrics table safely?  Can I do something like DELETE FROM agm.metrics where r_id like '%arcsoc.exe%' and status = 4 Is a status of 4 in the agm.metrics the error status - I couldn't find the values on the data model https://doc.arcgis.com/en/monitor/2023.1/get-started/windows/arcgis-monitor-information-model.htm#ESRI_SECTION1_8B001299A11E4A7C8A83292A5EBAF80F  Are there any relationships I'd need to clean up as well? I'm assuming if I deleted anything still in use this would be picked up again on the next discover? Thanks! Fraser ... View more

Hi there, I'm seeing a few of these popping up   in the resource column is that the observers table id #8 - so this:   this will help me track down what's failing. Thanks Fraser     ... View more