ORA-28501 Using Database Gateway for SQL Server 12C
(Doc ID 2013399.1)
Last updated on JUNE 08, 2023
Applies to:
Oracle Database Gateway for SQL Server - Version 12.1.0.2 and laterOracle Database Gateway for Informix - 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
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
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
For Oracle Database Gateway for Informix, the gateway trace shows the following:
10 Index(es) found:
Index: i1_bi_cliente, type=3, ASCENDING, UNIQUE, cardinality=66816
#1 Column 1: cliente_id
Index: i2_bi_cliente, type=3, ASCENDING, UNIQUE, cardinality=66816
#1 Column 6: codigo_lider
#2 Column 8: codigo_cliente
#3 Column 10: codigo_tipo_cliente
Index: i90_bi_cliente, type=3, DESCENDING, NON-UNIQUE, cardinality=66816
Error -> Invalid ordinal position for column '(null)': 0
#1 Column 0: (null)
Index: i1_bi_cliente, type=3, ASCENDING, UNIQUE, cardinality=66816
#1 Column 1: cliente_id
Index: i2_bi_cliente, type=3, ASCENDING, UNIQUE, cardinality=66816
#1 Column 6: codigo_lider
#2 Column 8: codigo_cliente
#3 Column 10: codigo_tipo_cliente
Index: i90_bi_cliente, type=3, DESCENDING, NON-UNIQUE, cardinality=66816
Error -> Invalid ordinal position for column '(null)': 0
#1 Column 0: (null)
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 |
References |