Thursday, November 20, 2008

Value does not fall within the expected range error while check-in of document

I was getting error while check-in of document from document library into SharePoint interface. Actually I have created Meta data fields and attached to document, I was able to check-in document from office application like word, but if I check-out and check-in same document from document library interface then I was getting error "Value does not fall within the expected range".

I tried looked into event log, but didn't find any good information then I found below error from SharePoint Logs.

Error into log file:

Application error when access /_layouts/Checkin.aspx, Error=Value does not fall within the expected range.   at
Microsoft.SharePoint.SPFieldCollection.GetFieldByInternalName(String strName, Boolean bThrowException)     at
Microsoft.SharePoint.SPFieldCollection.GetFieldByInternalName(String strName)     at Microsoft.SharePoint.SPListItem.get_MissingRequiredFields()     at
Microsoft.SharePoint.ApplicationPages.Checkin.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 


By looking at the error, I thought that issue was only because of meta fields column name and as we know internal name and display name is different for each column, I also found on the internet regarding same error saying that its because of  misspell name attribute into schema.xml file.

Then by looking and comparing each field I have found out that, by mistaken I added one extra equal(=) to end of my field name, by correcting my column name, my problem gets resolved and was able to successfully check-in document from SharePoint interface also.

SharePoint Logs – Tracing service lost trace events

Some time, my SharePoint logging didn’t work properly for some reason, if I looked into my SharePoint Logs directory then in every generated log file, I have found below lines.

Date and time        wsstracing.exe        (0x07E4) 0x1634         ULS Logging  Unified Logging Service uls1        Monitorable              Tracing Service lost trace events.           Current value 8.


I need to restart my logging service, SharePoint uses "Windows SharePoint Services Tracing" service for writing logs into ULS logs, so I went to services and restarted my "Windows SharePoint Services Tracing" services, once I did that, a new logs was created into SharePoint logs file. I also found out that might be this errors showed due to upgrade of service pack 1.

Tuesday, November 18, 2008

Crawling of PDF document from SharePoint search

I had issue while crawling of our SharePoint sites, I was getting error for the outlook message file in which there were embedded PDF document.

Errors which I was getting into crawl log:
1. The filtering process could not be initialized. Verify that the file extension is a known type and is correct
2. Error HRESULT E_FAIL has been returned from a call to a COM component.

I have found on the internet that I have to install extra filter into server which will search and crawl for PDF files, there are 2 free filters available. One is from Adobe Ifilter 6.0 and one from Foxit Filter.

I tried to play with both filter but I was getting error into PDF and message file, I know, I was missing in some little configuration and installation of something.

At the last, I have found one very good and important link, as per that link, Adobe has not created any separate iFilter for PDF file types after Adobe Reader 7 version.

So they suggested us to installed Adobe Reader 8 or reader 9 version into our server, because after reader 7, Adobe package iFilter functionality into same software as plugs-in.

So after doing configuration from below links, I got the success, now I am able to crawl message file and PDF documents from the SharePoint sites.


Good Reference Links. (all about Adobe PDF IFilter v6.0) (Different products from Adobe) ( How to install Adobe filter) (Manual for Foxit Filter)

Monday, November 10, 2008

Block specific file types while uploading from SharePoint interface

One easy way:

We can block specific type of files from entering file extension into “Blocked File Types” from the SharePoint Central Admin Site -> Operations-> Security Configuration.

We can select specific web application for blocking or not allowed file types/extension list.
Other way:

We can also do programming and modify current Upload.aspx page, we can write simple JavaScript by checking file extension and content type when user is uploading any file and then we can give alert to user if its not valid file type or extension type for uploading into SharePoint.

Friday, November 7, 2008

How to add new managed property and customize advanced search page

We can customize search and advanced search page, by adding properties to it, generally all columns which we created into site comes in crawl properties when we do FULL CRAWL of the SSP. So then after we have to create new managed properties from going to SSP->Search Settings, we have to mapped crawl properties to manage properties and we can use those all managed properties into customization of advanced search page by adding “Properties”  into it.

You can find all these stuff from below links

How to add property into advance result page

MOSS Faceted Search

From last some time, I am working in Search Functionality in SharePoint, we have installed “Search 2.5” into our server, and it gives us more ready to use web part functionality like search facets, caching, stemming and many more.

You can download faceted search 2.5 from codeplex by below link.

We have also installed SharePoint Infrastructure Upgrade patch, it includes Federated Search like we can easily view and capture our search data from SharePoint SSP Screen.

Till now, I did all things from SharePoint GUI only, not SharePoint Search object model, it has also many search library through which we can code our own specific search functionality, through SharePoint GUI, we can also customize functionality by changing respective web part configuration XML file.

I will give you updates regarding same on regular basis.

Tuesday, November 4, 2008

Conflict into SharePoint version

One time, I had problem while installation of MOSS 2007, my installation was corrupted due to some problem, so I was not able to repaired, every time I was getting error when I run “SharePoint Products and Configuration Wizard” from the interface.

I find the below solution, If we run below psconfig command from command prompt then will able to install SharePoint successfully without any version confliction.

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\BIN>
psconfig -cmd upgrade -inplace b2b -wait -force

SharePoint Products and Technologies Configuration Wizard version 12.0.6217.1000
Copyright (C) Microsoft Corporation 2005. All rights reserved.

Performing configuration task 1 of 4
Initializing SharePoint Products and Technologies upgrade...

Successfully initialized SharePoint Products and Technologies upgrade.

Performing configuration task 2 of 4
Initiating the upgrade sequence...

Successfully initiated the upgrade sequence.

Performing configuration task 3 of 4
Upgrading SharePoint Products and Technologies...

Successfully upgraded SharePoint Products and Technologies.

Performing configuration task 4 of 4
Finalizing the SharePoint Products and Technologies configuration...

Successfully completed the SharePoint Products and Technologies configuration.

Total number of configuration settings run: 4
Total number of successful configuration settings: 4
Total number of unsuccessful configuration settings: 0
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of the SharePoint Products and Technologies has succeeded.

Monday, November 3, 2008

Unable to connect to database. Check database connection information and make sure the database server is running

In the morning, we were getting below production issue in all SharePoint Sites.

Problem: Users getting errors saying that "Unable to connect to database.  Check database connection information and make sure the database server is running"

The SharePoint Farm appeared to have a login issue with the Database Server. The following error was noticed on the Database Server Event Type: Error
Event Source: NETLOGON
Event Category: None
Event ID: 5719
Date: 10/27/2008
Time: 9:36:22 AM
User: N/A
Computer: SQL DB Server Name
This computer was not able to set up a secure session with a domain controller in domain AD due to the following:
There are currently no logon servers available to service the logon request.
This may lead to authentication problems. Make sure that this computer is connected to the network. If the problem persists, please contact your domain administrator.
If this computer is a domain controller for the specified domain, it sets up the secure session to the primary domain controller emulator in the specified domain. Otherwise, this computer sets up the secure session to any domain controller in the specified domain.

Resolution: one of my colleague just logged into our Database server with SharePoint service account to verify the account was not locked out.  He was able to log in without error.  Almost immediately after logging in, the Database Connectivity issues started to clear up and we were able to open all SharePoint site and central admin site without any the errors.

We didn’t figure out the exact root cause for the issue, because we already looked into SharePoint Log, event log  and database log, but at the last, we found that in some particular time of period there were problem with SharePoint AD service account, and by just logging into server, it gets resolve.

I’ll update you, if we find the root cause for the problem.

Thursday, October 23, 2008

Integration and Configuration of Microsoft Dynamics GP 10.0 for SharePoint Server 2007

Microsoft Dynamic GP provides financial management functionality that includes general ledger, accounts payable, and accounts receivable modules to bank reporting, cash flow management, and reconciliation. It’s like ERP software.

Dynamic GP 10.0 has same look and feel like Microsoft Office Outlook and it also extend its business functionality through Microsoft Office SharePoint Server 2007, SQL Reporting Services, Web Services, BizTalk, Microsoft Office Excel, and Microsoft Office Word.

