Follow

Intermittent SSIS failure in execution

Symptoms:

Execution packages fail intermittently and produce different errors.

Error message:

Messages may include:

Package load failed for package: <Package Name>
Inner Exception
Unspecified Error
Error during execution of package for 
SSIS Package: <Package Name>
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: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.".

Failed to open a fastload rowset for "[dbo].[<Raw Table Name>]". Check that the object exists in the database.

Staging failed the pre-execute phase and returned error code 0xC0202040.
Error during execution of package for 
SSIS Package: AX_dbo_SMASERVICEORDERLINE_89eacedb-81bb-4c21-a2a0-5df1b0d8f2a0
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: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.".
Failed to open a fastload rowset for "[dbo].[<Raw Table Name>]". Check that the object exists in the database.

Underlying Cause:

This can be the result of network problems, including firewall settings that prevent TX DWA from retrieving SSIS packages or contacting the necessary database. 

Solution:

Review your firewall settings and ensure that TX DWA has the necessary permissions.  If your application server and database server are on different subnets, moving them to the same subnet may resolve this problem. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.