My Oracle Support Banner

DG4ODBC Connection to Attunity Connect Server Gives Intermittent Error - Lost Rpc Connection To Remote Agent (Doc ID 1418603.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


Using RDBMS 10.2.0.5 and Database Gateway for ODBC (DG4ODBC) 11.2.0.2 to connect to Attunity Connect Server on OpenVMS Server 5.3.2.4 with the Attunity Connect Driver for ODBC 3.5 intermittently gives the following error -

HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.name.com)(PORT=
1521)))(CONNECT_DATA=(SID=NAV_SHA))), NCR status = -2147385341


A DG4ODBC debug trace does not show any errors and ends with the following -

Entered hgogenconstr at 2012/02/08-10:44:46
dsn:DSN_NAME, name:CONNUSER
optn:
Entered hgocip at 2012/02/08-10:44:46
dsn:DSN_NAME
Exiting hgocip, rc=0 at 2012/02/08-10:44:46
Exiting hgogenconstr, rc=0 at 2012/02/08-10:44:46
Entered hgopoer at 2012/02/08-10:47:55




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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.