Suddenly we are having trouble with our Relational Datastore on ArcGIS Enterprise 10.5..
- If you validate the Hosting server in Portal you receive "failed to validate the server managed database".
- If you validate the Relational DataStore in ArcGIS Server it fails.
- If you go to validate the DataStore in arcgis/admin then it all seems to be valid and ready for requests.
- If we restart the servers (ArcGIS and Portal) then the issue is temporarily resolved - the DataStore and Hosting server are valid. You can successfully publish hosted layers. After a while it goes wrong again.
Looking in the ArcGIS Server Manager logs we can see messages such as :
Service containing process crashed for 'MyService.MapServer'. Please see if an error report was generated in 'C:\arcgisserver\logs\SERVERNAME\errorreports'. To send an error report to Esri, compose an e-mail to ArcGISErrorReport@esri.com and attach the error report file.
Any ideas? Could it be a hosted layer in the DataStore which is causing the problem?
Any help would be great.