1. Home
  2. Support
Article - CS277363

"Oracle to SQL Server Database" migration tool shows errors in StreamData table

Modified: 25-May-2018   


Applies To

  • Windchill PDMLink 11.0

Description

  • Oracle to SQL Server Database (O2S) migration tool shows errors in StreamData table
  • Errors below are displayed in O2S_Migration.log :
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():299 - Error Encountered during data moving: 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():300 -   ErrorCode     : -2147024784
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():301 -   SubComponent  : 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():296 -   Description   : 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():299 - Error Encountered during data moving: 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():300 -   ErrorCode     : -1071611290
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():301 -   SubComponent  : 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():296 -   Description   : 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():299 - Error Encountered during data moving: 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():300 -   ErrorCode     : -1071611291
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():301 -   SubComponent  : ORA_StreamData [1]
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():296 -   Description   : Failed to retrieve long data for column "LOBLOC".

ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():299 - Error Encountered during data moving: 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():300 -   ErrorCode     : -1071607780
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():301 -   SubComponent  : ORA_StreamData [1]
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():296 -   Description   : There was an error with ORA_StreamData.Outputs[OLE DB Source Output].Columns[LOBLOC] on ORA_StreamData.Outputs[OLE DB Source Output]. The column status returned was: "DBSTATUS_UNAVAILABLE".

ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():299 - Error Encountered during data moving: 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():300 -   ErrorCode     : -1071607767
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():301 -   SubComponent  : ORA_StreamData [1]
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():296 -   Description   : SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "ORA_StreamData.Outputs[OLE DB Source Output].Columns[LOBLOC]" failed because error code 0xC0209071 occurred, and the error row disposition on "ORA_StreamData.Outputs[OLE DB Source Output].Columns[LOBLOC]" 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 Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():299 - Error Encountered during data moving: 
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():300 -   ErrorCode     : -1073450952
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():301 -   SubComponent  : SSIS.Pipeline
ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():296 -   Description   : SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on ORA_StreamData returned error code 0xC0209029.  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.
This is a printer-friendly version of Article 277363 and may be out of date. For the latest version click CS277363