SAP Knowledge Base Article - Preview

2517141 - Error 1105 when creating primary index on SE14 - NetWeaver

Symptom

  • There is great deal of the space left in the filegroup but system still fails to create index due to the error "filegroup is full".
  • Error in SE14 Object Log
    Could not allocate space for object 'dbo.SORT temporary run storage: xxxxxxxxxxxxxxx' in database '<SID>' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    1.jpg 
  • Error when creating index in SSMS
    Msg 1105, Level 17, State 2, Line 2
    Could not allocate space for object 'dbo.SORT temporary run storage: xxxxxxxxxxxxxxx' in database '<SID>' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
    2.jpg


Read more...

Environment

SAP NetWeaver on Microsoft SQL Server

Keywords

Msg 1105, SE14, Create primary index, SORT_IN_TEMPDB, SAP Systems based on SAP NetWeaver , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

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.