nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issues while importing XML backup in JIRA 7.12.3

Ash_kida48

Hi Everyone,

We are seeing below issue while importing Mysql 5.6 XML backup to Postgres 9.6. in JIRA 7.12.3. We are using AWS RDS instances. Already used XML cleaner to clean backups before import.

---------------------------------------------------------------------------------------------

com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:9.6.9
- minor version:6
- major version:9
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.4.1212

org.postgresql.util.PSQLException: ERROR: relation "public.AO_455C86_PASS_POLICY_PROP" does not exist
Position: 32
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:9.6.9
- minor version:6
- major version:9
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.4.1212

org.postgresql.util.PSQLException: ERROR: relation "public.AO_455C86_PASS_POLICY_PROP" does not exist
Position: 32

TIA!!

Accepted answers

All comments

Thomas Deiler_db00h3

Dear @Ash,

is the XML backup of a lower version of Jira Software than 7.12.3?

So long

Thomas

Ash_kida48

@Thomas Deiler Thanks for your reply XML back is on JIRA 7.12.3.

we are switching database in the new instance.

Since MySQL RDS is not supported by Atlassian.

Thomas Deiler_db00h3

Ok, then something went wrong when exporting the data. The XML dump is free of any DB flavour. It would make no sense to export DB details in an XML file. Otherwise you could just dump the DB without Jira.

Just to double check - when you reimport into the same DB type, does the error occure, too?

Another source of the error: Have you set up postgresql like recommended by Atlassian?

Why does the driver say its version 9.4.1212 and not 9.6.9? Are there parallel DB versions installed?

So long

Thomas

Ash_kida48

Just to double check - when you reimport into the same DB type, does the error occure, too?

Re-Importing to the same XML to the same DB worked fine.

Another source of the error: Have you set up PostgreSQL like recommended by Atlassian?

We are using RDS Postgres and DB has been created instruction given by atlassian.

Why does the driver say its version 9.4.1212 and not 9.6.9? Are there parallel DB versions installed?

Using 9.4 JDBC is atlassian recommendation.

"Jira is tested and bundled with the 9.4 JDBC driver. You can also use the latest JDBC driver for your PostgreSQL version, though we can't guarantee it will work with your version of Jira."

Can you be more specific on this question,

"Are there parallel DB versions installed?"

TIA!!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-server

database

backup