Thursday, 7 June 2012

Converting URL to readable query string

Sometime we need to get the query string from URL when it's complex and has some character which we don't know how to map them.
Example: when you open SharePoint list for editing you will find URL like the below:

http://yourSiteRoot/English/News/Pages/Forms/AllItems.aspx?InitialTabId=Ribbon%2EDocument&VisibilityContext=WSSTabPersistence&SortField=%5fModerationStatus&SortDir=Asc&View=%7b4D9015AF%2d7ECD%2d4814%2dBAC9%2dAE402456253A%7d

if you want to map the query string to a meaningful URL you can use this site
http://www.albionresearch.com/misc/urlencode.php

I used it to convert my URL and below is the result:

http://yourSiteRoot/English/News/Pages/Forms/AllItems.aspx?InitialTabId=Ribbon.Document&VisibilityContext=WSSTabPersistence&SortField=_ModerationStatus&SortDir=Asc&View={4D9015AF-7ECD-4814-BAC9-AE402456253A}



it's very helpful, hope it helps you :)

Tuesday, 5 June 2012

Could not load file or assembly ‘RSSharePointSoapProxy'


ERROR:Could not load file or assembly ‘RSSharePointSoapProxy, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.

To Solve this Issue, Install the following reporting service add-in for SharePoint 2010.

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=622

Your backup is from a different version of Microsoft SharePoint Foundation -- Sharepoint 2010

while I was going to restore a SharePoint 2010 backup I got the below error

Your backup is from a different version of Microsoft SharePoint Foundation and cann't be restored to a server running the current version. The backup file should be restored to a server with version '4.1.6.0' or later.

and after searching I found the solution 
First, make sure that you have SharePoint SP1 installed
Second after installing SP1 you must run SharePoint Configuration Wizard because the SP1 installation is updating SharePoint but you need to run the configuration wizard to update the database with the new version of SharePoint.


I hope this post will be helpful for you.

Regards,
Ahmed Gamal

Backup and Restore SharePoint site



The best way to backup a SharePoint site is –
Stsadm –o backup –url -filename
And then at a later date you can restore the site using
Stsadm –o restore –url -filename

How to identify which version of SharePoint 2010 you have installed

this is a good link which will lead you to identify the version of SharePoint 2010 installed

http://nearbaseline.com.au/blog/2010/12/how-to-check-the-version-of-sharepoint-project-server-installed/

Sharepoint 2010 Configuration: Failed to create configuration database.

Sharepoint 2010 Configuration Wizard: Failed to create configuration database.

I had faced this problem while I was running SharePoint 2010 configuration wizard
Error:
Failed to create configuration database
and the type of exception was:  "Microsoft.Sharepoint.Upgrade.SPUpgradeException"

after long search I found the solution for my case:
http://iconraja.wordpress.com/2011/09/02/sharepoint-2010-failed-to-create-the-configuration-database/

after I downloaded and installed the mentioned tool the error was solved.
I think it add permission to some registry files related to SharePoint.


I found other suggested solutions that can be helped if the above one didn't fix your problem.

1. Edit in your SharePoint registry files
http://gopika-lasitha.blogspot.com/2011/02/failed-to-create-configuration-database.html

http://edwin.vriethoff.net/2008/02/01/microsoftsharepointupgradespupgradeexception-action-12010-of-microsoftofficeserver-searchupgradesearchserviceinstancesequence-failed/


2. Add “dbcreator” security role to the SharePoint admin user:
. Run Microsoft SQL server management studio
. Go to Security –> Logins –> –> Server Roles
. Check “dbcreator” role for the user
. Re-start SharePoint products configuration wizard.


Hope this helps you.