Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-5847

Query DSL provider plugin is not always being updated when Service Desk is updated

XMLWordPrintable

      Summary

      query dsl provider plugin is not always being updated when Service Desk is updated

      Environment

      Still trying to determine what environmental aspects might factor in here

      Steps to Reproduce

      1. Have an existing work Jira Service Desk (say a 3.7 or 3.8 version)
      2. Upgrade Jira/Service Desk to a more recent version, such as 7.9.2/3.12.2 or 7.10.0/3.13.0

      Expected Results

      Service Desk Queues should be functional after the upgrade

      Actual Results

      Queues are not working.
      Logs show error messages like this:

      2018-06-06 10:10:20,107 http-nio-1081-exec-10 ERROR <username> 610x154x1 192r6a6 (null),<user-ip>,127.0.0.1 /rest/servicedesk/1/servicedesk/<projectname>/queues [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: com.querydsl.sql.dml.SQLInsertClause.getBatchCount()I
java.lang.NoSuchMethodError: com.querydsl.sql.dml.SQLInsertClause.getBatchCount()I
 at com.atlassian.servicedesk.internal.feature.queue.QueueStore.addColumns(QueueStore.java:218)
 at com.atlassian.servicedesk.internal.feature.queue.QueueStore.addQueue(QueueStore.java:111)
 at com.atlassian.servicedesk.internal.feature.queue.QueueManagerImpl.lambda$null$4(QueueManagerImpl.java:80)
 at io.atlassian.fugue.Either$RightProjection.map(Either.java:872)
 at io.atlassian.fugue.Either.map(Either.java:217)
...

      Other variants include: 

      "com.querydsl.sql.dml.SQLUpdateClause.getBatchCount () I"

      Cause

      The Query dsl provider plugin is not always installed in the correct needed version after the upgrade.
      ie. SD 3.13 needs the plugin version 4.1.4, but sometimes only 4.0.7 is available.

      Workaround

      We can manually update this query dsl plugin to a newer version to fix this:

      1. Download the querydsl 4.1.4 plugin jar file in this link: querydsl-4.1.4-provider-plugin-1.0.jar
      2. Stop JIRA
      3. Remove the querydsl jar file that is located in the directory $JIRA_HOME/plugins/installed-plugins/ (the file name should be similar to querydsl-4.0.7-provider-plugin-1.1)
      4. Copy the downloaded file into this same /installed-plugins/ folder
      5. Start JIRA

      Notes

      This problem does not happen for all upgrades. Only some customers have found this plugin is not updating in their system.

            [JSDSERVER-5847] Query DSL provider plugin is not always being updated when Service Desk is updated

              szaporozhtsev Sergey Zaporozhtsev (Inactive)
              aheinzer Andy Heinzer
              Affected customers:
              35 This affects my team
              Watchers:
              42 Start watching this issue

                Created:
                Updated:
                Resolved: