topic Re: "Failure to access the DBMS server" with feature service in ArcGIS Enterprise Questions

"Failure to access the DBMS server" with feature service

RomanChueh — Wed, 13 Jan 2016 08:27:34 GMT

On one server I have ArcSDE running in SQL Server 2012 (SP2), and another server I have ArcGIS 10.3.1 Server hosting a feature service that access the ArcSDE database. The feature service runs fine until I see the following error message in the ArcGIS Server log:

Error: 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.

And then the following error message on every feature service request:

Error: Failure to access the DBMS server [[Microsoft][SQL Server Native Client 11.0]Communication link failure]

It seems database connection was temporary disconnected, and the only solution is to restart the service manually.

My question is: Why wouldn't the Feature Service reconnect with ArcSDE? Is there anyway around this beside restart the service manually?

Thanks,

Roman

Re: "Failure to access the DBMS server" with feature service

XanderBakker — Wed, 13 Jan 2016 11:39:03 GMT

Is there some time-out configured at the database side? What kind of tuning or configuration are you using for the service? Does it just happen to one specific service or to all services pointing to data in that database?

Re: "Failure to access the DBMS server" with feature service

RebeccaStrauch__GISP — Wed, 13 Jan 2016 16:59:41 GMT

When looking for the data download on MyEsri, I noticed the Native Clients for SQL Server 2012. Do you have that installed? It's found under the "Additional Products" section as shown in the second graphic (sorry for the poor graphic quality).

Re: "Failure to access the DBMS server" with feature service

RomanChueh — Wed, 13 Jan 2016 18:10:51 GMT

Yes, I have installed Microsoft SQL Server 2012 Native Client (64-bit) on the ArcGIS Server.

Re: "Failure to access the DBMS server" with feature service

RomanChueh — Wed, 13 Jan 2016 18:57:03 GMT

I don't have any time-out configured at the database side. It's a fresh install of SQL Server 2012 running on Windows Server 2012 R2, and Windows firewall is disabled.

The service contains a layer linked to a SDE feature class in the ArcSDE database. Other than having "Feature Access" capabilities checked, all other configurations are set to their default values. And, I only have this service on the ArcGIS Server.

I can simulate the problem by disconnecting network on the ArcGIS server for about 30 seconds, and then reconnect the network. The service does not recover from the network failure, and required a restart to get it back working. Shouldn't the service able to reconnect with ArcSDE after the network is restored?

Re: "Failure to access the DBMS server" with feature service

MichaelRobb — Wed, 13 Jan 2016 21:06:23 GMT

Hello!

Your question:

Why wouldn't the Feature Service reconnect with ArcSDE? The service would/should when the default time of 30 minutes is reached for that MappingService (FeatureAccess as well in this case) - as long as the database is reachable of course.

Is there anyway around this beside restart the service manually? In ArcGIS Server Manager or Catalog (as an admin .ags connection) you can adjust the check repair data connection instances to which ever time you'd like.

ArcGIS Service >> Processes >>

Re: "Failure to access the DBMS server" with feature service

RomanChueh — Thu, 14 Jan 2016 00:28:43 GMT

I have the option of "Periodically check and repair data connection for idle instances" checked, and I changed the time to 2 minutes instead of 30 minutes.

I am still having the same problem. I believe it's because the service never go to Idle when my application is running. The application consumes the Web Map that refresh the feature service every 30 seconds.

Re: "Failure to access the DBMS server" with feature service

MichaelRobb — Thu, 14 Jan 2016 02:24:08 GMT

You have a deeper underlying issue then. IT Network driven issue or perhaps configuration issues. If you are saying there is constant connection without issue, then random communication link failure.. it start to look at performance matrix on the SQL machine and network between ArcGIS Server and the SQL database.

Re: "Failure to access the DBMS server" with feature service

RomanChueh — Thu, 14 Jan 2016 19:16:30 GMT

Thank you for the advises, Michael.

I will looking info the network and SQL configuration. This problem seems to present itself when the database server or ArcGIS server is under heavy load. For example, backing up of the Geodatabase or copying large file between servers.

