アーティクル - CS406057
JMX テーブルのサイズが大きいため、Oracle から SQL Server への移行前診断ユーティリティがループに陥り、Windchill でテーブルのチェックを実行中に停止します。
修正日: 13-Dec-2023
適用対象
- Windchill PDMLink 11.0
説明
- JMX テーブルのサイズが大きいため、Oracle から SQL Server への移行前診断ユーティリティがループに陥り、テーブルのチェックの実行で停止する
- o2s_pre_migration_check.log には以下のスタック トレースが表示されます。
[2023-11-18 10:41:31,150] [Timer-1] (PreMigrationCheck.java:371)Elapsed time (0:11:58:10) - Current running DataOutOfRange:...checking table RecentUpdate in FINDINVALIDNUMBERIC INFO [2023-11-18 10:41:31,151] [Timer-1] (PreMigrationCheck.java:412)--------------------------------------------------------------- INFO [2023-11-18 10:42:31,115] [Timer-1] (PreMigrationCheck.java:334)=============================================================== INFO [2023-11-18 10:42:31,149] [Timer-1] (PreMigrationCheck.java:371)Elapsed time (0:11:59:10) - Current running DataOutOfRange:...checking table RecentUpdate in FINDINVALIDNUMBERIC INFO [2023-11-18 10:42:31,150] [Timer-1] (PreMigrationCheck.java:412)--------------------------------------------------------------- INFO [2023-11-18 10:43:31,116] [Timer-1] (PreMigrationCheck.java:334)=============================================================== INFO [2023-11-18 10:43:31,150] [Timer-1] (PreMigrationCheck.java:371)Elapsed time (0:12:0:10) - Current running DataOutOfRange:...checking table RecentUpdate in FINDINVALIDNUMBERIC INFO [2023-11-18 10:43:31,151] [Timer-1] (PreMigrationCheck.java:412)--------------------------------------------------------------- INFO [2023-11-18 10:44:31,116] [Timer-1] (PreMigrationCheck.java:334)=============================================================== INFO [2023-11-18 10:44:31,200] [Timer-1] (PreMigrationCheck.java:371)Elapsed time (0:12:1:10) - Current running DataOutOfRange:...checking table RecentUpdate in FINDINVALIDNUMBERIC INFO [2023-11-18 10:44:31,202] [Timer-1] (PreMigrationCheck.java:412)--------------------------------------------------------------- INFO [2023-11-18 10:45:31,117] [Timer-1] (PreMigrationCheck.java:334)=============================================================== INFO [2023-11-18 10:45:31,152] [Timer-1] (PreMigrationCheck.java:371)Elapsed time (0:12:2:10) - Current running DataOutOfRange:...checking table RecentUpdate in FINDINVALIDNUMBERIC INFO [2023-11-18 10:45:31,153] [Timer-1] (PreMigrationCheck.java:412)--------------------------------------------------------------- INFO [2023-11-18 10:46:31,117] [Timer-1] (PreMigrationCheck.java:334)=============================================================== INFO [2023-11-18 10:46:31,164] [Timer-1] (PreMigrationCheck.java:371)Elapsed time (0:12:3:10) - Current running DataOutOfRange:...checking table RecentUpdate in FINDINVALIDNUMBERIC INFO [2023-11-18 10:46:31,166] [Timer-1] (PreMigrationCheck.java:412)---------------------------------------------------------------
- テーブルo2s_diag_logにいくつかのエラー メッセージがあります。
SELECT ROWID, HeapMemoryUsage, NonHeapMemoryUsage, Uptime, ProcessCpuTime, JITCTime, GCTime_1, GCTime_2, GCCount_1, GCCount_2, Classes, Threads, TotalStartedThreadCount, TotalActiveUserCount FROM SMHealthStats WHERE LENGTH(LTRIM(REGEXP_REPLACE(ABS(HeapMemoryUsage), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(NonHeapMemoryUsage), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(Uptime), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(ProcessCpuTime), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(JITCTime), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(GCTime_1), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(GCTime_2), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(GCCount_1), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(GCCount_2), '[.]',''),'0')) >19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(Classes), '[.]',''),'0')) >10 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(Threads), '[.]',''),'0')) >10 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(TotalStartedThreadCount), '[.]',''),'0'))>19 OR LENGTH(LTRIM(REGEXP_REPLACE(ABS(TotalActiveUserCount), '[.]',''),'0')) >10;
最新バージョンはこちらを参照ください CS406057