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

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0