ORA-01591 Errors Occur when Multi-Mode e*Way, Using XA-enabled Oracle e*Way Connections, Attempts to Publish Data Retrieved from the Database. (Doc ID 1027435.1)

Last updated on OCTOBER 25, 2016

Applies to:

Sun e*Gate - Version 4.1.2 and later
Microsoft Windows (32-bit)
Sun SeeBeyond e*Gate - Version: 4.5.2 and later

Symptoms

The ORA-01591 errors are registered in Oracle trace file, for example:


*** 2002-05-29 10:52:43.170ksedmp: internal or fatal errorORA-01591: lock held by in-doubt distributed transaction 13.6.564Current SQL statement for this session:select * from <table>
where table <table> is the source of the retrieved data.


The e*Way's log itself provides no indication of error. The outward behaviour noted is that the e*Way continues to log normal activity, but does not otherwise perform further processing (e.g., in this scenario, the periodic polling of the table) and publishes no messages.

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