Jira Webhooks Plugin failure after upgrading to 10.3.5

Jira Development Jira Data Center
1

Hi all,

After upgrading Jira Data Center in RDS 15, we encountered the following issue:

Only 16 webhooks were present post-upgrade — we expected around 80.

We manually re-created the most critical webhooks using AO_4AEACD_WEBHOOK_DAO as a reference.

Some webhooks fired initially, but then stopped.

We discovered that a sequence does not exist in the DB.

Even the 16 migrated webhooks didn’t trigger creation of the sequence.

There’s no DDL included in JRASERVER-78741 to create it.

Our questions:

  1. Does Jira create the sequence automatically? If so, when is this supposed to happen during the upgrade or startup process?

  2. Should we manually replicate the migration described in JRASERVER-78741?

  3. If we apply the DML manually, is there anything else we should do to ensure proper functionality?

  4. Would disabling and re-enabling the plugin trigger the DAO upgrade and sequence creation?

Thanks in advance for any insights!