I am getting this error when trying to access Bamboo . I just did an upgrade from 5.15 to 6.1. In the log files, the fatal error is:
Bamboo DB must use case and accent sensitive (*_CS_AS) or binary (*_BIN) collation on all tables and columns.
My database is SQL Server and it's worked before. When I check the collation it says :
Latin1_General_CS_AS
So what am I doing wrong? How can I fix this?
Hi John,
I would verify the collation with the following query from the How to fix the collation of a Microsoft SQL Server database knowledge base article:
SELECT object_name(object_id) as TableName, name as ColumnName, collation_name
FROM sys.columns
WHERE collation_name <> 'Latin1_General_CS_AS'
AND object_name(object_id) NOT LIKE 'sys%'
AND object_name(object_id) NOT LIKE 'queue%'
AND object_name(object_id) NOT LIKE 'file%'
AND object_name(object_id) NOT LIKE 'spt%'
AND object_name(object_id) NOT LIKE 'MSrep%'
If it does not come back with the correct collations you'll need to setup the database per the instructions in Connecting Bamboo to an external database:Microsoft SQL Server.
If that comes out with the correct collation the next step would be to review the atlassian-bamboo.log for any additonal errors.
Cheers,
Branden
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.