DB error SQL error 1105 occurred

[Former Member]

Dears,

I have working on SAP ERP 6 EHP5 NW 7.02 on Sybase, and get the following error" DB error: SQL error 1105 occurred "also when try to open TCode: dbacockpit to extend the table space, the SAP GUI terminated and show the following error also <SID>: SAP System Message: Work process restated; session terminated.

so please advice how I can solve this issue, thanks in advance.

[Former Member]

1105 -  ASE has run out of space (data or log).

It's possible that dbacockpit is failing because it's running some SQL (to complete the extend) that uses space in tempdb - and it's tempdb that full.

Look at the ASE log to see where thr 1105 occured.

If tempdb is fulll :-

- Use an account that has a seperate tempdb (if set up)

- extend tempdb

- cleanout tempdb manually

- reboot

Cheers,

Chris