Register Database

CS_IBM

Greetings,
I am working on ArcGIS Enterprise 11.3 (Windows) on AWS.

I am trying to Register a PostgreSQL Geodatabase, that I can access in ArcGIS Pro.
I can access and import the Features into a Map.

I get an error message, when I try to register the gdb. there is no Error number or useful information to debug this??

The connection property set was missing a required property or the property value was unrecognized. Invalid connection property.[ ]

The Logs say no custom workspace factory in connection string.
There was no option to add a custom workspace factory??
Any suggestions?

Thanks
Clive

George_Thompson

Did you add the Enterprise machine to the pg_hba.config file?

Does the ArcGIS Enterprise machine have access to the PostgreSQL machine in AWS?

What user are you using to register the connection as? postgres, sde, other?

What is the version of PostgreSQL being used?

Is PostgreSQL RDS / Aurora / Stand-alone on VM?

--- George T.

CS_IBM

Hi George
we are connection to PostgreSQL RDS (PostgreSQL 16).
So unable to edit the pg_hba.config file, as I understand it.

I am connected as an admin user.
I can connect to the PostgreSQL in ArcGIS Pro, and import Features.

When I run the SDE connection file in ArcGIS Manager to Register the Enterprise gdb, I get the WORKSPACE_FACTORY error.

The Python syntax states the WORKSPACE_FACTORY is only for Snowflake, not PostgreSQL??

any suggestions to assist resolve this?

Thanks
Clive

George_Thompson

If your RDS is truly running PostgreSQL version 16, that may be the issue as it is not supported by 11.3: https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql...

Cloud based supported DB's: https://enterprise.arcgis.com/en/system-requirements/latest/windows/databases-in-the-cloud.htm#ESRI_...

Also review: https://enterprise.arcgis.com/en/system-requirements/latest/windows/databases-in-the-cloud.htm#ESRI_...

Can you test on a supported version of PostgreSQL and see if the behavior is the same?

I have seen where an unsupported version of an RDBMS may work (partially) on 1 client but not another.

Once you are on a supported release here is the EGDB doc: https://enterprise.arcgis.com/en/server/latest/cloud/amazon/create-geodatabase-in-amazon-rds-for-pos...

Hope this helps!

--- George T.

CS_IBM

We have installed 15.5

Still no nearer to resolving the error.
ERROR: Connection with initial workspace factory failed. Falling back to trying with the SqlWorkspaceFactory.

George_Thompson

Thanks for that confirmation on the version.

I am not sure what would cause this specific error, I would recommend that you work with Technical Support case to work with an analyst on this issue.

--- George T.