topic Register Database in ArcGIS Enterprise Questions

Register Database

CS_IBM — Thu, 06 Jun 2024 16:59:04 GMT

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

Re: Register Database

George_Thompson — Thu, 06 Jun 2024 17:46:50 GMT

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?

Re: Register Database

CS_IBM — Fri, 07 Jun 2024 09:52:46 GMT

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

Re: Register Database

George_Thompson — Fri, 07 Jun 2024 10:42:17 GMT

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

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

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

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

Hope this helps!

Re: Register Database

CS_IBM — Fri, 07 Jun 2024 11:29:28 GMT

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.

Re: Register Database

George_Thompson — Fri, 07 Jun 2024 12:11:03 GMT

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.

Re: Register Database

AyushAggarwal — Wed, 05 Feb 2025 14:37:15 GMT

Hi @CS_IBM,

We are facing the same exact issue. Were you able to find any solution?