Prev: Restoring a portal site to a new server.
Next: How to upload document into Sharepoint 2007 using the webservice
From: francois_michael_dain on 13 Oct 2006 04:51 Hy During a database migration SPS2003 to MOSS, i have the flowwing error in my update.log : [SPManager] [DEBUG] [08/10/2006 17:55:17]: [SPContentDatabase Name=portails1_site Parent=SPDatabaseServiceInstance] Running 15 of 133 steps [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:17]: Begin Initialize() [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:17]: End Initialize() [SecurityUpgrade2] [3.0.12.2000] [INFO] [08/10/2006 17:55:17]: Security upgrade step 2 : Sites and Webs. [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:17]: Begin Upgrade() [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:17]: ProcessSiteGroups... [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:17]: ProcessWebAcls... [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:18]: Processing web Url=/, Id=273023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE=19 [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:18]: Push sql command to the stack. Length=11623, Params=85. [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [08/10/2006 17:55:18]: Executing 1 sql commands. [SPContentDatabaseSequence] [ERROR] [08/10/2006 17:55:18]: Action 3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed. [SPContentDatabaseSequence] [ERROR] [08/10/2006 17:55:18]: Incorrect syntax near '?'. [SPContentDatabaseSequence] [ERROR] [08/10/2006 17:55:18]: 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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Upgrade.SecurityUpgradeAction.ExecuteSqlCmdList() at Microsoft.SharePoint.Upgrade.SecurityUpgrade2.ProcessWebAcl(Int32 iPageSize) at Microsoft.SharePoint.Upgrade.SecurityUpgrade2.Upgrade() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() Anyone have an idea on how t resolve this problem ? Thanks FMD |