Re: "Failure to access the DBMS server" with feature service

ChadKopplin — Thu, 14 Jan 2016 19:32:49 GMT

Do you have access to the sde database through SQL management studio installed on your computer? If you are not able to log into the database through SQL management studio, then there is probably an issue with the server access to the sql db.

Re: "Failure to access the DBMS server" with feature service

RomanChueh — Thu, 14 Jan 2016 19:44:05 GMT

I don't have SQL Management Studio install on the ArcGIS server, so I was able to test the database connection using it. However, from ArcGIS Server Manager, I was able to validate the registered database in the data store while the error is happening.

Re: "Failure to access the DBMS server" with feature service

MichaelRobb — Thu, 14 Jan 2016 22:03:52 GMT

There of course, many possibles at this point. But it doesn't sound ArcGIS Server specific. Could be Volume Snaps VM ? Could be like you say.. the hardware limitations are taking out the connections.

I'd be curious to what you discover.

Re: "Failure to access the DBMS server" with feature service

PaulHuffman — Fri, 01 Apr 2016 18:04:23 GMT

Where did you find that download page? I'm trying to find that version of SQL native client this morning.

Re: "Failure to access the DBMS server" with feature service

MichaelRobb — Fri, 01 Apr 2016 19:36:00 GMT

go to and sign into: https://my.esri.com/#/

my organizations >> Downloads >> Downloads >> Arcgis for Server Enterprise >> Additional Products

Re: "Failure to access the DBMS server" with feature service

PaulHuffman — Fri, 01 Apr 2016 21:27:07 GMT

Thanks, but it didn't work for me. I have a real small list of downloads at my own My ESRI because I generally get downloads from the OTSGS, and it looks like they changed their passwords. But now I see how that's supposed to work. That's the way my morning has gone. Everything I have tried to do has been blocked by passwords and insufficient permissions. Folks in the next office thought I was having a fight with someone what with all the cussing and yelling.

Re: "Failure to access the DBMS server" with feature service

RebeccaStrauch__GISP — Fri, 01 Apr 2016 21:45:43 GMT

Paul Huffman

I do not think they are esri specific (although I might be wrong), but zipped and attached. both 32 and 64 for SQL2012. Is that what you were looking for?

Re: "Failure to access the DBMS server" with feature service

MichaelRobb — Fri, 01 Apr 2016 22:36:16 GMT

You need Enterprise ArcGIS Server subscription to see those specific downloads.

Rebecca beat me to it... these are Microsoft Products anyways. (they are NOT ESRI specific) and one would get them from MSDN.

Re: "Failure to access the DBMS server" with feature service

PaulHuffman — Fri, 01 Apr 2016 22:43:30 GMT

Hey, thanks! But it gave me the same error message as the one I found. I thought I had the wrong one. Using the 64 bit version, I got "SQL Server 2012 Native Client Setup Interrupted". The 32 bit one doesn't even get started, so that's more evidence I have the correct one. I don't understand what my problem is. I've installed this twice on other machines this week, and a bunch more last month. Is it already installed? Don't see it in services. Should I see it in data sources if it were installed?

I must have already installed it because when I tried Create Enterprise Geodatabase, I got simply "Failure to access the DBMS server", and nothing about the SQL Server Client being wrong or missing.

Re: "Failure to access the DBMS server" with feature service

ShuhongYan — Fri, 17 Feb 2017 18:53:52 GMT

Hi Roman,

I met with the same problem too. ApplyEdits for a feature service fails randomly and the Server logs wrote when it fails:

"Error: Failure to access the DBMS server [[Microsoft][ODBC Driver 11 for SQL Server]Communication link failure] [sde.DEFAULT]."

Did you find the solution eventually?

Thanks,

Shuhong

Re: "Failure to access the DBMS server" with feature service

RomanChueh — Sat, 18 Feb 2017 12:23:22 GMT

Hi Shuhong,

No, I have not. I setup a python to monitor the ArcGIS server log, and notify me when these error occurs. Then, I restart the map service.