Collation error upgrading from 5 to 6

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
didzisk
Posts: 1
Joined: Wed Aug 29, 2012 6:12 am

Collation error upgrading from 5 to 6

Post by didzisk » Wed Aug 29, 2012 6:22 am

This is my log file:

Code: Select all

This may take a long time. Do NOT stop this process!
	Checking the installed database version... 5.1.0.0
OK
Putting sgvault database in single-user mode.
getting the collation of the current source control database
the Vault database has the collation SQL_Danish_Pref_CP1_CI_AS
Executing commands in index_ddl.sql
Read index_ddl.sql from our resources.
substituting collation for index_ddl.sqlwith collation SQL_Danish_Pref_CP1_CS_AS
	Creating SourceGear indexing database schema...Error executing SQL command in index_ddl.sql-------
 CREATE DATABASE [sgvaultindex]  COLLATE SQL_Danish_Pref_CP1_CS_AS 
--------
Invalid collation 'SQL_Danish_Pref_CP1_CS_AS'.
Vault Standard Setup is exiting due to a failure or cancellation. Error Code = -1280
Invalid collation 'SQL_Danish_Pref_CP1_CS_AS'.
Vault Standard Setup is exiting due to a failure or cancellation. Error Code = -1280ExitCode on exit: -1280
It looks like the installation is trying to use an (nonexistent) Case Sensitive (CS) collation, even if both existing databases use CI.

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Collation error upgrading from 5 to 6

Post by Beth » Wed Aug 29, 2012 10:05 am

We're checking into this now.

Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?
Beth Kieler
SourceGear Technical Support

Post Reply