SSIS: An OLE DB Error has occurred. error code 0x80004005, The peer prematurely closed the connection

1

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:

  1. SSIS: SQL Server 2016 version 13.0.5622.0 (OS 2016 Core Server)
  2. SSAS: SQL Server 2016 version 13.0.5102.14 (OS 2012 Server non-Core)

What we have tested so far:

  1. SSAS: When running SSAS Package directly - No Issues will Occur. Meaning, we remove doubts that concerns issues from SSAS
  2. SSIS:SQL Server 2016 version 13.0.5622.0 (OS 2012 Server non-Core) - When running the package under this server, issue will not occur.
  3. SSIS: SQL Server 2016 version 13.0.5622.0 (OS 2016 Core Server) - When running Package under this server, Issue will occur.
  4. from #3 - Updating Provider from MSOLAP.6 to MSOLAP.7 - Issue still occur.

Process:

  1. Create SSIS with Analysis Service Processing Task
  2. have connection string : Data Source=;Initial Catalog=;Provider=MSOLAP.7;Integrated Security=SSPI;Impersonation Level=Impersonate;
  3. Create SSAS Process : Any Process will do as long as it will run
  4. Run SSIS < Error will occur once SSIS executed

Has anybody encounter the same or the issue with similar like ours?

sql-server
ssis
ssas
asked on Stack Overflow Feb 28, 2020 by June Brian Salvado • edited Feb 28, 2020 by June Brian Salvado

1 Answer

0

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"

answered on Stack Overflow Jun 3, 2020 by Vamsy chiranjeevi • edited Jun 3, 2020 by Vamsy chiranjeevi

User contributions licensed under CC BY-SA 3.0