From: francois_michael_dain on
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