Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

1932
9
Jump to solution
06-23-2017 08:47 AM
venkateswarlunittala
New Contributor II

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) |... 

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

0 Kudos
1 Solution

Accepted Solutions
9 Replies
George_Thompson
Esri Frequent Contributor
venkateswarlunittala
New Contributor II

Hi George Thompson

Thanks for your reply, We will try with 9.4.5 Postgres 

Venkat

0 Kudos
venkateswarlunittala
New Contributor II

Hi George ,

Is AWS aurora with Postgres  work with  Geodatabase.

Thanks

Venkat

0 Kudos
George_Thompson
Esri Frequent Contributor

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 ... 

--- George T.
0 Kudos
VinceAngelo
Esri Esteemed Contributor

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

0 Kudos
venkateswarlunittala
New Contributor II

Hi Vince Angelo

Thank you for your clarification

Venkat

0 Kudos
VinceAngelo
Esri Esteemed Contributor

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

- V

venkateswarlunittala
New Contributor II

George Thompson

Thank you Venkat

johanwatt
New Contributor

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

0 Kudos