Saturday, September 24, 2011

Problem with Custom table activation

Joyjit Ghosh, Kolkata.

Background:
Recently we have seen a peculiar problem during activation of an existing custom table after a field addition.
During activation it was throwing following message:



From the above screen shots we were clueless about the problem
That's why thought to check the system log (SM21):

It gives the required hint that problem is with database physical storage


Solution:
After searching through SAP market place we have found an OSS note that gives a clue to resolve this issue. It states about a data dictionary table called DDSTORAGE that stores the parameters related to database storage for any data dictionary table. Further investigation reveals that to resolve this problem we have to increase the value for MAXEXTENTS parameter.


Changed the value of MAXEXTENTS parameter in debug mode.



After maintaining the value for parameter MAXEXTENTS when we had activated the table it was activated without any error.