Error while executing web part: Microsoft.BusinessData.Infrastructure.BdcException

Error Information:

Error while executing web part: Microsoft.BusinessData.Infrastructure.BdcException: The shim execution failed unexpectedly - Assembly was requested for LobSystem with Name 'My.BCS.ReferenceData', but this assembly was not returned. SystemUtility of Type 'Microsoft.SharePoint.BusinessData.SystemSpecific.DotNetAssembly.DotNetAssemblySystemUtility' requires the assembly to be uploaded.. ---> System.InvalidOperationException: Assembly was requested for LobSystem with Name 'My.BCS.ReferenceData', but this assembly was not returned. SystemUtility of Type 'Microsoft.SharePoint.BusinessData.SystemSpecific.DotNetAssembly.DotNetAssemblySystemUtility' .............................
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)

Solution:

Please execute the following script in your SharePoint machine (I think any web front end should be OK):

$url = "http://yoursharepointwebapplicationurl/"

#Reference the dll from GAC the version and public token will be different for yours (highlighted below)

$assemblyPath = "C:\Windows\assembly\GAC_MSIL\My.BCS.ReferenceData\1.0.0.0__148de4c699ea2f41\My.BCS.ReferenceData.dll"

$lobSystem = "My.BCS.ReferenceData"

Write-Host "Adding assembly to LOBSystem"

$serviceContext = Get-SPServiceContext $url

$lobSystem = Get-SPBusinessDataCatalogMetadataObject -ServiceContext $serviceContext -BdcObjectType lobsystem -Name $lobSystem

Import-SPBusinessDataCatalogDotNetAssembly -LobSystem $lobSystem -Path $assemblyPath

Please note that the above script will promopt for IIS reset, please continue with yes "Y" option.

The SamlSecurityToken is rejected because the SamlAssertion.NotBefore condition is not satisfied

Go to each machine in your SharePoint Farm

1. Restart the "Windows Time" service.  

2. Open a command prompt and type w32tm /resync​