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

Upgrade to 3.5.2 Professional causes error with Oracle 8i backend

    XMLWordPrintable

Details

    • Support Request
    • Resolution: Obsolete
    • Highest
    • None
    • 3.5.2
    • Installation
    • Linux Oracle 8i Tomcat 4

    Description

      Upgrade from 3.4 fails with SQL Exception:
      2006-03-10 16:07:00,040 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: S
      QL Exception while executing the following:SELECT PE.PROPERTY_KEY, PE.ENTITY_NAME, PE.ID, PS.propertyvalue FROM propertyentry PE LEFT JOIN propertystring PS O
      N PE.ID = PS.ID WHERE PE.PROPERTY_KEY=? AND PE.ENTITY_NAME=? (ORA-00933: SQL command not properly ended
      )
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PE.PROP
      ERTY_KEY, PE.ENTITY_NAME, PE.ID, PS.propertyvalue FROM propertyentry PE LEFT JOIN propertystring PS ON PE.ID = PS.ID WHERE PE.PROPERTY_KEY=? AND PE.ENTITY_NAM
      E=? (ORA-00933: SQL command not properly ended
      )
      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByAnd(DefaultOfBizDelegator.java:32)
      at com.atlassian.jira.user.util.UserUtilImpl.getUserLocalePreferenceEntries(UserUtilImpl.java:131)
      at com.atlassian.jira.user.util.UserUtilImpl.getUserLocalePreferenceCount(UserUtilImpl.java:122)
      at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build125.doUpgrade(UpgradeTask_Build125.java:60)
      at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:681)
      at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:577)
      at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:403)
      at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:351)
      at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:311)
      at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:68)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3212)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:3554)
      at org.apache.catalina.core.StandardHostDeployer.start(StandardHostDeployer.java:582)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:866)
      at org.apache.catalina.servlets.ManagerServlet.start(ManagerServlet.java:1056)
      at org.apache.catalina.servlets.HTMLManagerServlet.start(HTMLManagerServlet.java:506)
      at org.apache.catalina.servlets.HTMLManagerServlet.doGet(HTMLManagerServlet.java:108)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
      :

      Attachments

        Activity

          People

            Unassigned Unassigned
            f2a173cc4428 Eric Helfrich
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: