ArcGIS Datastore (relational data) stop working after latest patches

TonyAlfredsson_ — Mon, 03 Jul 2023 14:52:16 GMT

Hi,

After mainly installing the web-adaptor patch due to the bugs around the adaptor, stop responding to requests. We now have issues creating new hosted feature services. It also seems to be missing the feature-hosted services. (relational data)

The Datastore is up and running, and I can't find any errors in the logs.
The Validation of the relational data datastores is green.
The validation of operations in Portal is also green.

But when we try and publish something to the relational data datastore, I get the following error in the logs.

<Msg time="2023-07-03T14:47:58,68" type="SEVERE" code="6563" source="Admin" process="2124" thread="1" methodName="" machine="HOSTNAME" user="" elapsed="" requestID="b5329cda-1553-4465-af04-60c117cc634e">Failed to create the service 'Hosted/Layer_1.FeatureServer'. null</Msg>
<Msg time="2023-07-03T14:47:58,68" type="DEBUG" code="9999" source="Admin" process="2124" thread="1" methodName="" machine="HOSTNAME" user="" elapsed="" requestID="b5329cda-1553-4465-af04-60c117cc634e">com.esri.sds.util.JavaSDSException

Creating a new tile cache in the datastore work, and we can also use the hosted tile cache services. So the error seems to be related to the relational data only.

Any thoughts on how I could troubleshoot more, or what might be the cause? I have attached the full error and Java crash from ArcGIS Server.

We installed the following patches last Friday.

https://support.esri.com/en-us/patches-updates/2023/arcgis-web-adaptor-iis-11-1-reliability-patch
https://support.esri.com/en-us/patches-updates/2023/arcgis-server-11-1-map-service-and-custom-data-feeds-patch
https://support.esri.com/en-us/patches-updates/2023/portal-for-arcgis-enterprise-sites-security-patch

ArcGIS Server 11.1.42869
ArcGIS Portal 11.1.42869
ArcGIS Datastore 11.1.42869
ArcGIS Webadaptor 11.1.42869
ArcGIS Webstyles 11.1.42869

Regards, Tony

Re: ArcGIS Datastore (relational data) stop working after latest patches

ArchitSrivastava — Tue, 11 Jul 2023 12:12:31 GMT

Hello @TonyAlfredsson_

Can you try to run "describedatastore" on ArcGIS DataStore machine by following the below documentation:

ArcGIS Data Store command utility reference—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

What I would request you to look for specifically is whether the relational data store is in READWRITE or READONLY mode list under Data Store mode in the results.

It could be READONLY, if yes, try the below to change it to READWRITE

ArcGIS Data Store command utility reference—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

Hopefully, that is the cause of this issue. If not, try publishing a normal service like referencing from registered enterprise database this would allow us to narrow down if it's just a concern with "Hosted Services" or publishing altogether and we can pick up from there.

Let me know how it goes.

Hope it helps!

Warm Regards

topic ArcGIS Datastore (relational data) stop working after latest patches in ArcGIS Enterprise Questions

ArcGIS Datastore (relational data) stop working after latest patches

Re: ArcGIS Datastore (relational data) stop working after latest patches