OVH Cloud OVH Cloud

[MOSS2007] Erreur lors de la migration

14 réponses
Avatar
Memnoch
Bonjour,

J'ai déja posté un post similaire, mais ce dernier manquant d'information.
Voici un complément d'information.

L'erreur semble se produire à la deuxième étape de la migration des
sécurité. Voici un extrait du fichier de log :

[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Initialize()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
Initialize()
[SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
upgrade step 2 : Sites and Webs.
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Upgrade()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
ProcessSiteGroups...
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
ProcessWebAcls...
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Processing
web Url=/, Id=273023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE=19
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
command to the stack. Length=11623, Params=85.
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executing 1
sql commands.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax
near 'à'.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: 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()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Rollback()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Rollback()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Dispose()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Dispose()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
time: 00:00:00.4897501.
[SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
[SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
[SPManager] [ERROR] [13/10/2006 14:35:22]: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

Si vous avez une id, je suis preneur.


Merci

--
http://fmdain.blogspot.com/

10 réponses

1 2
Avatar
gilbert.nicolet
J'ai eu exactement la même erreur.
Voyant le petit "Incorrect syntax near 'à'. "
J'ai attribué cela à un problème à migrer des sites en
Français.... mais j'ai pas trouvé de solution.
Si ça peut donner une piste....
Avatar
Memnoch
En ce moment, je fais du profiling SQL pour savoir sur quelle commande, il y
a l'erreur...

--
http://fmdain.blogspot.com/


"" wrote:

J'ai eu exactement la même erreur.
Voyant le petit "Incorrect syntax near 'à'. "
J'ai attribué cela à un problème à migrer des sites en
Français.... mais j'ai pas trouvé de solution.
Si ça peut donner une piste....




Avatar
EROL MVP SPS - Club SharePoint MOSS FRANCE
Bonsoir,

Vous indiquez migration SPS 2003 vers MOSS 2007.

1 - Plate-forme en Français ?
2 - Base SQL 2005 quelle version et en Français ?
3 - AD sur un autre serveur que celui de MOSS 2007 ?

C'est bien cela ?
--
Cdlt
--
P. Erol GIRAUDY
--
Devenez membre du club SharePoint www.clubsps.org
Pour vous inscrire gratuitement au club SPS MOSS FRANCE,
cliquer ici : http://inscrits.clubsps.org/ .
http://www.shareclubs.org

"Memnoch" a écrit dans le message de
news:
Bonjour,

J'ai déja posté un post similaire, mais ce dernier manquant d'information.
Voici un complément d'information.

L'erreur semble se produire à la deuxième étape de la migration des
sécurité. Voici un extrait du fichier de log :

[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Initialize()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
Initialize()
[SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
upgrade step 2 : Sites and Webs.
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Upgrade()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
ProcessSiteGroups...
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
ProcessWebAcls...
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Processing
web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
command to the stack. Length623, ParamsÂ….
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executing
1
sql commands.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence
failed.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect
syntax
near 'à'.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: 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()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Rollback()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
Rollback()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Dispose()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
Dispose()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
time: 00:00:00.4897501.
[SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
[SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
[SPManager] [ERROR] [13/10/2006 14:35:22]: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

Si vous avez une id, je suis preneur.


Merci

--
http://fmdain.blogspot.com/


Avatar
Memnoch
Plateforme Française
SQl2k5 FR
Même AD
--
http://fmdain.blogspot.com/


"EROL MVP SPS - Club SharePoint MOSS FRAN" wrote:

Bonsoir,

Vous indiquez migration SPS 2003 vers MOSS 2007.

1 - Plate-forme en Français ?
2 - Base SQL 2005 quelle version et en Français ?
3 - AD sur un autre serveur que celui de MOSS 2007 ?

C'est bien cela ?
--
Cdlt
--
P. Erol GIRAUDY
--
Devenez membre du club SharePoint www.clubsps.org
Pour vous inscrire gratuitement au club SPS MOSS FRANCE,
cliquer ici : http://inscrits.clubsps.org/ .
http://www.shareclubs.org

"Memnoch" a écrit dans le message de
news:
> Bonjour,
>
> J'ai déja posté un post similaire, mais ce dernier manquant d'information.
> Voici un complément d'information.
>
> L'erreur semble se produire à la deuxième étape de la migration des
> sécurité. Voici un extrait du fichier de log :
>
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Initialize()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Initialize()
> [SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
> upgrade step 2 : Sites and Webs.
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Upgrade()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> ProcessSiteGroups...
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> ProcessWebAcls...
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Processing
> web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
> command to the stack. Length623, ParamsÂ….
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executing
> 1
> sql commands.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
> 3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence
> failed.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect
> syntax
> near 'à'.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: 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()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Rollback()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Rollback()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Dispose()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Dispose()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
> time: 00:00:00.4897501.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
> Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean
> breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
>
> Si vous avez une id, je suis preneur.
>
>
> Merci
>
> --
> http://fmdain.blogspot.com/





Avatar
Memnoch
SPS2003 FR --> MOSS2007 B2TRFR
SQL2k5 FR
Même AD pour les deux serveurs
--
http://fmdain.blogspot.com/


"EROL MVP SPS - Club SharePoint MOSS FRAN" wrote:

Bonsoir,

Vous indiquez migration SPS 2003 vers MOSS 2007.

1 - Plate-forme en Français ?
2 - Base SQL 2005 quelle version et en Français ?
3 - AD sur un autre serveur que celui de MOSS 2007 ?

C'est bien cela ?
--
Cdlt
--
P. Erol GIRAUDY
--
Devenez membre du club SharePoint www.clubsps.org
Pour vous inscrire gratuitement au club SPS MOSS FRANCE,
cliquer ici : http://inscrits.clubsps.org/ .
http://www.shareclubs.org

"Memnoch" a écrit dans le message de
news:
> Bonjour,
>
> J'ai déja posté un post similaire, mais ce dernier manquant d'information.
> Voici un complément d'information.
>
> L'erreur semble se produire à la deuxième étape de la migration des
> sécurité. Voici un extrait du fichier de log :
>
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Initialize()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Initialize()
> [SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
> upgrade step 2 : Sites and Webs.
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Upgrade()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> ProcessSiteGroups...
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> ProcessWebAcls...
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Processing
> web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
> command to the stack. Length623, ParamsÂ….
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executing
> 1
> sql commands.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
> 3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence
> failed.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect
> syntax
> near 'à'.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: 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()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Rollback()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Rollback()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Dispose()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Dispose()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
> time: 00:00:00.4897501.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
> Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean
> breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
>
> Si vous avez une id, je suis preneur.
>
>
> Merci
>
> --
> http://fmdain.blogspot.com/





Avatar
Java
Dans mon cas:
Windows server 2003 en Français
WSS2 installé anglais puis pack de langues
Pas de SQL, uniquement le MSDE installé automatiquement avec WSS2
pas de MOOS/SPS, uniquement WSS
AD sur un autre serveur
Le but était simplement de créer une machine WSS2, d'y copier des
sites WSS2 pour ensuite les migrer en 3.00 pour démonstration/tests

Je profite pour avoir des précisions sur la procédure.
Avec WSS2, on installe WSS2 anglais puis pack de langues français
avec WSS 3, qu'installer et dans quel ordre (pour un upgrade) entre
WSS 3 beta anglais
WSS 3 beta français
WSS 3 TR anglais
WSS 3 TR français
Avatar
Memnoch
Je viens de trouver la cause du problème, mais bon ca vas être dur de corrigé
vu que le SQL est généré par MOSS
--
http://fmdain.blogspot.com/


"Memnoch" wrote:

Bonjour,

J'ai déja posté un post similaire, mais ce dernier manquant d'information.
Voici un complément d'information.

L'erreur semble se produire à la deuxième étape de la migration des
sécurité. Voici un extrait du fichier de log :

[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Initialize()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
Initialize()
[SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
upgrade step 2 : Sites and Webs.
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Upgrade()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
ProcessSiteGroups...
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
ProcessWebAcls...
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Processing
web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
command to the stack. Length623, ParamsÂ….
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executing 1
sql commands.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax
near 'à'.
[SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: 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()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Rollback()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Rollback()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
Dispose()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Dispose()
[SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
time: 00:00:00.4897501.
[SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
[SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
[SPManager] [ERROR] [13/10/2006 14:35:22]: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

Si vous avez une id, je suis preneur.


Merci

--
http://fmdain.blogspot.com/


Avatar
bboule
Y aurait-il possibiltié que tu nous explique quelle est la solution
?????

Ca sera pratique !!!

merci d'avance

Cédric Petter

On Oct 16, 2:05 pm, Memnoch wrote:
Je viens de trouver la cause du problème, mais bon ca vas être dur de corrigé
vu que le SQL est généré par MOSS
--http://fmdain.blogspot.com/



"Memnoch" wrote:
> Bonjour,

> J'ai déja posté un post similaire, mais ce dernier manquant d'infor mation.
> Voici un complément d'information.

> L'erreur semble se produire à la deuxième étape de la migration d es
> sécurité. Voici un extrait du fichier de log :

> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Initialize()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> Initialize()
> [SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
> upgrade step 2 : Sites and Webs.
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Upgrade()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> ProcessSiteGroups...
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> ProcessWebAcls...
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Process ing
> web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
> command to the stack. Length623, Params….
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executi ng 1
> sql commands.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
> 3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence f ailed.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect sy ntax
> near 'à'.
> [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boo lean
> breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserState Obje­ct
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReade r ds,
> RunBehavior runBehavior, String resetOptionsString)
> at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehav ior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean asy nc)
> at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String meth od,
> DbAsyncResult result)
> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncR esult
> result, String methodName, Boolean sendToPipe)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlComm and
> command)
> at Microsoft.SharePoint.Upgrade.SecurityUpgradeAction.ExecuteSqlCmdL ist()
> at Microsoft.SharePoint.Upgrade.SecurityUpgrade2.ProcessWebAcl(Int32
> iPageSize)
> at Microsoft.SharePoint.Upgrade.SecurityUpgrade2.Upgrade()
> at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Rollback()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Rol lback()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> Dispose()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Dis pose()
> [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
> time: 00:00:00.4897501.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
> Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
> [SPManager] [ERROR] [13/10/2006 14:35:22]: at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boo lean
> breakConnection)
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)

> Si vous avez une id, je suis preneur.

> Merci

> --
>http://fmdain.blogspot.com/- Hide quoted text -- Show quoted text -


Avatar
bboule
C'est bon j'ai trouvé tout seul comme un grand !!
Il faut lors de la création de l'intance SQL, dans les paramètres du
classement du service, mettre les données suivantes :
- Indicateur de classement : Latin1 General
- décocher respecter la casse
- cocher respecter les accents
- cocher respecter les caractères Kana
- cocher respecter la largeur

et le tour est joué !!!

Salutations tout le monde

Cédric Petter

On Oct 16, 3:21 pm, "bboule" wrote:
Y aurait-il possibiltié que tu nous explique quelle est la solution
?????

Ca sera pratique !!!

merci d'avance

Cédric Petter

On Oct 16, 2:05 pm, Memnoch wrote:



> Je viens de trouver la cause du problème, mais bon ca vas être dur de corrigé
> vu que le SQL est généré par MOSS
> --http://fmdain.blogspot.com/

> "Memnoch" wrote:
> > Bonjour,

> > J'ai déja posté un post similaire, mais ce dernier manquant d'inf ormation.
> > Voici un complément d'information.

> > L'erreur semble se produire à la deuxième étape de la migration des
> > sécurité. Voici un extrait du fichier de log :

> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > Initialize()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> > Initialize()
> > [SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Securi ty
> > upgrade step 2 : Sites and Webs.
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > Upgrade()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> > ProcessSiteGroups...
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> > ProcessWebAcls...
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Proce ssing
> > web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=Tru e, cACE
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
> > command to the stack. Length623, Params….
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Execu ting 1
> > sql commands.
> > [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
> > 3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
> > [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax
> > near 'à'.
> > [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: at
> > System.Data.SqlClient.SqlConnection.OnError(SqlException exception, B oolean
> > breakConnection)
> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, Boolean breakConnection)
> > at
> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserSta teObje­­ct
> > stateObj)
> > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResult Set
> > bulkCopyHandler, TdsParserStateObject stateObj)
> > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataRea der ds,
> > RunBehavior runBehavior, String resetOptionsString)
> > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBeh avior
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean a sync)
> > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavi or
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String me thod,
> > DbAsyncResult result)
> > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyn cResult
> > result, String methodName, Boolean sendToPipe)
> > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> > at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCo mmand
> > command)
> > at Microsoft.SharePoint.Upgrade.SecurityUpgradeAction.ExecuteSqlCm dList()
> > at Microsoft.SharePoint.Upgrade.SecurityUpgrade2.ProcessWebAcl(Int 32
> > iPageSize)
> > at Microsoft.SharePoint.Upgrade.SecurityUpgrade2.Upgrade()
> > at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > Rollback()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End R ollback()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > Dispose()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End D ispose()
> > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elaps ed
> > time: 00:00:00.4897501.
> > [SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
> > Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
> > [SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à '.
> > [SPManager] [ERROR] [13/10/2006 14:35:22]: at
> > System.Data.SqlClient.SqlConnection.OnError(SqlException exception, B oolean
> > breakConnection)
> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, Boolean breakConnection)

> > Si vous avez une id, je suis preneur.

> > Merci

> > --
> >http://fmdain.blogspot.com/-Hide quoted text -- Show quoted text -- Hi de quoted text -- Show quoted text -


Avatar
Memnoch
et migration fonctionne ?
--
http://fmdain.blogspot.com/


"bboule" wrote:

C'est bon j'ai trouvé tout seul comme un grand !!
Il faut lors de la création de l'intance SQL, dans les paramètres du
classement du service, mettre les données suivantes :
- Indicateur de classement : Latin1 General
- décocher respecter la casse
- cocher respecter les accents
- cocher respecter les caractères Kana
- cocher respecter la largeur

et le tour est joué !!!

Salutations tout le monde

Cédric Petter

On Oct 16, 3:21 pm, "bboule" wrote:
> Y aurait-il possibiltié que tu nous explique quelle est la solution
> ?????
>
> Ca sera pratique !!!
>
> merci d'avance
>
> Cédric Petter
>
> On Oct 16, 2:05 pm, Memnoch wrote:
>
>
>
> > Je viens de trouver la cause du problème, mais bon ca vas être dur de corrigé
> > vu que le SQL est généré par MOSS
> > --http://fmdain.blogspot.com/
>
> > "Memnoch" wrote:
> > > Bonjour,
>
> > > J'ai déja posté un post similaire, mais ce dernier manquant d'information.
> > > Voici un complément d'information.
>
> > > L'erreur semble se produire à la deuxième étape de la migration des
> > > sécurité. Voici un extrait du fichier de log :
>
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > > Initialize()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End
> > > Initialize()
> > > [SecurityUpgrade2] [3.0.12.2000] [INFO] [13/10/2006 14:35:22]: Security
> > > upgrade step 2 : Sites and Webs.
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > > Upgrade()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> > > ProcessSiteGroups...
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]:
> > > ProcessWebAcls...
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Processing
> > > web Url=/, Id'3023eb-c4ba-4587-9a61-a51b10dad153, RootWeb=True, cACE
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Push sql
> > > command to the stack. Length623, ParamsÂ….
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Executing 1
> > > sql commands.
> > > [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Action
> > > 3.0.12.2000 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed.
> > > [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax
> > > near 'à'.
> > > [SPContentDatabaseSequence] [ERROR] [13/10/2006 14:35:22]: 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(TdsParserStateObje­­ct
> > > 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()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > > Rollback()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Rollback()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Begin
> > > Dispose()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: End Dispose()
> > > [SecurityUpgrade2] [3.0.12.2000] [DEBUG] [13/10/2006 14:35:22]: Elapsed
> > > time: 00:00:00.4897501.
> > > [SPManager] [ERROR] [13/10/2006 14:35:22]: Upgrade [SPContentDatabase
> > > Name=portails1_site Parent=SPDatabaseServiceInstance] failed.
> > > [SPManager] [ERROR] [13/10/2006 14:35:22]: Incorrect syntax near 'à'.
> > > [SPManager] [ERROR] [13/10/2006 14:35:22]: at
> > > System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
> > > breakConnection)
> > > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > exception, Boolean breakConnection)
>
> > > Si vous avez une id, je suis preneur.
>
> > > Merci
>
> > > --
> > >http://fmdain.blogspot.com/-Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -




1 2