kwizcom banner advertisement

Install and Configure Office Web Apps for SharePoint 2010

7:09 PM    , , ,
Introduction: Office Web Apps is introduced for the benefit of remote users who don't have Microsoft Office installed in their machines. This implementation guide walks through step by step on: Installing and Configuring Office Web Apps in SharePoint 2010. Steps Overview To install office web apps in SharePoint 2010, it takes these three steps: Install   Office Web apps binaries & run products and technologies configuration wizard Start the Office web apps services & create service applications Activate the Office web apps in site collections Important When installing on a SharePoint farm (not a standalone installation), you will need to install Office Web Apps on every server. You can load balance and install Office Web Apps on multiple servers to optimize performance. Service accounts you use need to have read/write access to the SharePoint Configuration database and all content databases that house the site collect
Install and Configure Office Web Apps for SharePoint 2010 Install and Configure Office Web Apps for SharePoint 2010 Reviewed by Salaudeen Rajack on 7:09 PM Rating: 5

Search Error 10032: Could not create a database session. Context: Application {GUID} Details: The database connection string is not available

2:58 PM    , , , , ,
SharePoint 2007 Search on a specific WFE returned " Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information ." while in other WFEs search worked perfectly. This happened after I stopped the search service on a specific server and started it on another server in the Farm. Examined the event logs and found the error: Could not create a database session. Context: Application {GUID} Details: The database connection string is not available  Fix:   Exported the registry key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\{GUID}] from the WFE where search works, and imported to the problematic server. Which was something like: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\19d466e6-f04b-40b5-b9fa-525791e7fb50\ResourceManager] "Data"="Server=SQLServerName;Database=SharedServices1_Search_DB;Trusted_Connection=yes;App=Wind
Search Error 10032: Could not create a database session. Context: Application {GUID} Details: The database connection string is not available Search Error 10032: Could not create a database session. Context: Application {GUID} Details: The database connection string is not available Reviewed by Salaudeen Rajack on 2:58 PM Rating: 5
SharePoint Web Services - Test Mode SharePoint Web Services - Test Mode Reviewed by Salaudeen Rajack on 12:45 AM Rating: 5

PSConfig Wizard Configuration Failed: An Update Conflict has occurred, and you must re-try this action. An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown

7:48 PM    , , , ,
During Service pack 3 patching on MOSS 2007, SharePoint Products and Technologies Configuration Wizard ended with Error: Configuration Failed " An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown ", An Update Conflict has occurred, and you must re-try this action. Checked the Update Log file: There is a log event with " An update conflict has occurred, and you must re-try this action. The object SPFarm Name=<Config-DB-Name> is being updated by <Farm-Admin-Account>, in the STSADM process, on machine <Server-Name>.  View the tracing log for more information about the conflict ." Solution : Clear config Cache as per Microsoft KB: http://support.microsoft.com/kb/939308/ and run the PSconfig wizard again! Try Runing: stsadm -o setproperty -propertyname command-line-upgrade-running -propertyvalue no   and then PSConfig -cmd upgrade -inplace b2b –wait -force
PSConfig Wizard Configuration Failed: An Update Conflict has occurred, and you must re-try this action. An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown PSConfig Wizard Configuration Failed: An Update Conflict has occurred, and you must re-try this action. An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown Reviewed by Salaudeen Rajack on 7:48 PM Rating: 5

SharePoint Configuration wizard stuck and never ending when applying service pack. "SyncUpgradeTimerJob: sleeping for 10 seconds" in Upgrade.log

7:09 PM    , , ,
I was doing a SharePoint 2007 SP3 upgrade, After installing the binaries, I ran SharePoint Products and Technologies Configuration Wizard. The wizard runs through and then gets stuck on "Performing configuration task 8 of 9". It hung for 8 hours! I looked in the upgrade.log, The log was full of thousands of “SyncUpgradeTimerJob: sleeping for 10 seconds” messages. Here is what I did to fix: Killed the wizard first! Stopped and set the start up type as manual for these services in services.msc console.      World wide web service      Microsoft Single Sign-on Service     Windows SharePoint Services Search Restarted "SharePoint SharePoint Services Timer" and "Windows SharePoint services Administration" Services Then tried upgrading from the command line           psconfig.exe -cmd upgrade -inplace b2b -force command executed in 30 min and upgraded successfully! Refer this link to Troubleshoot common Errors during patching: http://supp
SharePoint Configuration wizard stuck and never ending when applying service pack. "SyncUpgradeTimerJob: sleeping for 10 seconds" in Upgrade.log SharePoint Configuration wizard stuck and never ending when applying service pack. "SyncUpgradeTimerJob: sleeping for 10 seconds" in Upgrade.log Reviewed by Salaudeen Rajack on 7:09 PM Rating: 5

Do not delete Files in "C:\Windows\installer" On SharePoint Servers

2:10 PM    , , , ,
Never delete the Install cache folder %windir%\installer to free up some disk space. This will cause serious problems during service pack upgrades!  In one of my case, It happened. Installer folder was deleted and when I tried installing the Service pack 2 , It scolded me with this error: "The detection failed, this can be due to a corrupted installation database." Workaround is: I copied the files inside Installer cache from other SharePoint server and ran the upgrade again. It worked! Update: Found these articles to collect the Install cache from other servers and update the failed server: http://moss2007.kbnk.info/Patching/solved-the-detection-failed-this-can-be-due-to-a-corrupted-installation-database.html http://social.technet.microsoft.com/Forums/en/sharepointadmin/thread/cfa66cd3-2aa2-44ee-9393-ffae41d4f70c
Do not delete Files in "C:\Windows\installer" On SharePoint Servers Do not delete Files in "C:\Windows\installer" On SharePoint Servers Reviewed by Salaudeen Rajack on 2:10 PM Rating: 5

The secure sockets layer (SSL) certificate sent by the server was invalid and this item will not be crawled - SharePoint Search Error

4:50 PM    , , ,
When starting the full crawl of the default content which includes HTTPS sites, I received the error: "The secure sockets layer (SSL) certificate sent by the server was invalid and this item will not be crawled." Its because one of the site was SSL enabled and Index server is not configured to Trust the site. Solution: Go to "Central Administration > Application Management > Manage Search Service > and click on Farm Level Search Settings. Scroll to the bottom of the page, under the SSL Certificate Warning Configuration section, select the "Ignore SSL certificate name warnings" and click OK. Same can be done by clicking "Proxy and timeouts" link in Search Administration of SSP. Technet article: http://technet.microsoft.com/en-us/library/cc262907%28office.12%29.aspx For SharePoint 2010: http://technet.microsoft.com/en-us/library/ee792873.aspx
The secure sockets layer (SSL) certificate sent by the server was invalid and this item will not be crawled - SharePoint Search Error The secure sockets layer (SSL) certificate sent by the server was invalid and this item will not be crawled - SharePoint Search Error Reviewed by Salaudeen Rajack on 4:50 PM Rating: 5

Call web service from Nintex Workflow - To Copy List item between Site Collections

5:17 PM    , ,
Requirement: Copy a List item between site collections. Oops! Nintex doesn't has any direct method to do that. It offers Copy/Move/Create list items with in Same site, but not between site collections. So, Lets seek help from Web services with Nintex. Lets say, I've a Source-list and Target-List. What I want is: based on some conditions, copy the item from source list to target list. Here is the Nintex's part. Drop a Call web service action in Nintex workflow              2. Get the web services from the target site, e.g: http://SharePoint-Site.com/_vti_bin/Lists.asmx , and then configure the action as per the below picture     So, Look at the highlighted sections. Here you have to specify the GUID of the target list and supply the XML data for values.  <Batch OnError="Continue">      <Method ID="1" Cmd="New">               <Field Name="Title"> {ItemProperty:Title} </Field>           
Call web service from Nintex Workflow - To Copy List item between Site Collections Call web service from Nintex Workflow - To Copy List item between Site Collections Reviewed by Salaudeen Rajack on 5:17 PM Rating: 5

The expected version of the product was not found on the system - Error when trying to Install SharePoint Service pack

2:57 PM    , , , , ,
Usually, This error occurs when we miss some in-between updates. e.g. I Installed MOSS 2007 SP1 + Language Pack SP1, then Installed MOSS 2007 SP2 without Language pack and when I tried installing Oct-2009 CU, I got this error. Apparently we need to download and Install both the WSS and MOSS updates along with their language packs separately. Once I installed SP2 for the WSS and MOSS Language Packs, the update installed just fine. What if none of the above works? In case, If you installed all the updates along with their language packs, and still getting this error, then you can by-pass the version check by providing " PACKAGE.BYPASS.DETECTION.CHECK=1 " parameter to the installer. e.g. run the installer from command line as: " wssv3lpsp2-kb953338-x64-fullfile-en-us.exe PACKAGE.BYPASS.DETECTION.CHECK=1 " You can download the MOSS 2007 service packs from: http://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx
The expected version of the product was not found on the system - Error when trying to Install SharePoint Service pack The expected version of the product was not found on the system - Error when trying to Install SharePoint Service pack Reviewed by Salaudeen Rajack on 2:57 PM Rating: 5

Open with Windows Explorer Error: "Your client does not support opening this list with windows explorer"

