Re: Weird Error - CPF3E01 - DDM parameter value not supported. (using Db2 Connect driver for .NET Core)

I don't have an answer for you, but is there any reason you couldn't use the IBM i Access ODBC Driver ?

Are you deploying on Windows or another platform ?

There is a Nuget package now for the ODBC driver.

Might be worth a try. You could also see if there are any buffering switches on the DB2 connect driver connection string you can set perhaps.

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx

------------------------------

message: 2
date: Thu, 23 Jan 2020 09:00:08 -0700
from: Charles Wilt <charles.wilt@xxxxxxxxx>
subject: Re: Weird Error - CPF3E01 - DDM parameter value not
supported. (using Db2 Connect driver for .NET Core)

DS is 53 bytes...

DIM(9999)--> 529,947 bytes total

1192 records --> 63,176 bytes
1193 records --> 63,229 bytes

Doesn't seem to hit any limits I'm aware of...
Unless DDM is more limited than JDBC...

Charles



On Wed, Jan 22, 2020 at 10:27 PM Peter Dow <petercdow@xxxxxxxxx> wrote:

What's the total size of the data structure for 1192 elements?

On 1/22/2020 4:25 PM, Charles Wilt wrote:

Scenario
Db2 Connect driver for .NET CORE

Calling an external stored procedure written in RPG.

As long as the results set is 1192 records or less, it works fine, but

any

bigger and we get the following exception on record 1193.


CPF3E01 Diagnostic 40 01/22/20 18:09:47.424155 QCNTEDDM QSYS *STMT

QRWTSRVR

QSYS *STMT

From user . . . . . . . . . : DT1PYDC
From module . . . . . . . . : QCNTEDDM
From procedure . . . . . . : SNDMSG

Statement . . . . . . . . . : 8629
To module . . . . . . . . . : QRWTSRVR
To procedure . . . . . . . : main
Statement . . . . . . . . . : 325
Message . . . . : DDM parameter value not supported.
Cause . . . . . : A value was sent from the client that is not supported

by

this server. The following are not supported (See X'2156'): -- '1144'X or
'212D'X -- Version names. -- '2106'X -- Decimal precision of 15. --

'2112'X

-- Package names or collection identifiers greater than 10 characters in
length. -- '2128'X -- Collection identifiers greater than 10 characters

in

length. -- '2129'X -- Release of allocated resources at conversation
deallocation. IBM i supports release of resources only after commit. --
'2130'X -- Option to explain information about SQL statements. --

'2131'X --

User IDs greater than 10 characters in length. Recovery . . . : Change
the value sent by the client and try the operation again. Technical
description . . . . . . . . : If DDM code point X'2156' does not appear

in

the list above refer to the DDM Architecture Reference for more

information.

Doesn't matter what's in the results set, only if it bigger than 1192.

Calling the same store proc via JBDC using ACS Run SQL Scripts works

fine.

One thing that's a little different, the results set is built as an RPG
Array...

dcl-ds my_data qualified dim(9999);
ENTERPRISE char(4);
COMPANY char(3);
EMPLOYEE_ID char(9);
TECH_ID char(3);
//other fields snipped
end-ds;
dcl-s OutputRows int(10);

Exec SQL Set Result Sets
WITH RETURN TO CLIENT
ARRAY :my_data
FOR :outputrows ROWS;

Thoughts?
Charles