topic Re: Monitor 2023.3 database connection in ArcGIS Monitor Questions

Monitor 2023.3 database connection

Pat_Gallagher — Fri, 15 Dec 2023 21:58:13 GMT

I upgraded our ArcGIS Monitor to 2023.3 and now the database data is not showing correctly. There is a new Alerts section in the database and that seems to be breaking the database links to Monitor.

ArcGIS Monitor 2023.2

ArcGIS Monitor 2023.3

After the upgrade I am not getting any metric data showing in any serial chart. It looks like the database is not accepting any new information.

Re: Monitor 2023.3 database connection

EsriEvan — Fri, 15 Dec 2023 23:26:35 GMT

Hi Pat,

Would you reach out to Support to start the diagnosis process? Thanks!

Re: Monitor 2023.3 database connection

IrisHadarStltd — Sun, 17 Dec 2023 06:05:35 GMT

I also upgraded our ArcGIS Monitor to 2023.3 and I having the same problem .

Database Monitor log shows error :"Retention management failed for table 'metrics_data'", but all the seems to collect data.

Did you receive any answer from support ?

Re: Monitor 2023.3 database connection

EsriEvan — Tue, 19 Dec 2023 01:22:22 GMT

Hi folks,

The dev team has been working with support today and have made good progress. We'll have a writeup this early week and share more information then.

Re: Monitor 2023.3 database connection

IrisHadarStltd — Tue, 19 Dec 2023 08:07:21 GMT

Hi Evan

Thank you for providing the response.

Just to clarify, does the bug exclusively impact the display, or are there any potential ramifications for the underlying database?

Re: Monitor 2023.3 database connection

GJameson — Wed, 20 Dec 2023 21:26:20 GMT

Do you have an update, Evan? I'm experiencing the same issue as well. The update with hosted feature services are fantastic! Thanks in advance for your time.

Re: Monitor 2023.3 database connection

EsriEvan — Thu, 21 Dec 2023 17:52:48 GMT

Hi @Pat_Gallagher ,

I believe the issue you are encountering is a bug which prevents the schedule DB maintenance task from running, and new partitions are not created. This will be addressed in a 2023.3.1 patch we're compiling. As a workaround, running this manually via Admin > Database > Run should alleviate the issue and metrics data should begin to appear. If not, please reach out to support and we can diagnose further.

Hi @IrisHadarStltd @GJameson ,

We haven't been able to readily reproduce the "Retention management failed for table 'metrics_data'" error after an upgrade. Would you please reach out to support to get a ticket started? This will get us get more information to diagnose.

Thanks,

Re: Monitor 2023.3 database connection

NaveenK — Sat, 30 Dec 2023 03:42:08 GMT

Running the workaround also gives the same error message. It does not resolve the issue. I have opened a support case today. Thanks.

Re: Monitor 2023.3 database connection

TristanMcHardie — Mon, 08 Jan 2024 22:34:54 GMT

I've also just upgraded from 2023.2 to 2023.3 and have come across "retention management failed for table 'metrics_data’" in the logs. Metrics collection has stopped, and running the workaround above yields the same error. Any other workarounds or a timeframe for 2023.3.1?

Re: Monitor 2023.3 database connection

DerekLaw — Tue, 09 Jan 2024 14:15:54 GMT

Hi @TristanMcHardie,

> Any ... timeframe for 2023.3.1?

We're working to release ArcGIS Monitor 2023.3.1 by the end of Jan.

Hope this helps,

Re: Monitor 2023.3 database connection

AYUSHYADAV — Tue, 30 Jan 2024 16:13:15 GMT

Hi @DerekLaw ,

I can see from the ArcGIS Monitor documentation that version 2023.3.1 has been released.

But I can't find the setup for the same from my Esri. Below is the screenshot attached for the same

Can you tell me when we can expect to get it available on my Esri?

Thanks

Ayush

Re: Monitor 2023.3 database connection

DerekLaw — Tue, 30 Jan 2024 20:34:52 GMT

Hi @AYUSHYADAV,

ArcGIS Monitor 2023.3.1 is scheduled to be released today. I will post an update when it's available on MyEsri. Thanks for your patience.

UPDATE: The release is now available

Hope this helps,

Re: Monitor 2023.3 database connection

AYUSHYADAV — Thu, 01 Feb 2024 08:04:46 GMT

Thanks for the update! @DerekLaw .

Re: Monitor 2023.3 database connection

TimLehn — Sat, 10 Feb 2024 01:08:51 GMT

I just upgraded to this version and had same issue. In trying to resolve it I somehow lost connectivity to my database and it now would like me to register a database but when i try there are lots of errors with GUI.

error: insert into "strategies_registry" ("description", "name", "r_id", "subtype", "type") values ($1, $2, $3, $4, $5), ($6, $7, $8, $9, $10), ($11, $12, $13, $14, $15), ($16, $17, $18, $19, $20), ($21, $22, $23, $24, $25), ($26, $27, $28, $29, $30), ($31, $32, $33, $34, $35), ($36, $37, $38, $39, $40), ($41, $42, $43, $44, $45) on conflict ("r_id") do update set "name" = excluded."name", "description" = excluded."description", "type" = excluded."type", "subtype" = excluded."subtype" - there is no unique or exclusion constraint matching the ON CONFLICT specification