10:33 PM    ,
Some of the end users got the following message when trying to open a SharePoint Document Library in explorer view from Windows 7 / Windows Server 2008. Error : "Your client does not support opening this list with windows explorer" Try these solutions:  As of now, This feature is available only in IE 32 bit. (Not in 64-bit internet explorer, Google chrome, Firefox) Try this hot fix: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15123 after the fix, if SharePoint prompts for credentials, then implement this fix as well: http://support.microsoft.com/kb/943280/en-us Try this hot fix: http://support.microsoft.com/kb/841215   If you have IE 10, Try: http://support.microsoft.com/kb/2846960   Enable "Desktop Experience" pack in case of Windows 2008 http://technet.microsoft.com/en-us/library/cc772567.aspx Check the path of the folder in which you are trying to upload. It should not exceed the 100 character limit. (In IE6 espe
Open with Windows Explorer Error: "Your client does not support opening this list with windows explorer" Open with Windows Explorer Error: "Your client does not support opening this list with windows explorer" Reviewed by Salaudeen Rajack on 10:33 PM Rating: 5

How to send E-Mail using SPUtility.SendEmail

8:40 PM    , , ,
SharePoint SPUtility class has SendEmail method which is used to send email to any email address. By default, SPUtility.SendEmail() method picks the 'From address' from Outgoing E-Mail Settings in Central administration. Use SPUtility.IsEmailServerSet method to check if server is configured with SMTP mail settings. Here is a C# Example for sending E-mail using SPUtility.SendEmail: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using System.IO; using Microsoft.SharePoint.Utilities; using System.Collections.Specialized; namespace HideUserInfo { class SendEMail { static void Main(string[] args) { using (SPSite oSPSite = new SPSite("https://sharepoint.com")) //Site collection URL { using (SPWeb oSPWeb = oSPSite.OpenWeb("News")) //Subsite URL { Str
How to send E-Mail using SPUtility.SendEmail How to send E-Mail using SPUtility.SendEmail Reviewed by Salaudeen Rajack on 8:40 PM Rating: 5

Windows SharePoint Services Web Application - Stuck at "Starting" Status

5:49 PM    , , , , ,
I had this trouble after applying Service pack 3 on an existing MOSS 2007 environment: Windows SharePoint Services Web Application stuck at "Starting" status and yet it never starts! Solution: Stsadm command to stop windows SharePoint services web application stuck on stopping Jump started to STSADM to stop the service: stsadm -o provisionservice -action stop -servicetype SPWebService Did IISReset After that I could start it either from command line or from central admin. stsadm -o provisionservice -action start -servicetype SPWebService Please note: Stopping the Windows SharePoint Services Web Application will remove the virtual directories in IIS, reverts the web.config changes, etc. So, we have to apply the customizations once it started again.
Windows SharePoint Services Web Application - Stuck at "Starting" Status Windows SharePoint Services Web Application - Stuck at "Starting" Status Reviewed by Salaudeen Rajack on 5:49 PM Rating: 5

404 Page Not found on Checked Out Files

8:12 PM    ,
An end-user sent a mail along with SharePoint Document's URL to another user. When receiver tried accessing the document, it resulted "404 Page not found" to him. However the sender is able to access the document successfully! When I tried with Farm Admin access, even I got "404 Page not found", after an hour of going crazy, found the document was checked out by the sender! Get into the Document Library settings, Manage Checked out files, and then took the ownership of the file, checked it in. Solved the issue. In another case, this issue came up again. End-user received "The Specified name is already in use" since another file checked out has had the same name!
404 Page Not found on Checked Out Files 404 Page Not found on Checked Out Files Reviewed by Salaudeen Rajack on 8:12 PM Rating: 5

Incoming E-Mails with Attachments Failed - "Message size exceeds fixed maximum message size"

4:10 PM    , ,
In Nintex workflows, some of the alert mails were failed! further investigating found this issue happens only on notification mails with attachments of 1MB+. Moreover, There was a event logged in Event Log: System.Net.Mail.SmtpException: Exceeded storage allocation. The server response was: 5.3.4 Message size exceeds fixed maximum message size. Checked the Exchange Server Message size limits, It was 20MB but still unable to send mails with 2MB! After bit googling, found the issue: SMTP Server settings.  After increasing the Message Size & Session Size, everything turned to good.
Incoming E-Mails with Attachments Failed - "Message size exceeds fixed maximum message size" Incoming E-Mails with Attachments Failed - "Message size exceeds fixed maximum message size" Reviewed by Salaudeen Rajack on 4:10 PM Rating: 5

The start address is not valid for this content source type

