1. 主页
  2. 支持
技术文章 - CS404395

在 Windchill PDMLink 中迁移 StreamData 表时，“Oracle 到 SQL Server 数据库”迁移工具显示错误

已修改: 12-Dec-2023   


注意：本文已使用机器翻译软件翻译，以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意， PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情，请单击 此处 。
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • Windchill PDMLink 11.0 to 11.2

说明

  • Windchill Oracle 到 SQL Server 数据库迁移工具在迁移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中的建议确保磁盘和内存中有足够的空间
这是文章 404395 的 PDF 版本，可能已过期。最新版本 CS404395