Junction points & mount points cause error in Autogrowth MTE

July 30, 2009 at 5:49 pm

[] [] [] [] [] [] [] [] [] [] [] [] []

  1. RZ20 SQL Server message “No free space in file”Symptom The AutoGrowth MTE ( CCMS_MSS_SPACE_fileag_ma ) is Red and shows the message “No free space in file”. Autogrow on but not all files can grow, is shown. Other terms Autogrowth, SQL...
  2. ALV grid view paging error with several grid viewsSymptom In the ALV grid view control, when you display data page by page (paging) after a page navigation or a simple dialog step, the system may scroll to the incorrect page...

Symptom

Autogrowth MTE in RZ20 for SQL Server reports there is not enough room to grow
Other terms

Space management, RZ20 for SQL Server, Autogrowth, sap_mon_sqldbfiles, CCMS_MSS_SPACE_MGMT
Reason and Prerequisites

There is a programming error.
In release 620 and 640 this error is in function module CCMS_MSS_SPACE_MGMT.
In release 700 and 710, the stored procedure sap_mon_sqldbfiles needs to be changed.
The use of junction points or mount points is not considered when analyzing space availability.
Solution

Apply the appropriate 620 or 640 support pack or apply this change via snote. For 700, the stored procedure is included in EHp1 and basis support package 15. Its also available upon request

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment