AnsweredAssumed Answered

Register Database fails with "timeout expired"

Question asked by rmcculley on Sep 7, 2016
Latest reply on Sep 8, 2016 by JQuinn-esristaff

I have an ArcGIS server instance running on a cloud server on Amazon built using the Cloud Builder tool.  It's running on Ubuntu and is version 10.3.  ArcGIS for Server is running, and works perfectly with data copied to the server.

 

I've created an Enterprise Geodatabase in PostgreSQL on the same cloud server.  The database creation worked with no errors, and I've loaded data into the database.  I created the database using ArcCatalog on my local system.  I can connect to the database from ArcMap and ArcCatalog on my local machine.  When I try and register the database with ArcGIS for Server on the cloud server, I get the following error message:

 

The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[timeout expired SQL state: ]

I've tried changing authentication_timeout, statement_timeout, and lock_timeout to a few different values in the postgresql.conf file with no change.

 

I've tried executing the arcpy.CreateDatabaseConnection_management function on the cloud server, and it outputs:

 

timeout expired

Connection to database 'arcgis' failed.

timeout expired

timeout expired

Connection to database 'arcgis' failed.

timeout expired

<Result 'Z:\\gisdata\\ArcGIS_AWS.sde'>

Despite the messages, it succesfully creates the connection file.  If I try and register the database with that connection file, I still get the same error message as above.

 

Looking in the folder /arcigs/server/bin/ I see all of the .dll files required to connect to PostgreSQL.

 

What am I missing?  Why can't I register this geodatabase with the Server?

Outcomes