java.sql.SQLException: Cannot alter table 'usergrouppermissions' because this table does not exist in database 'tester'.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I'm using LocalSessionFactoryBean.updateDatabaseSchema and it's not working very well on SQL Server. Basically, if there are errors in the upgrade scripts generated by Hibernate, the update does not go through. I'm not sure exactly why this is happening but perhaps some log output and a couple fixes to the problem will help illustrate what's going on. Here is some log output: DEBUG (LocalSessionFactoryBean:executeSchemaScript) - Executing schema statement: create table usergrouppermissions (usergroupid int not null, permissionid int not null, primary key (usergroupid, permissionid)) DEBUG (LocalSessionFactoryBean:executeSchemaScript) - Executing schema statement: alter table files add constraint FK5CEBA778EB197A2 foreign key (createdbyuserid) references users WARN (LocalSessionFactoryBean:executeSchemaScript) - Unsuccessful schema statement: alter table files add constraint FK5CEBA778EB197A2 foreign key (createdbyuserid) references users java.sql.SQLException: Cannot alter table 'files' because this table does not exist in database 'tester'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:597) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:465) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:427) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1000) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:906) Then, later on in the log file.... WARN (LocalSessionFactoryBean:executeSchemaScript) - Unsuccessful schema statement: alter table usergrouppermissions add constraint FK11713E7042F124D0 foreign key (usergroupid) references usergroups java.sql.SQLException: Cannot alter table 'usergrouppermissions' because this table does not exist in database 'tester'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:597) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:465) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:427) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1000) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:906) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:888) at org.springframework.orm.hibernate3.LocalSessionFactoryBean$3.doInHibernate(LocalSessionFactoryBean.java:864) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:311) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:288) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.updateDatabaseSchema(LocalSessionFactoryBean.java:857) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:715) I'm not exactly clear why this is happening, but there are two possible solutions to the issue. Ideally, I would like for either of these solutions to be adopted as a chance to LocalSessionFactoryBean. If you don't like either of the changes, it would be at nice to at least introduce a configuration variable so that subclassing LocalSessionFactoryBean isn't needed just to make the updateDatabaseSchema method work on SQL Server. One solution is to set the flush mode on HibernateTemplate to EAGER in the updateDatabaseSchema method. The other solution is to setAutoCommit(true) in executeSchemaScript. I honestly think either or both solution should be OK, because most databases I've worked with (Oracle, MySQL) automatically commit DDL statements anyway, even if the statement appears in a transaction which is later rolled back. It looks like SQL Server doesn't though.
    via by Matthew Sgarlata,
  • I'm using LocalSessionFactoryBean.updateDatabaseSchema and it's not working very well on SQL Server. Basically, if there are errors in the upgrade scripts generated by Hibernate, the update does not go through. I'm not sure exactly why this is happening but perhaps some log output and a couple fixes to the problem will help illustrate what's going on. Here is some log output: DEBUG (LocalSessionFactoryBean:executeSchemaScript) - Executing schema statement: create table usergrouppermissions (usergroupid int not null, permissionid int not null, primary key (usergroupid, permissionid)) DEBUG (LocalSessionFactoryBean:executeSchemaScript) - Executing schema statement: alter table files add constraint FK5CEBA778EB197A2 foreign key (createdbyuserid) references users WARN (LocalSessionFactoryBean:executeSchemaScript) - Unsuccessful schema statement: alter table files add constraint FK5CEBA778EB197A2 foreign key (createdbyuserid) references users java.sql.SQLException: Cannot alter table 'files' because this table does not exist in database 'tester'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:597) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:465) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:427) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1000) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:906) Then, later on in the log file.... WARN (LocalSessionFactoryBean:executeSchemaScript) - Unsuccessful schema statement: alter table usergrouppermissions add constraint FK11713E7042F124D0 foreign key (usergroupid) references usergroups java.sql.SQLException: Cannot alter table 'usergrouppermissions' because this table does not exist in database 'tester'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:597) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:465) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:427) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1000) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:906) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:888) at org.springframework.orm.hibernate3.LocalSessionFactoryBean$3.doInHibernate(LocalSessionFactoryBean.java:864) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:311) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:288) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.updateDatabaseSchema(LocalSessionFactoryBean.java:857) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:715) I'm not exactly clear why this is happening, but there are two possible solutions to the issue. Ideally, I would like for either of these solutions to be adopted as a chance to LocalSessionFactoryBean. If you don't like either of the changes, it would be at nice to at least introduce a configuration variable so that subclassing LocalSessionFactoryBean isn't needed just to make the updateDatabaseSchema method work on SQL Server. One solution is to set the flush mode on HibernateTemplate to EAGER in the updateDatabaseSchema method. The other solution is to setAutoCommit(true) in executeSchemaScript. I honestly think either or both solution should be OK, because most databases I've worked with (Oracle, MySQL) automatically commit DDL statements anyway, even if the statement appears in a transaction which is later rolled back. It looks like SQL Server doesn't though.
    via by Matthew Sgarlata,
  • Error on create trigger
    via symmetricds by nuttinjeff
    ,
  • SelectiveDataReplication
    via symmetricds by manmadh
    ,
  • Stack trace: 2011-08-16 13:50:31,250 ajp-8012-11 ERROR oauth 830x206x1 - 10.1.0.20 /rpc/xmlrpc [net.java.ao.sql] Exception executing SQL update <CREATE TABLE AO_60DB71_RANK_ISSUE_LINK ( ISSUE_ID BIGINT NOT NULL, NEXT_ID BIGINT, PRIMARY KEY(ISSUE_ID) )> java.sql.SQLException: There is already an object named 'AO_60DB71_RANK_ISSUE_LINK' in the database. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2239) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:77) at net.java.ao.EntityManager.migrate(EntityManager.java:143) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:40) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39) at com.atlassian.activeobjects.internal.RegistryBasedActiveObjectsProvider.get(RegistryBasedActiveObjectsProvider.java:29) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.getDelegate(DelegatingActiveObjects.java:126) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.executeInTransaction(DelegatingActiveObjects.java:111) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy1137.executeInTransaction(Unknown Source) at com.atlassian.activeobjects.tx.TransactionalProxy.invoke(TransactionalProxy.java:33) at $Proxy1138.loadAll(Unknown Source) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:46) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:34) at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:93) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.fetchCreate(RankIndexServiceImpl.java:289) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.getIssuePosition(RankIndexServiceImpl.java:70) at com.atlassian.greenhopper.customfield.rank.RankCFType.getValueFromIssue(RankCFType.java:33) at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:316) at com.atlassian.jira.rpc.soap.util.SoapUtils.getCustomFieldValues(SoapUtils.java:256) at com.atlassian.jira.rpc.soap.beans.RemoteIssue.<init>(RemoteIssue.java:142) at com.atlassian.jira.rpc.soap.service.IssueServiceImpl.getIssue(IssueServiceImpl.java:197) at com.atlassian.jira.rpc.soap.JiraSoapServiceImpl.getIssue(JiraSoapServiceImpl.java:327) at com.atlassian.jira.rpc.xmlrpc.JiraXmlRpcService.getIssue(JiraXmlRpcService.java:122) 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.xmlrpc.Invoker.execute(Invoker.java:130) at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java:84) at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java:146) at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:139) at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:114) at com.atlassian.jira.web.servlet.rpc.PluggableXmlRpcRequestProcessor.process(PluggableXmlRpcRequestProcessor.java:35) at com.atlassian.jira.web.servlet.rpc.XmlRpcServlet.executeRequest(XmlRpcServlet.java:57) at com.atlassian.jira.web.servlet.rpc.XmlRpcServlet.doPost(XmlRpcServlet.java:33) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:103) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:19) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665) at java.lang.Thread.run(Thread.java:662)
    via by Kr Wo,
  • Moving an issue from one issue type to another I got: Cause: net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. Stack Trace: [hide] net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:46) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39) at com.atlassian.activeobjects.internal.RegistryBasedActiveObjectsProvider.get(RegistryBasedActiveObjectsProvider.java:29) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.getDelegate(DelegatingActiveObjects.java:126) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.executeInTransaction(DelegatingActiveObjects.java:111) at sun.reflect.GeneratedMethodAccessor1514.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy1161.executeInTransaction(Unknown Source) at com.atlassian.activeobjects.tx.TransactionalProxy.invoke(TransactionalProxy.java:33) at $Proxy1164.loadAll(Unknown Source) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:46) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:34) at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:93) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.fetchCreate(RankIndexServiceImpl.java:289) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.getIssuePosition(RankIndexServiceImpl.java:70) at com.atlassian.greenhopper.customfield.rank.RankCFType.getValueFromIssue(RankCFType.java:33) at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:316) at com.atlassian.jira.issue.fields.CustomFieldImpl.doesFieldHaveValue(CustomFieldImpl.java:1204) at com.atlassian.jira.issue.fields.CustomFieldImpl.needsMove(CustomFieldImpl.java:1082) at com.atlassian.jira.web.action.issue.MoveIssueUpdateFields.doDefault(MoveIssueUpdateFields.java:83) 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 webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:433) at webwork.action.ActionSupport.execute(ActionSupport.java:157) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:76) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:205) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:143) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:103) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at com.atlassian.jira.web.filters.PathExclusionFilter.doFilter(PathExclusionFilter.java:118) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:19) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2239) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:76) at net.java.ao.EntityManager.migrate(EntityManager.java:143) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:42) ... 169 more Referer URL: http://jira.unified.local/app/secure/MoveIssue!default.jspa?id=29099 Build Information: Uptime : N/A Version : 4.4.1 Build Number : 660 Build Date : Tue Aug 30 00:00:00 BST 2011 Build Revision : 161644 Atlassian Partner : null Installation Type : Standalone Server ID : AGZL-HKQO-1G2R-G5UG Last Upgrade : 16/Sep/11 5:39 PM (v4.3.2#616) Server Information: Application Server: Apache Tomcat/6.0.32 Servlet Version: 2.5 File Paths: Location of entityengine.xml: file:/C:/Program%20Files/Atlassian/JIRA%204.3.2/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: D:\jira\log\atlassian-jira.log Memory Information: Total Memory: 476 MB Free Memory: 134 MB Used Memory: 342 MB Total PermGen Memory: 256 MB Free PermGen Memory: 132 MB Used PermGen Memory: 123 MB System Information: System Date : Friday, 30 Sep 2011 System Time : 15:22:30 +0100 Current Working Directory : C:\WINDOWS\system32 Java Version : 1.6.0_26 Java Vendor : Sun Microsystems Inc. JVM Version : 1.0 JVM Vendor : Sun Microsystems Inc. JVM Implementation Version : 20.1-b02 Java Runtime : Java(TM) SE Runtime Environment Java VM : Java HotSpot(TM) Server VM User Name : SYSTEM User Timezone : Europe/London User Locale : English (United Kingdom) System Encoding : Cp1252 Operating System : Windows 2003 5.2 OS Architecture : x86 Application Server Container : Database type : mssql Database JNDI address : mssql jdbc:jtds:sqlserver://localhost:1433/jiradb_42;domain=USLDATA01; Database URL : Hidden Database version : 09.00.4053 Database driver : jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.4 External user management : OFF Crowd integration : ON JVM Input Arguments : -Dcatalina.base=C:\Program Files\Atlassian\JIRA 4.3.2 -Dcatalina.home=C:\Program Files\Atlassian\JIRA 4.3.2 -Djava.endorsed.dirs=C:\Program Files\Atlassian\JIRA 4.3.2\endorsed -Dmail.mime.decodeparameters=true -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Djava.io.tmpdir=C:\Program Files\Atlassian\JIRA 4.3.2\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Atlassian\JIRA 4.3.2\conf\logging.properties -XX:MaxPermSize=256m -Xms128m -Xmx512m Language Info: Installed languages: Catalan (Spain) Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) Dutch (Belgium) English (UK) English (United States) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Japanese (Japan) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey) Default language: English (UK) Request Information: - Request URL: http://jira.unified.local/app/500page.jsp - Scheme: http - Server: jira.unified.local - Port: 80 - URI: /app/500page.jsp - Context Path: /app - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: id=29099&assignee=null Request Attributes - javax.servlet.forward.request_uri : /app/secure/MoveIssueUpdateFields!default.jspa - javax.servlet.forward.context_path : /app - javax.servlet.forward.servlet_path : /secure/MoveIssueUpdateFields!default.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : id=29099&assignee=null - jira.request.time.micros : 0 - atlassian.core.seraph.original.url : /secure/MoveIssueUpdateFields!default.jspa?id=29099&assignee=null - javax.servlet.error.servlet_name : action - com.atlassian.jira.web.filters.JiraFirstFilter_alreadyfiltered : true - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@1093167 - com.atlassian.jira.web.filters.JiraLastFilter_alreadyfiltered : true - com.atlassian.jira.web.filters.accesslog.AccessLogFilter_already_filtered : true - jira.request.username : maiseya - javax.servlet.error.request_uri : /app/secure/MoveIssueUpdateFields!default.jspa - com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter_already_filtered : true - jira.webwork.cleanup : false - jira.request.start.millis : 1317392550505 - com.atlassian.jira.web.filters.accesslog.AccessLogRequestInfoexit.called : true - jira.request.assession.id : bo30ff - os_securityfilter_already_filtered : true - com.atlassian.jira.web.filters.JiraPostEncodingFilter_alreadyfiltered : true - jira.session.max.inactive.interval : 18000 - javax.servlet.error.message : - jira.session.last.accessed.time : 1317392550427 - webwork.result : Value stack =========== =========== - com.atlassian.seraph.auth.LoginReason : OK - jira.request.id : 922x36747x1 - javax.servlet.error.status_code : 500 - com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered : true - javax.servlet.error.exception : javax.servlet.ServletException: net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. Request Logging 0 log statements generated by this request: Listeners - Issue Assignment Listener (com.atlassian.jira.event.listeners.history.IssueAssignHistoryListener) - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener) Services - Backup service (com.atlassian.jira.service.services.export.ExportService) - Delay: 720 minutes - OPT_DATE_FORMAT: yyyy-MMM-dd-HHmm - DIR_NAME: D:\jira\backups - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes - Service Provider Token Remover (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 480 minutes - pluginJobName: Service Provider Token Remover - repeatInterval: 28800000 - initiallyFired: true - com.atlassian.jira.plugin.ext.bamboo.service.PlanStatusUpdateServiceImpl:job (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 1 minutes - pluginJobName: com.atlassian.jira.plugin.ext.bamboo.service.PlanStatusUpdateServiceImpl:job - repeatInterval: 60000 - initiallyFired: true - upmPluginUpgradeCheckJob (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 1440 minutes - pluginJobName: upmPluginUpgradeCheckJob - repeatInterval: 86400000 - initiallyFired: true Plugins - ActiveObjects Plugin - OSGi Bundle 0.15.8 - Plugin by Atlassian - Enabled - Admin Menu Sections 1.0 - Plugin by Atlassian - Enabled - Apache HttpClient OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Apache HttpCore OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Applinks Product Plugin 3.5.6 - Plugin by Atlassian - Enabled - build: 10 - Atlassian Embedded Crowd - Administration Plugin 1.2.9 - Plugin by Atlassian - Enabled - Atlassian Gadgets OAuth Service Provider Plugin 3.1.9 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Admin Quick Navigation Component 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Admin Summary Component 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Application Properties 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Closure Template Renderer 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Gadgets Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Look And Feel Logo Upload Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - OAuth Consumer SPI Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - OAuth Service Provider SPI Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Project Config Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - REST Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Shared Application Access Layer (SAL) Plugin 4.4.1 - Plugin by Atlassian Software Systems - Enabled - Atlassian JIRA - Plugins - View Issue Panels 4.4.1 - Plugin by ${project.organization.name} - Enabled - Atlassian OAuth Admin Plugin 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer Plugin 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer SPI 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider Plugin 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider SPI 1.2.2 - Plugin by Atlassian - Enabled - Atlassian REST - Module Types 2.5.0 - Plugin by Atlassian - Enabled - Atlassian Template Renderer API 1.3.1 - Plugin by Atlassian - Enabled - Atlassian Template Renderer Velocity 1.6 Plugin 1.3.1 - Plugin by Atlassian - Enabled - Atlassian UI Plugin 3.4.2 - Plugin by Atlassian - Enabled - Atlassian Universal Plugin Manager Plugin 1.5 - Plugin by Atlassian Pty Ltd - Enabled - BND Library 0.0.255 - Plugin by aQute SARL http://www.aQute.biz - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian - Enabled - Crowd REST API 1.0 - Plugin by Atlassian Software Systems - Enabled - Crowd REST API 1.0 - Plugin by Atlassian Software Systems - Enabled - Crowd System Password Encoders 1.0 - Plugin by Atlassian Software Systems - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian - Enabled - Embedded Gadgets Plugin 3.1.9 - Plugin by Atlassian - Enabled - FishEye Plugin 3.4.6 - Plugin by Atlassian Software Systems - Enabled - Gadget Dashboard Plugin 3.1.9 - Plugin by Atlassian - Enabled - Gadget Directory Plugin 3.1.9 - Plugin by Atlassian - Enabled - Gadget Spec Publisher Plugin 3.1.9 - Plugin by Atlassian - Enabled - GreenHopper 5.7.2 - Plugin by Atlassian - Enabled - ICU4J 3.8.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian - Enabled - JDOM DOM Processor 1.0.0 - Plugin by SpringSource - Enabled - JIRA Active Objects SPI implementation 0.15.8 - Plugin by Atlassian Software Systems - Enabled - JIRA Activity Stream Plugin 4.1.2 - Plugin by Atlassian - Enabled - JIRA Bamboo Plugin 4.3.1 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - configure.url: /secure/admin/jira/ViewBambooApplicationLinks.jspa - JIRA Calendar Plugin 1.18 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Charting Plugin 1.7.1 - Plugin by Atlassian - Enabled - JIRA Drag and Drop Attachment Plugin 2.6.0 - Plugin by Atlassian Pty Ltd. - Enabled - JIRA Feedback Plugin 1.0.6 - Plugin by Atlassian - Enabled - JIRA Footer 1.0 - Plugin by Atlassian - Enabled - JIRA JSON-RPC Plugin 1.0.2 - Plugin by Atlassian Software - Enabled - JIRA Misc Workflow Extensions 2.4.1 - Plugin by Innovalog - Enabled - JIRA Streams Inline Actions Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA TimeSheet Plugin 2.2 - Plugin by Andriy Zhdanov - Enabled - JIRA Toolkit Plugin 0.18 - Plugin by Atlassian - Enabled - JIRA Usage Hints 1.0 - Plugin by Atlassian - Enabled - JQL Functions 1.0 - Plugin by Atlassian - Enabled - JSON Library 20070829.0.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Keyboard Shortcuts Plugin 1.0 - Plugin by Atlassian - Enabled - Neko HTML 1.9.12.1 - Plugin by Atlassian Pty Ltd - Enabled - Opensocial Plugin 3.1.9 - Plugin by Atlassian - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian - Enabled - ROME, RSS and atOM utilitiEs for Java 1.0 - Plugin by Sun Microsystems - Enabled - ROME: RSS/Atom syndication and publishing tools 0.9.0 - Plugin by SpringSource - Enabled - RPC JIRA Plugin 4.4.1 - Plugin by Atlassian - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian - Enabled - Reports Plugin 1.0 - Plugin by Atlassian - Enabled - Streams API 4.1.2 - Plugin by Atlassian - Enabled - Streams Core Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Streams Inline Actions Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Streams Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Streams SPI 4.1.2 - Plugin by Atlassian - Enabled - Support Tools Plugin 2.6 - Plugin by Atlassian Support - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian - Enabled - User Format 1.0 - Plugin by Atlassian - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian - Enabled - User Profile Links 1.0 - Plugin by Atlassian - Enabled - User Profile Panels 1.0 - Plugin by Atlassian - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian - Enabled - Workflow Designer Plugin 2.0.0 - Plugin by Atlassian - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian - Enabled - jira-ical-feed 1.0.1 - Plugin by Atlassian - Enabled
    via by Andrew Maisey,
  • Moving an issue from one issue type to another I got: Cause: net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. Stack Trace: [hide] net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:46) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39) at com.atlassian.activeobjects.internal.RegistryBasedActiveObjectsProvider.get(RegistryBasedActiveObjectsProvider.java:29) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.getDelegate(DelegatingActiveObjects.java:126) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.executeInTransaction(DelegatingActiveObjects.java:111) at sun.reflect.GeneratedMethodAccessor1514.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy1161.executeInTransaction(Unknown Source) at com.atlassian.activeobjects.tx.TransactionalProxy.invoke(TransactionalProxy.java:33) at $Proxy1164.loadAll(Unknown Source) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:46) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:34) at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:93) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.fetchCreate(RankIndexServiceImpl.java:289) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.getIssuePosition(RankIndexServiceImpl.java:70) at com.atlassian.greenhopper.customfield.rank.RankCFType.getValueFromIssue(RankCFType.java:33) at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:316) at com.atlassian.jira.issue.fields.CustomFieldImpl.doesFieldHaveValue(CustomFieldImpl.java:1204) at com.atlassian.jira.issue.fields.CustomFieldImpl.needsMove(CustomFieldImpl.java:1082) at com.atlassian.jira.web.action.issue.MoveIssueUpdateFields.doDefault(MoveIssueUpdateFields.java:83) 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 webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56) at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:433) at webwork.action.ActionSupport.execute(ActionSupport.java:157) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:76) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:205) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:143) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:103) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at com.atlassian.jira.web.filters.PathExclusionFilter.doFilter(PathExclusionFilter.java:118) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:19) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2239) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:76) at net.java.ao.EntityManager.migrate(EntityManager.java:143) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:42) ... 169 more Referer URL: http://jira.unified.local/app/secure/MoveIssue!default.jspa?id=29099 Build Information: Uptime : N/A Version : 4.4.1 Build Number : 660 Build Date : Tue Aug 30 00:00:00 BST 2011 Build Revision : 161644 Atlassian Partner : null Installation Type : Standalone Server ID : AGZL-HKQO-1G2R-G5UG Last Upgrade : 16/Sep/11 5:39 PM (v4.3.2#616) Server Information: Application Server: Apache Tomcat/6.0.32 Servlet Version: 2.5 File Paths: Location of entityengine.xml: file:/C:/Program%20Files/Atlassian/JIRA%204.3.2/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: D:\jira\log\atlassian-jira.log Memory Information: Total Memory: 476 MB Free Memory: 134 MB Used Memory: 342 MB Total PermGen Memory: 256 MB Free PermGen Memory: 132 MB Used PermGen Memory: 123 MB System Information: System Date : Friday, 30 Sep 2011 System Time : 15:22:30 +0100 Current Working Directory : C:\WINDOWS\system32 Java Version : 1.6.0_26 Java Vendor : Sun Microsystems Inc. JVM Version : 1.0 JVM Vendor : Sun Microsystems Inc. JVM Implementation Version : 20.1-b02 Java Runtime : Java(TM) SE Runtime Environment Java VM : Java HotSpot(TM) Server VM User Name : SYSTEM User Timezone : Europe/London User Locale : English (United Kingdom) System Encoding : Cp1252 Operating System : Windows 2003 5.2 OS Architecture : x86 Application Server Container : Database type : mssql Database JNDI address : mssql jdbc:jtds:sqlserver://localhost:1433/jiradb_42;domain=USLDATA01; Database URL : Hidden Database version : 09.00.4053 Database driver : jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.4 External user management : OFF Crowd integration : ON JVM Input Arguments : -Dcatalina.base=C:\Program Files\Atlassian\JIRA 4.3.2 -Dcatalina.home=C:\Program Files\Atlassian\JIRA 4.3.2 -Djava.endorsed.dirs=C:\Program Files\Atlassian\JIRA 4.3.2\endorsed -Dmail.mime.decodeparameters=true -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Djava.io.tmpdir=C:\Program Files\Atlassian\JIRA 4.3.2\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Atlassian\JIRA 4.3.2\conf\logging.properties -XX:MaxPermSize=256m -Xms128m -Xmx512m Language Info: Installed languages: Catalan (Spain) Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) Dutch (Belgium) English (UK) English (United States) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Japanese (Japan) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey) Default language: English (UK) Request Information: - Request URL: http://jira.unified.local/app/500page.jsp - Scheme: http - Server: jira.unified.local - Port: 80 - URI: /app/500page.jsp - Context Path: /app - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: id=29099&assignee=null Request Attributes - javax.servlet.forward.request_uri : /app/secure/MoveIssueUpdateFields!default.jspa - javax.servlet.forward.context_path : /app - javax.servlet.forward.servlet_path : /secure/MoveIssueUpdateFields!default.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : id=29099&assignee=null - jira.request.time.micros : 0 - atlassian.core.seraph.original.url : /secure/MoveIssueUpdateFields!default.jspa?id=29099&assignee=null - javax.servlet.error.servlet_name : action - com.atlassian.jira.web.filters.JiraFirstFilter_alreadyfiltered : true - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@1093167 - com.atlassian.jira.web.filters.JiraLastFilter_alreadyfiltered : true - com.atlassian.jira.web.filters.accesslog.AccessLogFilter_already_filtered : true - jira.request.username : maiseya - javax.servlet.error.request_uri : /app/secure/MoveIssueUpdateFields!default.jspa - com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter_already_filtered : true - jira.webwork.cleanup : false - jira.request.start.millis : 1317392550505 - com.atlassian.jira.web.filters.accesslog.AccessLogRequestInfoexit.called : true - jira.request.assession.id : bo30ff - os_securityfilter_already_filtered : true - com.atlassian.jira.web.filters.JiraPostEncodingFilter_alreadyfiltered : true - jira.session.max.inactive.interval : 18000 - javax.servlet.error.message : - jira.session.last.accessed.time : 1317392550427 - webwork.result : Value stack =========== =========== - com.atlassian.seraph.auth.LoginReason : OK - jira.request.id : 922x36747x1 - javax.servlet.error.status_code : 500 - com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered : true - javax.servlet.error.exception : javax.servlet.ServletException: net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: Incorrect syntax near the keyword 'DEFAULT'. Request Logging 0 log statements generated by this request: Listeners - Issue Assignment Listener (com.atlassian.jira.event.listeners.history.IssueAssignHistoryListener) - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener) Services - Backup service (com.atlassian.jira.service.services.export.ExportService) - Delay: 720 minutes - OPT_DATE_FORMAT: yyyy-MMM-dd-HHmm - DIR_NAME: D:\jira\backups - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes - Service Provider Token Remover (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 480 minutes - pluginJobName: Service Provider Token Remover - repeatInterval: 28800000 - initiallyFired: true - com.atlassian.jira.plugin.ext.bamboo.service.PlanStatusUpdateServiceImpl:job (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 1 minutes - pluginJobName: com.atlassian.jira.plugin.ext.bamboo.service.PlanStatusUpdateServiceImpl:job - repeatInterval: 60000 - initiallyFired: true - upmPluginUpgradeCheckJob (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 1440 minutes - pluginJobName: upmPluginUpgradeCheckJob - repeatInterval: 86400000 - initiallyFired: true Plugins - ActiveObjects Plugin - OSGi Bundle 0.15.8 - Plugin by Atlassian - Enabled - Admin Menu Sections 1.0 - Plugin by Atlassian - Enabled - Apache HttpClient OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Apache HttpCore OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Applinks Product Plugin 3.5.6 - Plugin by Atlassian - Enabled - build: 10 - Atlassian Embedded Crowd - Administration Plugin 1.2.9 - Plugin by Atlassian - Enabled - Atlassian Gadgets OAuth Service Provider Plugin 3.1.9 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Admin Quick Navigation Component 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Admin Summary Component 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Application Properties 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Closure Template Renderer 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Gadgets Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Look And Feel Logo Upload Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - OAuth Consumer SPI Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - OAuth Service Provider SPI Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Project Config Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - REST Plugin 4.4.1 - Plugin by Atlassian - Enabled - Atlassian JIRA - Plugins - Shared Application Access Layer (SAL) Plugin 4.4.1 - Plugin by Atlassian Software Systems - Enabled - Atlassian JIRA - Plugins - View Issue Panels 4.4.1 - Plugin by ${project.organization.name} - Enabled - Atlassian OAuth Admin Plugin 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer Plugin 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer SPI 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider Plugin 1.2.2 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider SPI 1.2.2 - Plugin by Atlassian - Enabled - Atlassian REST - Module Types 2.5.0 - Plugin by Atlassian - Enabled - Atlassian Template Renderer API 1.3.1 - Plugin by Atlassian - Enabled - Atlassian Template Renderer Velocity 1.6 Plugin 1.3.1 - Plugin by Atlassian - Enabled - Atlassian UI Plugin 3.4.2 - Plugin by Atlassian - Enabled - Atlassian Universal Plugin Manager Plugin 1.5 - Plugin by Atlassian Pty Ltd - Enabled - BND Library 0.0.255 - Plugin by aQute SARL http://www.aQute.biz - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian - Enabled - Crowd REST API 1.0 - Plugin by Atlassian Software Systems - Enabled - Crowd REST API 1.0 - Plugin by Atlassian Software Systems - Enabled - Crowd System Password Encoders 1.0 - Plugin by Atlassian Software Systems - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian - Enabled - Embedded Gadgets Plugin 3.1.9 - Plugin by Atlassian - Enabled - FishEye Plugin 3.4.6 - Plugin by Atlassian Software Systems - Enabled - Gadget Dashboard Plugin 3.1.9 - Plugin by Atlassian - Enabled - Gadget Directory Plugin 3.1.9 - Plugin by Atlassian - Enabled - Gadget Spec Publisher Plugin 3.1.9 - Plugin by Atlassian - Enabled - GreenHopper 5.7.2 - Plugin by Atlassian - Enabled - ICU4J 3.8.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian - Enabled - JDOM DOM Processor 1.0.0 - Plugin by SpringSource - Enabled - JIRA Active Objects SPI implementation 0.15.8 - Plugin by Atlassian Software Systems - Enabled - JIRA Activity Stream Plugin 4.1.2 - Plugin by Atlassian - Enabled - JIRA Bamboo Plugin 4.3.1 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - configure.url: /secure/admin/jira/ViewBambooApplicationLinks.jspa - JIRA Calendar Plugin 1.18 - Plugin by Atlassian Pty Ltd - Enabled - JIRA Charting Plugin 1.7.1 - Plugin by Atlassian - Enabled - JIRA Drag and Drop Attachment Plugin 2.6.0 - Plugin by Atlassian Pty Ltd. - Enabled - JIRA Feedback Plugin 1.0.6 - Plugin by Atlassian - Enabled - JIRA Footer 1.0 - Plugin by Atlassian - Enabled - JIRA JSON-RPC Plugin 1.0.2 - Plugin by Atlassian Software - Enabled - JIRA Misc Workflow Extensions 2.4.1 - Plugin by Innovalog - Enabled - JIRA Streams Inline Actions Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA TimeSheet Plugin 2.2 - Plugin by Andriy Zhdanov - Enabled - JIRA Toolkit Plugin 0.18 - Plugin by Atlassian - Enabled - JIRA Usage Hints 1.0 - Plugin by Atlassian - Enabled - JQL Functions 1.0 - Plugin by Atlassian - Enabled - JSON Library 20070829.0.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Keyboard Shortcuts Plugin 1.0 - Plugin by Atlassian - Enabled - Neko HTML 1.9.12.1 - Plugin by Atlassian Pty Ltd - Enabled - Opensocial Plugin 3.1.9 - Plugin by Atlassian - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian - Enabled - ROME, RSS and atOM utilitiEs for Java 1.0 - Plugin by Sun Microsystems - Enabled - ROME: RSS/Atom syndication and publishing tools 0.9.0 - Plugin by SpringSource - Enabled - RPC JIRA Plugin 4.4.1 - Plugin by Atlassian - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian - Enabled - Reports Plugin 1.0 - Plugin by Atlassian - Enabled - Streams API 4.1.2 - Plugin by Atlassian - Enabled - Streams Core Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Streams Inline Actions Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Streams Plugin 4.1.2 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Streams SPI 4.1.2 - Plugin by Atlassian - Enabled - Support Tools Plugin 2.6 - Plugin by Atlassian Support - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian - Enabled - User Format 1.0 - Plugin by Atlassian - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian - Enabled - User Profile Links 1.0 - Plugin by Atlassian - Enabled - User Profile Panels 1.0 - Plugin by Atlassian - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian - Enabled - Workflow Designer Plugin 2.0.0 - Plugin by Atlassian - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian - Enabled - jira-ical-feed 1.0.1 - Plugin by Atlassian - Enabled
    via by Andrew Maisey,
  • Stack trace: 2011-08-16 13:50:31,250 ajp-8012-11 ERROR oauth 830x206x1 - 10.1.0.20 /rpc/xmlrpc [net.java.ao.sql] Exception executing SQL update <CREATE TABLE AO_60DB71_RANK_ISSUE_LINK ( ISSUE_ID BIGINT NOT NULL, NEXT_ID BIGINT, PRIMARY KEY(ISSUE_ID) )> java.sql.SQLException: There is already an object named 'AO_60DB71_RANK_ISSUE_LINK' in the database. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2239) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:77) at net.java.ao.EntityManager.migrate(EntityManager.java:143) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:40) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39) at com.atlassian.activeobjects.internal.RegistryBasedActiveObjectsProvider.get(RegistryBasedActiveObjectsProvider.java:29) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.getDelegate(DelegatingActiveObjects.java:126) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.executeInTransaction(DelegatingActiveObjects.java:111) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy1137.executeInTransaction(Unknown Source) at com.atlassian.activeobjects.tx.TransactionalProxy.invoke(TransactionalProxy.java:33) at $Proxy1138.loadAll(Unknown Source) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:46) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl$1.get(RankIndexServiceImpl.java:34) at com.google.common.base.Suppliers$MemoizingSupplier.get(Suppliers.java:93) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.fetchCreate(RankIndexServiceImpl.java:289) at com.atlassian.greenhopper.service.rank.RankIndexServiceImpl.getIssuePosition(RankIndexServiceImpl.java:70) at com.atlassian.greenhopper.customfield.rank.RankCFType.getValueFromIssue(RankCFType.java:33) at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:316) at com.atlassian.jira.rpc.soap.util.SoapUtils.getCustomFieldValues(SoapUtils.java:256) at com.atlassian.jira.rpc.soap.beans.RemoteIssue.<init>(RemoteIssue.java:142) at com.atlassian.jira.rpc.soap.service.IssueServiceImpl.getIssue(IssueServiceImpl.java:197) at com.atlassian.jira.rpc.soap.JiraSoapServiceImpl.getIssue(JiraSoapServiceImpl.java:327) at com.atlassian.jira.rpc.xmlrpc.JiraXmlRpcService.getIssue(JiraXmlRpcService.java:122) 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.xmlrpc.Invoker.execute(Invoker.java:130) at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java:84) at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java:146) at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:139) at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:114) at com.atlassian.jira.web.servlet.rpc.PluggableXmlRpcRequestProcessor.process(PluggableXmlRpcRequestProcessor.java:35) at com.atlassian.jira.web.servlet.rpc.XmlRpcServlet.executeRequest(XmlRpcServlet.java:57) at com.atlassian.jira.web.servlet.rpc.XmlRpcServlet.doPost(XmlRpcServlet.java:33) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:103) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:19) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:429) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665) at java.lang.Thread.run(Thread.java:662)
    via by Kr Wo,
    • java.sql.SQLException: Cannot alter table 'usergrouppermissions' because this table does not exist in database 'tester'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:597) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:465) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:427) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1000) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:906) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:888) at org.springframework.orm.hibernate3.LocalSessionFactoryBean$3.doInHibernate(LocalSessionFactoryBean.java:864) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:311) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:288) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.updateDatabaseSchema(LocalSessionFactoryBean.java:857) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:715)

    Users with the same issue

    odd
    odd72 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Eric
    Eric3 times, last one,
    Unknown visitor1 times, last one,
    22 more bugmates