Claus-Thomas Buhl wrote: > > Hi there, > > Is there any documentation on the following SAP DB error message: > > Command inactivity timeout (work rolled back) (command timeout)(63) > Errorcode = 700, ISAM = 0 > > This error message has the same error code as > `Session inactivity timeout' but obviously relates to an SQL command, > not to a CONNECT. > > What are the reasons for this error? > How do I get rid of this error? > > Context: SAP DB 7.3.0.32, MAXUSERTASKS=50, MAXSERVERTASKS=15, > DEADLOCK_DETECTION=4, SESSION_TIMEOUT 900, REQUEST_TIMEOUT 60 > > Regards, > > CTB > --
These are no different errors, just two namings. Explanation: An application connects to one task in the kernel and uses some resources. To avoid loosing those resources (and not being able to use that task for other work) a usertask not used by its application for a while (longer than SESSION_TIMEOUT tells this task to wait) will catch that fact, do a rollback release implicitly and return error 700 whenever the application wants to talk to that kernel-task again. This talking to the task again is not possible. A new connection has to be opened by that application before being able to talk to a (not necessarily the same) kernel task again. What kind of application do you have? Is the session-timeout of 15 minutes ok in this context? It does not seem to be. Elke > _______ > \o/|\o/ Claus-Thomas Buhl > | Diplom-Informatiker > \_____/ mailto:[EMAIL PROTECTED] > > H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim > Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED] > http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
