locked
cannot connect to MDS using add in for excel RRS feed

  • Question

  • I can browse the Master Data Manager at http://mytest:8080/default.aspx. I have created a new Model with Entities and Attributes and want to import data.

    When I create a new Master Data service connection on Excel and hit test, I get this error:

    "There was no endpoint listening at http://mytest:8080/service/service.svc/bhb that could accept the message. This is often caused by incorrect address or SOAP action. See InnerException, if present, for more details (mscorlib)"

    Any help is highly appreciated.

    Here is the log:

    2017-02-24T09:41:14.915       15792 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: MDS Excel plugin started successfully. Assembly version: 12.0.0.0, File version: 12.0.4417.0 ((SQL14_SP1_QFE-CU).150622-1239)
    2017-02-24T09:42:18.061       28600 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: Received EndpointNotFoundException. Showing custom error that it might be wrongly typed URL or old server. Exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://mytest:8080/service/service.svc/bhb that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: The remote server returned an error: (404) Not Found.
       at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
       --- End of inner exception stack trace ---

    Server stack trace: 
       at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(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 Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndServiceVersionGet(IAsyncResult result)
       at Microsoft.MasterDataServices.ExcelAddInCore.MDSServiceClient.EndServiceVersionGet(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Types.Operations.ServiceVersionGetOperation.EndOperation(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Operations.OperationExecuter.<>c__DisplayClassc.<ExecuteOperationAsync>b__b()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at System.Threading.Tasks.Task.Execute()
    2017-02-24T09:42:18.780       15792 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: ExceptionMessageBoxShown@The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.
    2017-02-24T09:42:48.956       29476 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: Received protocol exception. Signaling it is a server too old. Exception: System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '


    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">


        <head><title>
    Master Data Manager
    </title><link href="../../../Site.css" rel="stylesheet" type="text/css" /><meta http-equiv="Page-Enter" content="revealTrans(Duration=0,Transition=5)" /><meta http-equiv="Page-Exit" content="blendTrans(Duration=0)" />
        
    </head>
        <body id="ctl00_ctl00_bodyMain" bgcolor="white" onbeforeunload="UnloadPage(event);">
            <form name="aspnetForm" method="post" action="./bhb" id="aspnetForm">
    <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKMjEzOTQ3MDU2NA9kFgJmD2QWAmYPDxYCHghEdW1teUtleQUBMGQWAgIDD2QWAgIBD2QWAgIDD2QWBAIBDw8WBh4IRW50aXR5SWRmHgdNb2RlbElkAgQeCVZlcnNpb25JZAIDZBYEAgYPZBYCZg9kFgICAQ9kFgQCAQ8PFgIeBFRleHQFA3NubGRkAgUPD2QWBB4Lb25tb3VzZW92ZXIFKXRoaXMuc3JjPScvSW1hZ2VzL2hlbHBfY29udGV4dF9vdmVyLnBuZyc7Hgpvbm1vdXNlb3V0BSR0aGlzLnNyYz0nL0ltYWdlcy9oZWxwX2NvbnRleHQucG'.

    Server stack trace: 
       at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(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 Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndServiceVersionGet(IAsyncResult result)
       at Microsoft.MasterDataServices.ExcelAddInCore.MDSServiceClient.EndServiceVersionGet(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Types.Operations.ServiceVersionGetOperation.EndOperation(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Operations.OperationExecuter.<>c__DisplayClassc.<ExecuteOperationAsync>b__b()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at System.Threading.Tasks.Task.Execute()
    2017-02-24T09:42:49.112       15792 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: ExceptionMessageBoxShown@The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.
    2017-02-24T09:47:01.501       30180 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: Received EndpointNotFoundException. Showing custom error that it might be wrongly typed URL or old server. Exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://mytest:8080/service/service.svc/bhb that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: The remote server returned an error: (404) Not Found.
       at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
       --- End of inner exception stack trace ---

    Server stack trace: 
       at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(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 Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndServiceVersionGet(IAsyncResult result)
       at Microsoft.MasterDataServices.ExcelAddInCore.MDSServiceClient.EndServiceVersionGet(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Types.Operations.ServiceVersionGetOperation.EndOperation(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Operations.OperationExecuter.<>c__DisplayClassc.<ExecuteOperationAsync>b__b()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at System.Threading.Tasks.Task.Execute()
    2017-02-24T09:47:02.079       15792 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: ExceptionMessageBoxShown@The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.
    2017-02-24T09:51:11.159       25964 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: Received EndpointNotFoundException. Showing custom error that it might be wrongly typed URL or old server. Exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://mytest:8080/service/service.svc/bhb that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: The remote server returned an error: (404) Not Found.
       at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
       at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
       --- End of inner exception stack trace ---

    Server stack trace: 
       at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
       at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(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 Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndServiceVersionGet(IAsyncResult result)
       at Microsoft.MasterDataServices.ExcelAddInCore.MDSServiceClient.EndServiceVersionGet(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Types.Operations.ServiceVersionGetOperation.EndOperation(IAsyncResult ar)
       at Microsoft.MasterDataServices.ExcelAddInCore.Operations.OperationExecuter.<>c__DisplayClassc.<ExecuteOperationAsync>b__b()
       at System.Threading.Tasks.Task`1.InnerInvoke()
       at System.Threading.Tasks.Task.Execute()
    2017-02-24T09:51:11.768       15792 EXCEL.EXE                      EXCEL.EXE                                Generic          EventType: Error, Message: ExceptionMessageBoxShown@The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.

    Friday, February 24, 2017 3:20 PM

All replies

  • Hello,

    Refer following link

    https://social.technet.microsoft.com/wiki/contents/articles/4520.troubleshooting-the-master-data-services-add-in-for-excel.aspx


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Tuesday, March 28, 2017 4:29 AM
    Answerer