My developers created a sandbox code and uploaded it to a site collections under site Actions--Site settings--Galleries--Solut
ions for which the url is "/_catalogs/solutions/Form
Once uploaded, they were trying to "Activate" the solution by highlighting the solution and then clicking "Activate" on the ribbon but they were getting below error message.
In order to troubleshoot and fix the problem, below are the steps which was tried by me on the sharepoint environment:
The site collection containing this sandboxed solution has exceeded its daily resource usage quota.
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 1364ec53-0c27-426a-b298-164267001df7
Date and Time: 7/31/2012 12:58:38 PM
I Checked the site quota showing for sandbox solution at site Actions--Site settings--Galleries--Solutions, it was showing the message as:
Your resource quota is 0 server resources. Solutions can consume resources and may be temporarily disabled if your resource usage exceeds your quota.
I uploaded the same solution on a test site, newly created in SP2010 and tried to activate it but got the same error
I checked the site resource quota on the server and found following information:
Limit maximum usage per day to: 0 points
Send warning e-mail when usage per day reaches: 0 points
I checked the settings for other sites in the farm but they all has same settings
I checked the settings in other farms and found that other farms has setting as mentioned below:
Limit maximum usage per day to: 300 points
Send warning e-mail when usage per day reaches: 100 points
I checked the quota template settings for entire farm and found that it is different for other zone
I updated all the site quota template consistent with other zones and checked the issue but it was still showing as 0 resource quota
I restarted following service on the servers:
Microsoft SharePoint Foundation Sandboxed Code Service
I checked the issue but it was still not working
I rebooted the servers in maintenance window and checked the issue but it was still showing the same data
I changed the site quota template from current default template to a NEW QUOTA TEMPLATE and the site is now showing quota as follows
Your resource quota is 300 server resources. Solutions can consume resources and may be temporarily disabled if your resource usage exceeds your quota.
WOW! Finally the issue is fixed. Phew!!
You can find the similar content on my blog post at below mentioned link: