Need help - Confluence server down : Invocation of method 'isShowSignUp'

[Allwyn Titus]

Dear confluence experts & users,

We need your help to troubleshoot an issue that we are facing with on on-perm confluence server. We find that we are unable to access the contents as the confluence server re-directs to a System Error screen that has the below message as the clause. 

"Invocation of method 'isShowSignUp' in class com.atlassian.confluence.user.actions.LoginAction threw exception java.lang.NullPointerException: Application cannot be null at /login.vm[line 6, column 28]

    Application cannot be null" 

I did google a bit and found a relevant link here : 

https://confluence.atlassian.com/confkb/confluence-returns-system-error-due-to-invocation-of-method-isshowsignup-in-class-com-atlassian-confluence-user-actions-loginaction-threw-exception-java-lang-nullpointerexception-at-login-vm-693899125.html

But would like to understand if there is any other way, that does not alter the database (also not sure if the above suggested fix works) 

Would appreciate your help. Thank you ! 

[Fabio Racobaldo _Herzum_]

Hi @Allwyn Titus ,

please take a look to the following troubleshooting article https://confluence.atlassian.com/confkb/confluence-returns-system-error-due-to-invocation-of-method-isshowsignup-in-class-com-atlassian-confluence-user-actions-loginaction-threw-exception-java-lang-nullpointerexception-at-login-vm-693899125.html

Hope this helps,

Fabio

[Allwyn Titus]

Fabio,

Thanks for responding. The troubleshooting link only fixes if the list index is not proper. In my case the application_id is also null, also the cwd_application table is empty. 

Allwyn 

[Mayur Jadhav]

Hi @Allwyn Titus ,

Welcome to the Atlassian Community!!

As per the error and article it says that list of your directory is not in incremental order or it does not include a directory with a list-index of 0.

Please execute Select query and retrieve the details and then execute the update query one by one.

I would recommend to reach out to Atlassian Support for help if you not confident with solution.

Note: Kindly take the backup of Database before performing any kind of action on database.

[Allwyn Titus]

Mayur,

Thank you for responding. I executed the select query and found that both the list index and the application id were pointing to null. 

Also, the cwd_application table was empty. Following the advice in the below link :

https://confluence.atlassian.com/confkb/unable-to-log-in-to-confluence-after-an-xml-restore-715261580.html

The above link helps me to land on the login page, but this does not take my google-auth. 

Currently my cwd_application table looks like below 

+--------+------------------+------------------------+----------------------------+----------------------------+--------+-------------+---------------------+------------+
| id | application_name | lower_application_name | created_date | updated_date | active | description | application_type | credential |
+--------+------------------+------------------------+----------------------------+----------------------------+--------+-------------+---------------------+------------+
| 327681 | crowd-embedded | crowd-embedded | 2012-08-14 12:00:43.000000 | 2015-01-14 10:57:35.000000 | T | NULL | GENERIC_APPLICATION | X |
+--------+------------------+------------------------+----------------------------+----------------------------+--------+-------------+---------------------+------------+

and my cwd_app_dir_mapping table looks like below 

mysql> select * from cwd_app_dir_mapping;
+--------+----------------+--------------+-----------+------------+
| id | application_id | directory_id | allow_all | list_index |
+--------+----------------+--------------+-----------+------------+
| 393217 | 327681 | 360449 | T | 0 |
+--------+----------------+--------------+-----------+------------+

Allwyn