Upgrading Bamboo to 6.1 from 5.15 getting database error

jyanOSU September 2, 2017

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?

1 answer

0 votes
somethingblue
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 5, 2017

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events