ORA-28501 Using Database Gateway for SQL Server 12C (Doc ID 2013399.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 12.1.0.2 and later
Oracle Database Gateway for DRDA - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Using Database Gateway for SQL Server (DG4MSQL) or Database Gateway for DRDA (DG4DRDA) 12.1.0.2 with Oracle Database 12.1.0.2 to connect to SQL Server, produces the following error:

SELECT * FROM owner.activity@gp_proc;

ORA-28501: communication error on heterogeneous database link
ORA-02063: preceding line from GP_PROC


A gateway trace shows the following:

Entered hgotcis at 2015/05/22-12:18:34
Calling SQLStatistics for OWNER.ACTIVITY
IndexType=SQL_TABLE_STAT: cardinality=204
IndexType=1: PK_Activity
Calling SQLColumns for OWNER.ACTIVITY
1 Index(es) found:
Index: PK_Activity, type=1, ASCENDING, UNIQUE, cardinality=204
Error -> Invalid ordinal position for column 'ActivityID': 0
  #1 Column 0: ActivityID
Exiting hgotcis, rc=28501 at 2015/05/22-12:18:34
hostmstr: 140737288609792: HOA After hoxtcis
hostmstr: 140737288609792: RPC After Get Statistics

 

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