24 October, 2012

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


Exception occurred during request processing. (User: Form Name: , IP: , Request: Form ID: , Type: ThreadAbortException, Exception Message: Thread was being aborted.): Infopath


Issue:
Today in our environment we saw an SCOM alert which was continuously getting triggered.

SCOM Alert: Exception occurred while processing an InfoPath form template request
Source: spmwprodweb3
Path: spmwprodweb3.nam.nsroot.net
Alert Raised Time: 10/23/2012 3:21:06 PM Last modified by: System Last modified time: 10/23/2012 3:21:07 PM Alert description: Event ID 5367 from Source Office SharePoint Server on agent computer spmwprodweb3.nam.nsroot.net has triggered this Alert Description : Exception occurred during request processing. (User: Domain\User ID, Form Name: , IP: , Request: https://infopathformlib.site.url, Form ID: , Type: ThreadAbortException, Exception Message: Thread was being aborted.)

In Event logs

Event Type:  Error
Event Source:          Office SharePoint Server
Event Category:     Forms Services Runtime
Event ID:       5367
Date:              10/23/2012
Time:              2:21:55 PM
User:              N/A
Computer:    SPMWPRODWEB1
Description:
Exception occurred during request processing. (User: Domain\User ID, Form Name: , IP: , Request: https://infopathformlib.site.url, Form ID: , Type: ThreadAbortException, Exception Message: Thread was being aborted.)

In ULS logs

10/23/2012 14:28:19.68            w3wp.exe (0x2080)                                  0x327C          Forms Server                              Forms Services Runtime               82fp   Critical           Exception occurred during request processing. (User: Domain\User ID, Form Name: , IP: , Request: https://infopathformlib.site.url, Form ID: , Type: ThreadAbortException, Exception Message: Thread was being aborted.)          

Troubleshooting:
Checked on Google and it refers to the issue with anonymous access on the site http://vettekerry.wordpress.com/2008/06/03/login-required-on-anonymous-site.
MSDN community refers to the issue with “NT AUTHORITY\autenticated user" access on the site http://social.msdn.microsoft.com/Forums/pl/sharepointinfopath/thread/e0312df4-b950-4e42-ba49-a648055c8934.

In our environment we are neither using anonymous access on the site nor client have added “NT AUTHORITY\autenticated user" on the site.

Resolution:
The above article was referring to the permissions related issue. Hence tried to find the if the user is added on the site from “All People” group and no reference was found. Since there were 100 users it was very difficult to check them one by one. Asked the site admin if he has any reference list of users and he also confirmed that these users are yet to be permissioned on the site. Confirmed with the client they all treid to access the site before they were permissioned on the site resulting in SCOM Alert trigger for the InfoPath.

As alert was so huge in nature only a small portion of it was a cause of the issue i.e. user identified was not permissioned on the site. 

If you have any questions do let me know.