Monday, March 28, 2011

Page Edit Gives Error in SharePoint

[COMException (0x81070518): Unable to complete this operation.  Please contact your administrator.]
   Microsoft.SharePoint.Library.SPRequestInternalClass.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified) +0
   Microsoft.SharePoint.Library.SPRequest.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified) +220

We are getting this error for all the SharePoint Page Edits.
Reason:
SQL is Running out of space.
My DBA Shrinked Files. Issue is wiped off.

The errors that were sent to me did not really tell me anything but when they told me that they were unable to add, change or delete anything that was when I knew it had to deal with SQL being out of space or something like that.  After a little investigation I confirmed that the data drive was completely empty and the reason was because the SQL maintenance jobs.

Tuesday, March 22, 2011

Are there Ram Errors in Your Windows Server ?

http://oca.microsoft.com/en/windiag.asp

Are there apppools are crashing regularly?

Procdump.exe is the tool

For connecting Multiple Servers
MSRDPCLI.exe

Thursday, February 24, 2011

SharePoint JavaScript Error : Only for One User : library not registered

Error Message:

Website error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0;
.NET CLR 1.1.4322; MS-RTC LM 8; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Timestamp: Mon, 4 Jan 2010 18:27:45 UTC

Message: Library not registered.

Line: 1935
Char: 4
Code: 0
URL: http://server/_layouts/1033/init.js?rev=ck%2BHdHQ8ABQHif7kr%2Bj7iQ%3D%3D



Solution:
 
Word 2003-
  Help ->detect and repair - check discard my customized settings and restore default settings

Word 2007-
  Office button -> Word Options -> Resources -> Diagnose

Friday, February 18, 2011

Could not find WebTemplate PROJSING#75820 with LCID 1033.

Solution:

Copy the missed tempalte to this location. It will work

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\SiteTemplates

Wednesday, February 9, 2011

How to Extract DLLS from GAC

For those who wants to take a copy of the dll from GAC (Assembly), follow the below 3 simple steps:

1.       uninstall the dll using the following command in the command prompt
regsvr32 -u C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\shfusion.dll
2.       Now type assembly in the Run dialog box, you will see the folder view of the GAC. Copy the dll you want (Usually we would find the dlls under GAC_MSIL folder)
3.       To get back to the previous state of view, register the Shfusion dll using the following command
regsvr32 C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\shfusion.dll

Tuesday, February 1, 2011

SharePoint DB is full. How to reduce the size of a DB

My SharePoint site is down and i am not able to create any new sites.

Root Cause: My SQL DB is full.  E drive has left out 0 bytes.
I ran these commands against the large Databases and able to free up space up to 6 GB.


 
 /* Shrink Whole WSS_Content_ckm_sales_dev Database */
DBCC SHRINKDATABASE (WSS_Content_ckm_sales_dev)
GO
/* Get the Logical File Name */
USE WSS_Content_ckm_sales_dev
EXEC sp_helpfile
GO
/* Shrink MDF File of WSS_Content_ckm_sales_dev Database */
DBCC SHRINKFILE(WSS_Content_ckm_sales_dev)
GO