Error Ncr-01004 and ORA-3136 During Insert Using Database Gateway
Last updated on JANUARY 18, 2017
Applies to:Oracle Database Gateway for Sybase - Version 10.2.0.3 to 22.214.171.124 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Aug-2013***
Running an insert with a large number of rows over the TG4Sybase 10.2 gateway fails with:
Error 28500 trapped in 2PC on transaction 7.111.99450. Cleaning up.
Error stack returned to user:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
trying all tdps, ignoring failure
ORA-02063: preceding 2 lines from TG4SYBS
and a gateway debug trace shows the following errors -
DRV_GetRows: ORA-03136: inbound connection timed out
nvRETURN (./drv_irow.c 368): -2204
hoaexec (18): ; hoaexec Exited with retcode = 28500, nrows = 0.
HS Agent received unexpected RPC disconnect
Network error 1004: NCR-01004: NCRS: Write error.
hoaroll (12): ; hoaroll Entered. tflag = 0.
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