Error in 'Emails' tab in Jira ticket

Question

We recently made a change in Jira authentication via Crowd.  The 'username' now picks up the e-mail address of the user instead of 'firstname.lastname'.

After this change, if we use 'E-mail this Issue' button the Jira ticket, the e-mail is sent but the tab 'Emails' displays the following error:

'Error rendering 'com.metainf.jira.plugin.emailissue:audit-log-panel'. Please contact your JIRA administrators.'

Also we are getting the following error in the log:

Exception thrown while trying to call getActions() for com.metainf.jira.plugin.emailissue:audit-log-panel (The Emails Panel)

We are using the following versions:

Jira: 6.4.6

Email this Issue Plugin: 6.2.1.3

Any idea about the Jira database tables from which this plugin (Email Issue) picks up data from?

Any suggestions on how to fix this issue?

Rupa Jain · Answer

This issue got fixed. Basically there were some entries in cwd_user table that were missing in the app_user table. The following query was used: SELECT lower_user_name
FROM cwd_user WHERE lower_user_name NOT IN (SELECT lower_user_name FROM app_user);

Rupa Jain · Answer

Did not come across any stack trace in the log, but the following were the errors:

2018-02-16 11:08:16,579 http-bio-8080-exec-22 WARN jira.importer 668x7079x1 htjon1 147.249.171.66 /browse/ABC-4002099 [com.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.jira.util.dbc.Assertions$NullArgumentException - key should not be null!'.
2018-02-16 11:08:16,579 http-bio-8080-exec-22 ERROR jira.importer 668x7079x1 htjon1 147.249.171.66 /browse/ABC-4002099 [jira.plugin.issuetabpanel.IssueTabPanelInvokerImpl] Exception thrown while trying to call getActions() for com.metainf.jira.plugin.emailissue:audit-log-panel (The Emails Panel)
2018-02-16 11:09:10,890 http-bio-8080-exec-18 WARN jira.importer 669x7092x1 htjon1 147.249.171.66 /browse/ABC-4002099 [com.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.jira.util.dbc.Assertions$NullArgumentException - key should not be null!'.
2018-02-16 11:09:10,890 http-bio-8080-exec-18 ERROR jira.importer 669x7092x1 htjon1 147.249.171.66 /browse/ABC-4002099 [jira.plugin.issuetabpanel.IssueTabPanelInvokerImpl] Exception thrown while trying to call getActions() for com.metainf.jira.plugin.emailissue:audit-log-panel (The Emails Panel)
2018-02-16 11:09:31,954 http-bio-8080-exec-18 WARN jira.importer 669x7093x1 htjon1 147.249.171.66 /browse/ABC-4002099 [com.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.jira.util.dbc.Assertions$NullArgumentException - key should not be null!'.
2018-02-16 11:09:31,954 http-bio-8080-exec-18 ERROR jira.importer 669x7093x1 htjon1 147.249.171.66 /browse/ABC-4002099 [jira.plugin.issuetabpanel.IssueTabPanelInvokerImpl] Exception thrown while trying to call getActions() for com.metainf.jira.plugin.emailissue:audit-log-panel (The Emails Panel)
2018-02-16 11:13:15,073 http-bio-8080-exec-10 WARN rupa.goyal@fisglobal.com 673x7254x1 v3m5zh 147.249.171.66 /browse/ABC-4002098 [com.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.atlassian.jira.util.dbc.Assertions$NullArgumentException - key should not be null!'.
2018-02-16 11:13:15,073 http-bio-8080-exec-10 ERROR rupa.goyal@fisglobal.com 673x7254x1 v3m5zh 147.249.171.66 /browse/ABC-4002098 [jira.plugin.issuetabpanel.IssueTabPanelInvokerImpl] Exception thrown while trying to call getActions() for com.metainf.jira.plugin.emailissue:audit-log-panel (The Emails Panel)

Jeff Curry · Answer

Navigating to jira-base-url/plugins/servlet/active-objects/tables/list will show you the relating database tables.

If you can provide the full stack trace from the error log I can see if there's more to be learned, Exception thrown while trying to call getActions()  is too generic