Atlassian Support Tools displays page not found
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Clicking on the support tools plugin link will redirect you to "page not found".
The following might appear 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.
How to Rebuild the Content Indexes From Scratch on Unclustered Confluence.
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
Was this helpful?