Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-16243

Upgrading Jira to 7.6 causes DVCS to fail on MS SQL environments

    XMLWordPrintable

    Details

      Description

      Summary

      Upgrading Jira from version prior to 7.4 to 7.6+ causes DVCS to fail on MS SQL environments

      Environment

      • Jira 7.6.0
      • Jira database is using a MS SQL server on the backend such as 2012 or 2014

      Steps to Reproduce

      This problem can be reproduced by

      1. Install previous version of Jira such as 7.1.9 or 7.2.x
      2. Use a MS SQL 2012 database
      3. connect Jira to a bitbucket or github repo using the DVCS connector
      4. upgrade Jira to 7.6.0

      Expected Results

      DVCS works

      Actual Results

      DVCS stops working, and the logs have errors such as:

      Caught SQLServerException for select "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY", max("AO_E8B6CC_MESSAGE_QUEUE_ITEM"."RETRIES_COUNT") as "RETRIES_COUNT" from "dbo"."AO_E8B6CC_MESSAGE" "AO_E8B6CC_MESSAGE" left join "dbo"."AO_E8B6CC_MESSAGE_QUEUE_ITEM" "AO_E8B6CC_MESSAGE_QUEUE_ITEM" on "AO_E8B6CC_MESSAGE"."ID" = "AO_E8B6CC_MESSAGE_QUEUE_ITEM"."MESSAGE_ID" where "AO_E8B6CC_MESSAGE"."ID" = ? group by "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY"
      com.querydsl.core.QueryException: Caught SQLServerException for select "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY", max("AO_E8B6CC_MESSAGE_QUEUE_ITEM"."RETRIES_COUNT") as "RETRIES_COUNT" from "dbo"."AO_E8B6CC_MESSAGE" "AO_E8B6CC_MESSAGE" left join "dbo"."AO_E8B6CC_MESSAGE_QUEUE_ITEM" "AO_E8B6CC_MESSAGE_QUEUE_ITEM" on "AO_E8B6CC_MESSAGE"."ID" = "AO_E8B6CC_MESSAGE_QUEUE_ITEM"."MESSAGE_ID" where "AO_E8B6CC_MESSAGE"."ID" = ? group by "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY" 
      

      The more telling error is:

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. 
      

      Which appears to indicate that the DVCS is trying to make a SQL comparison/sort that is not possible in MS SQL

      Notes

       

      Workaround

      • Manually update all columns in table AO_E8B6CC_% from ntext to nvarchar(max)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              aheinzer Andrew Heinzer
              Votes:
              35 Vote for this issue
              Watchers:
              40 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: