From: Zabach, Elke (elke.zabachsap.com)
Date: Mon Jun 07 2004 - 06:21:45 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

H.K, SHESHACHALA wrote:
>
> Hi,
>
> Can anyone help on this:
>
> Error: SAPDB responded with:
> -24988,ERR_SQL: sql error
> 1,task limit
>
There are two possible reasons:
1. you specified the database-parameter (during installation) MAXUSERTASKS with the value x, meaning that in maximum x user may work with the database in parallel/at the same time being connected. The (x+1)st user tries to connect resulting in that error.
--> check who and why there is someone connected more/longer than expected.
Check the parameter SESSION_TIMEOUT if you have the idea, that user not doing anything remain with their connection in the database
Increase MAXUSERTASKS/minimize SESSION_TIMEOUT and/or check the application program behaviour concerning the connecting/reconnecting.

2. two user tried to do some database administration work in parallel (with dbm), which is not possible
--> they have to talk to each other and wait for each other

Elke
SAP Labs Berlin

> Rgds
> Shesh
>
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]