After integrating Dynamics GP 10.0 with MOSS 2007, users can access and analyze data from Dynamics GP and from any other application. User can easily create and deploy Office Excel reports to SharePoint Server.
Dynamic GP can export all their excel reports to SharePoint site in data connection and report library, when we are installing Dynamic GP 10.0, one installer/connector or utility is come with Dynamic GP which will helpful for connecting Dynamic GP SQL Server database and exports all company or specific company records to SharePoint site and create data connections and report library into given SharePoint site.

Steps for integrating and configuring Dynamic GP 10.0 to SharePoint site for excel reports which will be displayed into excel services.

1.    Click on connector installer for Microsoft.Dynamics.GP.BusinessIntelligence.MossDeployment and first select Data Connection checkbox for Microsoft Dynamics GP, it will deploy to SharePoint server.

2.    Enter Dynamic GP Database server name and credentials for accessing database server.

3.    Select the respective Dynamic GP Databases, which we want to deploy to SharePoint server.

4.    Give the SharePoint site URL and Data connection and Report Library name in which are data connection and report will be deploy.

5.    Now follow same step from step No 1 for creating excel reports for the Microsoft Dynamic GP data, first we have created Data connection, because before creating excel reports, it require connections. Follow same step from 2 to 4.

After doing above process, it will create data connection and reports into SharePoint site into Data Connections and Report Library as per below screenshot.

Now we can open Report Library and open excel reports into excel services of the SharePoint site.

Tuesday, October 21, 2008

SharePoint Security model

I have found some useful information related to SharePoint security from below links. (How to break inheritance and create unique security model from object model, also see second part of current blog) ( security improvement in MOSS, how to create security model for internet, intranet and extranet sharepoint site) (SharePoint and .NET security model) (All about SharePoint security framework)

Monday, October 20, 2008

SSRS 2005 deployment to FBA enabled MOSS site

I was having problem to deployed SSRS 2005 Report Model from visual studio to SharePoint Integrated mode with Forms Authentication enabled on MOSS site. It gives an error message "A connection could not be made to report server "http"//<sharepointservername>/"

Though, I was successfully able to deploy SSRS 2005 Report Model from visual studio to SharePoint Integrated mode with Windows Authentication enabled on MOSS site.

I installed SharePoint 2007 server, SQL server 2005 Developer Edition with sp2 and also applied hotfixes from Microsoft for reports to work with Forms Authentication.

I also worked with Microsoft Support team and I tried to find the resolution, at the last I came to one common point that its design limitation of SharePoint and sql server, so Microsoft support team told me that because of security reason, it has been designed that way only.

Few people already notice this bug and some of them get the temporary patch/fix from Microsoft but its not permanent solution, Microsoft is saying that this problem will resolved with SQL Server SP3.

Reference link :

Fetch list item using SPQuery

One of my friend has one scenario in which he has to change display text of one of the column of
Data Grid web part and Back color of Submit button quickly without much changes into code, so for finishing task quickly he approach below steps.

Normally we can keep all configuration values of project in web.config file to avoid deployment in small change cases.

The second way to do it is to keep these values in SharePoint List (values like Some display name
(webpart title, column header text, etc), color).

Example :

I have list with following 4 columns : Title, ElementID, Language, ElementType

In code, we can get any parameter value by calling the following function :

string webPartTitle = queryForName("ContractDetails_WebPart","WebPartTitle", "en").ToString();

This is very helpful technique in terms of small display changes because it removes overheads of going in the code again and deploying again.

public static string queryForName(string Keyword, string Type, string Language)
string Name = string.Empty;
SPWeb currentWeb = SPContext.Current.Web;
SPList elementList = currentWeb.Lists[_ElementList];
string queryString = "<Where><And><And><Eq><FieldRef Name=\"ElementID\" /><Value
Type=\"Text\">" + Keyword + "</Value></Eq><Eq><FieldRef Name=\"ElementType\" /><Value Type=\"Lookup\">" + Type +"</Value></Eq></And><Eq><FieldRef Name=\"Language\" /><Value
Type=\"Lookup\">" + Language + "</Value></Eq></And></Where>";

