SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

Blog

FIXED – Workflow Endpoint Not Found Exception: Unable to connect to the remote service

Recently I noticed the below error when viewing Workflow status on SharePoint Server 2013.   Root cause turned out to be a missing IIS binding for both HTTP: 12291 and HTTPS: 12290.   After adding the additional IIS binding the status page was able to render again.  Cheers!

shades_smile

Error

Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type ‘System.Web.HttpUnhandledException’ was thrown. —> Microsoft.Workflow.Client.WorkflowEndpointNotFoundException: Unable to connect to the remote service at http://sharepointwf:12291/SharePoint/default/c1740af1-82ad-4026-beb5-c6eddaea7d88/4d2c8da0-a0da-41c1-8387-96260df02a62/$Workflows/$Instances/4d10f51f-2e21-4ff7-aa3c-ceadde059a14. See InnerException for more details. Client ActivityId : 69ee049e-ffb2-209a-6826-71aedbaa6db7. —> 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 127.0.0.1:12291   
  at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)   
  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 Microsoft.Workflow.Common.AsyncResult.End[TAsyncResult](IAsyncResult result)

Screenshots

image
image
image
image

Office 365 – Hybrid Team Site Redirect AAM

Migrating team sites to Office 365?  Worried about broken links?  Check this out.

Recently I found a helpful STSADM trick that provides HTTP redirection for hybrid SharePoint farms moving team sites into the Office 365 cloud.   As we migrate sites and remove from the source farm on-premise users will see 404 Page Not Found when open old URLs.

However, we can use STSADM to provide a “<RedirectUrl>” Alternate Access Mapping (AAM) property on the source SharePoint Web Application (http://portal/*) which redirects user traffic to a destination Office 365 Tenant (ex:  https://tenant.sharepoint.com/*)

If you are gradually moving team sites into the cloud with third party tools (ShareGate, Metalogix, DocAve, etc.) this trick is invaluable to preserve a smooth user experience where old links will seamlessly redirect to Office 365 team sites in the cloud.  Cheers! 

shades_smile

Diagram

image

Commands

Enable AAM Redirect

Verify AAM Redirect

Screenshots

image

image

Video

References

VIDEO – Angular CLI – SPCRUD Todo List in SharePoint Content Editor (part 2 of 2)

Continued part 2 of earlier video at http://www.spjeff.com/2017/05/31/angular-cli-todo-list-in-sharepoint-content-editor/

Here we add “spcrud.ts” library with CRUD methods to save JSON data over REST api into SharePoint Lists.
SPCRUD is a Typescript library with methods to easily interact with SharePoint APIs by providing management of Digest Token, HTTP headers, and URL formatting. As developers we interact with simple TypeScript methods that have input validation which in turn execute the correct underlying HTTP call.

Cheers! 

shades_smile

Source Code

Video

Angular 2 CLI – SPCRUD Todo List in SharePoint Content Editor (Part 2 of 2) from Jeff Jones on Vimeo.

SMAT – Content Database Query

While reviewing the SharePoint Migration Assessment Tool (SMAT) I noticed the high performance data gathering. Running on a farm with thousands of sites the collection of data ran quickly.

Looking more closely we can see how Content Database SQL queries are used to collect a list of compatibility issues and populate the report. These are much faster than Server Object Model (SOM) front end techniques for collecting data.

Below are sample SQL queries that SMAT uses to check SharePoint content database and identify customizations that might not be compatible with Office 365.

Cheers!

shades_smile

SMAT Download

SMAT Report Categories

Microsoft.SharePoint.Migration.Scan.Scanner

image

AlertsScanner

AppsScanner

BrowserFileHandlingScanner

CheckedOutFilesScanner

CustomizedPagesScanner

CustomProfilePropertyMappingScanner

EmailEnabledListsScanner

FileVersionsScanner

InfoPathScanner

IRMEnabledLibraryScanner

LargeExcelFilesScanner

LargeListsScanner

LargeSitesScanner

LockedSitesScanner

LongODBUrlsScanner

NonDefaultMasterPageScanner

SandboxSolutionScanner

UnsupportedWebTemplatesScanner

WorkflowRunning2010Scanner

WorkflowRunning2013Scanner

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