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

Last updated on JANUARY 18, 2017

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

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