SPQuery query = new SPQuery();
query.Query = queryString;
SPListItemCollection results;
results = elementList.GetItems(query);
int itemsReturned = results.Count;

if (itemsReturned == 1)
foreach (SPListItem result in results)
Name = result[_ElementContent].ToString();
Name = "";
return Name;
catch (Exception ex)
return Name;

Saturday, October 18, 2008

Custom Themes in MOSS 2007

Steps to creating custom themes in MOSS 2007

1. Explore to the Themes folder e.g. LocalDrive:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\Themes

2. Make a copy of one of the existing theme folders and rename it e.g. MyCustomTheme.

3. Rename the .INF file which is in the MyCustomTheme folder to MyCustomTheme.INF

4. Edit MyCustomTheme.INF.

1. At the info section, Change the title, to “Custom Site Theme”.
2. In the titles section, rename the names to your new name. This section is to present the name in the different language.

5. Provide an image to give a preview of your theme.
This image should be placed in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES. E.g. MyCustomThemelogo.gif

6. Modify the c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\Layouts\1033\SPTHEMES.xml to include a reference to the new MyCustomTheme theme

<DisplayName> MyCustomTheme</DisplayName>

<Description> Apply this Theme for applying MyCustomThemelogo and unique colors and fonts styles.

<Preview>images/ MyCustomTheme.gif</Preview>

7. Modify the CSS within MyCustomTheme folder to personalize your theme.

8. Run iisreset from the command prompt

Apply the new theme "MyCustomTheme" to a site by click on SiteActions -> SiteSettings -> sitetheme.

Now Select the newly created theme and click on apply and you can see new look of your site according to you theme.

SharePoint Custom Actions

I came across requirement of customizing out of box SharePoint pages (like create.aspx, spcf.aspx, qstnew.aspx) to fulfill client need to add functionality or custom code in those pages.

Generally we are making copy of those pages for making changes and add custom link on page from where it’s getting called.


If you are required to override the Web Part Page/Survey Creation Page (spcf.aspx/new.aspx) then you have to add link under particular Group in Create.aspx page. This you can achieve without writing any code in create.aspx by creating Feature using Custom Actions.

SharePoint provides so many defaults Custom Actions which we can use as per our creativity.

Code example: To add custom link in Site Actions Menu which takes user to custCreate.aspx page.

Id = "RepLetterCustCreatePage"
Title = "Custom Create"
Description = "Add a new library, list or web page to this website using custom Create Page."
GroupId = "SiteActions"
Location = "Microsoft.SharePoint.StandardMenu">

<UrlAction Url="~site/_layouts/custcreate.aspx"/>


Example :

I also added custom link into SharePoint Central Admin Site into Operation TAB, on clicking of new added link, I am opening my ASPX page from Central Admin site.

Element file look like:

<Elements xmlns="">

Title="Custom Security"

Title="Termination Job">

<UrlAction Url="/_admin/TerminationJob.aspx"/>



One more thing, I remember that after developing feature, I was not able to see custom link into Central Admin site, I came to know that in feature file, where we are defining element manifest file, I use wrong tag for giving XML file location, we have to use


<ElementManifest Location="elementManifest.xml" />


I was using

<ElementFile Location="elementManifest.xml" />

Useful reference link for Custom Actions:

Disabling some file export options in Reporting Service

There are some options available in Reporting services to export reports.

If you want to disable few options from that list into all application on your server then you can make it visible false by editing one central config file named "rsreportserver.config"

You need to make visible false which ever extension you don't want in the list of export report.

But if you want to make this for only one particular application then you can write down below code into your application:

