24 October, 2012

Unable to restore files/folders from Site Collection Recycle Bin: SharePoint


Issue:

When we try to restore we get the Error Message: Unable to restore ‘file name’.

Troubleshooting Steps:

Checked on the path from where the Folder was deleted and confirmed that it was not modified or deleted i.e. all the top-level folders/sites where intact to get to the folder.

Checked for the available quota on site.

All looked fine still unable to restore.
Resolution:

Checked the Doclib where the Folder had to be restored and found a folder named similar to the folder which was to be restored. Eg. RC PHASEQ4 as to RC PHASEQ3.

So, renamed the similar folder to something else and tried restore, It Worked. Once restored, reverted the renamed folder to original.

This theory is well supported by

If you have any queries/questions regarding the above mentioned information then please let me know. 
I would be more than happy to help you as well as resolves your issues, Thank you.
 

Excel calculation Services Fail to start : SharePoint


Issue: We noticed today that the Excel calculation services were not running and we were receiving an error as 


“An error has occurred. Please contact your system administrator if this problem persists."

The SCOM were throwing too many errors as

Alert: Error communicating with Excel Calculation Services
Source: spmwprodweb2
Path: spmwprodweb2.nam.nsroot.net
Last modified time: Alert description: Event ID 5240 from Source Office SharePoint Server on agent computer spmwprodweb2.nam.nsroot.net has triggered this Alert Description: There was an error in communicating with Excel Calculation Services 

There were no application logs in the event viewer related to these errors.

STEPS Performed to correct the issue:

1.       Stopped and started the Excel calculation service.
2.       Ran stsadm –o execadmsvcjobs 

Resolution

We had to switch the service role to another server so service was stopped at One Application server and Started on another Application server. 

If you have any queries/questions regarding the above mentioned information then please let me know. 

I would be more than happy to help you as well as resolves your issues, Thank you.


MCSE: Reinvented for the SharePoint and MCSE on Cloud

 Why MCSE:
  • Recognized globally as the standard for IT excellence
  • Validates deep expertise across broad solutions
  • Demonstrates up-to-date skills on changing technologies
MCSE: SharePoint Certification Overview
Microsoft Windows Server Certification Overview
SQL Server Certification Overview
Get Started with a Private Cloud Certification
Courtesy: Microsoft.com

SharePoint 2010 - Loading the Document Information Panel in MS Word throws a warning when 'Run ActiveX controls & PlugIns' for internet zone is set to 'Administrator Approved'


What is Document Information Panel in Microsoft Word?
A document information panel is a form that is displayed within the client application, and which contains fields for the document metadata. Document information panels enable users to enter important metadata about a file anytime they want, without having to leave the client application.

Document information panels are available in Microsoft Word 2010, Microsoft PowerPoint 2010, and Microsoft Excel 2010. For SharePoint documents, these client applications auto generate the document information panels for a document, based on the metadata schema of the content type assigned to the document.

Problem Description:
If a site falls in the intranet zone and the internet security setting “Run ActiveX controls and plug-ins” for the internet zone is configured to “Administrator Approved” and a user tries to create a new document within a document library, they gets the following warning

Microsoft InfoPath
One or more ActiveX controls could not be displayed because either:

Your current security settings prohibit running ActiveX controls on this page, or
You have blocked a publisher of one of the controls.

As a result, the page might not display correctly.

While troubleshooting the issue, I came across multiple resolutions as well as workarounds and would like to share with all of you.

Resolution
Option 1: Change the IE security setting from Administrator Approved to Enable for internet zone.

Option 2: Customize the Document Information Panel using InfoPath so you can modify the security setting in InfoPath from “Restricted” to “Domain” and re-publish the XSN back to your content type. This will now cause InfoPath to adhere to the “Local Intranet” security settings in Internet Explorer.

Note: Once you publish the Document Information Panel using InfoPath every user must have InfoPath installed on their machines for the Document Information Panel to display.

Option 3: Add the Managed Metadata Control to the list of approved controls. To do this there are two options:

Roll out the following registry modification to all users:

·         HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls
·         Create a new DWORD value that is the GUID for the Managed Metadata control, which is: {64247C52-5C34-4597-B2A3-17BF5617F17F}
- Set this value to: 0

How to reproduce the issue:

1)      Add site to intranet zone in Internet Explorer.
2)      Configure the “Run ActiveX Controls and PlugIns” settings to Administrator approved for the internet zone and enabled for intranet zone.
3)      Open a SharePoint 2010 site and then a document library that has at least one managed metadata column.
4)      On the ribbon, click on Documents and then New Document.
5)      Word opens, and then we get a warning dialog

If you have any queries/questions regarding the above mentioned information then please let me know. 
I would be more than happy to help you as well as resolves your issues, Thank you.

Unable to “Edit series” for an event in calendar list in SharePoint


ISSUE:
Unable to “Edit series” for an event in calendar list

DESCRIPTION:
There is a repeating event (event series) in SharePoint calendar list with “All day event” selected and no specific start and end time. When someone opens an event and then clicks on "Edit series", it opens up the series in edit mode. But after making any type of changes, page can’t be saved and clicking “Ok” returns to same edit page reflecting some validation errors which doesn't allow us to commit the changes.

WORKAROUND/SOLUTION:
Solution for this problem issue is extremely simple very obviousness.

Whether we make changes to the series or not, we must unchecked the box for “All day event” and then select the check box again