Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
AW: Need help
From: Zabach, Elke (elke.zabachsap.com)
Date: Mon Jun 07 2004 - 06:21:45 CDT
H.K, SHESHACHALA wrote:
> 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
SAP Labs Berlin
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb