topic Re: Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store in Geodatabase Questions

Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store

mfcallahan — Tue, 21 Feb 2023 20:26:19 GMT

I have a PostgreSQL database instance running in the Azure Database for PostgreSQL service. I am able to successfully connect, create enterprise geodatabases within, and load feature classes. I am also able to register the database as a data store, both via ArcGIS Pro and ArcGIS Server Manager. However, when attempting to share a table in the database as a web layer (right click > Sharing > Share as web layer), it will ultimately fail with error 00231, "Layer's data source must be registered with the server." seemingly not recognizing the registered data store I had just added. I verified there were no typos or other configuration errors.

Tech support provided the following guidance, which did not resolve the issue.

Remove previously registered data store
Open "Share as Web Layer" tool
Run "Analyze" and right click error 00231 > Register Data Source with Server

I observed something interesting at this point; the connection string automatically generated in the dialog box truncates the "@hostname" part of the username, and the validation will fail:

I am able to click "Import" in this dialog box and manually specify the .sde connection file, the generated connection string does not malform the username, and the data store can be registered. However, I am right back to the same issue and receive error 00231 once again when attempting to run "Share as Web Layer."

I'm hoping someone out there has observed this and found a workaround! 🤞

Re: Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store

ChrisUnderwood — Fri, 24 Feb 2023 17:51:25 GMT

You haven't stated which Deployment Model you are using with your Azure Database for PostgreSQL.

https://learn.microsoft.com/en-us/azure/postgresql/single-server/overview#deployment-models

PostgreSQL databases in Azure can be “Azure Database for PostgreSQL single server” or “Azure Database for PostgreSQL flexible server”. For Single server I would try using “username@database” style login, for flexible server I would try using just “username” style.

Re: Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store

mfcallahan — Sat, 25 Feb 2023 18:22:10 GMT

I am using the Single Server Azure Database for PostgreSQL deployment. I am also using the "username@hostname" credential - omitting the @hostname will not allow login on any client, Pro included. The issue here is that the connection string generated by ArcGIS Pro appears to be truncating the "@username"

Re: Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store

ChrisUnderwood — Thu, 09 Mar 2023 16:59:12 GMT

Are you using an up-to-date version of ArcGIS Pro, eg 2.9.7, or 3.0.4, or 3.1.0 ?

Re: Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store

mfcallahan — Thu, 09 Mar 2023 17:08:59 GMT

This issue is occurring in ArcGIS Pro 3.0.3, 3.0.4, and 3.1.0; ArcGIS Server version is 10.8.1. Esri has confirmed this is a bug (BUG-000156390). Pretty frustrating as it is claimed here that Microsoft Azure Database for PostgreSQL (Single Server option) is supported by Esri, but it doesn't appear to be fully so.

https://desktop.arcgis.com/en/system-requirements/latest/databases-in-the-cloud.htm

Re: Sharing a web layer fails with error 00231, despite the database already being registered as an ArcGIS Server data store

ANH — Mon, 15 Apr 2024 01:44:26 GMT

Hi @mfcallahan, did you manage to find a fix or workaround for this? I am currently experiencing the same problem.