Error in SQL during Upgrade Task

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: High
    • 4.2
    • Affects Version/s: 4.2 - EAP
    • Component/s: Installation
    • Environment:

      JAC, Performance.

    • 4.02

      2010-05-04 01:49:24,618 main INFO      [jira.upgrade.tasks.UpgradeTask_Build552] Converting search requests to use the new labels system field is 100% complete.
      2010-05-04 01:49:24,618 main INFO      [jira.upgrade.tasks.UpgradeTask_Build552] Updating saved filters to use the new labels system field...DONE
      2010-05-04 01:49:24,618 main INFO      [jira.upgrade.tasks.UpgradeTask_Build552] Updating label gadgets use the new labels system field...
      2010-05-04 01:49:24,717 main ERROR      [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception whi
      le executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY =  ? ) (You have a
      n error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY =  'fieldId' )' at line 1)
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE
      FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY =  ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo
      ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY =  'fieldId' )' at line 1)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:188)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:175)
              at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.updateGadgetConfigurations(UpgradeTask_Build552.java:190)
              at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.doUpgrade(UpgradeTask_Build552.java:151)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:562)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:466)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:402)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:353)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:292)
              at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100)
              at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:49)
              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
              at org.apache.catalina.core.StandardService.start(StandardService.java:516)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:583)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpref
      erence WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY =  ? ) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s
      yntax to use near ') ) AND (USERPREFKEY =  'fieldId' )' at line 1)
              at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:596)
              at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1076)
              at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:919)
              at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:162)
              at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:960)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:183)
              ... 25 more
      

              Assignee:
              Andreas Knecht (Inactive)
              Reporter:
              George Barnett (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m