Skip to Content
0
Oct 30, 2015 at 06:49 AM

ASE SQL ERROR 1105

738 Views

Dear Gurus,

Good afternoon. I am facing the below error in our ecc production server. I am pasting the sid.log below for your understanding.

00:0008:00000:00112:2015/10/30 11:32:17.31 server Error: 1105, Severity: 17, State: 2
00:0008:00000:00112:2015/10/30 11:32:17.31 server Can't allocate space for object 'temp worktable' in database 'saptempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
00:0008:00000:00112:2015/10/30 11:34:41.74 server Error: 1105, Severity: 17, State: 2
00:0008:00000:00112:2015/10/30 11:34:41.74 server Can't allocate space for object 'temp worktable' in database 'saptempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.


our database is on sybase and os is on suse linux. i added space to database using isql editor with the below command but still issue is persisting.

after login to isql editor i used the below command and added space to databaes


use master

go

disk resize name="SID_data_001{,size='XGB'

go

alter database SID on SID_data_001='XGB'

go


here in the above log its showing i need to add some space on saptempdb..i am new to sybase so please guide what should i do and what command should i need to perform and add the space and how much space should i need to add to saptempdb. I am waiting for your valuable feedback and suggestions. i am attaching database log and also the sm21 log for your reference.Thanks in advance.


Best regards,

venkat.

Attachments