topic Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS in Geodatabase Questions

Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

venkateswarlunittala — Fri, 23 Jun 2017 15:47:29 GMT

Hi GIS Experts,

Any help is appreciated.

Following these instructions

Create a geodatabase on Amazon Relational Database Service for PostgreSQL—ArcGIS for Server (10.4) | ArcGIS Enterprise

PostgreSQL 9.6.2 Amazon RDS

PostGIS 2.3.2 (64bit)

ArcGIS 10.4.1

Enable Enterprise Geodatabase gives below error

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: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

George_Thompson — Fri, 23 Jun 2017 16:36:38 GMT

It looks like you are not on a support PostgreSQL version: PostgreSQL database requirements for ArcGIS 10.4.x—Help | ArcGIS Desktop

The highest support version is 9.4.5, not 9.6.x

Also review this GeoNet post: https://community.esri.com/message/650241-re-solved-amazon-postgresql-rds-enable-enterprise-geodatabase-crashes-using-104?c…

https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=d763a900-aac0-499a-ac50-105afbc102b8&searchIndex=1‌

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

venkateswarlunittala — Fri, 23 Jun 2017 16:44:30 GMT

Hi George Thompson

Thanks for your reply, We will try with 9.4.5 Postgres

Venkat

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

venkateswarlunittala — Fri, 23 Jun 2017 16:58:16 GMT

Hi George ,

Is AWS aurora with Postgres work with Geodatabase.

Thanks

Venkat

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

George_Thompson — Fri, 23 Jun 2017 17:04:16 GMT

I am not familiar with AWS Aurora and Geodatabase functionality. i would review this link: Geodatabases in PostgreSQL included with ArcGIS Enterprise on Amazon Web Services—ArcGIS Enterprise on AWS | ArcGIS Ente…

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

venkateswarlunittala — Fri, 23 Jun 2017 17:08:35 GMT

George Thompson

Thank you Venkat

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

VinceAngelo — Fri, 23 Jun 2017 18:00:42 GMT

Any of the PG 9.4.x releases (where x >= 5) are supported with ArcGIS 10.4.1. Only 9.4.5 was certified.

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

venkateswarlunittala — Fri, 23 Jun 2017 18:20:55 GMT

Hi Vince Angelo

Thank you for your clarification

Venkat

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

VinceAngelo — Fri, 23 Jun 2017 18:30:47 GMT

Please use the "Mark Correct", "Helpful", and "Like" buttons in lieu of adding records to the database with thanks.

- V

Re: Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

johanwatt — Sun, 21 Aug 2022 06:00:41 GMT

AWS RDS with PostgreSQL 9.6.2

The latest version of PostGIS is 2.3.2 (64-bit)

ArcGIS 10.4.1

When I enable Enterprise Geodatabase, I receive the following error message

Start Time: Friday, June 23, 2017, at 06:39:09
The authorization file has been validated.
The user has the necessary privileges in order to set up the geodatabase.
It has been enabled for the database instance to support XML.
The RDBMS instance that is connected to Esri spatial type configuration is already configured.
A stored procedure could not be created in the geodatabase due to an error. The error code is (42); the error code is (42);
The DBMS error code for this error is -42.
ERROR: there are too many parameters specified for the RAISE command.
CONTEXT: Compilation of the PL/PgSQL function "sde_layer_def_change_table_name" near line 20 of the file
The SQL state at the moment is 42601.

Additional error information can be found in the setup log at the following location:
C:\Users\ADMINI~1\AppData\Local\Temp\2\sde_setup.log
The geodatabase tables and stored procedures could not be created.
The command (EnableEnterpriseGeodatabase) could not be executed.
The request failed on Fri Jun 23 06:39:34 2017 (Elapsed Time: 25.13 seconds)

Thanks