AnsweredAssumed Answered

Failing Enable Geodatabase Amazon RDS Postgres and PostGIS

Question asked by gisshell on Jun 23, 2017
Latest reply on Jun 23, 2017 by vangelo-esristaff

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

Outcomes