3:03 PM    , ,
Ever get this error when trying to add a content source in SharePoint Search? This is because of the option "Crawl everything under the host name of each start address" which will accept only the host names(like http://sharePoint.com) and not the Sub-site URLs(like http://sharePoint.com/sites/abc/default.aspx) If you enter http://sharePoint.com/sub-site/default.aspx and select "Crawl only the SharePoint site of each start address" then SharePoint will crawl from the top-level site of the given URL entered. Here SharePoint will crawl from http://sharePoint.com/ and all its sub-sites. Reference: http://technet.microsoft.com/en-us/library/cc262531(office.12).aspx
The start address is not valid for this content source type The start address is not valid for this content source type Reviewed by Salaudeen Rajack on 3:03 PM Rating: 5

Truncate and Shrink SharePoint Transaction Logs, Databases

5:19 PM    , , , ,
Some of the Transaction Logs and databases grown rapidly and on urgent basis I had to truncate the Log files on SharePoint Content Databases. Here is the SQL script to truncate and shrink SharePoint transaction log: Use <database_name> GO ALTER DATABASE <database_name> SET RECOVERY SIMPLE GO DBCC SHRINKFILE (Database_Log_Name, 1); GO ALTER DATABASE <database_name> SET RECOVERY FULL GO Important: Please note the <database_Name> and <database_log_Name> in above examples are logical names. This sets the recovery model to "SIMPLE" temporarily, Shrink the Log file and set back to "FULL" recovery model. After executing the SQL script to truncate transaction log in my SharePoint 2010, it recovered me considerable space now! Shrink SQL Server Database, Log Files from SSMS: Shrinking can be done from SQL Server Management Studio also. Go to SSMS >> Right click the target Database >> Tasks >> Shrink >> Files
Truncate and Shrink SharePoint Transaction Logs, Databases Truncate and Shrink SharePoint Transaction Logs, Databases Reviewed by Salaudeen Rajack on 5:19 PM Rating: 5

Office SharePoint Server Search is missing in Services on Server?

3:56 PM    , , ,
There is a requirement to transfer the Search Index role to another server in the farm in order to reduce the load on a particular server. So went to " Central Administration > Operations > Services on Server " I wondered, "Office SharePoint Server Search" is missing in Servers on the Server!!! This is because: When you install SharePoint, You have to choose "Complete" installation instead of "Web Front End". Unfortunately, There is no way to fix this other than: uninstall and Re-Install SharePoint on that particular machine. So be careful which option you're choosing, because after a wrong decision, I had to suffer here.
Office SharePoint Server Search is missing in Services on Server? Office SharePoint Server Search is missing in Services on Server? Reviewed by Salaudeen Rajack on 3:56 PM Rating: 5

SharePoint Farm Passphrase: What is that? How to Reset?

3:21 PM    , , , , ,
What is Farm Passphrase? Farm Phrase is a new security feature introduced in SharePoint 2010. When you need to join the new server to an Existing SharePoint farm, you need to enter this Farm Phrase password. While adding a new server via psconfig wizard, You have to enter the Farm's pass phrase, and then Click next to continue. Forgot Farm Phrase? You can Reset SharePoint Farm Passphrase! So, you are adding a new server to the farm and you are unable to remember that very important password? No problem! You can use PowerShell to reset the Pass Phrase. Currently there is no option to retrieve the farm's existing passphrase. To reset the forgotten farm passphrase, Run these commands to the server which is already connected to the existing Farm. Log-in to SharePoint server and go to Start > All Programs > Microsoft SharePoint 2010 Products > SharePoint 2010 Management Shell. right click the link and run as administrator. Next step:  at the PowerShell pr
SharePoint Farm Passphrase: What is that? How to Reset? SharePoint Farm Passphrase: What is that? How to Reset? Reviewed by Salaudeen Rajack on 3:21 PM Rating: 5

Consistent Top Navigation Menu across All site collections in SharePoint 2010

12:41 PM    , , , , , ,
Requirement: Display a consistent Top Navigation Menu for across site collections in SharePoint. We can fulfill this requirement by using custom sitemap providers in SharePoint. Here are the steps at high level Create your own sitemap file in Layouts folder Add a Site Map Provider in web.config file Add a SiteMapDataSource to your master page change the SharePoint menu's datasource to your custom SiteMapDataSource Lets start building SharePoint 2010 common navigation across site collections. 1. Create your own sitemap file in Layouts folder Modify the site map to match your navigation needs and save it with a .sitemap extension in a location accessible by your SharePoint farm. The _LAYOUTS directory is a great place since any site can get to that location (i.e. _/layouts/BPCorp.sitemap) Create the sitemap as per the following template code < siteMap >    < siteMapNode title ="Container" url ="" >    < siteMapNode ti
Consistent Top Navigation Menu across All site collections in SharePoint 2010 Consistent Top Navigation Menu across All site collections in SharePoint 2010 Reviewed by Salaudeen Rajack on 12:41 PM Rating: 5
Powered by Blogger.