Target event_log shows:
[05/15/07 22:57 Error: 15017 - Error on splex.splex_time(gen_row, gen_tab);., rowid AAAF2jACeAAB86LAAS : ORA-06502: PL/SQL: numeric or value error: character string buffer too small.ORA-06512: at line 8.
Either conflict resolution or transformation procedure failed with the above error.
Bad date passed into src_ora_time for sp_cr package when transformation or conflict resolution procedures are called on 10g database
WORKAROUND:
1. stop post
2. Change src_ora_time from varchar2(20) to varchar2(25) on sp_cr package on target, and recompile sp_cr
3. start post
Note: If you run ora_setup again, it may revert it back to varchar2(20) and you have to manually change it again to varchar2(25).
STATUS:
Waiting for fix in a future release.
Applies only to 10g with Shareplex 5.3.3 and use of conflict resolution or transformation
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center