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

UpgradeTask_Build401$CalculatingResolutionDateConsumer fails on Sybase DBMS with SQLException

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Medium
    • None
    • 4.0
    • Installation

    Description

      Hello,

      when connected to a Sybase DBMS upgrade task UpgradeTask_Build401 will fail throwing an exception due to bad SQL:

      2009-10-14 09:58:51,957 http-8080-4 ERROR anonymous 35884x9x1 1lj127n /secure/SetupImport.jspa [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT MAX(CG.CREATED), CG.issueid FROM changegroup CG INNER JOIN changeitem CI ON CG.ID = CI.groupid WHERE (CG.issueid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) AND ((CI.FIELD =  ? ) OR (CI.FIELD =  ? )) AND (CI.NEWSTRING IS NOT NULL ) AND (CI.OLDVALUE IS NULL ) GROUP BY CG.issueid (TEXT-, IMAGE- und UNITEXT-Datentypen dürfen in WHERE-Klausel nur mit dem Ausdruck LIKE verwendet werden.)
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT MAX(CG.CREATED), CG.issueid FROM changegroup CG INNER JOIN changeitem CI ON CG.ID = CI.groupid WHERE (CG.issueid IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ) AND ((CI.FIELD =  ? ) OR (CI.FIELD =  ? )) AND (CI.NEWSTRING IS NOT NULL ) AND (CI.OLDVALUE IS NULL ) GROUP BY CG.issueid (TEXT-, IMAGE- und UNITEXT-Datentypen dürfen in WHERE-Klausel nur mit dem Ausdruck LIKE verwendet werden.)
      	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:174)
      	at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401$CalculatingResolutionDateConsumer.processBatch(UpgradeTask_Build401.java:279)
      	at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.calculateResolutionDateForAllIssues(UpgradeTask_Build401.java:179)
      	at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.doUpgrade(UpgradeTask_Build401.java:114)
      	at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:508)
      

      Running the query directly returns the following error:

      TEXT, IMAGE and UNITEXT datatypes may not be used in a WHERE clause, except with the LIKE expression.
      

      Best Regards,
      Edoardo

      Attachments

        Activity

          People

            Unassigned Unassigned
            ecausarano Edoardo Causarano [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: