Dynamics Community Forum Thread Details

Hi there, I need some help with trouble shooting an issue with a SANA (vesion 8.3) test portal accessing data via MS Dynamic AX 2012 R2 (version 4.1.2.3210).

The basic topology is:

SAN Test Web Server (SQL express 2012 / 2008, IIS 8, Win2k12r2) ==> Aif Server (Dynamic 2012 R2, Win2k8 R2 Std) ==> AOS server (Win2k8 R2 Std)

The servers are all in the same Domain.

Basic Trouble Shooting

I can ping SANA web server, Aif and AOS servers fine. And the ping test work from each server find.
Name resolution is working as expected.
The inbound and outbound ports are not being blocked. The test was telnet and openning the xppservices.svc from SANA Web page fine.
I can open the http://Aif_Server:xxxx/MicrosoftDynamicsAXAif60/SanaCommerce/xppservice.svc fine and hope to the
I can deploy the AIF port successfully
But I cannot pin point where the issue is with AIF error (AifrequestProcessor-processWcfRequest ) "Requested Company could not be determined" ?
Checked binding connection string from SANA Web to Aif server and they are working.
Checked the service accounts being used in connection string configuration. They are all present in AX and they are associated to the correct company ID.
I can see POST 500 errors from Aif server to SAN server. The ports are open between the server. Not sure how to troubleshoot this?

So the basic items are working like network, dns, and ports being open.

I need help with diagnosing fault and eliminating Aif & AOS as being an issue.

Error message from main web portal:

Server Error in '/' Application.

An error occurred.

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.ServiceModel.FaultException: An error occurred.

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:

