topic Create Enterprise GeoDatabase Error on PostGreSQL in Data Management Questions

Create Enterprise GeoDatabase Error on PostGreSQL

SignalGroup — Mon, 22 May 2017 04:05:25 GMT

I am running Create Enterprise GeoDatabase tool on PostgreSQL Database on windows ,this tool is throwing above error

Re: Create Enterprise GeoDatabase Error on PostGreSQL

JayantaPoddar — Mon, 22 May 2017 08:07:21 GMT

What is the version of PostgreSQL? PostgreSQL database requirements for ArcGIS 10.4.x

Re: Create Enterprise GeoDatabase Error on PostGreSQL

ChrisCatania — Mon, 22 May 2017 17:04:25 GMT

Hi Signal Group team - Thanks for asking your questions and welcome to the GeoNet community! I wanted to let you know that we're moving your question to the Managing Data‌ space so our Esri and user subject matter experts can further help answer this and future questions. So you're aware on how and where to post your questions, here's a few quick tips and reminders:

First, use the GeoNet search (top right corner by your profile icon) to search and see if your question has already by asked/answered previously.
If not, than we suggest reviewing the GeoNet Community Structure, to find the most relevant space to post your question.
The GeoNet GeoNet Help group is for questions and tips on how to use the GeoNet community platform not the Esri ArcGIS platform. Following steps 1 & 2 above will give you the best results for getting Esri product questions answered.
This GeoNet 101 "How to Ask Questions on GeoNet" post is also a helpful guide to asking questions: https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-to-ask-questions-and-get-answers

Thanks again for contributing and I hope this helps and let us know if you have any questions.

Re: Create Enterprise GeoDatabase Error on PostGreSQL

George_Thompson — Mon, 22 May 2017 17:07:00 GMT

https://community.esri.com/groups/geodatabase?sr=search&searchId=9850c319-40b0-4a2b-9181-054373003cca&searchIndex=0‌ for a wider audience.

Re: Create Enterprise GeoDatabase Error on PostGreSQL

VinceAngelo — Mon, 22 May 2017 19:11:34 GMT

It's always critical to specify, in the question:

The exact release of the database to which you are connecting, and
The exact release of ArcGIS which is being used to connect.

The error message implies that your database is incompatible with your Desktop.

- V

Re: Create Enterprise GeoDatabase Error on PostGreSQL

SignalGroup — Tue, 23 May 2017 04:06:32 GMT

I am using Postgres 9.4.11(64bit) , PostGIS 2.3.2 (64bit) , ArcGIS 10.4 ..

Windows 8 64Bit OS.

Re: Create Enterprise GeoDatabase Error on PostGreSQL

SignalGroup — Tue, 23 May 2017 04:07:50 GMT

I am using Postgres 9.4.11(64bit) , PostGIS 2.3.2 (64bit) , ArcGIS 10.4 ..

Windows 8 64Bit OS.

Re: Create Enterprise GeoDatabase Error on PostGreSQL

Asrujit_SenGupta — Tue, 23 May 2017 04:11:10 GMT

Well from the System Requirements page PostgreSQL database requirements for ArcGIS 10.4.x—System Requirements | ArcGIS Desktop , it seems that the PostGIS 2.3.2 is not supported with 10.4.x yet.

Can you try with PostGIS 2.2 and check...

Re: Create Enterprise GeoDatabase Error on PostGreSQL

SignalGroup — Wed, 24 May 2017 08:53:52 GMT

Thanks for Solution .

It is working now ..One Problem is that we should connect the DB using SDE User ,then run this particular tool on that connection ,it works.

Re: Create Enterprise GeoDatabase Error on PostGreSQL

Asrujit_SenGupta — Wed, 24 May 2017 10:18:30 GMT

That is because the PostgreSQL Enterprise Geodatabase System Table needs to be created under the SDE Schema.

Create a geodatabase in PostgreSQL on Windows—Help | ArcGIS Desktop

Check the "Create a geodatabase" part in the above link..

Re: Create Enterprise GeoDatabase Error on PostGreSQL

venkateswarlunittala — Fri, 23 Jun 2017 06:50:06 GMT

Amazon RDS Postgres Enable Gerodatabase tool with Postgis 2.2.5

ArcGIS 10.4.1

I am getting below error any help is appreciated.

Start Time: Fri Jun 23 06:39:09 2017
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.
Failed to create stored procedures in the geodatabase. Error (-42)
DBMS error code: -42
ERROR: too many parameters specified for RAISE
CONTEXT: compilation of PL/pgSQL function "sde_layer_def_change_table_name" near line 20
SQL state: 42601

See the setup log in the following location for additional error information:
C:\Users\ADMINI~1\AppData\Local\Temp\2\sde_setup.log
Could not create geodatabase tables and stored procedures.
Failed to execute (EnableEnterpriseGeodatabase).
Failed at Fri Jun 23 06:39:34 2017 (Elapsed Time: 25.13 seconds)

Thanks

Venkat

Re: Create Enterprise GeoDatabase Error on PostGreSQL

VinceAngelo — Fri, 23 Jun 2017 14:22:00 GMT

Please ask a new question instead of adding on to an existing thread with a different environment. As stated in this thread, it's always critical to specify, in the question, the exact release of the database to which you are connecting.