Msg1105 Level 17 State 16: in database 'NPL' , 'default' segment is full/has no free extents

[stephen_xue]

Hi,

i have got lots of dump in ST22 as below

i have tried to reorg the table and got the following error in isql

however when i check the "default" segment of NPL, i found there are still lots of free pages:

any ideas what the problem is? my system information is:

NW ABAP 7.52 SP04 Developer Edition.

Regards

[rafael_cano_perez]

Hi Stephen

The formatting of my answer came really bad ( these HTML editors .... )

My experience is that when I expand the transactional log with something like:

use master 
disk resize name="NPL_log_001", size="8192M" 
go 
alter database NPL log on NPL_log_001="8192M"            
go 


use NPL 
go 
sp_helpdevice NPL_log_001
go

sp_helpdb NPL
go 

I get to see that the log has some new free space.

Anyway, it is good that you don't get spade dumps anymore.

Regards, Rafael

[stephen_xue]

is the free space you see same as the amount added, which is 8G here? i have tried to add 50M to a device which is full and the free disc added was around 2.5M something when the device has been checked, which is really wired.

the deleting of application log in the ABAP stack does help so far. 🙂 thx