The requested service, 'net.tcp://sql1/Epicor/Ice/Lib/SessionMod.svc' could not be activated

[b.huang (Ben Huang)]

Anyone can help this error when log in?

Application Error

Exception caught in: mscorlib

Error Detail

Message: The requested service, ‘net.tcp://sql1/Epicor/Ice/Lib/SessionMod.svc’ could not be activated. See the server’s diagnostic trace logs for more information.
Program: CommonLanguageRuntimeLibrary
Method: HandleReturnMessage

Client Stack Trace

Server stack trace:
at System.ServiceModel.Channels.ConnectionUpgradeHelper.DecodeFramingFault(ClientFramingDecoder decoder, IConnection connection, Uri via, String contentType, TimeoutHelper& timeoutHelper)
at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment1 preamble, TimeoutHelper& timeoutHelper) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper) at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.SecurityChannelFactory1.ClientSecurityChannel`1.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open()

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at System.ServiceModel.ICommunicationObject.Open()
at Epicor.ServiceModel.Channels.ChannelEntry1.CreateNewChannel() at Epicor.ServiceModel.Channels.ChannelEntry1.CreateChannel()
at Epicor.ServiceModel.Channels.ChannelEntry1.GetContract() at Epicor.ServiceModel.Channels.ImplBase1.GetChannel()
at Epicor.ServiceModel.Channels.ImplBase`1.HandleContractBeforeCall()
at Ice.Proxy.Lib.SessionModImpl.Login()
at Ice.Core.Session…ctor(String userID, String password, String asUrl, LicenseType licenseType, String pathToConfigurationFile, Boolean fwVerCheck, String companyID, String plantID)
at Ice.Core.Session…ctor(String userID, String password, LicenseType licenseType)
at IceShell.Apps.LogonDialog.logOn(String userID, String password, Boolean promptUpdatePassword)
at IceShell.Apps.LogonDialog.DoWorkLogon()

[Olga (Olga Klimova)]

go to sql1 server machine and look into Event viewer. There will be more detailed error about this.

[aidacra (Nathan your friendly neighborhood Support Engineer)]

Assuming this was working previously, from the Epicor Administration Console, right-click on the name of the appserver process you are trying to log into, and Recycle. Then, try to log into the client again.

[tkoch (Theodore Koch)]

I usually see this on our dev server if it is running low on memory, as @aidacra suggested recycling will fix it. I have also seen cases where SQL Report Services service will eat up a lot of memory and this service needs to be restarted. Also, it is a good idea in general to put a limit on the max amount of memory SQL can consume.

[aidacra (Nathan your friendly neighborhood Support Engineer)]

Agree completely.

KBs on how to do those things:

• KB0043949 Message: The requested service could not be activated. (talks about recycling the appserver, and if that doesn’t resolve it, how to grab the event viewer logs)
• KB0041536 Windows Event Viewer logs to troubleshoot client/server error (how to export the event viewer logs so that Support can review if a recycle doesn’t resolve it)
• KB0029125 Memory gates checking failed because the free memory (xxxx bytes) (if you see a low memory condition in the event viewer logs)
• KB0029307 SQL - Implement Epicor SQL server best practices TSQL script (how to limit SQL to change the max memory it can use, terms and conditions apply as some things within SQL don’t honor this)