24 October, 2012

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.

Duplicates entries in SharePoint Datasheet view Export to Spreadsheet


ISSUE:
Duplicate items appear when viewing items in Datasheet view in SharePoint.  This also happens when using the Export to Spreadsheet (Excel).  If duplicates appear in Datasheet view, they will also appear during Export to Spreadsheet and vice versa.

DESCRIPTION:
The list has got versioning switched off, and views fine in standard list view. However, when you switch to either datasheet view or Excel Export it shows the same rows up to three times in sequential rows.

WORAROUND/SOLUTION:
The affected lists have a REQUIRED lookup field which allows multiple values.
If you have a view that does NOT include this field and it is either a datasheet or you "Switch to Datasheet" then datasheet shows duplicate items depending on how many multi-values are selected.   

Our work-around was to create a specific Datasheet view with the field included.  The multi-value field does not show in datasheet, because multi-value lookup fields don't seem to work in datasheet.  However, it's important to include the field in the view to avoid duplicates.

Unfortunately, if you have a view that does not include the field and then "Switch to Datasheet" you will encounter the same problem.

The duplicates appear also when you try to Export to Excel.  If you have a view that would be affected by the "Switch to Datasheet" duplicates problem, when you try to Export to Excel, it will also appear.

So before you uncheck multiple values make sure you do it with the consent of the user.

Reference:


Specified argument was out of the range of valid values/Provisioning did not succeed/The feature failed to activate

Most of the SharePoint problems revolves around features, activations, publishing, enterprise, solutions and so on…Today I was working with one user and he was facing some error message while activating publishing feature at the site level.

What exactly those error messages: (3 different error messages)

Specified argument was out of the range of valid values.
Parameter name: ContentTypeId   at Microsoft.SharePoint.SPContentTypeBindingElement.EnsureContentTypeExists(SPWeb web)
   at Microsoft.SharePoint.SPContentTypeBindingElement.ElementActivated(SPFeaturePropertyCollection props, SPSqlCommand sqlcmdAppendOnly, SPWebApplication webApp, SPSite site, SPWeb web, Boolean fForce)
   at Microsoft.SharePoint.Administration.SPElementDefinitionCollection.ProvisionContentTypeAndEventReceiverBindings(SPFeaturePropertyCollection props, SPSite site, SPWeb web, Boolean fForce)
   at Microsoft.SharePoint.Administration.SPElementDefinitionCollection.ProvisionElements(SPFeaturePropertyCollection props, SPWebApplication webapp, SPSite site, SPWeb web, Boolean fForce)
   at Microsoft.SharePoint.SPFeature.ProvisionElements(SPFeaturePropertyCollection props, SPWebApplication webapp, SPSite site, SPWeb web, Boolean fForce)
   at Microsoft.SharePoint.SPFeature.Activate(SPSite siteParent, SPWeb webParent, SPFeaturePropertyCollection props, Boolean fForce)
   at Microsoft.SharePoint.SPFeatureCollection.AddInternal(Guid featureId, SPFeaturePropertyCollection properties, Boolean force, Boolean fMarkOnly)
   at Microsoft.SharePoint.SPFeatureCollection.Add(Guid featureId, Boolean force)
   at Microsoft.SharePoint.SPFeatureCollection.CheckSameScopeDependency(SPFeatureDefinition featdefDependant, SPFeatureDefinition featdefDependency, Boolean fActivateHidden, Boolean fForce)
   at Microsoft.SharePoint.SPFeatureCollection.CheckFeatureDependency(SPFeatureDefinition featdefDependant, SPFeatureDependency featdep, Boolean fActivateHidden, Boolean fForce)
   at Microsoft.SharePoint.SPFeatureCollection.CheckFeatureDependencies(Guid featidDependee, Boolean fActivateHidden, Boolean fForce)
   at Microsoft.SharePoint.SPFeatureCollection.AddInternal(Guid featureId, SPFeaturePropertyCollection properties, Boolean force, Boolean fMarkOnly)
   at Microsoft.SharePoint.SPFeatureCollection.Add(Guid featureId)
   at Microsoft.SharePoint.WebControls.FeatureActivator.BtnActivateFeature_Click(Object objSender, EventArgs evtargs)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Provisioning did not succeed. Details: Failed to create the 'Pages' library. Ori
ginalException: Content type '0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130E
C3DB064584E219954237AF39' not found in web 'https://sharepointknowledgemanagement.net/sites/DemoSite'.

The feature failed to activate because a list at 'Documents' already exists in this site.  Delete or rename the list and try activating the feature again.    at Microsoft.SharePoint.Publishing.Internal.ProvisioningHelper.AddList(SPListCollection lists, String urlName, String title, String description, Guid featureId, Int32 templateType, Boolean& newListCreated)
   at Microsoft.SharePoint.Publishing.Internal.ProvisioningHelper.AddList(SPListCollection lists, String urlName, String title, String description, Guid featureId, SPListTemplateType templateType, Boolean& newListCreated)
   at Microsoft.SharePoint.Publishing.Internal.AreaProvisioner.CreateDocumentsDocumentLibrary(SPList approvalTaskList)

Troubleshooting steps:

Try activating the publishing feature at the site collection level. If it’s successful then forthcoming issues will also gets resolved and you can successfully activates the feature at the subsite level too.

If the error message stated that the list is already exist then open the site (on which you are facing problems) in SPD (SharePoint Designer). You will see the same list that was reflected in the error message. Either delete it or rename it and then try to activate the feature. It will be successful.

If you are facing problems by means of GUI then try to activate the same by means of stsadm command.

Check the ULS logs for detail error messages

Check event logs for any specific event ID’s

Isolate the problem specific to a site, site collection, list, and particular feature at which level. 

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

Preventing Lync Server 2010 certificate expiration


Problem Description:
A Lync Server Certificate is about to expire in a few days:
·         An expired certificate will cause the Lync Server 2010 services to not start
·         An expired certificate may communication between Lync Server 2010 Server roles to fail
 
More details:
There are two way to locate information about the certificate that is associated with the Lync Server 2010 server

Method 1: Using Lync Server Deployment Wizard

Note You can also request a certificate from an internal CA, or assign an existing certificate from this wizard.
1.      Launch the Lync Server Deployment Wizard from the Windows Start menu on the Lync Server 2010 server
2.      Click on “Install or Update Lync Server System”
3.      Click run on Step 3: Request, Install or Assign Certificates
4.      Use the Certificate Wizard to view all the certificates that are installed for the Lync Server 2010 server

Method 2: Using Lync Management Shell

Use the PowerShell cmdlet Get-CsCertificate to locate information about the certificate associated with the Lync Server 2010 server

Note To view all properties on the certificate objects returned to see the SAN’s. Use with a "Get-CsCertificate | fl –property * cmdlet

For more information on Get-CsCertificate cmdlet please refer the following technet document
Get-CsCertificate

To request a certificate using the Lync Management Shell use the Request-CsCertificate cmdlet

For more information on Request-CsCertificate cmdlet please refer the following technet document
Request-CsCertificate

To import a certificate using Lync Management Shell use the Import-CsCertificate cmdlet

For more information on Import-CsCertificate cmdlet please refer the following technet document
Import-CsCertificate

To assign a certificate using Lync Management Shell use the Set-CsCertificate cmdlet

For more information on Set-CsCertificate cmdlet please refer the following technet document
Set-CsCertificate