Thursday, March 05, 2009

Unable to add selected web part(s).

ERROR:
Assemblies that implement ASP.NET Web Parts and are installed into a partially trusted location, such as the bin directory, must be compiled with the AllowPartiallyTrustedCallersAttribute set for import to succeed.

SOLUTION:
Add [assembly:AllowPartiallyTrustedCallers] to AssemblyInfo.cs

REFER :
http://msdn.microsoft.com/en-us/library/system.security.allowpartiallytrustedcallersattribute(VS.71).aspx

Tuesday, February 10, 2009

Hiding Menu Items on SharePoint 2007 List

If your requirement is to hide any menu item in SharePoint list for e.g. "Connect to Outlook" or "Open with Access" etc. then "ToolBar Manager " feature in codeplex is of great help .
http://www.codeplex.com/features

There are additional features which are useful too. You can download the same from :
http://www.codeplex.com/features/Release/ProjectReleases.aspx?ReleaseId=2502#ReleaseFiles

Thursday, February 05, 2009

Configuring AJAX in ASP.NET

Here is the list of web.config entries requires for AJAX to work in ASP.NET App.

Delete all Items in SharePoint List

You might end up with this requirement quite often and and try top down approach for delete :
for (int count=0;count < itemCount ; count++)
{ itemcoll[count].Delete(); }

and bump into exceptions , well the other way to do it is bottom up delete

for (int count =itemCount-1 ; count>0 ; count--)
{ itemcoll[count].Delete(); }

SharePoint Utility Pack

If you are looking for a tool for Site Mangement with following features :

  • Recursively deleting sites
  • Create a list in multiple sites at once
  • Modifying field settings - some internal settings that you cannot modify in the regular interface, and the option to modify lists with the same name in multiple sites at once
  • Push a web part to multiple sites (a specific page in each site) at once
  • Manage list event hanlders (register and remove event handlers from lists)
Then you need to have this tool by Ishai Sagi

The event handler functionality has proven to be of great help to me.

Friday, January 30, 2009

Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'

Have you ever got this error while trying to run an ASP.NET 2.0  web application in same port containing SharePoint 2007 Portal?

If yes here is the fix :

Add partitionResolverType="" in your ASP.NET web.config file

e.g.
sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" partitionResolverType="" sqlConnectionString="data 
source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20"



Thursday, January 22, 2009

SharePoint List Rating Engine

In my previous post of rating i had mentioned the lack of rating in discussion board .
http://metahat.blogspot.com/2008/12/sharepoint-listcontent-rating-system.html

Thanks to http://www.codeplex.com/site/users/view/StephaneEyskens for updating the rating engine and incorporating it in the discussion forum control too.

You can get the same from http://www.codeplex.com/sptoolbasket

Friday, December 26, 2008

Migrating SharePoint /MOSS 2007 database from one Farm / DB to another Farm /DB

In case you are performing any one of these activities then you are looking at right blog :
1) Migrating Portal from One Farm to another Farm
2)Migrating Portal from Development/Test Server to Production Server

I would like to put this process in order to make other's life simpler.If you are performing these migration /move and facing these errors then you have to follow this blog :

ERROR 1 :
An unexpected error occurred while refreshing the shared object manager cache.
Reason: Object reference not set to an instance of an object.
Techinal Details:System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Office.Server.Administration.SharedResourceProviderStoreDependency.get_IsValid() at Microsoft.Office.Server.Administration.SharedObjectManager.Refresh()


ERROR 2 :
"The search service is currently offline. Visit the Services on Server page in SharePoint Central Administration to verify whether the service is enabled. This might also be because an indexer move is in progress. "

Process for Farm Migration

1)Back up Complete Farm using Central Administration (Central Administration > Operations > Perform a Backup )
2) Disconnect from existing Server farm using SharePoint Products and Technologies Configuration Wizard
3) Create New Farm using "SharePoint Products and Technologies Configuration Wizard" in desired DB server and Web Server
4)Most important STEP , if you miss this you will end up with all kind of search errors in world
Start all services in that server

  • Excel Calculation Services
  • Office SharePoint Server Search
  • Windows SharePoint Services Help Search
5)Restore farm back using Central Administration (Central Administration > Operations > Restore from Backup )


AFTER MIGRATION
Once you are done you might get this Error :
Following Web Part error in the page: “One of the properties of the Web Part has an incorrect format. Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again.”

Suggestion: The AppPool may not have appropriate permissions
Do this ,

  • GO TO Central Administration (Central Administration > Operations > Service Accounts)
  • Select Web Application Pool option
  • Select the Central Administration Web app from drop down
  • Provide Account ID to be used by web application

One More Pit Fall After Migration :

Infopath Managed form stops working . If you have Infopath Managed form in your site upload the same to (Central Administration > Application Management > Manage Form Templates )

Well these steps might help to make migration much simpler .

Also refer this excellent blog post for process with image depiction:
http://lkar.blogspot.com/2008/05/moving-moss-project-server-2007.html



Tuesday, December 16, 2008

SharePoint List/Content Rating System

I am working on rating system for SharePoint list and got this excellent sample in codeplex.


It seems to work great with Custom List, Issue List , Document library and Link list but unfortunately lacking the most important list (Discussion Board). 

Well i am still trying to figure out ways to integrate the same engine to Discussion Board , if i get something it will be soon in my blog.

Cheers
-Rags

What are Content Type IDs?

Excellent Article in order to understand Content Type IDs.

http://blogs.msdn.com/andrew_may/archive/2006/06/24/SharePointBeta2WhatAreContentTypeIDs.aspx

Monday, December 15, 2008

Redirecting to same Page ASP.NET

Simple concept but still pain in head if unable to figure out :)

  Response.Redirect("#"); 

Tuesday, December 02, 2008

Application synchronization failed for Microsoft.Office.Server.Search.Administration.SearchService..

ERROR:

Application synchronization failed for Microsoft.Office.Server.Search.Administration.SearchService.
Reason: Object reference not set to an instance of an object.


Resolution :
The following worked with me , i hate to say this but i have no clue what went wrong and why this started working .

In order to get search working i did the following steps and all other options didn't worked even given here in microsoft discussion group


  • Start the search using Central Adminsitration -> Operations -> Services on Server ->Click "Start" for "Office SharePoint Server Search "

  • Select only "Use this server for serving search queries". Provide credentials and Press "OK". This should atleast start the search service

  • Now go back go Central Adminsitration -> Operations -> Services on Server ->Click Link "Office SharePoint Server Search"

  • Select "Use this server for indexing content" too and provide credentials and Press OK

  • This was start indexer too

  • Now go forward and create a new SSP. Now you will see indexer available in dropdown


Hope it works for others too.

Monday, November 24, 2008

Backup / Restoring SharePoint 2007 Site from SQL Database

I got this excellent article on SharePointdogs for backup / restoring the SharePoint site from SQL DB :

http://sharepointdogs.wordpress.com/2008/07/30/content-migration-or-backuprestore-in-moss-2007/#comment-9

Here is one of defined approach which worked wonders for me :

USING SQL
Using SQL, Backup the SQL Content Databases which are required and Restore them to a new databases in the SQL and attach these databases to the new application.
(Briefly we can say that take your content db ‘Offline’ using the Central admin. Take the content database offline in SQL Studio (Take Offline context menu item). Copy your database mdf and ldf files to the new machine (the destination machine). Attach the copies on the new SQL server using SQL Studio. Add the copied content DB to the Web Application on the new machine using the Central Admin on the new web server.)
STEPS:
1)Find the content Database
These are listed under Central Admin->Application Management->Site Collection List
2) Backup the content database
You could alternatively detach it, and copy it. Just doing a backup in SQL Server 2005 Management studio is easier.
3) Restore content database to new server
Copy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the “options” tabof the restore dialog to get it to work. (Overwrite db).
4) Create Web App on new Server
Central Admin->Application Management->Create or extend Web App->Create New Web App.
5) Associate restored DB with new Web App
Central Admin->Application Management->
SharePoint Web Application Management->Content Databases->
Remove Content Database from your new web app.
Now use STSADM to add restored DB to this web app
c:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.
run this command from there.
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
6) Run ISSRESET from command prompt.

Tuesday, November 11, 2008

Setting RSS Update time limit in SharePoint 2007

My previous blog on RSS ended with a very un-satisfied note as i was still trying to find the way to set the update time for RSS feeds in SharePoint 2007 . I am glad i got it now. It was a setting in Site Collection Level . Here it goes :



  • Go to Site Settings

  • In Site Adminisration Section click on link RSS

  • Set the Time To Live(Minutes) filed with required refresh time



Outlook 2007 RSS feed not updating when Sync with SharePoint 2007 List

I had issue wherein my Outlook 2007 RSS was not updating once new data is added to the SharePoint List. After lot of brain damage it came to my notice that it starts working when i remove the "Update check box " as shown in figure below while adding the New feed.Well i am still working on actual issue and trying to understand how to define content feed publisher time limit.


Tuesday, November 04, 2008

Get Discussion List Items from SharePoint Discussion Forum

If you are trying to retrieve all the root items of the Discussion List this way , it's not going to work :
SPSite site = new SPSite("Site URL");
SPWeb web = site.OpenWeb();
SPList list1 = web.Lists["DiscussionListName"];

SPListItemCollection coll = list1.Items ;



Well Here is the right way of doing it :-)
SPSite site = new SPSite("Site URL");
SPWeb web = site.OpenWeb();
SPList list1 = web.Lists["DiscussionListName"];
SPListItemCollection coll =list1.Folders ;

Friday, October 10, 2008

This page has encountered a critical error. Contact your system administrator if this problem persists.

ERROR:"An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. "

Do you get this error in your sharepoint site ?

Just one bad day you come in to see that your main page is bombing due to this error with no proper clue .Well it happened to me and i had no idea what went wrong.After lot of research i found something.

I had "?" marks all over my web.config file , which even erased some of characters.

Solution :

Search for "?" in web.config and start fixing the character in the file. I would suggest replace the web.config (obviously retain the custom entry ) with working one , i replaced my web .config with a working one and Volla!!! it worked for me .

In short the culprit is web.config and not SharePoint installation.

Cheers!!!

If this helps do leave comments , i would like to know how many SharePointeers got into this issue. :-)

Wednesday, October 01, 2008

Restricting MySite Create Access in MOSS 2007

Ever thought of restricting the MySite creation access and to allow very few user to create there personal site ?
Then this is for you :

Open Shared Service Provider Administration Page and click on link as shown in image to specify the access level of users .

Do leave message if this helps you. It's good to know i am not the only one having this requirememt :)

Reference Architecture for AI-integrated Genomic Analytics on Oracle Cloud Infrastructure

 I have been thinking about writing this blog for some time. Genomics is a fascinating field and has potential to unlock so many hidden scie...