Skip to main content

Posts

Showing posts from 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...

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.

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.

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-topba...

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

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

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...

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!

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 co...

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

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 SharePoi...

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.

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.

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 = $f...

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 Management High Reached maximum number of failed machines based on ping results for this routing group Request Management Medium Mapping URI from 'http://siteCollection:80/_vti_bin/client.svc/ProcessQuery' to 'http://<SPAppServer>_vti_bin/client.svc/ProcessQuery' Logging Correlation Data Medium Name=Request (POST:http://siteCollection/_vti_bin/client.svc/ProcessQuery) Authentication Authorization Medium Non-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|<userLoginName>, ClaimsCount=25 CSOM Medium Begin CSOM Request ManagedThreadId=103, NativeThreadId=11660 Logging Corre...

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

SharePoint Survey - Deleting a question without deleting responses.

Unfortunately, while deleting a question in SharePoint 2010 Survey deletes all responses for the question too. 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.

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.

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 ...