Progress 9.1d SP 9 (Red Hat 2.1)
SQL Server 2005 (Windows Server 2003)
The task I take all of the records for various tables and dump them into a SQL database using SSIS. I have been doing this on multiple MFGPro dbs for almost 2 1/2 years now. About 4 months ago the job that replicates the ad_mstr for one of our MFGPro instances decided to stop working.
I have done the following:
1. recreated the SSIS job.
2. restarted the server.
3. recreated the SSIS job on a different server.
All of them still produce the same errors.
[DTS.Pipeline] Information: Execute phase is beginning.
[Source - Query [1]] Error: The component "Source - Query" (1) was unable to process the data.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (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.
[DTS.Pipeline] Error: 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.
[DTS.Pipeline] Error: 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.
[DTS.Pipeline] Error: 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.
[DTS.Pipeline] Information: Post Execute phase is beginning.
The strange thing is while in SSIS using the Import/Export Wizard, the query parses without a problem and I can pull the sample 100 rows. Could this be a data issue?
Thanks for the help!
SQL Server 2005 (Windows Server 2003)
The task I take all of the records for various tables and dump them into a SQL database using SSIS. I have been doing this on multiple MFGPro dbs for almost 2 1/2 years now. About 4 months ago the job that replicates the ad_mstr for one of our MFGPro instances decided to stop working.
I have done the following:
1. recreated the SSIS job.
2. restarted the server.
3. recreated the SSIS job on a different server.
All of them still produce the same errors.
[DTS.Pipeline] Information: Execute phase is beginning.
[Source - Query [1]] Error: The component "Source - Query" (1) was unable to process the data.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (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.
[DTS.Pipeline] Error: 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.
[DTS.Pipeline] Error: 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.
[DTS.Pipeline] Error: 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.
[DTS.Pipeline] Information: Post Execute phase is beginning.
The strange thing is while in SSIS using the Import/Export Wizard, the query parses without a problem and I can pull the sample 100 rows. Could this be a data issue?
Thanks for the help!
