Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-38536

Installation of Wallboard plugin causes SQL exception to be thrown in JIRA logs when using SQL Server

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 6.3.1
    • 6.2.2, 6.2.5, 6.2.6
    • Dashboard & Gadgets
    • Wallboard plugin v.1.8.4
      SQL server 2008, 2012, jTDS 1.2.4

    Description

      Steps to reproduce

      • Setup a JIRA installation with SQL server as the database
      • Install the Wallboard plugin (current version is v.1.8.4)

      Results

      • The wallboard plugin is installed successfully as expected
      • The wallboard plugin appears to be functional as expected
      • The following errors are thrown in the logs on installing the plugin, and during subsequent JIRA restarts
        2014-05-29 23:41:23,246 localhost-startStop-1 ERROR      [sal.core.upgrade.DefaultPluginUpgradeManager] Upgrade error: Unexpected exception caught during plugin upgrade: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTALPAGE, PORTLET_ID, COLUMN_NUMBER, positionseq, GADGET_XML, COLOR FROM dbo.portletconfiguration WHERE (GADGET_XML =  ? ) (The data types ntext and nvarchar are incompatible in the equal to operator.)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:499)
        	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:336)
        

      Workaround
      No workaround needed. For the instances on which this upgrade task fails, it actually does nothing. So, if you are unable to launch a dashboard after your recent JIRA upgrade it must be due to an unrelated issue.

      Attachments

        Issue Links

          Activity

            People

              idick Ian Dick
              takindele Taiwo Akindele (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              21 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: