SQL Server 2014 Master Data Services issue + [HttpWebRequest_WebException_RemoteServer] Arguments : NotFound Debugging resouce strings are unavailable and its solution

Hi All

when we restored the MDS database in sql server and configured the Master data services configuration manager  and all the settings went well . when we try to access the Master data services web service we are able to access the web service but when we click on any feature we are getting the
[HttpWebRequest_WebException_RemoteServer] Arguments : NotFound  Debugging resouce strings are unavailable  as shown below

then we try to browse the  MDS services

http://localhost/MDS/Service/Service.svc

we got the fallowing error

Server Error in '/MDS_PreProd' Application.

---

Memory gates checking failed because the free memory (5234458624 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InsufficientMemoryException: Memory gates checking failed because the free memory (5234458624 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InsufficientMemoryException: Memory gates checking failed because the free memory (5234458624 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.]    System.ServiceModel.Activation.ServiceMemoryGates.Check(Int32 minFreeMemoryPercentage, Boolean throwOnLowMemory, UInt64& availableMemoryBytes) +108307    System.ServiceModel.HostingManager.CheckMemoryCloseIdleServices(EventTraceActivity eventTraceActivity) +86    System.ServiceModel.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity) +883   [ServiceActivationException: The service '/MDS_PreProd/Service/Service.svc' cannot be activated due to an exception during compilation.  The exception message is: Memory gates checking failed because the free memory (5234458624 bytes) is less than 5% of total memory.  As a result, the service will not be available for incoming requests.  To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element..]    System.Runtime.AsyncResult.End(IAsyncResult result) +624474    System.ServiceModel.Activation.HostedHttpRequestAsyncResult.End(IAsyncResult result) +196075    System.Web.AsyncEventExecutionStep.OnAsyncEventCompletion(IAsyncResult ar) +166

From this we come to know the Application server is having  Physical memory access . due to less than 5 percent physically memory available IIS is not able to start . to solve this

we need to  kill the process which is taking most of the memory , so that  it  will release physically memory.

after  killing the process and check the MDS web app  then this issue is gone .

Hope this Post is helpful for you .

Thanks

Surendra Thota