由于 JMX 表尺寸较大，Oracle 到 SQL Server 的预迁移诊断实用程序会陷入循环并卡在 Windchill 中运行检查表中

• Oracle 到 SQL Server 的预迁移诊断实用程序遇到循环，并且由于 JMX 表尺寸过大而无法运行检查表
  • 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;