System error

[Jira Admin]

Hello!

An error occurs when trying to access the site (version 8.0.2):

Filter execution threw an exception
com/opensymphony/xwork/config/ConfigurationManager

In log file:
caused by: javax.servlet.ServletException: Filter execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:196)
caused by: java.lang.NoClassDefFoundError: com/opensymphony/xwork/config/ConfigurationManager
at com.atlassian.plugins.authentication.impl.web.filter.authentication.ConfluenceAuthenticationFilter.shouldFilter(ConfluenceAuthenticationFilter.java:78)

[Yi Xie · Accepted solution]

Hi, @Jira Admin ! Welcome to the community!

Do you upgrade your SSO plugin before see the error?

This is a bug. The Team has known it. And you can see the following issue to keep track of this problem.

https://jira.atlassian.com/browse/CONFSERVER-81603

You could try the following steps to make it work.

1. Verify version 4.2.15 is in <confluence-install>/confluence/WEB-INF/atlassian-bundled-plugins
2. Run the SQL query below

   select * from plugindata where pluginkey = 'com.atlassian.plugins.authentication.atlassian-authentication-plugin'
   

3. Take note of the pluginId and verify the filename has a version greater than 4.2.15
   
4. Then run the SQL query below:

   delete from plugindata where plugindataid = <pluginId>
   

5. Restart Confluence

[Jira Admin]

Thanks, that worked for me.

[Netset]

I have the same problem 

BUT

mysql> select * from plugindata where pluginkey = 'com.atlassian.plugins.authentication.atlassian-authentication-plugin';
ERROR 1146 (42S02): Table 'confluence.plugindata' doesn't exist

[Sagar Patil]

Hii @Yi Xie and team,

I attempted the proposed workaround, but no pluginId was displayed. In my case, we simply installed the Microsoft SSO plugins using a obr file and configured App Federation Metadata Url.

The query doesn't return any pluginId, therefore I manually deleted below file using the path given into the solution, but still it's showing me error when I clicks on plugins configuration page. 

'com.atlassian.plugins.authentication.atlassian-authentication-plugin'

Please review the screenshots below and let me know if you have any other guidelines.

Screen-shots :-

SQL query 
https://sagarpatil-perennialsys.tinytake.com/msc/Nzg3NzE5N18yMDk2MDQyMA

Confluence Login Page 
https://sagarpatil-perennialsys.tinytake.com/msc/Nzg3NzIwNV8yMDk2MDQyOA

User-installed app Page 
https://sagarpatil-perennialsys.tinytake.com/msc/Nzg3NzIwOF8yMDk2MDQzMQ

Error Page Screen-shot 
https://sagarpatil-perennialsys.tinytake.com/msc/Nzg3NzIyMF8yMDk2MDQ0Mw

Please do the needful.

Thanks and regards,

Sagar Patil

[Winston Holmes]

I did the SSO upgrade while I was on Confluence 7.18.1. After the upgrade to 8.0.2, I encountered the filter execution error. The 2 SQL commands did fix the issue. However, the output of the SELECT command was more readable when the desired columns were requested.

confluence=> select plugindataid,pluginkey,filename,lastmoddate from plugindata where pluginkey = 'com.atlassian.plugins.authentication.atlassian-authentication-plugin';
 plugindataid | pluginkey | filename | lastmoddate 
--------------+----------------------------------------------------------------------+-----------------------------------------------------------------------+-------------------------
107610113 | com.atlassian.plugins.authentication.atlassian-authentication-plugin | plugin.7679188536727309477.atlassian-authentication-plugin-4.2.20.jar | 2023-01-14 09:57:15.204
(1 row)
confluence=> delete from plugindata where plugindataid = 107610113;
DELETE 1
confluence=> \q

[Radek Dostál]

You don't by any chance happen to know John do you?

https://community.atlassian.com/t5/Confluence-questions/Failure-Updating-App/qaq-p/2237964

[Jira Admin]

No, I don't know.