Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Gateway for Sybase commits distributed transaction with error.

Oracle Gateway for Sybase commits distributed transaction with error.

Hello !
I have installed Oracle Transparent Gateway for Sybase ver. 8.1.6 under HP-UX 11.0,
configured it and connected to Sybase Anyware 7 (client 12.5). Gateway works fine. I
can read data from Sybase and perform remote transaction but when I tried to
commit _distributed_ transaction I received next error :
SQL> commit;
commit
*
ERROR at line 1:
ORA-02053: transaction 7.135.2649 committed, some remote DBs may be in-doubt
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Transparent gateway for SYBASE]tm_recover-forget commitconfirm: cannot
delete
CC record(nvDeleteCCRecord) rc=-2224 tdp=: anyware
ORA-02063: preceding 2 lines from ANYNI
--
The transaction was commited on the both databases, but gateway didn't
delete line from table RECOVER.HS_TRANSACTON_LOG on Sybase side. User
RECOVER was created, table HS_TRANSACTON_LOG was created and privileges were
granted too. I've found following lines in gateway's trace file :
(0) DELETE FROM RECOVER.HS_TRANSACTION_LOG WHERE
(0) (RECOVER.HS_TRANSACTION_LOG.GLOBAL_TRAN_ID = ?)
--
I guess the problem is because in where clause plased "?" instead of real
transaction ID.
Does anybody know how to fix this problem ?
Should I tune any parameters on Sybase side ?
Thanks in advance.