private void DisableUnwantedExportFormats()
foreach (RenderingExtension extension in ReportViewer1.ServerReport.ListRenderingExtensions())
if (extension.Name == "XML" || extension.Name == "IMAGE" || extension.Name == "MHTML"
|| extension.Name == "PDF" || extension.Name =="RGDI" || extension.Name == "XLTemplate"
|| extension.Name == "WordTemplate" || extension.Name == "HTML4.0" || extension.Name == "HTML3.2")
FieldInfo info = extension.GetType().GetField("m_serverExtension", BindingFlags.NonPublic |     BindingFlags.Instance);
if (info != null)
Extension rsExtension = info.GetValue(extension) as Extension;
if (rsExtension != null)
rsExtension.Visible = false;

Tuesday, October 14, 2008

SPListItem Class

In SharePoint object model, for document library, each item consider as SPListItem in code, like If I have one word document file and one folder then both comes under SPListItem class, but for differentiate purpose we can check SPListItem.ContentType.Name and compare with "folder" type or anything.

SharePoint Manager 2007 – Administration Tool

SharePoint Manager 2007 - Administration tool which will give one window interface to see all our farms web application lists and object model data.

It’s not like Avepoint tool, because Avepoint is used for taking backup, restore and scheduling all things, SPM 2007 don’t have this type of facility, but it’s give inner details of all farm web application, list, site collection and features also.

We can also change any value and that will reflect into Central Admin or web application level from SPM 2007.

There is one loop hole or bug into SharePoint Manager 2007 tool, it will display plain text password.
We can see password by opening tool and going to

ENT Farm Configuration -> Administration Service -> Web Application -> Click on web application name -> SharePoint Central Administration v3

Check properties into right side of window, it will show username and plain password field.

Difference between ASP.NET and windows form Drop down list/Combo box

There is difference between ASP.NET and windows form Drop down list/Combo box.

In ASP.NET drop down list, while adding items into drop down list, we can assign/add only List Item or string into dropdown list (dropdownname.Items.add)

In Window Combo box, we can assign/add object into controls.

So there might be limitation if we want to add Object into ASP.NET drop down list item by items.

If we are going to add ListItems in ASP.Net Dropdown by
Listitem itm = new ListItem and add that drpobject.Items.add(itm)

And if we are going to select particular item by drpobject.Items[1].selected = true

We will get error like "Multiple Items cannot select".

So if we do not want this item we have to add items like drpobject.items.add(new listitm(Displaytext,Value)) and we want to select some other values then we can also use
dropdown.clearselection() method.

Meta data information from SharePoint document

We can see meta data and content type information into document quickly by doing Right click on document “Properties” into file system, there will be tab called “Custom”, from this tab, we can see all meta data like same way we used to do “View Properties” from selecting document into SharePoint site.

Access denied error while installing feature

I was getting “Access denied” in command prompt when I tried to execute below command

Stsadm –o installfeature –name “featurename” –force


1. Log in user was not added into Central Admin Database security group into SQL Server.

2. Log in user has to be in farm administrator/site collection users group in SharePoint site.

By adding my current Log in users into above two parts, I was able to successfully install feature.

Monday, September 22, 2008

Audiences creation and compilation

With the help of audiences, we can target content to users based on their job or task, as defined by their membership security group, distribution list, and organizational reporting structure.

We can create Audiences from SSP - > Audiences -> create Audiences link.

Purpose of audience compilation:  when any new user is added into active directory at the same time, it will not add into audience group, so for reflecting and making synchronization with active directory, compilation is necessary.

Manual compilation of Audiences
1. go to SSP - > Audiences -> view Audiences link and select each audience name and click on compile

Scheduling compilation of Audiences
1. On the Shared Services Administration home page, in the Audiences section, click Audiences.

2. On the Manage Audiences page, click Specify compilation schedule.

3. On the Specify Compilation Schedule page, select Enable scheduling.

4. Select a start time in the Start at menu, as follows:
•To compile audiences at the same time each day, select Every day.
•To compile audiences at the same time once per week, select Every week on, and then select a day of the week
•To compile audiences once a month, select Every month on this date, and then select a day of the month.

Google Maps and MOSS

One of my friend has requirements to show Google maps into contact list for SharePoint site, so below are some of the links which will show how to integrate Google maps into SharePoint site.

