Skip to Content
0
Former Member
Feb 25, 2011 at 09:54 AM

dbs/ada/input_parameters = 10000 doesn't work

111 Views

Hello,

does anyone have experience with setting the parameter dbs/ada/input_parameters larger than the default value 2000?

Following problem:

Yesterday some short dumps occured because of a too complex SQL statement (marker count = 2772 > max. marker count = 2000).

After increasing the parameter dbs/ada/input_parameters = 10000 (SAP note 655018), different short dumps are processed on the system:

1. DBIF_RSQL_SQL_ERROR

***LOG BY4=> sql error -1114 performing PRE on table NAST [dbtran#7588]

***LOG BY0=> POS(1) Communication packet too small [dbtran#7588]

2. DBIF_RSQL_SQL_ERROR

BE***LOG BYL=> DBQ action required because of database error [dbsh#1104]

B1SQL code: -602, SQL text: POS(0) System error: Move error [dbsh.c#1112]

BE***LOG BY4=> sql error -602 performing PRE on table NAST [dbtran#7588]

BE***LOG BY0=> POS(0) System error: Move error [dbtran#7588]

Concerning sql error -1114, I only found SAP note 140739.

The parameter value for CommandBufferSize is 131072, so the note doesn't help.

It is always the same SQL statement that causes the trouble. The database version is 7.7.06.15 and the SAP Kernel is quite new (7.01 PL 105), so I would say that dbs/ada/input_parameters = 10000 should generally work.

it seems that about 3.000 input variables cause the program crash.

Regards

Thomas