DG4DRDA Gateway Fails With ORA-28500 When Statistics Are Turned On And Connecting To AS400 (Doc ID 1538708.1)

Last updated on MARCH 21, 2013

Applies to:

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

Symptoms

Selecting from an AS400 table using the Database Gateway for DRDA (DG4DRDA) with HS_SUPPORT_STATISTICS set to TRUE fails with error:

 

select count(*) from DUAL@IOS_EMGTW_11_2_0_3_DB
  *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from IOS_EMGTW_11_2_0_3_DB

 

and a gateway trace shows:

 

...

SQLGetDiagRec returns rc=100 (SQL_NO_DATA) for handle 1aed47a0 (SQL_HANDLE_STMT)
Exiting hgopoer, rc=0 at 2013/03/18-10:45:22 with error ptr FILE:hgopoer.c LINE:186 FUNCTION:hgopoer() ID:GetDiagRec error
hgotcis, line 571: calling SQLStatistics got sqlstate

...

 

 

Changes

 Enabling statistics for the gateway using -

HS_SUPPORT_STATISTICS=TRUE

 

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