Well we've been on Azure for about 18 months now and I'm still fighting DBMS errors. Our current setup is Server 10.3.1 on a D3 VM instance with our database in an S3 Azure SQL instance. We have ~15 or so Feature Services that are being used to edit attributes (no geometry manipulation or creation) using custom built javascript webapps. At various times we end up with the following DBMS errors:
Service instance activation failed in 'XXX/XXX.MapServer'. AutomationException: 0x80004005 - Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host. ] [dbo.DEFAULT] in 'esriDataSourcesGDB.SdeWorkspace.1' |
or
Error: Underlying DBMS error [HY009:[Microsoft][ODBC Driver Manager] Invalid argument value] [XXX]. |
Whenever these errors occur, the ONLY solution is to restart the service manually.
I've fiddled with the service settings and a typical setup is:
- Min 0 and Max 5 processes in high isolation
- Recycle every 24 hours
- Periodically check and repair data connections for idle instances every 10 minutes
- Max. time an idle instance can be kept running: 600 seconds
Additionally, we also get other errors that I'm not sure are directly related to the above or not since they don't seem to occur at the same times. I've emailed some of these reports to Esri but without any feedback:
Failed to initialize server object 'XXX/XXX': 0x80004005: Unspecified error |
which then leads to
Instance of the service 'XXX' crashed. Please see if an error report was generated in 'C:\arcgisserver\logs\XXX\errorreports'. To send an error report to Esri, compose an e-mail to ArcGISErrorReport@esri.com and attach the error report file. |
If anybody has any suggestions here, I'd really appreciate it. It's gotten so bad that we've spun up an AWS instance to start testing things out there but I really don't want to move 18 months of data and probably 50 million records to a whole different platform unless there's just no alternative.
.png "KathleenWallis"){kind=avatar}
