When a compare table is issued with the table HIGH_PRECISION, the following logs are generated in the event_log file at the target machine:
"12/01/05 16:02 Process launched: sp_declt (for o.SOURCE-o.TARGET-136309542) [pid = 26454]
12/01/05 16:02 Notice: Opened DataEquator session log file /usr/app/TARGET/splex/splex_queue/log/TARGET_declt-OWNER.HIGH_PRECISION-10562-01.log [sp_declt(deq)/26454]
12/01/05 16:02 Notice: Oracle env - TARGET:/usr/app/TARGET/oracle/product/10.1.0 [sp_declt(pdb)/26454]
12/01/05 16:04 Error: Oracle Error 1406: ORA-01406: fetched column value was truncated. [sp_declt(deq)/26454]
12/01/05 16:04 Internal error: Error 1 in de_batch_setup see TARGET_OWNER.HIGH_PRECISION-10562-*.log [sp_declt(deq)/26454]
12/01/05 16:04 Process exited sp_declt (for o.SOURCE-o.TARGET-136309542) [pid = 26454] - exit(0)"
Further inspection identified that for compare to work, it has several decimal points (tested with >=6 digits ) then the sum of the exponential value and the number of decimal points must be less than 135 (i.e 9.88888888E-126 has 8 decimal points and an exponential value of 125 - total is 8 + 126 = 134 - it fails with 9.999999999E-126 which has a total of 9+126=135).
update "HIGH_PRECISION" set C3=9.88888888E-126,C_MAT04=9.88888888E-126,C6=9.88888888E-126,C7=9.88888888E-126,C8=9.88888888E-126;
Same Compare now works
ID Tablename Status Since
---------- ---------------------------------------- --------- ------------------
2786.1 "OWNER"."HIGH_PRECISION" In Sync 17-Jan-06 11:57:14
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center