Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Unable to access the Attachments after restoring the Jira backup on a newly installed OnpreJirasrvr

Unable to access the Attachments after restoring the Jira backup on a newly installed On premises Jira server.

As part of disaster recovery, Installed Jira on a new server, Backup has been restored using restoration process. After restore, able to access the Projects and Takas. But unable to access any attached filed. It is giving the following error.1.PNG

 

During the verification found DB is not configured and it is pointing to the back up file. 

Can you please provide the steps how to configure the Jira with Database?we are using Jira 8.8.0 with PostgreSQL.

2.JPG

4 answers

0 votes

I'm very confused.  You say you've restored a backup, and you say you're using postgres, but your system information says you're on h2, not postgres.

So what did you actually restore?  A postgres backed Jira or an h2 one?  And did your backup process include the attachments?  If so, then how?

The Jira back up has been created as ZIP file  using Import and Export --> "Backup System" option

backup.JPG

 

and after installing the Jira on Test server, used the "Restore System" option to restore the backup file created from Production server

Restor.JPG

I can see all projects and Tasks have been restored successfully but attachments are missing. Then I copied the "Data" folder from the production server to Test Server. Now attachments are showing correctly. 

 

Now I got new question as follows:

1. The process I followed for Restoring the Jira on Test server is correct or not?

2. What is the role of PostgresSQL DB in the Jira? The reason, I didnot used any DB restoration or import while establishing the JIra on Test server. But restoring the backup file on Test server, the system info on Test server is showing as follows. Looks I misssed some Database related restore steps. Can you please suggest?

2.JPG

0 votes

Ok, so you've taken an export of one system (which looks like it was running with a Postgres back-end) and restored it on a system which uses h2 for its database.

That's fine,

But yes, the export/import does not include attachments, so restoring them from the data directory on the source system over to the target fixes your problem.

However, one other problem - you say you "restored the data directory" - exactly what do you mean by "data directory"?  If you restored the "jira home data" directory, then you could have just connected your test system to your production data, and that is a very bad thing.  

Do you mean that you restored only the attachments directory?

I have copied the "Data" directory from Production server and replaced it on Test Server as follows. Then attachments started working.

data.JPG

 

My question is what is the role of DB in Jira system? Can we  install Jira without a DB and make it as production system? I have not installed "h2" DB and not sure from where it has been picked. Can we have quick screen sharing session?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

263 views 7 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you