Thanks for your help
the first query returns FRENCH_CI_AS
the second NULL
Anyway I found my problem, I believed I had Vault3 on my computer instead it
was Vault2, knowing I migrated my database successfully (to Vault3 then 4)
Thanks;
Alex
"Jeff Pek (Autodesk)" a écrit dans le message de
news: 4948281@discussion.autodesk.com...
Could you try to run these commands on a command line on the server?
osql -S%computername%\AutodeskVault -dMaster -E -Q"SELECT
CAST(SERVERPROPERTY(N'Collation') AS CHAR(50))"
osql -S%computername%\AutodeskVault -E -Q"SELECT
CAST(DATABASEPROPERTY('Vault','Collation') AS CHAR(50))"
and let me know what is output?
Thanks,
Jeff
Jeff Pek (Autodesk) wrote:
> This usually will only happen if you're moving a Vault between systems
> with different locale settings. Is this happening on the same machine on
> which the vault was created?
>
> Jeff
>
> Alexandre DUBOIS wrote:
>
>>I cannot migrate my vault3 database I got an error with sorting :
>>
>>here is the main problem, (see attached log)
>>
>>Échec de ALTER DATABASE. Le classement par défaut de la base de données
>>'Vault' ne peut pas être défini avec la valeur French_CI_AS.
>>
>>but I always installed french vault,
>>
>>Any advices ?
>>
>>thanks,
>>
>>Alex
>>
>>
>>------------------------------------------------------------------------
>>
>>
>>06/09/05 15:00:24:
>>Connectivity.VaultManager.exe -Omigrate -VUadministrator -Lc:\vault.txt
>>
>>06/09/05 15:00:24: Connectivity.Application.VaultManager.ServiceException:
>>MigrateVaultFailed ---> Connectivity.Core.Util.CoreException:
>>MigrateVaultFailed ---> System.Data.SqlClient.SqlException: Le colonne
>>'uf_GetVaultPathFromFileID.VaultPath' dépend du classement de base de
>>données.
>>Le colonne 'uf_RecurseAllVerChildrenAndParents.ParentItemRef' dépend du
>>classement de base de données.
>>Le colonne 'uf_RecurseAllVerChildrenAndParents.ChildrenItemRef' dépend du
>>classement de base de données.
>>Le colonne 'uf_RecurseProjectParent.ProjectPath' dépend du classement de
>>base de données.
>>Échec de ALTER DATABASE. Le classement par défaut de la base de données
>>'Vault' ne peut pas être défini avec la valeur French_CI_AS.
>> at Connectivity.Core.DataAccess.Migrate3toBeta2.Execute()
>> at Connectivity.Core.DataAccess.Migration.Migrate()
>> --- Fin de la trace de la pile d'exception interne ---
>>
>>Server stack trace:
>> at Connectivity.Core.DataAccess.Migration.Migrate()
>> at
>> Connectivity.Core.Services.KnowledgeVaultService.MigrateKnowledgeVault(String
>> vaultName, String dbUser, String dbPass)
>> at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target,
>> Boolean fExecuteInContext)
>> at
>> System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage
>> msg, Int32 methodPtr, Boolean fExecuteInContext)
>>
>>Exception rethrown at [0]:
>> at
>> System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
>> reqMsg, IMessage retMsg)
>> at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
>> msgData, Int32 type)
>> at
>> Connectivity.Core.Services.KnowledgeVaultService.MigrateKnowledgeVault(String
>> vaultName, String dbUser, String dbPass)
>> at
>> Connectivity.Application.VaultManager.KnowledgeVaultService.MigrateKnowledgeVault(String
>> vaultName, String dbUser, String dbPass)
>> --- Fin de la trace de la pile d'exception interne ---
>> at
>> Connectivity.Application.VaultManager.KnowledgeVaultService.MigrateKnowledgeVault(String
>> vaultName, String dbUser, String dbPass)
>> at
>> Connectivity.Application.VaultManager.MigrateAllCommand.DoVaultsMigrate(LoginInfo
>> dbLogin)
>>06/09/05 15:00:27:
>>
>>