Two things have to be considered.

1. We can use content editor web part and add JavaScript provided from Google

2. Has to generate or enter key from Google.

Reference links:

Tuesday, September 16, 2008

Hiding/Deleting Current Navigation(Left Navigation) from Document library

Below are some of the ways to hide/delete left side navigation from SharePoint Page.

1. Left side navigation bar has predefined placeholder into main master file, so if we open our master page into SharePoint designer and try to find navigation placeholder tag and removed that tag then left side navigation bar will not be displayed into any of site.

So removing place holder from master page will completely remove it for all child pages.

2. If we want to hide in some of the pages then we can override style and achieve result.

I. we have to Edit page in designer and unlock region and remove left navigation frame OR
II. We can put left navigation bar in child page and put nothing inside that tag OR
II. We can put
.ms-navframe{ display:none; }
</style> on page.

With any of the above steps, left side navigation bar will be removed/hide from pages or document library.

Sunday, September 14, 2008

Restoring SharePoint Site.

I was getting below error while executing follow steps.

1. Executed command for restoring SharePoint site.

stsadm -o deletesite -url %SITE% -deleteadaccounts false
stsadm -o restore -url %SITE% -filename %BACKUPFILE LOCATION%

Error: The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space.

Solution: I delete any unnecessary sites and also truncate logs for SQL database, so after that there was enough free space.

After this, I was able to restore SharePoint site successfully.

2. I had created new farm envirorment and trying to restore sharepoint site.

Error : Your backup is from a different version of Windows SharePoint Services and cannot be restored to a server running the current version. The backup file should be restored to a server with version '' or later.

Solution : I need to install/run infrastructure updates into my new created farm server, The Infrastructure Update contains the new Enterprise Search features that were shipped in Search Server 2008 and Search Server 2008 Express that were are not already in SharePoint Server 2007; this includes Federated Search capability, a unified administration dashboard and several Search core platform performance updates.

you can download updates from below location.

After doing installation, I was able to restore sharepoint site.

Monday, June 9, 2008

Installation of MOSS 2007 on Windows Server 2008

I have successfully installed MOSS 2007 on Windows Server 2008, but I found many blogs and material which says there are some features or things which will not work on Windows Server 2008.
Microsoft is also not giving any type of support call for Windows Server 2008 installation for SharePoint.

Pre-requisite for Installation of MOSS 2007 on Windows Server 2008

1. Install .NET framework 3.0

2. Install WSS 3.0 with SP1;amp;amp;clcid=0x409

3. MOSS 2007 with SP1.


1. In Windows Server 2008, there are many inbuilt software and framework, we have to use "Role Management Tool - Server Manager" and install .NET framework 3.0 on Windows Server 2008.

2. I was getting red color error when I start my central administration site, because I didn’t configure SSP.

3. While configuring SSP of office SharePoint search and WSS search - we have to give domain name\username into site, there are two type of admin user; one is for local system and one for domain admin user.

Many of my problems get resolved after using domain admin user credentials.

below are links which will be useful for installing MOSS 2007 on Window Server 2008.

One of my good friend (Hemen) give me above link, it has all process step by step, we can easily install MOSS 2007 by referring above link.;amp;amp;clcid=0x409

Thursday, May 8, 2008

Problems which I faced in projects

1. When I try to Import excel sheet data into custom list, at that time I was getting "'Method Post of object IOWSPostData failed' error and not able to import data.

Solution Steps : I thought its may be because of excel sheet size or any other problem, but its general error, so I have to make changes in one of the excel VB file as per below links, after that I am able to successfully import excel sheet into custom lis.

Solution Links :

2. When I try to change Page Navigation by editing at that time, I was getting error "The page has been modified by another author".

Solution Steps : This error comes due to migration of pages from one server to other server, like development to staging or production server, so some page contains old reference URL, I have to go manually each pages and remove old master and content pages reference links, below links also has some automatted utility which will convert broken links, But I don't have trust on same/

Solution Links :

Excel Services and Dashboard

Forms Based Authentication Links