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.

[John_Spence · Accepted solution]

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

[Anonymous User]

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

[EvanMosby]

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:

XXX:/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. 

[_VincePoy_]

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