Symptom
During SELECT INTO, BCP, or CREATE INDEX:
- Msg 1105, Level 17, State 2
Can't allocate space for object 'objname' in database 'dbname' because 'default' segment is full/has no free extents. - DBCC CHECKALLOC reports a Msg 2502 on syslogs:
Msg 2502, Level 16, State 1:
Server 'myserver', Line 2:
Table Corrupt: A page is linked in more than one chain; check this page: page number=XXXX allocation status=XXX - dbccc usedextents(dbname, 0,1,1) does not fix the issue
- starting ASE with traceflags 7408/7409 does not fix the issue
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
- Database should not have a space problem (1105s occur even when used space is much less than free space)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
unexplained 1105, default segment full, shrinkdb, shrink, segmap 0, Msg 2502, sysusages_check sysusages_check.ddl select sysusages calculate order , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.