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:
- SSIS: SQL Server 2016 version 13.0.5622.0 (OS 2016 Core Server)
- SSAS: SQL Server 2016 version 13.0.5102.14 (OS 2012 Server non-Core)
What we have tested so far:
- SSAS: When running SSAS Package directly - No Issues will Occur. Meaning, we remove doubts that concerns issues from SSAS
- 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.
- SSIS: SQL Server 2016 version 13.0.5622.0 (OS 2016 Core Server) - When running Package under this server, Issue will occur.
- from #3 - Updating Provider from MSOLAP.6 to MSOLAP.7 - Issue still occur.
Process:
- Create SSIS with Analysis Service Processing Task
- have connection string : Data Source=;Initial Catalog=;Provider=MSOLAP.7;Integrated Security=SSPI;Impersonation Level=Impersonate;
- Create SSAS Process : Any Process will do as long as it will run
- Run SSIS < Error will occur once SSIS executed
Has anybody encounter the same or the issue with similar like ours?
2条答案
按热度按时间wj8zmpe11#
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"
8i9zcol22#
The problem is in 32BITS driver version. Use 64 bits driver and will work fine