addcontentdb: "The signature of the public key is invalid."
in [Windows Services]
|
Prev: spdwfextensions -unable to use workflow variables
Next: Configuration deployment test -> staging -> prod ? How to automati
From: Jan Welmann on 12 Nov 2009 06:16 Hello, we have the following scenario: -Our old SharePoint crashed -There were no backups -The only thing that could be rescued were the .mdf files from the sharepoint config and content db's -It's my job to clean up the mess. The new machine has the same setup as the old one: SQL2k5+SPS2007 SP2 I tryied the following to recover the web app: -Create new web app + site collection via central admin -Copy old content db to sharepoint sql-server data directory -Attached database via Management Studio -STSADM -o addcontentdb -url http://theurl:2080 -databasename WSS_Content_... The last step fails with this msg (excerpt from 'Upgrade.log'): --BEGIN EXCERPT-- [SPContentDatabaseSequence] [DEBUG] [11/12/2009 11:51:51 AM]: Finished executing database object restore script. [SPContentDatabaseSequence] [DEBUG] [11/12/2009 11:51:51 AM]: Executing SQL DDL Script. [SPContentDatabaseSequence] [DEBUG] [11/12/2009 11:51:51 AM]: Applying WYukon signature to SPContentDatabase Name=WSS_Content_650874d60fa9405db9b28c2de50d76f8 Parent=SPDatabaseServiceInstance Name=Microsoft##SSEE. [SPManager] [ERROR] [11/12/2009 11:51:51 AM]: Upgrade [SPContentDatabase Name=WSS_Content_650874d60fa9405db9b28c2de50d76f8 Parent=SPDatabaseServiceInstance Name=Microsoft##SSEE] failed. [SPManager] [ERROR] [11/12/2009 11:51:51 AM]: The signature of the public key is invalid. Signing object:[dbo].[AllDocs] [SPManager] [ERROR] [11/12/2009 11:51:51 AM]: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteScript(TextReader textReader, Int32 commandTimeout) at Microsoft.SharePoint.Administration.SPDatabase.ApplyWYukonSignatureFile(SqlSession session, String sqlSignaturePath) at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ApplyWYukonSignature(String sqlSignaturePath) at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.PostUpgrade() at Microsoft.SharePoint.Upgrade.SPManager.Upgrade(Object o, Boolean bRecurse) --END EXERPT-- I have no idea what this message is about. Did the old sharepoint add a certificate to the db that is incompatible with the new installation? Can you give me any advice on how to move on? Cheers, Jan |