Select to view content in your preferred language

ArcGIS Datastore (relational data) stop working after latest patches

447
1
07-03-2023 07:52 AM
TonyAlfredsson_
New Contributor

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-f...
https://support.esri.com/en-us/patches-updates/2023/portal-for-arcgis-enterprise-sites-security-patc...

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

1 Reply
ArchitSrivastava
Occasional Contributor II

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

0 Kudos