TG4MSQL Using TWO_PHASE_COMMIT Fails With Error "tm_rollback_from_failure Heuristic roll back trying all tdps, ignoring failure"

(Doc ID 398920.1)

Last updated on APRIL 26, 2012

Applies to:

Oracle Database Gateway for SQL Server - Version to
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2010***
Oracle Transparent Gateway for Microsoft SQL Server - Version: to
***Checked for relevance on 26-APR-2012***


Using Tg4MSQL with SQL Server 2005 / 2000  in
mode fails with error:


ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]tm_rollback_from_failure: Heuristic roll back:
trying all tdps, ignoring failure
ORA-02063: preceding 2 lines from BORIS


This error was reported against SQL Server 2005 but it was also reproduced against SQL Server 2000.


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