Database exception: Space for user session exhausted

[Former Member]

Hi,

We are experiencing following issue whenever we deploy an ear file.

We are using SAP WebAS 6.40 with MaxDB

com.sap.dbtech.jdbc.exceptions.DatabaseException: [-907]: Space for user session exhausted

Thanks,

[former_member229109 · Accepted solution]

Hello Prathap,

You reported database error::

-907: Space for user session exhausted

Explanation for this error:

You have not been connected to the database system because

there is not sufficient free temporary disk space to connect

to a normal database session.

In this case you can connect as soon as another user has disconnected,

or when deletion of other users’ result tables frees up sufficient

storage space again.

And I think the solution in your case will be, if you can use the Database Manager to connect and reconfigure the database instance.

May be this problem occur due the lack of space in data or log volumes. You could check it, for example in DBMGUI, or review the messages in the knldiag file.

-> If you have DB_FULL problem in the database, please check if you could add

data volume using DBMGUI.

-> If you have LOG_FULL problem in the database, please create the log backup.

***

MAXDB documentation available at http://dev.mysql.com/doc/maxdb

Thank you and best regards, Natalia Khlopina