Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Upgrade error from 4.0.1 to 4.1.0 (Lite)

Description

Nothing is working after upgrading this addon from version 4.0.1 to 4.1.0.

Error on admin page:

There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:12.00.6329 - minor version:0 - major version:12 Driver: - name:Microsoft JDBC Driver 7.2 for SQL Server - version:7.2.1.0 com.microsoft.sqlserver.jdbc.SQLServerException: Column 'dbo.AO_3FB43F_BUILDS.ID' is not of same collation as referencing column 'AO_3FB43F_BUILD_TO_DEPLOY_ENVS.BUILD_ID' in foreign key 'fk_ao_3fb43f_build_to_deploy_envs_build_id'. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:53) at org.marvelution.jji.data.access.model.v2.To_7_StoreJobParentNames.upgrade(To_7_StoreJobParentNames.java:48)

Environment

Jira Server 8.5.1 (docker self-hosted)

Attachments

3
  • 18 Nov 2019, 10:14 AM
  • 18 Nov 2019, 09:52 AM
  • 18 Nov 2019, 09:52 AM

Activity

Show:

Mark Rekveld November 18, 2019 at 11:47 AM

Cool thanks for letting me know.

Michael Kriese November 18, 2019 at 11:08 AM

This can be closed, as it was a collation mismatch in my database.
After fixing collation, upgrade went fine.

Regards,
Michael

Michael Kriese November 18, 2019 at 10:15 AM

Look like i have some collation mismatches

I'll try to fix that and report back.

Michael Kriese November 18, 2019 at 9:53 AM

Here some structure information. jira2 is the database name.

Mark Rekveld November 18, 2019 at 9:46 AM

I'm not sure which settings would be of interest. I'm no DBA and not sure what MSSQL has to offer that would impact this or cause this error.

I'll try to see if I can find any setting in MSSQL docs.

Cheers,
Mark

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Zoom

Open Zoom
Created November 12, 2019 at 1:54 PM
Updated November 18, 2019 at 11:47 AM
Resolved November 18, 2019 at 11:47 AM
Configure
Zoom