Details
-
Support Request
-
Resolution: Obsolete
-
Highest
-
None
-
3.5.2
-
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)
: