Upgrading Bamboo to 6.1 from 5.15 getting database error

jyanOSU

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?

somethingblue

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:

 

<span class="token keyword">SELECT</span> object_name<span class="token punctuation">(</span>object_id<span class="token punctuation">)</span> <span class="token keyword">as</span> TableName<span class="token punctuation">,</span> name <span class="token keyword">as</span> ColumnName<span class="token punctuation">,</span> collation_name
<span class="token keyword">FROM</span> sys<span class="token punctuation">.</span><span class="token keyword">columns</span>
<span class="token keyword">WHERE</span> collation_name <span class="token operator"><></span> <span class="token string">'Latin1_General_CS_AS'</span>
<span class="token operator">AND</span> object_name<span class="token punctuation">(</span>object_id<span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token operator">LIKE</span> <span class="token string">'sys%'</span>
<span class="token operator">AND</span> object_name<span class="token punctuation">(</span>object_id<span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token operator">LIKE</span> <span class="token string">'queue%'</span>
<span class="token operator">AND</span> object_name<span class="token punctuation">(</span>object_id<span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token operator">LIKE</span> <span class="token string">'file%'</span>
<span class="token operator">AND</span> object_name<span class="token punctuation">(</span>object_id<span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token operator">LIKE</span> <span class="token string">'spt%'</span>
<span class="token operator">AND</span> object_name<span class="token punctuation">(</span>object_id<span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token operator">LIKE</span> <span class="token string">'MSrep%'</span><code>

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