Increase SharePoint Upload Limit

Are you facing issues when trying to upload files of size above 50 MB to your SharePoint 2007 document library?

Well, I have tried to list down how you can fix those issues and ultimately increase the SharePoint Upload Limit:

First, increase the Maximum Upload Size for a specific web application.

• Go to the Central Administration > Application Management > Web Application General Settings
• Specify the new maximum upload size for your webapplication. For now, we are setting it to 256MB. It could be even set upto 2GB.

Your second step should be to try increasing your default chunk size of large files by trying this STSADM command:

Stsadm.exe –o setproperty –pn large–file–chunk–size –pv   

• This basically denotes the chunk of data that can be read from SQL Server at one time.
• The -pv which determines the property value stands for the upload size in bytes (B).
• It could be set to a maximum of 2GB i.e. (2,147,483,648 B).
• Do an IISRESET

Next, in web.config file of your particular web application, under the httpRuntime tag in system.web section, increase the upload limit to match the value that you set earlier in central administration. You also need to add the execution timeout to allow more time before the upload operation times out as shown in the example below:

httpRuntime executionTimeout="300" maxRequestLength="256000"

where

• 300 means 5 minutes as execution time out
• 256000 allows uploading 256 MB files.

After the above changes, MOSS would allow files of more than 50 MB to get uploaded easily. Incase you still face challenges, check if the file you are trying to upload, is it a blocked file type e.g. EXE, DLL, etc.

Hope this helps you.

SharePoint Timer Job stuck at Deploying

Dealing with SharePoint solution packages and solution deployment stuck at "Deploying" status!!

Well don’t panic, here is just what the doctor ordered:

1. Check the Timer Job Status for the solution deployment in Central Administration. There could be entries with “Failed” as the job status.
2. Lets try to set things right by running stsadm -o execadmsvcjobs command.
   Note that in a farm environment, you need to run the above command on all the servers.
3. As a next step, try restarting the OWSTIMER Service on all boxes in the farm.
4. If the above steps do not help the solution deployment. You may try retracting the solution using Retract solution command or through the Central Admin's Solution Management.
   stsadm.exe -o retractsolution -name
   For your knowledge, retracting a solution creates another “deployment job”.
   
   Now if retracting the solution does not work, do not try to Force Delete the solution as that would throw an exception, "The solution cannot be removed when job is scheduled or running"
5. Get a list of all the pending & active deployments on your MOSS Farm using
   stsadm -o enumdeployments command.
   Make a note of the GUID of the various solutions on the command window as this would be required in next step.
6. As a last nail in the coffin, we now need to simply cancel the solution deployment by passing the GUID of the solution as shown below
   stsadm -o canceldeployment -id "job id string here"

After performing the above steps, you would be able to either put the SharePoint Timer Job into completion or atleast remove the solution package being stuck in deployment.

If the problem still persists (esp. in the MOSS 2007 Farm environment), you might need to remove/detach a defective WFE from the farm and then retry deployment.

I have tried to put together the steps which have worked for me, hope this post helps you all too.

How to Fix Central Administration: Service Unavailable Issue?

While working on MOSS Servers, you all must have faced 2 common issues quite frequently

1. You receive a "Cannot connect to the configuration database"
2. Service Unavailable

Basically, the configuration database is where SP stores all information about the SharePoint 2007 installation and the server farm, hence, it is required for the Central Administration to work fine.

Suddenly while you are in the middle of your important SharePoint deployment or configuration, either of these issues will prop up and eat up lengthy hours. Even the easiest solutions to all SharePoint problems i.e. IISReset or Server restart also do not end your miseries.

Hence, I decided, lets apply TRY-CATCH-FINALLY on these issues for once-n-for-all here.

For Issue#1:

Try to run the SharePoint configuration wizard once, follow these steps for the same:

Click Start, click Run, type cmd in the Open box, and then click OK. Change to the following directory: system drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin Run the following command: psconfig -cmd upgrade -inplace b2b

The above steps should fix the issue, but if your problem still persists, then check the event logs of your server. Checking those logs will let you know issues such as -

• Is your SQL server agent running?
• Credentials (app pool permissions) used for connecting to SQL Server is working or failing?
• Facing any network issues to be able to connect to DB?
  (this only applies if the SQL is applied on a separate box from MOSS 2007)
• so on..

For Issue#2:

If even after carrying out the above suggestions, you are not able to track down the problem, then you could unprovision Central Administration and then reprovision it.

This could be easily done via an STSADM command given below:

stsadm.exe -o provisionservice -action start -servicetype Microsoft.SharePoint.Administration.SPWebService -servicename WSS_Administration

 
I sincerely hope this helps you all in fixing this critical MOSS 2007 Central Administration issue.