SAP ABAP Message Class SMMSS_DDIC Message Number 007 (FILEGROUP is not set for the table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_DDIC (Package) Data Dictionary Porting for Microsoft SQL Server

Attribute

Message class	SMMSS_DDIC
Short Description	DDIC Messages for Microsoft SQL Server
Message Number	007
Documentation status		Space: object requires documentation
Authorization check Error Message	☐
Changed On	20130531

Message Text

FILEGROUP is not set for the table

Help Document

Diagnosis

You have set CLUSTERED YES and FILEGROUP for an index; FILEGROUP is not set for the table. However, the table exists in the database and is located in a different filegroup. During conversion, the table would first be created in its current filegroup and then in the filegroup selected for the index. Depending on the size of the table, this could be very expensive.

System Response

Procedure

If you do not want to convert the table, but rather move it into the filegroup you selected for the index by creating a new index (activate and adjust database) for which you have set CLUSTERED YES, you do not have to do anything. However, if you want to convert the table, you should set CLUSTERED YES for the same filegroup as for the index.

Procedure for System Administration

History

Last changed on/by	20130531	SAP
SAP Release Created in