Wednesday, October 29, 2014

Error while starting VM - Failed to allocate resources while connecting to a virtual network

Solution:

Change Network Adapter settings for the virtual machine to "Not Connected", start the VM and change the network adapter to the default one.

Error Details:

[Window Title]
Virtual Machine Connection

[Main Instruction]
The application encountered an error while attempting to change the state of 'machine_name'.

[Content]
'machine_name' failed to start.

Synthetic Ethernet Port (Instance ID GUID): Error 'The specified network resource or device is no longer available.'.

Failed to allocate resources while connecting to a virtual network.

[Expanded Information]
'machine_name' failed to start. (Virtual machine ID GUID)

'machine_name' Synthetic Ethernet Port: Failed to finish reserving resources with Error 'The specified network resource or device is no longer available.' (0x80070037). (Virtual machine ID GUID)

'machine_name' failed to allocate resources while connecting to a virtual network: The specified network resource or device is no longer available. (0x80070037) (Virtual Machine ID GUID)

[V] See details  [Close]

Thursday, October 23, 2014

HTML Link button


WRONG:
<a href="https://www.blogger.com/nextpage.html"><button>NEXT PAGE</button></a>

 RIGHT:
<form action="/nextpage.html" method="get"> <buttontype submit="">NEXT PAGE</buttontype></form>

Thursday, October 16, 2014

Excel Power Query : Unable to sign in to SharePoint on premises site

Quick tip: If you are using a computer not connected to a domain and accessing a site which requires domain credentials, you will need to set up windows credentials from control panel.



Thursday, October 9, 2014

Quick Gains for SP Development

For ensuring that SP Context is initialized before calling a Javascript.

$(document).ready(function () {
    SP.SOD.executeFunc('sp.js', 'SP.ClientContext', function () {
        //Your code here
    });
});

Thursday, October 2, 2014

SharePoint 2013 - Quick edit disabled in list or document library

Recently had an issue where the quick edit button on the document library ribbon menu was disabled or grayed out.

Initially i suspected
Turns out that there is a setting in the advanced settings to enable it.

Monday, September 1, 2014

SharePoint 2010 - Search box disappeared

Had a weird issue today where the SharePoint search box stopped appearing after a windows update.
An iisreset resolved the issue! Thanks to my client team member who mentioned that a similar issue was resolved by IISRESET.

Wednesday, August 20, 2014

SharePoint online menu gone black

If any of you are wondering why your SharePoint online menu suddenly went black, I believe this is from an update rolled out by Microsoft.





They have set both the background and foreground to black :)

.o365cs-base.o365cst.o365spo button.o365cs-spo-topbarMenuOpen, .o365cs-base.o365cst.o365spo button.o365cs-spo-topbarHover, .o365cs-base.o365cst.o365spo a.o365cs-spo-topbarMenuOpen, .o365cs-base.o365cst.o365spo a.o365cs-spo-topbarHover {
    background-color: #000;
    border-color: #dedede;
    color: #000;
}

.o365spo.o365cs-nav-contextMenu .o365cs-base.o365cst.o365cs-contextMenu {
    background-color: #000;
}

https://prod.msocdn.com/3.06.5615.1/en-US/css/O365ShellCore.css 

Waiting for a fix!

Until they roll out a fix, add this to your custom css. And dont forget to clean up later.

.o365cs-base.o365cst.o365spo button.o365cs-spo-topbarMenuOpen, .o365cs-base.o365cst.o365spo button.o365cs-spo-topbarHover, .o365cs-base.o365cst.o365spo a.o365cs-spo-topbarMenuOpen, .o365cs-base.o365cst.o365spo a.o365cs-spo-topbarHover {
    background-color: #ececec !important;
    border-color: #dedede;
    color: #000;
}

.o365spo.o365cs-nav-contextMenu .o365cs-base.o365cst.o365cs-contextMenu {
    background-color: #ececec !important;
}

Wednesday, August 13, 2014

PowerShell to check for long file names breaking OneDrive sync


get-childitem "C:\temp" -rec | where {!$_.PSIsContainer} |  foreach-object -process { if($_.FullName.Length + 19 -gt 236){ $_.FullName}}

* 19 char in c:\users\onedrive 

Thursday, July 24, 2014

SharePoint 2010 - Adding user to a group throws error in IE 9


SharePoint 2010 - Adding user to a group throws error in IE 9

System.InvalidOperationException: Namespace prefix 'xsd' is not defined.   
 at System.Xml.Serialization.XmlSerializationReader.ToXmlQualifiedName(String value, Boolean decodeName)    
 at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderDictionaryEntryArray.Read1_Object(Boolean isNullable, Boolean checkType)    
 at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderDictionaryEntryArray.Read2_DictionaryEntry(Boolean checkType)    
 at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderDictionaryEntryArray.Read3_ArrayOfDictionaryEntry()

Happens when you force your page to render in IE 9 and higher.

There is a detailed discussion here :

http://social.msdn.microsoft.com/Forums/en-US/90b3835c-6754-4bb6-9fd4-b74f16f236ff/sharepoint-2010-and-ie9-compatibility?forum=sharepointgeneralprevious

Friday, July 11, 2014

Delete office 2013 document cache


Using office 2013 with skydrive and skydrive pro I was getting the following error.

An error occurred while accessing the Office Document Cache.

a quick startup/shutdown script was created to fix this.


cd "C:\Users\\AppData\Local\Microsoft\Office\15.0"
rd OfficeFileCache /s
y

echo "delete successful"

Add to startup and shutdown scripts by opening gpedit.msc



Thursday, July 10, 2014

SharePoint managed metadata fields not editable after restore


Here is a script to to fix term store ID's in metadata fields  for lists in a website when it has been restored from  another farm with the same taxonomy structure and terms.

Click here to download the script

SharePoint managed metadata fields not editable after restore

Tuesday, July 1, 2014

OWA not working after security update


Office web apps for SharePoint 2013 not working after security updates / server patching.

After installation of the following security patches, OWA stopped working there by causing issues with SharePoint 2013.

Details of ULS logs are provided below.

FarmStateReplicator.exe (0x0CD8)
Office Web Apps
Farm State

Error when trying to connect to Farm State Manager service: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http:///farmstatemanager/FarmStateManager.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context) at System.Net.HttpWebRequest.GetRequestStream() at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream() --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream() at System.ServiceModel.Channels.HttpOutput.Send(TimeSpan timeout) at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.SendRequest(Message message, TimeSpan timeout) at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Office.Web.Apps.Environment.WacServer.IFarmStateManagerService.GetAllSettings(DateTime lastGetTime, Guid correlationId) at Microsoft.Office.Web.Apps.Environment.WacServer.RemoteFarmSettings.Refresh() at Microsoft.Office.Web.Apps.Environment.WacServer.ACacheableFarmStateObject.Sync(Boolean force) at Microsoft.Office.Web.Apps.Environment.WacServer.AFarmSettings.get_MasterMachineName() at Microsoft.Office.Web.Apps.Environment.WacServer.RemoteFarmState.get_IsMaster() at Microsoft.Office.Web.WacServer.FarmStateReplicator.Replicate()

Understood that the following security updates were installed in the server

LinkDescriptionHotFixID
http://support.microsoft.com/?kbid=2843630UpdateKB2843630
http://support.microsoft.com/?kbid=2851234UpdateKB2851234
http://support.microsoft.com/?kbid=2898865Security UpdateKB2898865
http://support.microsoft.com/?kbid=2898866Security UpdateKB2898866
http://support.microsoft.com/?kbid=2901119Security UpdateKB2901119
http://support.microsoft.com/?kbid=2901120Security UpdateKB2901120
http://support.microsoft.com/?kbid=2903938UpdateKB2903938
http://support.microsoft.com/?kbid=2904659Security UpdateKB2904659
http://support.microsoft.com/?kbid=2909210Security UpdateKB2909210
http://support.microsoft.com/?kbid=2911101UpdateKB2911101
http://support.microsoft.com/?kbid=2912390Security UpdateKB2912390
http://support.microsoft.com/?kbid=2916036Security UpdateKB2916036
http://support.microsoft.com/?kbid=2917499UpdateKB2917499
http://support.microsoft.com/?kbid=2919393UpdateKB2919393
http://support.microsoft.com/?kbid=2925418Security UpdateKB2925418
http://support.microsoft.com/?kbid=2929755UpdateKB2929755
http://support.microsoft.com/?kbid=2930275Security UpdateKB2930275

The OWA server event logs have the following errors.


Service cannot be started. System.InvalidOperationException: The certificate has not been specified.
   at Microsoft.Web.Administration.SiteCollection.Add(String name, String bindingInformation, String physicalPath, Byte[] certificateHash)
   at Microsoft.Office.Web.Environment.WacServer.IisProvisioningUtil.ProvisionNewSite(ServerManager serverManager, String name, String physicalPath, String applicationPoolName, List`1 bindings)
   at Microsoft.Office.Web.Environment.WacServer.AgentManager.AgentController.ProvisionTopLevelSites(IEnumerable`1 webAgentsToRun)
   at Microsoft.Office.Web.Environment.WacServer.AgentManager.AgentController.StartAgents()
   at Microsoft.Office.Web.Environment.WacServer.AgentManager.AgentManagerApplication.OnStart(String[] args)
   at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)


trying to query the webapps machine returns the below error.

Get-OfficeWebAppsMachine

Get-OfficeWebAppsMachine : It does not appear that this machine is part of an Office Web Apps Server farm.
At line:1 char:1
+ Get-OfficeWebAppsMachine
+ ~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Get-OfficeWebAppsMachine], InvalidOperationException
    + FullyQualifiedErrorId : NotJoinedToFarm.AgentManagerNotRunning,Microsoft.Office.Web.Apps.Administration.GetMachineCommand

Get-OfficeWebAppsFarm


Get-OfficeWebAppsFarm : It does not appear that this machine is part of an Office Web Apps Server farm.
At line:1 char:1
+ Get-OfficeWebAppsFarm
+ ~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Get-OfficeWebAppsFarm], InvalidOperationException
    + FullyQualifiedErrorId : NotJoinedToFarm.AgentManagerNotRunning,Microsoft.Office.Web.Apps.Administration.GetFarmCommand

Restart-Service WACSM

WARNING: Waiting for service 'Office Web Apps (WACSM)' to start...
WARNING: Waiting for service 'Office Web Apps (WACSM)' to start...
Restart-Service : Failed to start service 'Office Web Apps (WACSM)'.
At line:1 char:1
+ Restart-Service WACSM
+ ~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OpenError: (System.ServiceProcess.ServiceController:ServiceController) [Restart-Service], ServiceCommandException
    + FullyQualifiedErrorId : StartServiceFailed,Microsoft.PowerShell.Commands.RestartServiceCommand

tried  the below with no result.

dism /online /enable-feature /featurename:IIS-ASPNET45
#reference : http://technet.microsoft.com/en-us/library/jj219455(v=office.15).aspx

Tried

Repair-OfficeWebAppsFarm

Did not work

Finally for the solution

On OWA server:

Remove-OfficeWebAppsMachine
New-OfficeWebAppsFarm -InternalUrl "https://server.contoso.com" -ExternalUrl "https://wacweb01.contoso.com" -CertificateName "OfficeWebApps Certificate" -EditingEnabled

To verify that the farm was created successfully, navigate to:

https://server.contoso.com/hosting/discovery

On SharePoint 2013
# Point PROD to PROD OWA server
Remove-SPWOPIBinding -All:$true
New-SPWOPIBinding -ServerName _owaservername_
#Set-SPWOPIZone -zone "external-https"
Get-SPWOPIZone
Get-SPWOPIZone | Get-SPWOPIBinding

Thankfully did not have to reinstall as mentioned in the article
http://technet.microsoft.com/en-us/library/jj966220.aspx

Quoted below:
WarningWarning:
Applying Office Web Apps Server updates by using the automatic updates process isn’t supported with Office Web Apps Server. This is because updates to an Office Web Apps Server must be applied in a specific way, as described in this article. If Office Web Apps Server updates are applied automatically, users may be unable to view or edit documents in Office Web Apps. If this happens, you have to rebuild your Office Web Apps Server farm. To rebuild a farm, you must remove the Office Web Apps Server from the farm by using Remove-OfficeWebAppsMachine, uninstall Office Web Apps Server by using Add or remove programs, and then reinstall Office Web Apps Server by following the steps that are described in Deploy Office Web Apps Server. After you have reinstalled, apply the update by following the steps that are described in this article.
It is important that you review the guidelines in Planning updates for Office Web Apps Server and establish an update process for the Office Web Apps Server farm.

Wednesday, June 25, 2014

SharePoint Search - Restrict result source to a single content type

Ever tried adding a result source in SharePoint to restrict your results to a single content type?
The query builder makes it sound easy by giving you options to add a simple filter ContentType "equals" "your content type".

Resutls? NONE returned.

Finally figured out that manually giving the contentype ID as "Contains starts with" > Manual value does the trick!


Friday, June 20, 2014

SharePoint 2013 workflow : The server was unable to process the request


Here, I received another SharePoint 2013 workflow error.
This time the workflow was not able to send emails and the following error was being shown

Retrying last request. Next attempt scheduled in less than one minute. Details of last request: HTTP Unauthorized to http://sitename/_vti_bin/client.svc/web/lists/getbyid(guid'guid') Correlation Id: id Instance Id: id

Fortunately I came across this post which gave me the answer
http://sharepoint.stackexchange.com/questions/89101/failed-to-retrieve-the-com-class-factory-for-component-with-clsid-sp-sprequest

Solution 1:
In InetMgr, go to advanced settings for Security Token Service Application Pool and change "Load User Profile" to true. Recycle application pool.

Reason 2 and Solution 2 : There could be another reason for this error. The workflow authentication can fail if the user executing the workflow (this will be the user initiating the workflow) is given permission through active directory group and the container for this group is not selected to be synchronised in the active directory connection.

You can test this out by giving the user permissions directly on the site through a SharePoint group and re-trying the workflow again.


