"_Main_XXXXX:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005."
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login timeout expired".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in login response".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: Timeout error . "."
Otherwise, the issue is not limited to SSIS or PowerBI reports only. Any application can hit performance issues and timeouts while connecting with SQL Server.
This fix introduces two new columns, error_code and op_history insys.dm_os_buffer_descriptors DMV. Error_code column represents the errorinformation during latest attempt to populate the buffer in question.Op_history column represents operational history of the buffer in bit format (4bit per operation, 16 operations total, last 4 bits represent the latestoperation and shift left as time progresses).
Note This fix does not resolve any specific errors that you see while populating the bufferpages. It only exposes information about error codes and operations on buffersso that additional troubleshooting can be performed with the new information.
This issue is fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server: