Self Signed SSL Certificate with MakeCert

Requirement: Create a self signed certificate for SSL with private key and public key

Solution:

The following command can be used to create private key and public key. 

makecert -r -pe -n "CN=mycompany.com" -b 08/07/2015 -e 08/07/2040 -sky exchange Server.cer -sv Server.pvk

pvk2pfx.exe -pvk Server.pvk -spc Server.cer -pfx Server.pfx

Additional Details:

To understand the command more in details, please refer below link:

https://msdn.microsoft.com/en-us/library/bfsktky3(v=vs.90).aspx

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

Solution:

Go to all SharePoint Servers in Farm and perform the following:

1. Restart the "Windows Time" service.  

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

 

Panel

Click to slide down panel

Hello world!

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​