topic Re: ArcGIS Pro create enterprise geodatabase not finishing in ArcGIS Pro Questions

ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Sat, 11 Dec 2021 17:49:58 GMT

I am trying to create GDBs in postgres for ArcGIS Enterprise. While the tool starts properly, it seems to get stuck at 9% .

When I look into my postgres server connection I can see that the gdb was still created.

I wouldn't care if there would be a way of terminating the progress but the only way to stop it (to be able to continue with the work I was doing...) is to "kill" the task in the task manager and to open the project again. And that is annoying...

Does anybody else have a similar problem?

I saw this post https://community.esri.com/thread/232476-arcgis-pro-create-enterprise-gdb-fails-in-postgres but (as much as I understand the issue) this does not apply to my problem.

I am using ArcGIS Pro 2.4.1 on ArcGIS Enterprise 10.7 on Ubuntu with Postgres 10.

This is how far it goes:

User has privileges required to create database objects.
Geodatabase admin user already exists.
Database created.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Connected RDBMS instance is setup for Esri spatial type configuration.‍‍‍‍‍‍‍

When I try to create the gdb from ArcMap 10.7 then I get following error:

Executing: CreateEnterpriseGeodatabase PostgreSQL 10.10.91.25 bio_indicators DATABASE_AUTH postgres ***** SDE_SCHEMA sde ***** # 
***** [this is were the link to the key code is]
Start Time: Thu Sep 26 11:58:34 2019
User has privileges required to create database objects.
Geodatabase admin user already exists.
Database created.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
You must copy the latest ST_GEOMETRY library to the PostgreSQL software location. Refer to the ArcGIS help topics for more details.
Connected RDBMS instance is not setup for Esri spatial type configuration.
Failed to execute (CreateEnterpriseGeodatabase).
Failed at Thu Sep 26 11:58:40 2019 (Elapsed Time: 6.09 seconds)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

but even this gdb is created eventually. But I cannot import any data into it as far as I tried.

I confirmed that the st_geometry.so is in the right place - what else can I do?

Re: ArcGIS Pro create enterprise geodatabase not finishing

George_Thompson — Thu, 26 Sep 2019 22:17:33 GMT

I have seen that on Postgres on Windows machines related to Microsoft Visual C++ Redistributable for Visual Studio 2017 not being installed, but not on Ubuntu.

Did you follow this help doc: Create a geodatabase in PostgreSQL on Linux—Geodatabases in PostgreSQL | ArcGIS Desktop

Are you running Postgres 10.7, at a minimum?

Is the ArcGIS Pro client and the Postgres RDBMS in the same location (i.e. data center or office)?

Geodatabase‌ ArcGIS Enterprise‌

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Fri, 27 Sep 2019 13:31:11 GMT

Soooo, it turned out that it's running with PostgresSql 11.4 (I got a wrong information yesterday).

I am connecting through a VPN with the server, so we are not at the same place.

My colleague was creating gdbs from her computer with ArcMap (not sure which version so, she is not here today) which have been working well. The ones I created turn out to be not really ArcGIS spatial gdbs as they don't support feature datasets and also not relationship classes.

After trying to copy the right st_geometry.so I cannot connect any longer to the ones my colleague created before while mine are still connecting. I get this error message:

It seems not to recognize the st_geometry.so file in the /usr/lib/postgresql/11/lib folder anymore to supposed to be working with 11 but says it's 10. (I renamed the existing ones, then copied one from 10 but that didn't help, I removed that one again and named back the old one but it seems like it still sees that wrong file)

I don't have a st_geometry.so file for Psql 11 on my computer do make sure that the proper version is online. Is there a way to get that file from somewhere?

I have to admit that this is my first Enterprise experience at all...

Re: ArcGIS Pro create enterprise geodatabase not finishing

George_Thompson — Fri, 27 Sep 2019 13:42:29 GMT

Edit: Support for Postgres 11 starts with ArcGIS Server 10.7.1, not 10.7; PostgreSQL database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.4—System Requirements | ArcGIS Desktop

I do no think it has to do with the authorization file version.

You can download the Pro Database Support files from My Esri and there is a *.so for Postgres 11.

Try that and let us know.

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Wed, 02 Oct 2019 14:19:58 GMT

So, I'm back to start... Thanks for the hint where to download the library files, at least now I'm back to where I startet on Friday morning 😞 I also copied that 11 folder to my local installation (as I thought maybe it would help) but without a change.

