[Solved]SharePoint 2007 error: the file is checked out or locked for editing domain\User

On my SharePoint 2007 site, I have a picture library. There was a file which I wanted to delete , but when I tried to delete it  from the library , it gave me an error “file is checked out or locked for editing by domain\user” . Actually that file was checked by a user who is no more in AD. After lot of Google search I found that , we can delete the file forcefully using SHarePoint designer. 

What is Metafile in Windows

Metafile is consists of NTFS metadata, which is part of part of the system cache . NTFS metadata includes the MFT as well as the other various NTFS metadata files .In the MFT each file attribute record takes 1k and each file has at least one attribute record. Add to this the other NTFS metadata files and you can see why the Metafile category can grow quite large on servers with lots of files.

More about different types of files which consume the physical memory on Windows Server:http://blogs.technet.com/b/askperf/archive/2010/08/13/introduction-to-the-new-sysinternals-tool-rammap.aspx

High Memory Uses by Metafile on Server 2008 R2

My server was eating up lot of physical memory and was crashing due to shortage of RAM . I was not able to resolve the issue for 2 days but file I came to know about a utility called RamMap from Microsoft , which I ran on my server. It revealed that metafile consuming the highest amount of RAM.

High memory uses by metafile on Server 2008 R2 can be reduced using an another Microsoft called CacheSet which can be downloaded from here :http://technet.microsoft.com/en-us/sysinternals/bb897561.aspx 

More info about metafile : What is metafile? and different types of files which consume the physical memory on Windows Server.

Excel Web Access Graphs Showing Gray Color

In my SharePoint2007 environment I use Excel Web Access to show the Excel charts with-in SharePoint site. The issue was , all Excel Web Access Charts started showing only gray color . I did lot of search on Google but could not find any solution.

Solution: I ran "sharepoint Technologies and Configuration wizard" on my SharePoint servers and rebooted them. That resolved my issue. I hope this helps some else in future.

HTTP 500 Internal Server Error in SCCM Reporting

When you try to run a large report on SCCM 2007 you might come across this error “HTTP 500 Internal Server Error” and page shows “The website cannot display the page” . This is the default behavior of IIS which has a default buffer size limited 4 MB for ASP response. To resolve the issue we need to increase the size of ASP response to resolve the HTTP 500 Internal Server Error .

Steps:

-On SCCM server go to Start—>Run—>cmd—>Click Ok—>Type cd /d %systemdrive%\inetpub\adminscripts -–>Enter—> type cscript.exe adsutil.vbs SET w3svc/aspbufferinglimit 67108864

( buffer size increased to 64MB)

For more details please read this article.

[Solved]error: System Changes Require Reboot

While installing SQL Management studio on my Windows 7 computer I came across the error “Pending System Changes Require Reboot” . I restarted the system but again same error came up. I did some research on Google and found this solution.

1. Locate the registry :
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager\

2. Delete registry value “PendingFileRenameOperations”

3. Look for the same registry value at these locations and delete it:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentSet001\Control\SessionManager\

HKEY_LOCAL_MACHINE\SYSTEM\CurrentSet002\Control\SessionManager\

Note: Backup the registry before doing any change and do the registry changes at your own risk

How to Export Members of Exchange Distribution List

I came across this nice VB script to export the list of members of a distribution list of exchange :

'Script begins here

Dim objGroup, objUser, objFSO, objFile, strDomain, strGroup, Domain, Group

'Change DomainName to the name of the domain the group is in
strDomain = Inputbox ("Enter the Domain name", "Data needed", "Default domain name")
'Change GroupName to the name of the group whose members you want to export
strGroup = InputBox ("Enter the Group name", "Data needed", "Default group name")
Set objFSO = CreateObject("Scripting.FileSystemObject")
'On the next line change the name and path of the file that export data will be written to.
Set objFile = objFSO.CreateTextFile("C:\Bin\" & strGroup & " - Members.csv")
Set objGroup = GetObject("WinNT://" & strDomain & "/" & strGroup & ",group")
For Each objUser In objGroup.Members
    objFile.WriteLine objUser.Name & " - " & objUser.Class
Next
objFile.Close
Set objFile = Nothing
Set objFSO = Nothing
Set objUser = Nothing
Set objGroup = Nothing
Wscript.Echo "Done"
Wscript.Echo "Please check the c: for your output file"

Note: The script will ask you the domain name and the group the distribution group for which member list to be created.