Article - CS404395

"Oracle to SQL Server Database" migration tool shows errors when migrating StreamData table in Windchill PDMLink

Modified: 12-Dec-2023   


Applies To

  • Windchill PDMLink 11.0 to 11.2

Description

  • Windchill Oracle to SQL Server Database Migration Tool shows errors when migrating StreamData table :
[7] INFO  Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():327 - Moving data result:Success
[7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():332 - Error Encountered during data moving: 
[7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():333 -   ErrorCode     : -2147024784
 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():334 -   SubComponent  : 
[7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():329 -   Description   : 
[7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():332 - Error Encountered during data moving: 
[7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():333 -   ErrorCode     : -1071611290
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():334 -   SubComponent  : 
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():329 -   Description   : 
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():332 - Error Encountered during data moving: 
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():333 -   ErrorCode     : -1071611291
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():334 -   SubComponent  : ORA_StreamData [1]
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():329 -   Description   : Failed to retrieve long data for column "LOBLOC".

2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():332 - Error Encountered during data moving: 
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():333 -   ErrorCode     : -1071607780
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():334 -   SubComponent  : ORA_StreamData [1]
2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():329 -   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".

2023-11-01 02:25:30,606 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():332 - Error Encountered during data moving: 
2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():333 -   ErrorCode     : -1071607767
2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():334 -   SubComponent  : ORA_StreamData [1]
2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():329 -   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.

2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():332 - Error Encountered during data moving: 
2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():333 -   ErrorCode     : -1073450952
2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():334 -   SubComponent  : SSIS.Pipeline
2023-11-01 02:25:30,622 [7] ERROR Oracle_SQLServer_Dynamic_Mig.SSISPackage.execPackage():329 -   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.
 
  • In the o2smig__ssis_b_<batch number of streamdata table>.log, found below error message:
Rows sent to the error output(s) will be lost. Add new data flow transformations or destinations to receive error rows, or reconfigure the component to stop redirecting rows to the error output(s).
 
  • Already follow the suggestions in CS277363  to make sure enough space in disk and memory
This is a printer-friendly version of Article 404395 and may be out of date. For the latest version click CS404395