Which tables stores JIRA Service Desk emails waiting for processing?

[Dastin_Kuwałek__SoftwarePlant_]

My Service Desk email channel stopped processing emails. Although the connection log shows only success and emails are being marked as processed, no new issues are being created.

After digging deeper I found our about Mail ProcessorJobRunner.
In logs, during the email processing, I see error
RuntimeException: Unable to read next message IOException: invalid characters encountered in base64 data

In this case, my approach was to find the JIRA table where pulled emails are stored and remove the mail item. But it makes me wonder if one problematic email would stop the whole queue and block any further email processing.

Help will be greatly appreciated!

[Dastin_Kuwałek__SoftwarePlant_ · Accepted solution]

It turned out that recreating the Service Desk mail channel fixed the issue. More details available here:

• https://jira.atlassian.com/browse/JSDSERVER-5096
• https://jira.atlassian.com/browse/JSDSERVER-5094

[Patrick S]

This is the table that stores the email queue. I believe the numbers are variable during installation, but the _NOTIF_BATCH_QUEUE will be consistent.

AO_4E8AE6_NOTIF_BATCH_QUEUE