最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

SQL 2014上的DIXF – 无法预览源文件 – CommunicationException – 从DMFServiceHelper.svc接收到HTTP响应时发生错误 / DIXF on SQL 2014 – Cannot Preview source file – CommunicationException – An error occurred while receiving the HTTP response from DMFServiceHelper.svc

网络文摘 William 113浏览 0评论
Consider a scenario where you are importing data using DIXF, and you get an error when you try to “Preview source file” and you are running SQL Server 2014 SP2 CU10 or CU11. 1. The error The error you see looks something like this: System.ServiceModel.CommunicationException: An error occurred while receiving the HTTP response to http://servernamehere:7000/DMFService/DMFServiceHelper.svc. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). We also see these sorts of events in the Windows Event Log: Event 1026 – .NET Runtime – Application: Microsoft.Dynamics.AX.DMF.SSISHelperService.exe – The process was terminated due to an unhandled exception – exception code 1 Event 1000 – Application Error – Faulting application name: Microsoft.Dynamics.AX.DMF.SSISHelperService.exe, version:6.3.6000.3667 – Faulting module name: KERNELBASE.dll, version: 6.3.9600.18202 2. Cause There is a SSIS issue in SQL Server 2104 SP2 CU10 for which a fix will ship in SP2 CU12. 3. Possible workarounds On AX side, the issue will repro only when “Create error file” is enabled in “Data import/export framework parameters“. Thus, as a workaround, users can un-check this option until the SSIS fix has shipped. Another option is to uninstall the SQL Server CU that is causing the issue and wait for CU12 to ship. Please implement this in TEST first, before rolling out in PROD, in line with your change management processes.
发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址