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; } } }

ArcGIS Monitor 2023.0 Setup Issues

John_Spence

Is anyone else running into issues getting the latest flavor up and running? I am getting these types of errors:

error: create table "agm_schema" ("id" serial primary key, "name" varchar(255), "batch" integer, "migration_time" timestamptz default CURRENT_TIMESTAMP) - no schema has been selected to create in

from a locally installed PostgreSQL database w/ Monitor.

Find more posts tagged with

Accepted answers

John_Spence

DOH! Didn't set to the search_path to Current.

All comments

John_Spence

DOH! Didn't set to the search_path to Current.

EsriEvan

Hi John - happy to hear you were able to troubleshoot this yourself! This is an interesting one and I will bring it back to the dev team. Perhaps the team can add some additional handling to set the search_path to Current if not already.

John_Spence

That would be great! I am sure it would help someone out since we are not all in the PostgreSQL world. If they could add compatibility to v15 too, it would be great. I guess when I was installing all the documentation on requirements wasn't out so it was a bit of a guessing game. There are a few oddities/quirks. I may pull it down and reinstall everything just to drop the quirks.

PGF50

I am facing issues with deployment of ArcGIS Monitor on SUSE Linux Enterprise Server 15 Service Pack 4. The installation goes well without any errors however when I try to start the service I get the error shown below:

xyz:/usr/lib/arcgis/monitor/bin> ./arcgis-monitor
node:internal/errors:477
ErrorCaptureStackTrace(err);
^

Error: spawn netstat ENOENT
at ChildProcess._handle.onexit (node:internal/child_process:283:19)
at onErrorNT (node:internal/child_process:476:16)
at processTicksAndRejections (node:internal/process/task_queues:82:21)
at process.runNextTicks [as _tickCallback] (node:internal/process/task_queues:64:3)
at Function.runMain (pkg/prelude/bootstrap.js:1984:13)
at node:internal/main/run_main_module:17:47 {
errno: -2,
code: 'ENOENT',
syscall: 'spawn netstat',
path: 'netstat',
spawnargs: [ '-r', '-n', '-A', 'inet' ],
cmd: 'netstat -r -n -A inet',
stdout: '',
stderr: ''
}

Node.js v18.5.0

I am doing this on two machines and getting similar results, any ideas would help to resolve this issue?

PGF50

I used the instruction's PDF that come with the installation files. I have setup Postgres and configured it according to the directions also provided in the PDF.

Anonymous User

where in the above referenced code does he need to set the search_path to Current? is it after the timestamp?

_VincePoy_

Worth adding here, the database name, user name and schema name must all be the same.

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.