SharePoint 2016 + Windows Server 2016 -Microsoft WCF Data Services 5.6 as error

April 8, 2017

Case:
SharePoint 2016 + Windows Server 2016
Problem:
Pre-Requist wizard fails to install Microsoft WCF Data Services 5.6 as error as:

“configuration error”
So solution is to download and install WCF data service manually. As a result Pre-Requist wizard shows that WCF Data Service can be installed successfully. Wizard succeeds.
When Farm configuration wizard is run, Wizard fails with following error.

04/06/2017 11:49:01 9 INF The parameter localserverrole is chosen, so returning the value as SingleServerFarm
04/06/2017 11:52:09 9 ERR Task configdb has failed with an unknown exception
04/06/2017 11:52:09 9 ERR Exception: Microsoft.SharePoint.Upgrade.SPUpgradeException: One or more types failed to load. Please refer to the upgrade log for more details.
at Microsoft.SharePoint.Upgrade.SPActionSequence.LoadUpgradeActions()
at Microsoft.SharePoint.Upgrade.SPActionSequence.get_Actions()
at Microsoft.SharePoint.Upgrade.SPActionSequence.get_ActionsInternal()
at Microsoft.SharePoint.Upgrade.SPUtility.GetLatestTargetSchemaVersionBeforeMajorVersion(Type typeActionSequence, Int32 majorVer)
at Microsoft.SharePoint.Upgrade.SPSiteSequence.get_PreviousTargetSchemaVersion()
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.PopulateSequencesTable(StringBuilder sqlstr, Boolean siteSequence)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ConstructSiteNeedsUpgradeQuery(Guid siteId)
at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.GetSiteNeedsUpgrade(SPUpgradeSession session, SPContentDatabase database, Dictionary`2& dictSitesNeedUpgrade, Dictionary`2& dictSitesNeedFeatureUpgrade)
at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.AddNextLevelObjects()
at Microsoft.SharePoint.Upgrade.SPHierarchyManager.Grow(SPTree`1 root, Boolean bRecursing, SPDelegateManager delegateManager)
at Microsoft.SharePoint.Upgrade.SPHierarchyManager.Grow(SPTree`1 root, SPDelegateManager delegateManager)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Administration.SPServerProductInfo.DetectLocalUpgradeStatus()
at Microsoft.SharePoint.Administration.SPServerProductInfo.DetectLocalProductVersions(SPProductVersions prodVer)
at Microsoft.SharePoint.Administration.SPServerProductInfo.UpdateProductInfoInDatabase(Guid serverGuid)
at Microsoft.SharePoint.Administration.SPFarm.Join(Boolean skipRegisterAsDistributedCacheHost, Nullable`1 serverRole)
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()
at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()
04/06/2017 11:52:09 9 INF Entering function Common.BuildExceptionMessage

ULS logs at that time suggest following directions.

04/06/2017 19:34:01.06 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywv Medium 04/06/2017 19:34:01.06 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywv DEBUG Microsoft.SharePoint, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Failed to call GetTypes() 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.Edm, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Failed to call GetTypes() 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.OData, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Failed to call GetTypes() 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.OData, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Failed to call GetTypes() 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.OData, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Failed to call GetTypes() 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.OData, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Failed to call GetTypes() 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.50 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Upgrade ajywy Unexpected 04/06/2017 19:34:02.50 psconfigui (0x00B8) 0x027C SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.OData, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000
04/06/2017 19:34:02.52 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Topology aj4j4 Unexpected Joining Farm failed. The exception type is Microsoft.SharePoint.Upgrade.SPUpgradeException The exception is One or more types failed to load. Please refer to the upgrade log for more details. StackTrace is at Microsoft.SharePoint.Upgrade.SPActionSequence.LoadUpgradeActions() at Microsoft.SharePoint.Upgrade.SPActionSequence.get_Actions() at Microsoft.SharePoint.Upgrade.SPActionSequence.get_ActionsInternal() at Microsoft.SharePoint.Upgrade.SPUtility.GetLatestTargetSchemaVersionBeforeMajorVersion(Type typeActionSequence, Int32 majorVer) at Microsoft.SharePoint.Upgrade.SPSiteSequence.get_PreviousTargetSchemaVersion() at Microsoft.SharePoint.Upgrade.SPUpgradeSession.PopulateSequencesTable(StringBuilder sqlstr, Boolean siteSequence) at Microsoft.SharePoint.Upgrade.SPUp...
04/06/2017 19:34:02.52* psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Topology aj4j4 Unexpected ...gradeSession.ConstructSiteNeedsUpgradeQuery(Guid siteId) at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.GetSiteNeedsUpgrade(SPUpgradeSession session, SPContentDatabase database, Dictionary`2& dictSitesNeedUpgrade, Dictionary`2& dictSitesNeedFeatureUpgrade) at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.AddNextLevelObjects() at Microsoft.SharePoint.Upgrade.SPHierarchyManager.Grow(SPTree`1 root, Boolean bRecursing, SPDelegateManager delegateManager) at Microsoft.SharePoint.Upgrade.SPHierarchyManager.Grow(SPTree`1 root, SPDelegateManager delegateManager) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse) at ...
04/06/2017 19:34:02.52* psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Topology aj4j4 Unexpected ...Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.ReflexiveNeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgrade(Object o, Boolean bRecurse) at Microsoft.SharePoint.Administration.SPServerProductInfo.DetectLocalUpgradeStatus() at Microsoft.SharePoint.Admi...
04/06/2017 19:34:02.52* psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Topology aj4j4 Unexpected ...nistration.SPServerProductInfo.DetectLocalProductVersions(SPProductVersions prodVer) at Microsoft.SharePoint.Administration.SPServerProductInfo.UpdateProductInfoInDatabase(Guid serverGuid) at Microsoft.SharePoint.Administration.SPFarm.Join(Boolean skipRegisterAsDistributedCacheHost, Nullable`1 serverRole)
04/06/2017 19:34:02.52 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Topology 88ah High Unjoining the farm.
04/06/2017 19:34:02.52 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Topology 7f7z Medium Attempting to unprovision the instance of the service.
04/06/2017 19:34:02.52 psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Config Cache 8xqz Medium Updating SPPersistedObject SPUsageServiceInstance. Version: 3285 Ensure: False, SkipObjectCallbackCheck: False, HashCode: 16766519, Id: 6acbaa8c-6140-4187-ab98-43e9e1632956, Stack: at Microsoft.SharePoint.Administration.SPPersistedObject.BaseUpdateCore(Boolean legacyUpdate) at Microsoft.SharePoint.Administration.SPPersistedObject.Update() at Microsoft.SharePoint.Administration.SPServer.Unprovision() at Microsoft.SharePoint.Administration.SPFarm.Unjoin() at Microsoft.SharePoint.Administration.SPFarm.Join(Boolean skipRegisterAsDistributedCacheHost, Nullable`1 serverRole) at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb() at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run() at Microsoft.Sh...
04/06/2017 19:34:02.52* psconfigui.exe (0x00B8) 0x027C SharePoint Foundation Config Cache 8xqz Medium ...arePoint.PostSetupConfiguration.TaskThread.ExecuteTask() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()

Solution:: “Microsoft WCF Data Services 5.6” is not installed correctly, even it says so, that everything is ok.
Solution is to repair “Microsoft WCF Data Services 5.6”, then run SharePoint configuration wizard again. It will work like charm.

Advertisements

SharePoint 2016 + Windows Server 2016-Web Server (IIS) Role: configuration error

April 8, 2017

Case:
SharePoint 2016 + Windows Server 2016
Problem:
Pre-Requist wizard fails as error as:
• Web Server (IIS) Role: configuration error

Solution:
Googled it. Got reference from Swiss guy’s blog.

https://www.techtask.com/sharepoint-2016-unable-to-install-application-server-role-web-server-iis-role/

Slight modification for Windows Server 2016,
Remove Application-Server and AS-Web_support features.
Run poweshell as below.
Add-WindowsFeature Web-Server,Windows-Identity-Foundation,NET-Framework-45-ASPNET,Web-Mgmt-Console,Web-Mgmt-Compat,Web-Metabase,Web-Lgcy-Mgmt-Console,Web-Lgcy-Scripting,Web-Mgmt-Tools,Web-WMI, Web-Common-HTTP,NET-HTTP-Activation,NET-Non-HTTP-Activ,NET-WCF-HTTP-Activation45 -Source 'F:\sources\sxs'
Problem solved…!