Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ASE SQL ERROR 1105

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question