TG4MSQL Using TWO_PHASE_COMMIT Fails With Error "tm_rollback_from_failure Heuristic roll back trying all tdps, ignoring failure"
Last updated on APRIL 26, 2012
Applies to:Oracle Database Gateway for SQL Server - Version 10.1.0.1 to 10.2.0.5
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2010***
Oracle Transparent Gateway for Microsoft SQL Server - Version: 10.1.0.1 to 10.2.0.5
***Checked for relevance on 26-APR-2012***
Using Tg4MSQL with SQL Server 2005 / 2000 in
mode fails with error:
[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
Million Knowledge Articles and hundreds of Community platforms