topic Error registring the dataStore with ArcGIS Server in ArcGIS Enterprise Questions

Error registring the dataStore with ArcGIS Server

SaraEL_MALKI — Wed, 11 Jul 2018 10:37:52 GMT

Hello guys,

I'm configuring my dataStore 10.5.1 with the ArcGIS Server on Windows Server 2008 R2,

when I clicked on finish I got the error above!

I read all the documentation about the configuration, the only thing that I didn't get is the highlighted sentence:

because during the configuration, I used my "siteadmin" user which is the admin of my arcgis server site, what is a BUILT-IN user ??

EDIT:

progress: the built-in user used in siteadmin ( and it's not the source of error)

I have found the log file of datastore and it's saying that it can't find POSTGRES !!!

( the logfile is in french)

pg_restore: [programme d'archivage (db)] Erreur pendant le traitement de la TOC (« PROCESSING TOC ») :
pg_restore: [programme d'archivage (db)] Erreur à partir de l'entrée TOC 2863 ; 0 0 ACL public postgres
pg_restore: [programme d'archivage (db)] could not execute query: ERREUR: le rÃ´le Â« postgres Â» n'existe pas
La commande était : REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
...
ATTENTION : erreurs ignorées lors de la restauration : 1

but why it is searching for postgres ?? because I wanna work with Oracle as relational database !

Randall Williams‌ Robert Scheitlin, GISP‌

Re: Error registring the dataStore with ArcGIS Server

RandallWilliams — Thu, 12 Jul 2018 15:29:56 GMT

Hi Sara,

Apologies for the delay.

A 'built in' user means a user refers to a user created using the default ArcGIS Server configuration using the built-in user and role store, as opposed to a user from an enterprise user store (like LDAP/Active Directory).

The siteadmin account you mention is an example of a built-in user.

Re: Error registring the dataStore with ArcGIS Server

SaraEL_MALKI — Thu, 12 Jul 2018 19:16:34 GMT

I checked the log file and it says that it couldn't connect with PostgreSql، but why it is searching for postgres ?? because I want to work with Oracle.

do I need to configure something in order ti change postgres to oracle ??

Re: Error registring the dataStore with ArcGIS Server

JacobBoyle412 — Fri, 13 Jul 2018 19:11:06 GMT

Data Store uses a PostgreSQL instance for the Relational Data Store. That is why you are seeing PostgreSQL errors.

Re: Error registring the dataStore with ArcGIS Server

SaraEL_MALKI — Fri, 13 Jul 2018 19:59:49 GMT

so I need to install PostgreSql ??!

Re: Error registring the dataStore with ArcGIS Server

JacobBoyle412 — Fri, 13 Jul 2018 21:09:34 GMT

nope, it's built into the installer for Data Store. We(Esri) take care of all of the back end stuff. ArcGIS Data Store is intended to be a hands off data cache.

I'd like to point you to a white paper from Esri about this very subject: https://community.esri.com/community/gis/enterprise-gis/arcgis-enterprise/blog/2018/06/13/esri-whitepaper-data-in-arcgis-user-managed-and-arcgis-managed

Give this a once through, and if you find you have further questions, I'll be happy to help you.

Re: Error registring the dataStore with ArcGIS Server

RandallWilliams — Fri, 13 Jul 2018 23:51:01 GMT

Sara,

I'd like to understand what you'd like to do, since you mention Oracle but you also mention the Data Store.

Is your intention to deploy a 'base enterprise deployment' of ArcGIS, consisting of Portal for ArcGIS, ArcGIS Server, and the ArcGIS Data Store?

Or is your intention to register an instance of Oracle as an enterprise geodatabase with your ArcGIS Deployment?

The configuration workflows differ, which is why I'm asking.

Re: Error registring the dataStore with ArcGIS Server

SaraEL_MALKI — Sat, 14 Jul 2018 04:47:35 GMT

it is absolutely the second option !

Re: Error registring the dataStore with ArcGIS Server

RandallWilliams — Mon, 16 Jul 2018 13:22:40 GMT

OK.

This is the doc you should reference: