Atlassian Support Tools displays page not found
Symptoms
Clicking on the support tools plugin link will redirect you to a page not found:
 |
|---|
The following might appears in atlassian-confluence.log as well:
2015-01-19 23:30:43,303 ERROR [http-bio-8090-exec-3] [atlassian.plugin.servlet.DefaultServletModuleManager] getServlet Unable to create servlet
-- referer: https://confluence.ninjas.com/confluence/admin/viewgeneralconfig.action | url: /confluence/plugins/servlet/stp/view/ | userName: rrogers
com.atlassian.util.concurrent.LazyReference$InitializationException: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2
...
Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2
at org.springframework.dao.support.DataAccessUtils.singleResult(DataAccessUtils.java:53)
at com.atlassian.confluence.themes.persistence.hibernate.DefaultPersistentDecoratorDao$1.doInHibernate(DefaultPersistentDecoratorDao.java:148)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
at com.atlassian.confluence.themes.persistence.hibernate.DefaultPersistentDecoratorDao.getFromDB(DefaultPersistentDecoratorDao.java:128)
at com.atlassian.confluence.themes.persistence.hibernate.DefaultPersistentDecoratorDao.get(DefaultPersistentDecoratorDao.java:115)
at sun.reflect.GeneratedMethodAccessor451.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy89.get(Unknown Source)
at com.atlassian.support.tools.salext.ConfluenceApplicationInfo.getCustomDecorators(ConfluenceApplicationInfo.java:384)
at com.atlassian.support.tools.salext.ConfluenceApplicationInfo.initServletInfo(ConfluenceApplicationInfo.java:353)
at com.atlassian.support.tools.servlet.SupportToolsViewServlet.init(SupportToolsViewServlet.java:69)
at com.atlassian.plugin.servlet.DelegatingPluginServlet.init(DelegatingPluginServlet.java:56)
at com.atlassian.plugin.servlet.DefaultServletModuleManager$LazyLoadedServletReference.create(DefaultServletModuleManager.java:462)
at com.atlassian.plugin.servlet.DefaultServletModuleManager$LazyLoadedServletReference.create(DefaultServletModuleManager.java:447)
at com.atlassian.util.concurrent.LazyReference$Sync.run(LazyReference.java:321)
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:143)
... 209 more
Causes
We have two main causes for this miss behaviour:
- Using an incompatible version of the Support Tools Plugin.
- There is a duplicated record at DECORATOR table.
Resolution 1
- Upgrade to the to the latest compatible version.
- Clear the Plugin cache.
- How to Rebuild the Content Indexes From Scratch on Confluence Server.
Resolution 2
Run the below select against your database:
SELECT * FROM DECORATOR;Under "DECORATORNAME" column check if you see any duplicated record.
- Copy the DECORATORID for those duplicated lines
- Copy the contents of the "BODY" column for a notepad area.
- Compare the output of the duplicated lines.
- If they are the same, just take note of the bigger DECORATORID you took note in step 2. If they are different means they are customized and you will need to choose each one you will delete.
- Shutdown Confluence.
- Backup your database for safety measure.
Run below query to remove the duplicated line:
delete from DECORATOR where DECORATORID = <ID from step 2>;Delete all the directories listed in the Clear Confluence Plugin Cache guide.
- Star Confluence and check for the miss behaviour again
Last modified on Nov 2, 2018
Powered by Confluence and Scroll Viewport.