My Oracle Support Banner

Migration Job Finishing With Success But It Isn't Migrating All Data. (Doc ID 436922.1)

Last updated on FEBRUARY 25, 2020

Applies to:

Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.

Goal

How can user resolve errors with 'Migrate from Version by Book' job when using
large data volumes?

In OC 4.5, "Migrate Form Version by book" job is showing Success status but not migrating all data. and Output file shows following error.

*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 198
ORA-06512: at "SYS.DBMS_OUTPUT", line 139
ORA-06512: at "OPA.OPA_USER_MSG", line 267
ORA-06512: at "RXC.OCL_DCIF_MIGRATE", line 646
ORA-06512: at line 1




Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.