nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Monitor 2023.3.1: Unable to register a component: SQL Server

RickChu

Hello,

We have recently setup ArcGIS Monitor 2023.3.1. I have registered several components but I'm having trouble registering a SQL Server component..

On the screen where you configure the Address, Database, username and password, I filled in the fields and clicked "Register Component". After a few seconds I get this message:

An error occurred running the observer

Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?

I have verified that the userid and password are correct and that no firewalls are blocking access to SQL Server.

I had no trouble adding a Postgresql server

Any thoughts on what may cause this error?

Find more posts tagged with

Accepted answers

RickChu

There is another post for the same error but a different ESRI product. They recommended restarting the service. I restarted ArcGIS Monitor Service and Postgresql. After the restart, I was able to register SQL Server.

I don't know the root cause, but it appears that my problem is resolved.

All comments

Shawn_NG

@RickChu Since your are registering SQL Server database, did you follow the pre-requisite steps mentioned in document https://doc.arcgis.com/en/monitor/2023.3/get-started/windows/register-sql-server-databases.htm#ESRI_SECTION1_340B7B4284AB4E7589AE93EFBBF0D9F0

StevenBeothy

I had a client who had this same error and their issue was resolved by them updating their NSG in Azure to allow the ArcGIS Monitor server. Check to see if you have a firewall rule blocking the ArcGIS Monitor Server or Agent.

RickChu

I don't know the root cause, but it appears that my problem is resolved.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.