If I understood correctly, Postgres 11.4 is installed but the Enterprise is *using* (please don't ask me how this works...) version 10 - I don't know how to test this. Any hint? When I try the - version command it brings me the 11.4 but our IT lady said it is still using 10 only.

Unfortunately we couldn't find another computer yet where we would be able to use the VPN connection AND have the same software version installed as I do to test if this is an issue of my computer or if it is a different problem. I am not sure if I mentioned before that my colleague was able to create two (ArcGIS enabled) databases without an issue but she is now on maternal leave...

Any other idea what I could try to figure out where the problem is?

Re: ArcGIS Pro create enterprise geodatabase not finishing

George_Thompson — Wed, 02 Oct 2019 14:33:56 GMT

I think that there needs to be some clarification in this post. Sorry that I am not an Linux guru.

- ArcGIS Enterprise might have a different version of Postgres that is used behind the scenes. This is independent of Enterprise Geodatabase version of Postgres that you decide to use.

- When you connect to the Postgres instance on the Linux machine via PgAdmin and run

SHOW server_version;

What are the results?

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Wed, 02 Oct 2019 19:52:36 GMT

The result is

11.4 (Ubuntu 11.4-1.pgdg16.04+1)

Re: ArcGIS Pro create enterprise geodatabase not finishing

George_Thompson — Thu, 03 Oct 2019 11:00:03 GMT

Ok, so it look like the PG version is 11.4. I am not sure why you are having issues once you place the PG 11 .so file from My Esri in the correct location.

My suggestion would be to open a tech support case and work with an analyst who can review it in more detail.

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Thu, 03 Oct 2019 11:05:16 GMT

Thanks for taking your time to look into it George!

Re: ArcGIS Pro create enterprise geodatabase not finishing

StefKoroblitsas — Fri, 04 Oct 2019 13:22:37 GMT

I think im having the similar/same issue, This is how far it goes in 10.7.1:

it just keeps spinning. Im using windows and postgres 11.2

I was getting the intital error as you in Arcmap but updated to 10.7.1 and it changed to above.

Let me know if you find a solution

Stef

Re: ArcGIS Pro create enterprise geodatabase not finishing

George_Thompson — Fri, 04 Oct 2019 16:41:05 GMT

Is your Desktop client in the same location as your Postgres DB server?

Re: ArcGIS Pro create enterprise geodatabase not finishing

StefKoroblitsas — Fri, 04 Oct 2019 22:56:02 GMT

Hi George,

We have put postgres on an azure machine and want to create the enterprise geodatabase on our desktop but I've also tried having arcmap on our azure machine and I get the same result, gets3/4 through and then hangs.

I've got a ticket at the moment but its moving very slowly.

Cheers

Stef

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Sat, 05 Oct 2019 20:15:41 GMT

I also opened a ticket now. I am afraid it will be tricky to have it solved because of the strange IT infrastructure for the project I am working on... I will let you know when we found a solution!

Re: ArcGIS Pro create enterprise geodatabase not finishing

MarcoBoeringa — Sun, 06 Oct 2019 10:54:20 GMT

I don't know your requirements, but you are aware that you can access PostgreSQL/PostGIS spatial databases without enabling them as an ESRI Enterprise Geodatabase?

Unless you have specific needs for an ESRI Enterprise Geodatabase due to ArcGIS editing workflows, need for advanced geodatabase data types, relationship classes etc, you may be able to simply connect to the spatial database using ArcGIS Query Layers and not enable an Enterprise Geodatabase.

You just need to run the Add Incrementing ID Field tool against any spatial table in the PostGreSQL/PostGIS database if there is no suitable unique ID field for each record in the table. You will then be able to add a Query Layer including spatial columns to ArcGIS.

If your requirements are just "read-only" access of PostGIS data maintained by another software package, this setup may suffice.

I have run such a setup against large PostGIS databases with great success.

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Sun, 06 Oct 2019 11:20:40 GMT

Unfortunately I need the functionality of an Enterprise Geodatabase - I need Feature datasets and relationship classes to maintain the structure of the local gdb otherwise it becomes too complicated for our client to maintain the data...

Re: ArcGIS Pro create enterprise geodatabase not finishing

Nicole_Ueberschär — Thu, 10 Oct 2019 13:49:53 GMT

I cannot really tell which of the steps I did today solved the problem but I did

- copy (again, I was sure I tried that before) the st_geometry.so file from my ArcPro DatabaseSupport folder (postgres 11) to the /usr/lib/postgresql/11/lib folder on the server (I had downloaded those files for myEsri as I couldn't find them locally)

- upgrade my ArcMap installation to 10.7.1 [remark: I understood that the SERVER installation has to be compatible with the postgres installation but I learned today that the desktop version is the one that needs to be compatible; ]

- copy the DatabaseSupport files for postgres into the installation of ArcGIS Pro (I realized today that postgres was missing here, I don't know why I didn't find that before)

So possibly a combination of all made it finally work today. My only issue is now that it takes about 9 minutes to create an Enterprise GDB but that might be caused by the VPN connection I have to use to connect to the server.

Maybe this helps someone else...

Thanks for looking into it!

Re: ArcGIS Pro create enterprise geodatabase not finishing

AzinSharaf — Fri, 26 Mar 2021 20:49:24 GMT

I had same issue but in SQL Server and Windows. Restarting the SQL Server Windows service resolved the issue.

Re: ArcGIS Pro create enterprise geodatabase not finishing

Carolyn_Jones — Thu, 06 Jun 2024 20:24:39 GMT

Restarting the SQL Server Windows Service resolved the 'Enable Enterprise Geodatabase' GP tool hanging for me as well.