[FaultException: An error occurred.]
   System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +14579646
   System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +622
   Sana.Commerce.Provider.AX.Interface.IAXDataServiceClient.ProcessRequest(AXDataServiceClientProcessRequestRequest request) +0
   Sana.Commerce.Provider.AX.Interface.AXWebServiceClient.ProcessRequest(String _request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXWebServiceClient.cs:443
   Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(String request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:75
   Sana.Commerce.Sdk.ExtendedAXConnection.SendRequest(String requestString) in d:\Development\Projects\ComfortGroup\Sana.Commerce.Sdk\Customization\NavisionConnection\ExtendedAXConnection.cs:20
   Sana.Commerce.Provider.Navision.NavisionConnectionBase.ProfileRequest(String request) in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\NavisionInterface\NavisionConnectionBase.cs:185
   Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(INavisionRequest request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:165

[AXException: An error occurred while communicating with AX.]
   Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(INavisionRequest request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:174
   Sana.Commerce.Provider.Navision.NavisionSanaProvider.SendRequest(INavisionRequest request) in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\Provider\NavisionSanaProvider.cs:135
   Sana.Commerce.Provider.Navision.NavisionSanaProvider.<BuildXmlHelper>b__2() in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\Provider\NavisionSanaProvider.cs:169
   Sana.Commerce.Web.Business.Utilities.Caching.WebCacheManager.FromCache(String cachekey, Int32 minutesToCache, Func`1 actionFunction, GetExpirationDate getExpirationDate, Boolean& fromCache) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Utilities\Caching\WebCacheManager.cs:440
   Sana.Commerce.Web.Business.Utilities.Caching.WebCacheManager.FromCache(String cachekey, Int32 minutesToCache, Func`1 actionFunction) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Utilities\Caching\WebCacheManager.cs:336
   Sana.Commerce.Provider.Navision.NavisionSanaProvider.BuildXmlHelper() in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\Provider\NavisionSanaProvider.cs:159
   Sana.Commerce.Provider.Navision.NavisionSanaProvider.get_XmlHelper() in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\Provider\NavisionSanaProvider.cs:40
   Sana.Commerce.Provider.Navision.NavisionSanaProvider.SendRequest(INavisionRequest request) in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\Provider\NavisionSanaProvider.cs:129
   Sana.Commerce.Provider.Navision.Common.NavisionCommonProvider.GetDefaultCurrency() in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\Provider\Common\NavisionCommonProvider.cs:182
   Sana.Commerce.Common.CommonManager`1.<GetDefaultCurrency>b__8() in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce\Business\Common\CommonManager.cs:93
   Sana.Commerce.Web.Business.Utilities.Caching.WebCacheManager.FromCache(String cachekey, Int32 minutesToCache, Func`1 actionFunction, GetExpirationDate getExpirationDate, Boolean& fromCache) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Utilities\Caching\WebCacheManager.cs:440
   Sana.Commerce.Web.Business.Utilities.Caching.WebCacheManager.FromCache(String cachekey, Int32 minutesToCache, Func`1 actionFunction) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Utilities\Caching\WebCacheManager.cs:336
   Sana.Commerce.Common.CommonManager`1.GetDefaultCurrency() in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce\Business\Common\CommonManager.cs:92
   Sana.Commerce.Web.Business.Http.Request.Handlers.RequestHandlerBase.InitializeCommerceContext() in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Http\Request\Handlers\RequestHandlerBase.cs:200
   Sana.Commerce.Web.Business.Http.Request.Handlers.DefaultRequestHandler.Handle(AcquireRequestStateEvent event) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Http\Request\Handlers\DefaultRequestHandler.cs:48
   Sana.Commerce.Web.Business.Http.Request.RequestManager.Publish(TEvent event) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Web\Business\Http\Request\RequestManager.cs:30
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.342

TraceLog From SANA Web server

imestamp: 05/16/2018 09:29:05
Message: An error occurred. SOURCE:mscorlib FORM: QUERYSTRING: returnurl=%2fhome Url: testauordering.comfortgroup.com/.../login;br/>TARGETSITE: Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage) STACKTRACE: 
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

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 Sana.Commerce.Provider.AX.Interface.IAXDataServiceClient.ProcessRequest(AXDataServiceClientProcessRequestRequest request)
at Sana.Commerce.Provider.AX.Interface.AXWebServiceClient.ProcessRequest(String _request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXWebServiceClient.cs:line 443
at Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(String request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:line 75
at Sana.Commerce.Sdk.ExtendedAXConnection.SendRequest(String requestString) in d:\Development\Projects\ComfortGroup\Sana.Commerce.Sdk\Customization\NavisionConnection\ExtendedAXConnection.cs:line 20
at Sana.Commerce.Provider.Navision.NavisionConnectionBase.ProfileRequest(String request) in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\NavisionInterface\NavisionConnectionBase.cs:line 185
at Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(INavisionRequest request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:line 165 MESSAGES:An error occurred while communicating with AX.
An error occurred.
Category: Error
Priority: 3
Machine: NZSANAT01
Extra data:
----------------------------------------
Timestamp: 05/16/2018 10:00:29
Message: An error occurred. SOURCE:mscorlib FORM: QUERYSTRING: Url: testsleepmakerauportal.comfortgroup.com/browserconfig.xml TARGETSITE: Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage) STACKTRACE: 
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Event Log error at the time when everything went wrong (we are not getting the below anymore):

Timestamp: 11/10/2017 04:16:24

Message: The requested service, 'http://server:port/MicrosoftDynamicsAXAif60/SanaCommerce/xppservice.svc' could not be activated. See the server's diagnostic trace logs for more information. SOURCE:mscorlib FORM: QUERYSTRING: Url: testflooringportal.comfortgroup.com/.../home TARGETSITE: Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage) STACKTRACE:

Server stack trace:

at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory`1 factory, WebException responseException, ChannelBinding channelBinding)

at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)

at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

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 Sana.Commerce.Provider.AX.Interface.IAXDataServiceClient.ProcessRequest(AXDataServiceClientProcessRequestRequest request)

at Sana.Commerce.Provider.AX.Interface.AXWebServiceClient.ProcessRequest(String _request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXWebServiceClient.cs:line 443

at Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(String request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:line 75

at Sana.Commerce.Sdk.ExtendedAXConnection.SendRequest(String requestString) in d:\Development\Projects\ComfortGroup\Sana.Commerce.Sdk\Customization\NavisionConnection\ExtendedAXConnection.cs:line 20

at Sana.Commerce.Provider.Navision.NavisionConnectionBase.ProfileRequest(String request) in c:\Builds\2\7\Sources\Framework\Sana.Commerce.Provider.Navision\NavisionInterface\NavisionConnectionBase.cs:line 185

at Sana.Commerce.Provider.AX.Interface.AXConnection.SendRequest(INavisionRequest request) in d:\development\vsts\Releases\8.3.1\Framework\Sana.Commerce.Provider.AX\Interface\AXConnection.cs:line 165 MESSAGES:An error occurred while communicating with AX.

The requested service, 'http://server:port/MicrosoftDynamicsAXAif60/SanaCommerce/xppservice.svc' could not be activated. See the server's diagnostic trace logs for more information.

Category: Error

Priority: 3

Machine: SAN Web Server

Extra data:

An error occurred.
Category: Error
Priority: 3

Machine: Server Name
Extra data:
----------------------------------------