My Oracle Support Banner

ODP connection terminated when AS400 client receives protocol error sqlcode -30000 (Doc ID 2391849.1)

Last updated on APRIL 26, 2018

Applies to:

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

Symptoms

The client detected a protocol violation, sqlcode -30000 and sqlstate 58,
EXECUTION FAILED DUE TO A DISTRIBUTION PROTOCOL ERROR,
when trying to return parameters from Oracle's stored procedure back to AS400 (DB2/400 v7.1).

ODP did not fail and the trace shows a procedure call with 5 parameters that are all INOUT type
and of datatype VARCHAR2, and each separate ODP request executed successfully
but the connection was terminated when the client received sqlcode -30000.

The SQLCODE -30000 indicates an anomaly (short field length) was detected in the response data, but that the session continues.

RPG400 Joblog:

CALL PGM(xxxxxxx/TW351AR) PARM('PROCTEST' 'xxxxxx' 'LEN2TPAG')
Database connection started over TCP/IP or a local socket.
CONNECT to relational database PROCTEST completed.
Current connection is to relational database PROCTEST.
The data descriptor received is not valid.
Unable to retrieve query options file.
Unable to retrieve query options file.
**** Starting optimizer debug message for query .
All access paths were considered for file QASXSYMP.
All access paths were considered for file QASXPROB.
File QASXSYMP processed in join position 1.
File QASXPROB processed in join position 2.
Unable to retrieve query options file.
Temporary result file built for query.
Access path built for file *N.
Unable to retrieve query options file.
**** Ending debug message for query .
An internal error was detected while processing a DRDA request.
Distributed Relational Database Architecture (DRDA) protocol error.
An internal error was detected while processing a DRDA request.
Distributed Relational Database Architecture (DRDA) protocol error.
Database TCP/IP or local socket connection ended.
RPG procedure TW351AR returned with halt indicator 1 on.
Application error. RNX0233 unmonitored by TW351AR at statement *N,
instruction X'0000'.
SQLSTT = '58008'
SQLCOD = -000030000.

  

 

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!


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