My Oracle Support Banner

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 FEBRUARY 01, 2022

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:


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

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
Symptoms
Changes
Cause
Solution
References


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