DTS_E_PRIMEOUTPUTFAILED

This is a tricky and elusive error that is showing up now and then in a SSIS job. The full text of the error is, “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBC Source returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.”

A colleague pointed out this article, that came up thanks to the Google overlords. While it was wrote for Server 2003 it lead me down the rabbit hole where I found a few posts indicating TOE/Chimney can be a problem with Server 2008.

That lead me to this page coving TCP Chimney offload. The feature attempts to offload TCP connections to the network adapter and, according to at least one MS guy, can be a bit dodgy. I’m looking to see if that offloading is happening during the SSIS job. I’m using netstat, run from an elevated command prompt, to write the state of the active connections to a file every 60 seconds

netstat -t 60 > C:\temp\netstat.txt

Active Connections
Proto Local Address Foreign Address State Offload State
TCP 10.10.1.37:135 10.10.26.168:54637 ESTABLISHED InHost

Here’s hoping that something interesting is logged tonight that will help put a stop to DTS_E_PRIMEOUTPUTFAILED.

Update
It’s not a TCP Chimney offload problem which is too bad for a few reasons. One, it’s a new problem to me and I like to solve new problems rather than figuring out I made the same mistake again. Second and more important, the problem is still out there.

The logging for netstat -t showed no offloading to the NIC. What would have been better and faster would have been to run netsh int tcp show chimneystats

20150324-netsh int tcp show chimneystats

This not only shows me that nothing was offloaded, PMAX = 0, but offloading isn’t even supported, Supp = No. That would have saved me a bit of time if I had used this first. Didn’t solve anything, but I did learn something so it’s not a total waste.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s