Chris
2009-02-17 21:28:12 UTC
Hopefully someone can help me with this. I have an SSIS package that
runs great in all my environments. However, this package recently
stopped working in my production environment. If I export the package
to any other environment it runs great. In prod, the error below
shows up and it will not run. Does anyone have any idea what the
problem is? This is a clustered environment while the others are
not. Any insight would be great. The main purpose of this package is
to take data from an AS400 and bring into a SQL DB.
Thanks for any help!
Error: 0xC0209029 at ItemMsgs, ITEMMSGSN2 [1]: SSIS Error Code
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component
"ITEMMSGSN2" (1)" failed because error code 0x80004003 occurred, and
the error row disposition on "output column "MSGCODE" (28)" specifies
failure on error. An error occurred on the specified object of the
specified component. There may be error messages posted before this
with more information about the failure.
Error: 0xC0209029 at ItemMast, ITEMMASTN2 [173]: SSIS Error Code
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component
"ITEMMASTN2" (173)" failed because error code 0x80004003 occurred, and
the error row disposition on "output column "DESCR" (1082)" specifies
failure on error. An error occurred on the specified object of the
specified component. There may be error messages posted before this
with more information about the failure.
Error: 0xC02090F5 at ItemMast, ITEMMASTN2 [173]: The component
"ITEMMASTN2" (173) was unable to process the data.
Error: 0xC02090F5 at ItemMsgs, ITEMMSGSN2 [1]: The component
"ITEMMSGSN2" (1) was unable to process the data.
Error: 0xC0047038 at ItemMast, DTS.Pipeline: SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component
"ITEMMASTN2" (173) 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: 0xC0047038 at ItemMsgs, DTS.Pipeline: SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component
"ITEMMSGSN2" (1) 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 ItemMsgs, 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.
Error: 0xC0047021 at ItemMast, 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.
Error: 0xC0047039 at ItemMast, 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: 0xC0047039 at ItemMsgs, 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 ItemMast, 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.
Error: 0xC0047021 at ItemMsgs, 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.
runs great in all my environments. However, this package recently
stopped working in my production environment. If I export the package
to any other environment it runs great. In prod, the error below
shows up and it will not run. Does anyone have any idea what the
problem is? This is a clustered environment while the others are
not. Any insight would be great. The main purpose of this package is
to take data from an AS400 and bring into a SQL DB.
Thanks for any help!
Error: 0xC0209029 at ItemMsgs, ITEMMSGSN2 [1]: SSIS Error Code
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component
"ITEMMSGSN2" (1)" failed because error code 0x80004003 occurred, and
the error row disposition on "output column "MSGCODE" (28)" specifies
failure on error. An error occurred on the specified object of the
specified component. There may be error messages posted before this
with more information about the failure.
Error: 0xC0209029 at ItemMast, ITEMMASTN2 [173]: SSIS Error Code
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component
"ITEMMASTN2" (173)" failed because error code 0x80004003 occurred, and
the error row disposition on "output column "DESCR" (1082)" specifies
failure on error. An error occurred on the specified object of the
specified component. There may be error messages posted before this
with more information about the failure.
Error: 0xC02090F5 at ItemMast, ITEMMASTN2 [173]: The component
"ITEMMASTN2" (173) was unable to process the data.
Error: 0xC02090F5 at ItemMsgs, ITEMMSGSN2 [1]: The component
"ITEMMSGSN2" (1) was unable to process the data.
Error: 0xC0047038 at ItemMast, DTS.Pipeline: SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component
"ITEMMASTN2" (173) 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: 0xC0047038 at ItemMsgs, DTS.Pipeline: SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component
"ITEMMSGSN2" (1) 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 ItemMsgs, 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.
Error: 0xC0047021 at ItemMast, 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.
Error: 0xC0047039 at ItemMast, 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: 0xC0047039 at ItemMsgs, 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 ItemMast, 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.
Error: 0xC0047021 at ItemMsgs, 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.