Error Ncr-01004 and ORA-3136 During Insert Using Database Gateway
(Doc ID 1196299.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for Sybase - Version 10.2.0.3 to 11.2.0.1 [Release 10.2 to 11.2]Information in this document applies to any platform.
Symptoms
Running an insert with a large number of rows over the TG4Sybase 10.2 gateway fails with:
Mon Aug 30 13:41:54 2010
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
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 -
Execute SQL statement
DRV_GetRows: ORA-03136: inbound connection timed out
...
nvRETURN (./drv_irow.c 368): -2204
DRV_GetRows: ORA-03136: inbound connection timed out
...
nvRETURN (./drv_irow.c 368): -2204
and -
hoastmt.c (2094): ; hosceac_end_agent_callback(): Exited with retcode = 0.
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.
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |