OWB 11.2 Mapping Based On Advanced Queue Source Fails With ORA-25228: timeout or end-of-fetch during message dequeue from string.string (Doc ID 1379646.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

Migration from previous version  to OWB 11.2.0.x.

OWB 11.2 mapping having an Oracle Advanced Queue (AQ) as source fails with:

ORA-25228 : timeout or end-of-fetch during message dequeue from string.string


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.

Changes

Upgrade to version  11.2 .

Cause

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