discard on table with BLOB, but no rows exist in source or target
edited Nov 26, 2012 4:50AM in GoldenGate, Streams and Distributed Database (MOSC) 9 commentsAnswered ✓
RHEL 5.6, Oracle 11.2.0.3.0 RAC, GoldenGate 11.2.1.0
I regularly get entries in my discard file references a table that contains a BLOB. The entry references RAW data so I believe it has something to do with the BLOB. When I search for the entry in either source or target i find no rows. I'd like to know if anyone understands what is happening here.
here is the table:
I regularly get entries in my discard file references a table that contains a BLOB. The entry references RAW data so I believe it has something to do with the BLOB. When I search for the entry in either source or target i find no rows. I'd like to know if anyone understands what is happening here.
here is the table:
desc flux_stb_message
Name Null? Type
----------------------------------------- -------- ----------------------------
FLUX_STB_MESSAGE_QUEUE_ID NOT NULL NUMBER
MESSAGE BLOB
LAST_MODIFIED_DATE DATE
REQUEST_BYTES BLOB
Here is the discard entryName Null? Type
----------------------------------------- -------- ----------------------------
FLUX_STB_MESSAGE_QUEUE_ID NOT NULL NUMBER
MESSAGE BLOB
LAST_MODIFIED_DATE DATE
REQUEST_BYTES BLOB
Discard record on fetch result = INCONSISTENTROW (11)
1