Extract Fails With Error OGG-02704 Failed to read entire LOB column xxxx of table xxxx.xxxx

(Doc ID 2143862.1)

Last updated on MAY 29, 2016

Applies to:

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


Extract abends with below error:

2016-04-29 11:56:59 INFO OGG-01517 Position of first record processed Sequence 455816, RBA 39506448, SCN 48.2459416673, Apr 28, 2016 1:23:13 PM.

2016-04-29 11:57:04 INFO OGG-01021 Command received from GGSCI: STATUS.

2016-04-29 12:04:03 INFO OGG-01971 The previous message, 'INFO OGG-01021', repeated 1 times.

2016-04-29 12:04:03 INFO OGG-06507 MAPTABLE resolved (entry xxxx.xxxx): TABLE "xxxx"."xxxx".

2016-04-29 12:04:04 INFO OGG-06509 Using the following key columns for source table xxxx.xxxx: ID, SEQ_NO.

Source Context :
SourceModule : [ggdb.ora.db.old]
SourceID : [/scratch/debassah/view_storage/debassah_OraFBOs/oggcore/OpenSys/src/gglib/ggdbora/dboci8.c]
SourceFunction : [process_select_lob]
SourceLine : [5924]

2016-04-29 12:04:05 ERROR OGG-02704 Failed to read entire LOB column xxxx of table xxxx. Expected length was 32770 characters. Only 30000 bytes was read.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms