SSIS error Code DTS_E_OLEDERROR. An OLE DB Error has occurred. error code 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server 2016 Analysis Services.” Hresult: 0x80004005 Description: “An error was encountered in the transport layer.”. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server 2016 Analysis Services.” Hresult: 0x80004005 Description: “The peer prematurely closed the connection.”.
Issue encountered: When trying to run SSAS Cube from SSIS.
Following SQL server setup:
What we have tested so far:
Process:
Has anybody encounter the same or the issue with similar like ours?
I had the similar issue the only change being the OS is windows 2016 server non-core. Initially the Analysis Engine was running on SQL Server 2017 RTM Version. After applying the Latest Cumulative Update (CU20) the issue got resolved. May be it worked in my case hence thought of sharing so that it could help others.
Below are the details
OS: Windows 2016 Server non Core SQL Version: 2017 RTM
when executed the Package from the same server we got the below error "The Following System Occurred" .
However when executed remotely we got the error "The peer prematurely closed the connection"
User contributions licensed under CC BY-SA 3.0