SSO error while start and stopping the application

SSO error while start and stopping the application

An error of this form appears while trying to start/delete/restart the BizTalk application in Administration console:

"Could not store transport type data for Receive Location 'Recv.Loc' to config store. Primary SSO Server 'Sql-server' failed. The external credentials in the SSO database are more recent."

Error details are:

SSO AUDIT
Function: SetConfigInfo
Tracking ID: df1dd0b0-c9d5-4012-bb97-336aa8df78b3
Client Computer: BTS06-Platform.contoso.com (mmc.exe:1884)
Client User: BTS06-PLATFORM\Administrator
Application Name: {D2241406-0767-4C13-98EB-43EECE80F8A0}
Error Code: 0xC0002A40, The external credentials in the SSO database are more recent.

Description

This error arises when the system date is not correct.

·         Run the following query in SSODB database.

select dateadd(m,-1,ec_timestamp),* from SSODB..SSOX_ExternalCredentials
where datediff(m,ec_timestamp,getdate())<>0

select dateadd(year,-1,ec_timestamp),* from SSODB..SSOX_ExternalCredentials
where datediff(year,ec_timestamp,getdate())<>0

·         If any rows are retrieved then there has been some changes in the system date. Run the following query in case any rows are retrieved in the first case.

update SSODB..SSOX_ExternalCredentials set  ec_timestamp = dateadd(m,-1,ec_timestamp) where datediff(m,ec_timestamp,getdate())<>0

update SSODB..SSOX_ExternalCredentials set  ec_timestamp = dateadd(year,-1,ec_timestamp) where datediff(year,ec_timestamp,getdate())<>0

·         Now restart Host Instances and continue with the application.

Can't able connect with SSODB from biztalk admin console

Can't able connect with SSODB from biztalk admin console

There are lot of causes and solutions available in the internet. But I have the issue which is entirely different from others and fortunately I have solved the issue!!!!
root Cause:
I have did something in the biztalk admin console regarding Entereprise SSO configuration.

Problem:

I can't restart or start the application in the console.

Solation:

1.Reconfigure the SSO related thing from the stable documentation or try recall from your memeory if possible
2.Restore the stable config with the export config options