we are unable to setup JIRA, we have this error when crating new project :
org.postgresql.util.PSQLException: ERROR: relation "AO_B9A0F0_APPLIED_TEMPLATE" does not exist
Thanks - We faced the same issue while trying to hook up an Azure postgresql db service to a Jira instance
It is related to this issue: https://jira.atlassian.com/browse/JRASERVER-64886
"ALTER DATABASE <database_name> SET search_path TO schema1,schema2;"
The search_path parameter sets the order in which schemas are searched using non-qualified object names.
This fixed my problem installing Jira 8.2.1 with Azure Database for Postgresql.
I had to use a non-default schema because Azure was adding 2 PostgreSQL extensions, which caused Jira to think the DB was not empty.
I couldn't easily remove the extensions via my Terraform modules.
So I changed my Terraform module to set the new schema name to be the same as the jiradbuser user name (default search path in PostgreSQL is "$user", public).
This fixed the "org.postgresql.util.PSQLException: ERROR: relation "AO... does not exist" errors.
OA tables are for plugins. Go to admin panel / System / Plugin data storage. Here you can find plugin which uses this table.
Other option - database is not supported by JIRA. Here is list of supported databases: https://confluence.atlassian.com/adminjiraserver072/supported-platforms-828787550.html