アーティクル - CS404395

Windchill PDMLink で StreamData テーブルを移行するときに、「Oracle to SQL Server Database」移行ツールでエラーが表示される

修正日: 12-Dec-2023   


注記:ここに記載されている情報は、お客様の利便性向上のため機械翻訳ソフトを使用しています。PTCは、ここに記載されている情報の翻訳の正確性について、一切の責任を負いませんので、ご了承ください。英語の原文を参照するには、こちら。この機械翻訳に関する詳細は、こちら。
お知らせいただき、ありがとうございます。この機械翻訳をレビューします。

適用対象

  • 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