0 Replies Latest reply: Oct 24, 2013 8:39 AM by 887829 RSS

    ORA-12571 error when DTS run




      When DTS is run in scheduled time it fails with following error at step 3 after fetching certain records from Oracle giving below error, After failure  when manually run from same client it executes successfully.

      Error Message

      Executed as user: \sqlclust. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  12:35:19 AM  Error: 2013-10-23 01:03:13.75     Code: 0xC0202009     Source: DFT_ PKG_CALL_WRAP_FS OLE_SRC_Call_Wrap_FS [1293]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Oracle"  Hresult: 0x80004005  Description: "ORA-12571: TNS:packet writer failure  ".  End Error  Error: 2013-10-23 01:03:13.75     Code: 0xC0047038     Source: DFT_ TEST_CALL_WRAP_FS SSIS.Pipeline     Description: SSIS Error Code DTS_E_MAINOUTPUTFAILED.  The MainOutput method on component "OLE_SRC_Call_Wrap_FS" (1293) returned error code 0xC0202009.  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.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  12:35:19 AM  Finished: 1:04:30 AM  Elapsed:  1751.7 seconds.  The package execution failed.  The step failed.