OWB 11.2 Mapping Based On Advanced Queue Source Fails With ORA-25228: timeout or end-of-fetch during message dequeue from string.string
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 11.2 and later
Information in this document applies to any platform.
Migration from previous version to OWB 11.2.0.x.
OWB 11.2 mapping having an Oracle Advanced Queue (AQ) as source fails with:
The mapping is frequently called from a script using the sqlplus_exec_template.sql approach and the error occurs when new messages are being added to the queue whilst the mapping is running the de-queue.
Upgrade to version 11.2 .
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