What does this error mean?

  • When I manually run my SSIS package, I get the following error output in the Debug Output:

    Error: 0xC0047062 at Data Flow Task, agtprof [3495]: System.NullReferenceException: Object reference not set to an instance of an object.

    at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)

    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket)

    Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "agtprof" (3495) returned error code 0x80004003. 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.

    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread1" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.

    Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

    Information: 0x402090DF at Data Flow Task, IEXAGTPROF [3691]: The final commit for the data insertion has started.

    Information: 0x402090E0 at Data Flow Task, IEXAGTPROF [3691]: The final commit for the data insertion has ended.

    Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread1" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

    Error: 0xC02090F5 at Data Flow Task, agtdata [3909]: The component "agtdata" (3909) was unable to process the data.

    Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "agtdata" (3909) returned error code 0xC02090F5. 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.

    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.

    The error messages are very vague. Any ideas?


    Live to Throw
    Throw to Live
    Will Summers

  • there seems to be some issue with a null reference in your data reader source. is any part of this handled dynamically at run time?

    tom

    Life: it twists and turns like a twisty turny thing

  • None of it is at runtime. I actually fixed this error this morning by deleting the object and recreating the transfer. Thanks for the reply.


    Live to Throw
    Throw to Live
    Will Summers

  • I'm curious what you deleted. I'm trying to move about a 300 Gig table from Oracle into my SQL Server 2005 data warehouse and get the same error after about 250 million rows.

    So far we've tried:

    Changing from an ODBC connection to a .Net connection, and now we're looking at an ado.net.

    I'm looking for any input on the problem. Even if it's just comiseration over a shared experience. If there are enough of those perhaps it's something MS can weigh in on?

  • I think the problem I originally had was that I had copied this project to connect to a different database. I think it still had some kind of link to the old connection. I basically just recreated the object path that had the error and it worked fine.


    Live to Throw
    Throw to Live
    Will Summers

  • Bob,

    Did you find some resolution to this error?

    i am getting a similar one:

    Code: 0xC02090F5

    Source: DATAFLOW TASK NAME DataReader Source [4459]

    Description: The component "DataReader Source 1" (4459) was unable to process the data.

    I do not get this error at the same object everyday. the object that failed with this error yesterday would work fine today. but then, there will be some other module that would fail with this error.

    Please help me.

  • Will Summers (10/2/2008)


    None of it is at runtime. I actually fixed this error this morning by deleting the object and recreating the transfer. Thanks for the reply.

    I just deleted and recreated the object that was generating the error and it has worked fine since then.


    Live to Throw
    Throw to Live
    Will Summers

  • I changed the connetion type from an ADO.Net connection and cleared off a larger volumn for the query cache and it got further but so far we've not gotten all 700 million rows. At this point I'm going to go for smaller chuncks and just deal with it. But the strait answer is no it didn't really get resolved.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply