Tuesday, September 20, 2016

Search Issue in SharePoint 2010: Chinese customers are getting search issue in SharePoint 2010

It's Microsoft Product issue...............................

Summary


Chinese customers are getting search issue in SharePoint 2010 farm


Issue Description


If you create a team site by specifying Chinese as default language and insert this word (0407-BSa-14) in a list, you are able to search it from Chinese and English language enabled machine.

If you create a team site by specifying English as default language and upload the same word (0407-BSa-14), you are unable to search it using Chinese language enabled machine but able to search it using English language enabled machine.

We believe that if the default language of the site is English, SharePoint crawler is using language based word breaker(as per default language of the site) while indexing the content for the site for which SharePoint is unable to search such keywords(0407-BSa-14) from Chinese language enabled machine. If it's searched from English language enabled machine, Search results are displaying.

We saw that when Chinese customers search the keywords which contains double hyphen (-), they are getting this issue.

Software Versions


SharePoint 2010: 14.0.7113.5000

Friday, September 16, 2016

Updating Active Directory User/Group profile information in SharePoint 2007 site

If you would like to update Active Directory User/Group profile information in a SharePoint 2007 site, you can use below commands to achieve this.

[Reflection.Assembly]::Load("Microsoft.SharePoint, Version=12.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c")

$site = New-Object -TypeName Microsoft.SharePoint.SPSite -ArgumentList http://sharePointsiteurl
$group = $site.RootWeb.SiteUsers["Domain\grouploginname"]
$group.Name = "Group Name"
$group.Email = "groupemail@test.com"
$group.Update()

Important Note: SID should match in both Active Directory and SharePoint for the user/group, otherwise the above steps will not work.

To check the SID of a group from Active Directory
Command: wmic useraccount where name='grouploginname' get sid

To check the SID of a group In SharePoint

Look for the User Profile database to get the SID of the group.

SharePoint Solution deployment failed due to locking of a DLL

During the solution Deployment in SharePoint, if you are trying to upgrade a solution and the deployment failed in any server in the farm, there could be a possibility that it is trying to overwrite on an existing dll and the same dll was being used or locked by existing process which was running in the server. So we need to find out which process is locking the dll ?

Solution: Open command prompt and run the following command

tasklist /m <thelocked.dll>

This will show all the processes that are currently using that dll and you need to restart the services for those processes.

If the above solution did not help, you may need to reboot the server.

How to find the site collections and their size in a content Database in SharePoint 2010 ?

Use the below PowerShell Command to find the site collections and their size in a content Database.

Get-SPSite -Limit All -ContentDatabase ContentDBName | select url, @{label="Size";Expression={$_.usage.storage}} 

Search from SharePoint Logs in SharePoint 2010

SharePoint logs are generated in all servers in a farm. So if you would like to find the log for your application issue, you need to look into all servers in the farm. Then you do not need to open ULS log file from each server rather you can use Merge-SPLogFile powershell command in one server to get the ULS logs from the entire farm and investigate it. 

Examples:

  • Get the logs for the correlation id between the time range

Merge-SPLogFile -Correlation "E0BB34790-4523-A353-046F-ABCD454E24D4" -StartTime "06/23/2015 17:10" -EndTime "06/23/20 17:15" -Path "e:\Sam\FarmMergedLog.log"

  • Get the logs for the message 'deadlock' between the time range

Merge-SPLogFile -Message "*deadlock*" -StartTime "06/23/2015 17:10" -EndTime "06/23/20 17:15" -Path "e:\Sam\FarmMergedLog.log"

Once the Merge log file got generated and you can open in ULS Viewer.

One more interesting thing is that you can also filter log files by specifying 'second' duration in the command. This is really required as thousands of logs generated in a minute. 

Example: Get the logs between the time range

Merge-SPLogFile -StartTime "06/23/2015 17:10:15" -EndTime "06/23/20 17:10:45" -Path "e:\Sam\FarmMergedLog.log"

To know more in details please refer the below link

http://technet.microsoft.com/en-us/library/ff607721.aspx

Unable to upload files in SharePoint site for RBS enabled farm.

Issue:


I was unable to upload files larger than 5MB (as per the rule set in DocAve console) in SharePoint site for RBS enabled farm.

Analysis and Solution:


Stub database for the web application was renamed after execution of MoveStub (Site collection move) command for which we could not open the files. Normally it should rename the database back to its original state after successful execution of that command, but it did not. So we have to manually rename the database name to actual name, then documents started opening without any issue.


Also there are few WFE servers where we still unable to upload files, to fix that you may need to restart the DocAve Agent service (in services.msc) in the respective WFE servers.

Hope it helps !

Quota Increase process for RBS/Non-RBS enabled Farm in SharePoint 2010 using DocAve 6.0 ?

If you would like to increase the quota of a site collection, you should consider the below cases and recommended solutions.

  •  If the site collection quota request is for 50/100 GB?
o   You should create a new content database.
o   Move the site collection to new content database.
  • If the site collection database is having more than expected site collections?
o   You should create a new content database.
o   Move the site collection to new content database.
  • If the SQL instance for the site collection database is having low space in SQL server drives?
o   You should create a new content database in a different SQL instance where you have plenty of space.
o   Move the site collection to new content database.

Steps for Moving the site collection to new content database for RBS enabled Farm using DocAve 6.0

  •  Move the site collection to new content database in the same SQL instance
o   You need to open AgentToolSP2010MoveStub tool of DocAve 6.
o   Run –MoveSPSite command to move the site.
  Examaple: -MoveSPSite [Site Collection URL] [DestinationDatabaseName] [SourceRBSProvider] [DestinationRbsProvider]

  • Move the site collection to new content database in a different SQL instance
o   Take the backup the site from Source database using SharePoint Native command.
o   Enable RBS and configure rules in the destination database

o   Restore the site in the destination database using SharePoint Native command.