How to configure Service Desk to process old emails

[Matt Deir]

I've tried the guide here - https://confluence.atlassian.com/jirakb/configure-jira-service-desk-to-process-old-emails-806455097.html

But the table does not seem to exist in my Jira DB:

[42P01] ERROR: relation "ao_2c4e5c_mailconnection" does not exist

Any help would be appreciated.

JIRA Service Desk 4.11.0

[Lenard Bernardo]

Hi Matt,

Thanks for your question.

Can you please try wrapping the table names with quotes?

For example:

SELECT * FROM "AO_2C4E5C_MAILCONNECTION";

UPDATE "AO_2C4E5C_MAILCONNECTION" SET PULL_FROM_DATE = [NEW_EPOCH_VALUE] WHERE EMAIL_ADDRESS = 'EMAIL_ADDRESS_FROM_CHANNEL';

Thank you,

Lenard
Jira Service Desk

ps. if this answer is correct, please select the ‘accept answer’ button