Significant ULS Log Entries are given below :
SPApplicationAuthenticationModule: Failed to build cache key for user
The set of claims could not be mapped to a single user identity. Exception Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA). has occured.
The registered mappered failed to resolve to one identity claim. Exception: System.Runtime.InteropServices.COMException (0x800703FA): Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA). at Microsoft.SharePoint.Library.SPRequest..ctor() at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(SPSite site, String name, Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, SPAppPrincipalToken appPrincipalToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous) at Microsoft.SharePoint.SPRequestManager.GetContextRequest(SPRequestAuthenticationMode authenticationMode) at Microsoft.SharePoint.Administration.SPFarm.get_RequestAny() at Microsoft.SharePoint.SPSecurity.GetCurrentUserTokenNoApplicationPrincipalDelegated() at Microsoft.SharePoint.SPSecurity.GetCurrentUserToken() at Microsoft.SharePoint.SPSecurity.EnsureOriginatingUserToken() at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) at Microsoft.Office.Server.Security.UserProfileIdentityClaimMapper.GetMappedIdentityClaim(Uri context, IEnumerable`1 identityClaims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.GetClaimFromExternalMapper(Uri contextUri, List`1 claims)
STS Call Claims Saml: Problem getting output claims identity. Exception: 'System.Runtime.InteropServices.COMException (0x800703FA): Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA). at Microsoft.SharePoint.Library.SPRequest..ctor() at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(SPSite site, String name, Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, SPAppPrincipalToken appPrincipalToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous) at Microsoft.SharePoint.SPRequestManager.GetContextRequest(SPRequestAuthenticationMode authenticationMode) at Microsoft.SharePoint.Administration.SPFarm.get_RequestAny() at Microsoft.SharePoint.SPSecurity.GetCurrentUserTokenNoApplicationPrincipalDelegated() at Microsoft.SharePoint.SPSecurity.GetCurrentUserToken() at Microsoft.SharePoint.SPSecurity.EnsureOriginatingUserToken() at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) at Microsoft.Office.Server.Security.UserProfileIdentityClaimMapper.GetMappedIdentityClaim(Uri context, IEnumerable`1 identityClaims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.GetClaimFromExternalMapper(Uri contextUri, List`1 claims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.ResolveUserIdentityClaim(Uri contextUri, ClaimCollection inputClaims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.GetIdentityClaim(Uri contextUri, ClaimCollection inputClaims, SPCallingIdentityType callerType) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.GetLogonIdentityClaim(SPRequestInfo requestInfo, IClaimsIdentity inputIdentity, IClaimsIdentity outputIdentity, SPCallingIdentityType callerType) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.EnsureSharePointClaims(SPRequestInfo requestInfo, IClaimsIdentity outputIdentity, SPCallingIdentityType callerType) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.AugmentOutputIdentityForRequest(SPRequestInfo requestInfo, IClaimsIdentity outputIdentity) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.GetOutputClaimsIdentity(IClaimsPrincipal principal, RequestSecurityToken request, Scope scope)'.
STS Call: Failed to issue new security token. Exception: System.Runtime.InteropServices.COMException (0x800703FA): Retrieving the COM class factory for component with CLSID {BDEADF26-C265-11D0-BCED-00A0C90AB50F} failed due to the following error: 800703fa Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA). at Microsoft.SharePoint.Library.SPRequest..ctor() at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(SPSite site, String name, Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, SPAppPrincipalToken appPrincipalToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous) at Microsoft.SharePoint.SPRequestManager.GetContextRequest(SPRequestAuthenticationMode authenticationMode) at Microsoft.SharePoint.Administration.SPFarm.get_RequestAny() at Microsoft.SharePoint.SPSecurity.GetCurrentUserTokenNoApplicationPrincipalDelegated() at Microsoft.SharePoint.SPSecurity.GetCurrentUserToken() at Microsoft.SharePoint.SPSecurity.EnsureOriginatingUserToken() at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) at Microsoft.Office.Server.Security.UserProfileIdentityClaimMapper.GetMappedIdentityClaim(Uri context, IEnumerable`1 identityClaims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.GetClaimFromExternalMapper(Uri contextUri, List`1 claims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.ResolveUserIdentityClaim(Uri contextUri, ClaimCollection inputClaims) at Microsoft.SharePoint.IdentityModel.SPIdentityClaimMapperOperations.GetIdentityClaim(Uri contextUri, ClaimCollection inputClaims, SPCallingIdentityType callerType) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.GetLogonIdentityClaim(SPRequestInfo requestInfo, IClaimsIdentity inputIdentity, IClaimsIdentity outputIdentity, SPCallingIdentityType callerType) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.EnsureSharePointClaims(SPRequestInfo requestInfo, IClaimsIdentity outputIdentity, SPCallingIdentityType callerType) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.AugmentOutputIdentityForRequest(SPRequestInfo requestInfo, IClaimsIdentity outputIdentity) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.GetOutputClaimsIdentity(IClaimsPrincipal principal, RequestSecurityToken request, Scope scope) at Microsoft.IdentityModel.SecurityTokenService.SecurityTokenService.Issue(IClaimsPrincipal principal, RequestSecurityToken request) at Microsoft.SharePoint.IdentityModel.SPSecurityTokenService.Issue(IClaimsPrincipal principal, RequestSecurityToken request)
SPSecurityContext: Request for security token failed with exception: System.ServiceModel.FaultException: The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework SDK documentation and inspect the server trace logs. at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.ReadResponse(Message response) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.Issue(RequestSecurityToken rst, RequestSecurityTokenResponse& rstr) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.Issue(RequestSecurityToken rst) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForContext(Uri context, Boolean bearerToken, SecurityToken onBehalfOf, SecurityToken actAs, SecurityToken delegateTo, SPRequestSecurityTokenProperties properties)
An exception occurred when trying to issue security token: The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework SDK documentation and inspect the server trace logs..
SPApplicationAuthenticationModule: Error authenticating request, Error details { Header: {0}, Body: {1} }. Available parameters: 3001000;reason="There has been an error authenticating the request.";category="invalid_client" {"error_description":"The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework SDK documentation and inspect the server trace logs."} .
Application error when access /_vti_bin/client.svc, Error=The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework SDK documentation and inspect the server trace logs. at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.ReadResponse(Message response) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.Issue(RequestSecurityToken rst, RequestSecurityTokenResponse& rstr) at Microsoft.IdentityModel.Protocols.WSTrust.WSTrustChannel.Issue(RequestSecurityToken rst) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForContext(Uri context, Boolean bearerToken, SecurityToken onBehalfOf, SecurityToken actAs, SecurityToken delegateTo, SPRequestSecurityTokenProperties properties) at Microsoft.SharePoint.SPSecurityContext.SecurityTokenForApplicationAuthentication(Uri context, SecurityToken onBehalfOf) at Microsoft.SharePoint.IdentityModel.SPApplicationAuthenticationModule.<>c__DisplayClass4.b__3() at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode) at Microsoft.SharePoint.IdentityModel.SPApplicationAuthenticationModule.ConstructIClaimsPrincipalAndSetThreadIdentity(HttpApplication httpApplication, HttpContext httpContext, SPFederationAuthenticationModule fam) at Microsoft.SharePoint.IdentityModel.SPApplicationAuthenticationModule.AuthenticateRequest(Object sender, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


Workflow suspended error for Reason 2

RequestorId: guid. Details: RequestorId: guid. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ApplicationException: HTTP 401 {"error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access denied. You do not have permission to perform this action or access this resource."}}} {"Transfer-Encoding":["chunked"],"X-SharePointHealthScore":["0"],"SPClientServiceRequestDuration":["6"],"SPRequestGuid":["dguid"],"request-id":["ddd1f137-185d-9315-8eb4-456650fc11be"],"X-FRAME-OPTIONS":["SAMEORIGIN"],"Cache-Control":["max-age=0, private"],"WWW-Authenticate":["Negotiate","NTLM"],"X-AspNet-Version":["4.0.30319"],"X-Powered-By":["ASP.NET"],"X-Content-Type-Options":["nosniff"],"X-MS-InvokeApp":["1; RequireReadOnly"],"MicrosoftSharePointTeamServices":["15.0.0.4535"],"Date":["Thu, 10 Sep 2015 00:56:01 GMT"]} at Microsoft.Activities.Hosting.Runtime.Subroutine.SubroutineChild.Execute(CodeActivityContext context) at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)


ULS Logs for Reason 2

Category Message
Application Authentication SPApplicationAuthenticationModule: Failed to build cache key for user
Claims Authentication SPJsonWebSecurityBaseTokenHandler: ValidateActorIsSelfIssuer! Issuer '00000005-0000-0000-c000-000000000000' is not self issuer.
User Profiles Couldn't find a user using property 'WorkEmail' of value xxxx@xxxx.xx
Claims Authentication STS Call Claims Saml: Successfully requested oauth claim identity.
Authentication Authorization OAuth app principal Name=i:0i.t|ms.sp.ext|guid@guid, IsAppOnlyRequest=False, UserIdentityName=0#.w|domain\user, ClaimsCount=16
CSOM Request does not have SPBasePermissions.UseRemoteAPIs permission. Need to check it when each API is accessed
CSOM The request does not have required permission to access SP.RequestContext.Current
CSOM Exception occured in scope Microsoft.SharePoint.SPContext.get_current. Exception=System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.     at Microsoft.SharePoint.Client.ServerStub.CheckRequiredResourceRight(ProxyContext proxyContext, String memberName, ResourceRight right)     at Microsoft.SharePoint.Client.ServerStub.CheckBlockedGetProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.ServerStub.SPContextServerStub.GetStaticProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.ServerStub.GetStaticPropertyWithMonitoredScope(String propertyName, ProxyContext proxyContext)
CSOM Original error: System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.     at Microsoft.SharePoint.Client.ServerStub.CheckRequiredResourceRight(ProxyContext proxyContext, String memberName, ResourceRight right)     at Microsoft.SharePoint.Client.ServerStub.CheckBlockedGetProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.ServerStub.SPContextServerStub.GetStaticProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.ServerStub.GetStaticPropertyWithMonitoredScope(String propertyName, ProxyContext proxyContext)
Microfeeds SocialRESTExceptionProcessingHandler.DoServerExceptionProcessing - SharePoint Server Exception [System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.     at Microsoft.SharePoint.Client.ServerStub.CheckRequiredResourceRight(ProxyContext proxyContext, String memberName, ResourceRight right)     at Microsoft.SharePoint.Client.ServerStub.CheckBlockedGetProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.ServerStub.SPContextServerStub.GetStaticProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.ServerStub.GetStaticPropertyWithMonitoredScope(String propertyName, ProxyContext proxyContext)]
Authentication Authorization Throw UnauthorizedAccessException instead of SPUtilityInternal.Send401 for client.svc request.
CSOM Original error: System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.     at Microsoft.SharePoint.Client.ServerStub.CheckRequiredResourceRight(ProxyContext proxyContext, String memberName, ResourceRight right)     at Microsoft.SharePoint.Client.ServerStub.CheckBlockedGetProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.ServerStub.SPContextServerStub.GetStaticProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.ServerStub.GetStaticPropertyWithMonitoredScope(String propertyName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.GetObjectFromPathRoot(Boolean mainRequestPath, EdmParserNode node, Boolean resourceEndpoint, MethodInformation& methodInfo)     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.GetObjectFromPath(Boolean mainRequestPath, String path, String pathForErrorMessage)     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.Process()     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.ProcessRequest()
Microfeeds SocialRESTExceptionProcessingHandler.DoServerExceptionProcessing - SharePoint Server Exception [System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.     at Microsoft.SharePoint.Client.ServerStub.CheckRequiredResourceRight(ProxyContext proxyContext, String memberName, ResourceRight right)     at Microsoft.SharePoint.Client.ServerStub.CheckBlockedGetProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.ServerStub.SPContextServerStub.GetStaticProperty(String propName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.ServerStub.GetStaticPropertyWithMonitoredScope(String propertyName, ProxyContext proxyContext)     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.GetObjectFromPathRoot(Boolean mainRequestPath, EdmParserNode node, Boolean resourceEndpoint, MethodInformation& methodInfo)     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.GetObjectFromPath(Boolean mainRequestPath, String path, String pathForErrorMessage)     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.Process()     at Microsoft.SharePoint.Client.Rest.RestRequestProcessor.ProcessRequest()]
Authentication Authorization Throw UnauthorizedAccessException instead of SPUtilityInternal.Send401 for client.svc request.

Change SharePoint site regional settings or culture info

Here is a quick script to change the regional settings for your sharepoint site.

function ChangeSiteCultureInfo() {
    [CmdletBinding()]
     Param(
      [Parameter(Mandatory=$True,
  ValueFromPipeline=$True)]
       [string]$spSiteUrl,
       [ValidateSet("en-AU","en")]
       [string]$culture = "en-AU"
       )
       BEGIN {}
    PROCESS
       {
         Write-Host "Processing site $spSiteUrl"
         $spsite  = Get-SPSite -Identity $spSiteUrl
         $rootWeb = $spsite.RootWeb 
         $cultureInfo = [System.Globalization.CultureInfo]::GetCultureInfo($culture)
         Write-Host "Curent local setting is $($rootWeb.Locale) "
         $rootWeb.Locale = $culture 
         $rootWeb.Update() 
         $rootWeb.Dispose() 
         $spsite.Dispose() 
         Write-Host "Finished Updating the locale of $spSiteUrl to $cultureInfo"
       }
       END {}
       
}
Usage:
 url_here | ChangeSiteCultureInfo

Thursday, June 19, 2014

The option for the SharePoint 2013 workflow platform is not available because the workflow service is not configured on the server

I came across this scenario where I could not create a SharePoint 2013 designer workflow on just one of the site collection.

Turns out that it is an issue with the template used for creating the site and we need to enable a couple of hidden features to enable 2013 workflows.
Here is a code snippet to help you solve this issue.
function enableWorkflowHiddenFeatures() {
    [CmdletBinding()]
     Param(
      [Parameter(Mandatory=$True,
  ValueFromPipeline=$True)]
       [string]$spSiteUrl
       )
       BEGIN {}
    PROCESS
       {
            try{
            Enable-SPFeature -Identity WorkflowServiceStore –Url $spSiteUrl
            }catch{ Write-Host $_.Message -ForegroundColor Red }
            try{
            Enable-SPFeature -Identity WorkflowTask –Url $spSiteUrl
            }catch{ Write-Host $_.Message -ForegroundColor Red }
           
       }
       END {}
       
}

  enableWorkflowHiddenFeatures -spSiteUrl siteurl


Error Message : The option for the SharePoint 2013 workflow platform is not available because the workflow service is not configured on the server. Please contact your server administrator.




Wednesday, June 18, 2014

Download source code from TFS as a ZIP file

Tip : To get a clean download of the source code as a ZIP file from TFS, Just visit the web portal, right click on the project and select download as ZIP. Too easy.



Wednesday, June 11, 2014

Adding list item context menu to initiate workflow

It is very easy to add a list item context menu to initiate a SharePoint workflow
Use designer to add a custom action and you are done.

Why blog this? there are confusing blogs out there to try and build a url to do this!






SharePoint 2013 - Triggering list item changed workflow from another workflow.

Courtesy to one of my customers, I learned yet another tip for SharePoint 2013.

Scenario : You are developing workflows in SharePoint 2013
You have enabled the setting to trigger the workflow every time a list item is changed.
You have another workflow on the same list which makes a change to the list item.
You expect the item changed workflow to be triggered.

What happens:
2013 workflows are not triggered by changes made by other workflows.
2010 workflows can be triggered by changes made by other workflows.


Tuesday, June 10, 2014

Save SharePoint list attachments to a folder

Here is a powershell script to save SharePoint list attachments to a folder

Add-PsSnapin Microsoft.SharePoint.PowerShell

function downloadListAttachments ( ){
[CmdletBinding()]
 Param(
  [Parameter(Mandatory=$True,Position=1)]
   [string]$siteURL,
   [Parameter(Mandatory=$True)]
   [string]$listName,
   [string]$Path

)

    
    $tempLocation = $Path      
    $w = Get-SPWeb $siteURL   
    $l = $w.Lists[$listName]    
    foreach ($listItem in $l.Items)
    {
          Write-Host "    Content: " $listItem.ID 
           $destinationfolder = $tempLocation         
           if (!(Test-Path -path $destinationfolder))        
                {            
                 $dest = New-Item $destinationfolder -type directory          
                }
           foreach ($attachment in $listItem.Attachments)    
           {     
               $attachment   
               $file = $w.GetFile($listItem.Attachments.UrlPrefix + $attachment)        
               $bytes = $file.OpenBinary()                
               $path = $destinationfolder + "\" + $attachment 
               Write "Saving $path" 
               $fs = New-Object System.IO.FileStream($path, "OpenOrCreate") 
               $fs.Write($bytes, 0 , $bytes.Length)    
               $fs.Close()    
           }
     }
 }
 
downloadListAttachments -siteURL "https://abc" -listName "ListName" -Path "C:\Temp"


Reference : http://bhatiaashish.blogspot.com.au/2012/08/powershell-script-to-download.html

Cannot Create Managed Metadata column through SharePoint designer

True. You cannot create managed metadata column through SharePoint designer.
Use the site settings page from UI.

Thursday, May 29, 2014

Sharepoint 2013 Workflow - something went wrong


When I try to run a worflow created using SharePoint 2013 designer, I get the following error:

"Something went wrong. To try again, reload the page and then start the workflow."





Resolution:

Restart these services:

  • Service Bus Gateway
  • Service Bus Message Broker


Edit the workflow in designer and republish.



ULS logs for reference:

Request ManagementHighReached maximum number of failed machines based on ping results for this routing group
Request ManagementMediumMapping URI from 'http://siteCollection:80/_vti_bin/client.svc/ProcessQuery' to 'http://<SPAppServer>_vti_bin/client.svc/ProcessQuery'
Logging Correlation DataMediumName=Request (POST:http://siteCollection/_vti_bin/client.svc/ProcessQuery)
Authentication AuthorizationMediumNon-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|<userLoginName>, ClaimsCount=25
CSOMMediumBegin CSOM Request ManagedThreadId=103, NativeThreadId=11660
Logging Correlation DataMediumSite=/
MicrofeedsHighserviceHost_RequestExecuting
Application AuthenticationHighToken request correlation id: '3982959c-aa59-0006-d6a0-f6602b29fb27'.
Claims AuthenticationMediumUsing UPN '<userEmail>domin.au' for SMTP claim
Workflow ServicesExceptionMicrosoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) StackTrace: at Microsoft.Office.Server.Native.dll: (sig=35339f9c-8871-4ef1-9118-9c1bd0cb6598|2|microsoft.office.server.native.pdb, offset=131CE) at Microsoft.Office.Server.Native.dll: (offset=21B4D)
Unified Logging ServiceMonitorableWatson bucket parameters: SharePoint Server 2013, ULSException14, 044806dd "sharepoint server", 0f001181 "15.0.4481.0", 09d02580 "microsoft.workflow.client", 01009cc3 "1.0.40131.0", 52ef34cc "mon feb 03 16:18:52 2014", 0000005e "0000005e", 00000076 "00000076", 2e474e4c "invalidrequestexception", 0021c2c4 "ai2le"
CSOMHighException occured in scope Microsoft.SharePoint.WorkflowServices.WorkflowInstanceService.StartWorkflowOnListItem. Exception=Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid)
CSOMHighOriginal error: Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid)
MicrofeedsMediumSocialRESTExceptionProcessingHandler.DoServerExceptionProcessing - SharePoint Server Exception [Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid)]
MonitoringHighLeaving Monitored Scope (Microsoft.SharePoint.WorkflowServices.WorkflowInstanceService.StartWorkflowOnListItem). Execution Time=66.6597
MicrofeedsHighserviceHost_RequestExecuted
CSOMHighOriginal error: Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.InvokeMethod(Object obj, String methodName, XmlNodeList xmlargs, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessMethod(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessOne(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessStatements(XmlNode xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.Process()
MicrofeedsMediumSocialRESTExceptionProcessingHandler.DoServerExceptionProcessing - SharePoint Server Exception [Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.InvokeMethod(Object obj, String methodName, XmlNodeList xmlargs, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessMethod(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessOne(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessStatements(XmlNode xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.Process()]
CSOMHighMicrosoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.InvokeMethod(Object obj, String methodName, XmlNodeList xmlargs, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessMethod(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessOne(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessStatements(XmlNode xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.Process()
CSOMHighRequestMessage: <Request xmlns="http://schemas.microsoft.com/sharepoint/clientquery/2009" SchemaVersion="15.0.0.0" LibraryVersion="15.0.0.0" ApplicationName="Javascript Library"><Actions><ObjectPath Id="13" ObjectPathId="12" /><Method Name="StartWorkflowOnListItem" Id="14" ObjectPathId="12"><Parameters><Parameter ObjectPathId="8" /><Parameter Type="String">2</Parameter><Parameter Type="Dictionary" /></Parameters></Method></Actions><ObjectPaths><Identity Id="8" Name="50e607f0-ceab-4a8c-90c5-81e2f2ba78d9:0fa6047a-6101-4aa8-8b7b-20e4e155fa4d" /><Method Id="12" ParentId="4" Name="GetWorkflowInstanceService" /><Constructor Id="4" TypeId="{4ccc7f0e-bf7e-4477-999c-6458a73d0039}"><Parameters><Parameter ObjectPathId="2" /></Parameters></Constructor><Property Id="2" ParentId="0" Name="Web" /><StaticProperty Id="0" TypeId="{3747adcd-a3c3-41b9-bfab-4a64dd2f1e0a}" Name="Current" /></ObjectPaths></Request>
CSOMHighOriginal error: Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.InvokeMethod(Object obj, String methodName, XmlNodeList xmlargs, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessMethod(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessOne(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessStatements(XmlNode xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.Process()
MicrofeedsMediumSocialRESTExceptionProcessingHandler.DoServerExceptionProcessing - SharePoint Server Exception [Microsoft.Workflow.Client.InvalidRequestException: The scope '/SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125' has no workflows under it. HTTP headers received from the server - ActivityId: b66b51cc-a3d5-4032-a3df-20b1fd353bb5. NodeId: <MachineName>. Scope: /SharePoint/default/5df325c9-a3f0-44c3-a5f4-3e45fc780429/05ce15dc-ef4c-4796-85a9-1d6ade911125. Client ActivityId : d485959c-3abe-0006-d6a0-fab859e8d823. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.Workflow.Client.HttpGetResponseAsyncResult`1.End(IAsyncResult result) at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) --- End of inner exception stack trace --- at Microsoft.Workflow.Client.ClientHelpers.SendRequest[T](HttpWebRequest request, T content) at Microsoft.Workflow.Client.WorkflowManager.StartInternal(String workflowName, WorkflowStartParameters startParameters) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowManagementClient.StartInstance(String serviceGroupName, String workflowName, String monitoringParam, String activationKey, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflow(WorkflowSubscription subscription, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider.StartWorkflowOnListItem(WorkflowSubscription subscription, Int32 itemId, IDictionary`2 payload) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.StartWorkflowOnListItem_MethodProxy(WorkflowInstanceService target, XmlNodeList xmlargs, ProxyContext proxyContext) at Microsoft.SharePoint.WorkflowServices.WorkflowInstanceServiceServerStub.InvokeMethod(Object target, String methodName, XmlNodeList xmlargs, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ServerStub.InvokeMethodWithMonitoredScope(Object target, String methodName, XmlNodeList args, ProxyContext proxyContext, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.InvokeMethod(Object obj, String methodName, XmlNodeList xmlargs, Boolean& isVoid) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessMethod(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessOne(XmlElement xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.ProcessStatements(XmlNode xe) at Microsoft.SharePoint.Client.ClientMethodsProcessor.Process()]
CSOMMediumEnd CSOM Request. Duration=73 milliseconds.
Request ManagementHigh[Forced due to logging gap, cached @ 05/29/2014 14:15:19.01, Original Level: Verbose] Size of data: '{0}' bytes
Request ManagementHigh[Forced due to logging gap, Original Level: Verbose] Proxy response duration: WFE '{0}', RM '{1}'
Micro TraceMediumMicro Trace Tags: 0 nasq,2 agb9s,0 agw10,5 aizmk,14 b4ly,13 b4ly,24 b4ly,3 aiv3l,0 airzh,10 ahjq1,0 agmjp,0 aizmo,0 b4ly,0 aizmj,0 agmjp,0 aizmo,0 afxv7,0 aiv4i,0 agmjp,0 aizmo,0 agw11
MonitoringMediumLeaving Monitored Scope (Request (POST:http://siteCollection/_vti_bin/client.svc/ProcessQuery)). Execution Time=78.6582
Micro TraceMediumMicro Trace Tags: 0 nasq,0 ai2q3,0 adc7u
MonitoringMediumLeaving Monitored Scope (Request (POST:http://siteCollection/_vti_bin/client.svc/ProcessQuery)). Execution Time=80.8053

Monday, May 26, 2014

SharePoint Incoming e-mail - show the sender as a column



Scenario: In a SharePoint email enabled list, receive emails from an external sender and display the from address as a column.

For email enabled lists, there is a column called e-mail sender as per extract from MSDN article below. The tricky part is that it does not show up as a column in the library settings. Just go to "Modify this view" and select these columns to be shown.

The following fields are mapped from an e-mail message to a list: E-Mail Sender, E-Mail To, E-Mail Cc, E-Mail Subject, Body of the message, and attachments.

http://office.microsoft.com/en-au/sharepoint-server-help/introduction-to-incoming-e-mail-HA010082306.aspx


Monday, May 12, 2014

SharePoint Survey - Deleting a question without deleting responses.


Unfortunately, while deleting a question in SharePoint 2010 Survey deletes all responses for the question too.


This question and Its responses will be permanently deleted. Are you   sure you want to delete this question?

How to preserve the responses for a question and still retire the question?

Add the new questions that you want to include in the survey.
Then using SPD, create new forms for new item, edit item and display item. In the "new item" and "edit item" pages, hide the retired questions by applying the style attribute style="display:none" to the row elements. Now in the view item page, either hide or mark the question as retired.



Thursday, April 24, 2014

office 365 error the characters you entered didnt match

In Office 356, if you attempt login with incorrect password too many times it returns the error

You've tried to sign in too many times with an incorrect user ID or password.
after this sometimes you get the error

The characters you entered didn't match. Please try again.

If you face this error even after entering the correct captcha, it is just because your password is incorrect. Just a wrong error message. The new password might not have yet synced with office 365.

Friday, April 11, 2014

BCS Error - Access denied by Business Data Connectivity


I recently came across this error while attempting to configure an external content type in SharePoint 2013.
The error message showed Access denied by Business Data Connectivity.
On verifying the ULS logs the found errors as given in the table beneath the post

Found the following support article, but it did not like the problem that I was having at hand.
http://support.microsoft.com/kb/2686411

Then I came across this comment on the link
http://stackoverflow.com/questions/4168309/sharepoint-bcs-sss-help-needed

This happens because you have not set access on the BCS object that you created. Go into Central Administration and select your External Content Type or other object and select Set Permissions from the dropdown. Your authentication is working or you would not be able to save the object you created to the metadata store. You now need to tell the metadata store who has access to the objects you created in BCS. 

It worked like a charm.

Updating in my blog post so that someone searching for similar errors in ULS get some Info here.





Reached maximum number of failed machines based on ping results for this routing group
Mapping URI from
Name=Request
Non-OAuth request. IsAuthenticated=True, UserIdentityName=, ClaimsCount=25
Site=/sites/Test
External Lists: Using the default Filter settings for Finder 'Read Item'in Entity 'TestExteranlContentType' of EntityNamespace 'http://s/sites/test'. This will likely result in significant performance degradation.  Stack trace    at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)     at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstancesInternal(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Int32 firstRowIndex, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)     at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstances(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Int32 firstRowIndex, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)     at Microsoft.SharePoint.SPListItemCollection.EnsureEntityDataViewAndOrdering(String& bdcidFirstRow, String& bdcidNextPageFirstRow)     at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()     at Microsoft.SharePoint.SPListItemCollection.get_Count()     at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList)     at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal()     at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)     at Microsoft.SharePoint.ApplicationPages.InplaceViewEditor.RenderListView()     at Microsoft.SharePoint.ApplicationPages.InplaceViewEditor.Execute(String strCmd)     at Microsoft.SharePoint.ApplicationPages.InplaceViewEditor.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)     at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)     at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
Enter:IsIntranetAddress - Trying to find IP address of server name .
Exit:IsIntranetAddress - IP address of server name '' is 'found'.
Access Denied for User '0#.w|', which may be an impersonation by 'NT AUTHORITY\IUSR'. Securable MethodInstance with Name 'ApplicationDetailsRead List' has ACL that contains:
Error while executing web part: Microsoft.SharePoint.SPException: Access denied by Business Data Connectivity. ---> Microsoft.BusinessData.Infrastructure.AccessDeniedException: Access denied by Business Data Connectivity.     at Microsoft.SharePoint.BusinessData.Runtime.DataClassRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs, IFilterCollection filters)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteFiltered(IEntity this, IFilterCollection filterCollection, IMethodInstance methodInstanceToExecute, ILobSystemInstance lobSystemInstance)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.b__4(IEntity e, IMethodInstance mi, IFilterCollection fc, ILobSystemInstance lsi)     at Microsoft.SharePoint.BusinessData.Runtime.EntityInstanceEnumeratorFactory.CreateEntityInstanceEnumerator(IEntity entity, IMethodInstance methodInstance, IFilterCollection filters, ILobSystemInstance lobSystemInstance, ExecutionCallBack executionCallBack)     at Microsoft.SharePoint.BusinessData.MetadataModel.Static.Entity.FindFiltered(IFilterCollection filterCollection, String finderName, ILobSystemInstance lobSystemInstance)     at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)     --- End of inner exception stack trace ---     at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)     at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstancesInternal(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Int32 firstRowIndex, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)     at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstances(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Int32 firstRowIndex, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)     at Microsoft.SharePoint.SPListItemCollection.EnsureEntityDataViewAndOrdering(String& bdcidFirstRow, String& bdcidNextPageFirstRow)     at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()     at Microsoft.SharePoint.SPListItemCollection.get_Count()     at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList)     at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal()     at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator()     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)
InnerException 1: Access Denied for User '', which may be an impersonation by 'NT AUTHORITY\IUSR'. Securable MethodInstance with Name 'ApplicationDetailsRead List' denied access. Stack Trace:    at Microsoft.SharePoint.BusinessData.Runtime.DataClassRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs, IFilterCollection filters)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteFiltered(IEntity this, IFilterCollection filterCollection, IMethodInstance methodInstanceToExecute, ILobSystemInstance lobSystemInstance)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.b__4(IEntity e, IMethodInstance mi, IFilterCollection fc, ILobSystemInstance lsi)     at Microsoft.SharePoint.BusinessData.Runtime.EntityInstanceEnumeratorFactory.CreateEntityInstanceEnumerator(IEntity entity, IMethodInstance methodInstance, IFilterCollection filters, ILobSystemInstance lobSystemInstance, ExecutionCallBack executionCallBack)     at Microsoft.SharePoint.BusinessData.MetadataModel.Static.Entity.FindFiltered(IFilterCollection filterCollection, String finderName, ILobSystemInstance lobSystemInstance)     at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)
External Lists: Using the default Filter settings for Finder 'ApplicationDetailsRead Item'in Entity 'TestExteranlContentType' of EntityNamespace 'http'. This will likely result in significant performance degradation.  Stack trace    at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)     at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstancesInternal(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Int32 firstRowIndex, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)     at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstances(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Int32 firstRowIndex, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)     at Microsoft.SharePoint.SPListItemCollection.EnsureEntityDataViewAndOrdering(String& bdcidFirstRow, String& bdcidNextPageFirstRow)     at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()     at Microsoft.SharePoint.SPListItemCollection.get_Count()     at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList)     at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal()     at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator()     at Microsoft.SharePoint.SPList.RenderListData(XsltListViewWebPart xslWebPart, SPView view, TextWriter output)     at Microsoft.SharePoint.ApplicationPages.InplaceViewEditor.Execute(String strCmd)     at Microsoft.SharePoint.ApplicationPages.InplaceViewEditor.OnLoad(EventArgs e)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)     at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)     at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
InnerException 1: Access Denied for User '0#.w|', which may be an impersonation by 'NT AUTHORITY\IUSR'. Securable MethodInstance with Name 'ApplicationDetailsRead List' denied access. Stack Trace:    at Microsoft.SharePoint.BusinessData.Runtime.DataClassRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs, IFilterCollection filters)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteFiltered(IEntity this, IFilterCollection filterCollection, IMethodInstance methodInstanceToExecute, ILobSystemInstance lobSystemInstance)     at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.b__4(IEntity e, IMethodInstance mi, IFilterCollection fc, ILobSystemInstance lsi)     at Microsoft.SharePoint.BusinessData.Runtime.EntityInstanceEnumeratorFactory.CreateEntityInstanceEnumerator(IEntity entity, IMethodInstance methodInstance, IFilterCollection filters, ILobSystemInstance lobSystemInstance, ExecutionCallBack executionCallBack)     at Microsoft.SharePoint.BusinessData.MetadataModel.Static.Entity.FindFiltered(IFilterCollection filterCollection, String finderName, ILobSystemInstance lobSystemInstance)     at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)