Friday, March 20, 2015

The external credentials in the SSO database are more recent.

I got the following error when adding Trading Partner information in the BizTalk console.

Software I was using:

BizTalk 2013 R2
SQL 2014
 
SSO AUDIT
 Function: SetConfigInfo
 Tracking ID: 7e95dcb7-088f-4b8a-aa6a-57a3141132f0
 Client Computer: local (mmc.exe:6916)
 Client User:
 Application Name: {6d186731-31d0-45d6-a773-7a7f9f516138}
 Error Code: 0xC0002A40, The external credentials in the SSO database are more recent.

Or

SSO AUDIT
 Function: GetConfigInfo ({5DDE9C84-BF89-47FF-8F19-4862FE3F0FA8})
 Tracking ID: 51cb5a98-a60a-4481-9631-c47f6d6ea68f
 Client Computer: local (BTSNTSvc.exe:14568)
 Client User: BiztalkDev
 Application Name: {56B82475-ED73-456B-9F68-1F4599F11E01}
 Error Code: 0x80090005, Bad Data.


Local server name removed.






replacing the stored procedure in the SSO database ([dbo].[ssox_spStoreXp2]) seem to solve this problem.  I got this SQL stored procedure from MS.  See download:


Download:


https://sites.google.com/site/biztalkcsharpandsql/SSOPatch.sql?attredirects=0&d=1

No comments:

Post a Comment