Hi to all.

I'm trying to run a report with a huge SQL chain, accesing to TERADATA, but the output is the next:

(FOC1400) SQLCODE ES 302 (HEX: 0000012E)
: CLI2: BADBUFRQ(302): Invalid buffer size.
L (FOC1406) ERROR DE APERTURA DE CURSOR DE SQL. : TSADMOZU

The environment is WebFOCUS 7.6.8 with UAS and TERADATA CLI 12, hosted in SunOS SOLARIS 5.10 64Bits.

This is the content of clispb.dat from /usr/local/pr/teradata/client/lib:

req_buf_len=1024
resp_buf_len=65477
max_num_sess=300
i_dbcpath=dbc
change_opts=Y
keep_resp=N
loc_mode=N
wait_for_resp=N
parcel_mode=Y
resp_mode=R
use_presence_bits=N
msg_security=N
var_len_req=N
var_len_fetch=N
wait_across_crash=N
tell_about_crash=Y
two_resp_bufs=N
save_resp_buf=N
ret_time=N
req_proc_opt=E
maximum_parcel=H

The issue continues.

Greetings and Thank you

This message has been edited. Last edited by: Kerry,

How large is the SQL ?

According to a Google search of the error,there are limits to the size.

Hi Waz, thank you for the response.

The Query is quite huge, has 1145 lines of query.

Greetings,
Jose Gonzalez

FYI, Jose has a case opened on this issue and the case is in research mode.

Jose, when you hear any update/solution, can you please post it here? Thank you in advance for sharing with all.

Cheers,

Kerry

Hi to all.

This problem is solved itself using WebFOCUS 7702M Gen 629.

I think this issue is possible to solve with another lower version, but this concretly is that I needed install for my customer and the problem did go away.

Best regards,
Jose Gonzalez