アーティクル - CS404395
Windchill PDMLink で StreamData テーブルを移行するときに、「Oracle to SQL Server Database」移行ツールでエラーが表示される
修正日: 12-Dec-2023
適用対象
- Windchill PDMLink 11.0 to 11.2
説明
- Windchill Oracle to SQL Server Database Migration Tool は、 StreamDataテーブルの移行時にエラーを表示します。
[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.
- o2smig__ssis_b_<ストリームデータ テーブルのバッチ番号>.logに、次のエラー メッセージが見つかります。
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).
- すでにCS277363の提案に従って、ディスクとメモリに十分なスペースを確保してください。
最新バージョンはこちらを参照ください CS404395