Due to large size of JMX tables, Oracle to SQL Server Pre-Migration Diagnostic Utility is running into loops and stuck with running checking table in Windchill

• Oracle to SQL Server Pre-Migration Diagnostic Utility is running into loops and stuck with running checking table due to large size of JMX tables 
  • o2s_pre_migration_check.log shows below stack trace:

[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)---------------------------------------------------------------

• There are some ERROR message in table 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;