JIRA Cloud Backup

  • 83Views
  • Last Post 1 weeks ago
0
votes
shravanakumar ks posted this 05 December 2019

Greetings

Today, we are doing Backup of JIRA cloud instance using Backup manager which is available under 

system > export and import > Backup manager > Create Backup for server

We need to backup JIRA cloud on daily basis for some internal reposrting purposes and hence looking at option to automate the same. 

Just wanted to check the following

1. Is it possible to automate the JIRA cloud back up using 'Skyvia Backup for Jira'

2. While trying to connect to the JIRA cloud instance, I am getting the attached error. 

 

Is there anything that you can assist us fixing the error so that we can evaluate the Backup automation process

Let me know if you need additional details. 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 05 December 2019

Hello!

Thank you for your interest in Skyvia!

 

1. Is it possible to automate the JIRA cloud back up using 'Skyvia Backup for Jira'

 

Yes, it is possible to schedule an automatic backup of your Jira data via Skyvia. Please take a look at https://skyvia.com/resources/docs/index.html?how_to_create_or_edit_backup.htm

https://skyvia.com/resources/docs/scheduling_packages.htm

 

2. While trying to connect to the JIRA cloud instance, I am getting the attached error.

 

This is an "Unauthorized (401)" error which means that incorrect login or password is used. It is required to use an API token for a successful connection. Please see https://skyvia.com/resources/docs/jira_connections.htm

JIC: Please also pay attention to the "Jira-Specific Features and Limitations" section.

In order to connect to your Jira instance, you need to specify your Domain, your email address and generate a token at https://id.atlassian.com/manage/api-tokens and use it as a Password.

 

Best regards,

Mariia

0
votes
shravanakumar ks posted this 09 December 2019

Mariia - 

Thanks for your quick response. I am using API token to autheticate and it does not allow me to enter the token created at the new connection window. The token text box is disabled. please see the screenshot attached. 

 

 

Let me know if you need additional details. 

0
votes
Mariia Zaharova posted this 09 December 2019

Hello!

 

Please specify at what exactly step this error occurs: before entering JIRA credentials or after?

JIC: We could not reproduce such an issue with our test account.

 

Also, we would recommend contacting JIRA support with this case since according to the JIRA forums, this error occurs quite often for a variety of reasons (not in Skyvia).

 

Best regards,

Mariia

0
votes
shravanakumar ks posted this 10 December 2019

In the new connection, after providing the details such as name, domain, API version etc. I am clicking on 'Log ub with JIRA' which is resulting the error. 

By the way, can you help me undeerstand why the Token field is disabled in the new connection widnow? 

I will also check with Atlassian on this issue. Thanks !

0
votes
Mariia Zaharova posted this 10 December 2019

Thank you for the reply and details.

 

By the way, can you help me undeerstand why the Token field is disabled in the new connection widnow? 

This is the expected behavior. OAuth authorization assumes that after the login to Jira, the token is automatically received and filled in the corresponding field. There is no way to enter it manually. Please refer to https://skyvia.com/resources/docs/index.html?jira_connections.htm

 

You can specify your Token manually when using Basic authentication (as we have mentioned above).

 

Best regards,

Mariia

0
votes
shravanakumar ks posted this 12 December 2019

Mariia - 

I am able to connect to the JIRA Cloud instance successfully. 

Per your documentation https://skyvia.com/resources/docs/index.html?how_to_create_or_edit_backup.htmI 

I have done the following

1. Connection - JIRA Cloud

2. Select Objects - Issues

3. Setup Schedule - One Time, Now, Timezone

4. Click on Save

Which triggered the Backup, However this is not ending. There are 208300 issues in our JIRA cloud instance. Is there a way to check the progress of this activity? I have attached one screenshot of the status

Couple of other questions around this are:

1. What will be the format of this backup(example: XML)?

2. Once completed, How do I restore this backup in JIRA server instance? Can you provide some instructions or link to your documentation. Thanks !

 

Refresh 

 

 

0
votes
Mariia Zaharova posted this 12 December 2019

There are 208300 issues in our JIRA cloud instance. Is there a way to check the progress of this activity? I have attached one screenshot of the status

The package is running, for now, it processed 191301 records.

 

How do I restore this backup in JIRA server instance? Can you provide some instructions or link to your documentation.

Here is the documentation regarding Restore process (please pay attention to the Restoring Data to Other Connections section): https://skyvia.com/resources/docs/index.html?how_to_restore_data.htm

 

Best regards,

Mariia

0
votes
shravanakumar ks posted this 12 December 2019

Mariia - 

For restoration, I need to create a new connection to JIRA server. I am not able to establish a successful connection. Is there anything that you can assist? Please see attached screenshot of the issue details. Thanks !

 

0
votes
Mariia Zaharova posted this 13 December 2019

Hello!

 

Please double-check URL that is specified for the Domain parameter (also, try specifying IP) and check if your Jira Server allows connections from Skyvia IP: 40.118.246.204

 

 

Best regards,

Mariia

0
votes
shravanakumar ks posted this 13 December 2019

Mariia - 

I am able to establish successful connectiom from my JIRA server to Skyvia IP: 40.118.246.204

Please see screenshot below. However, The issue is connecting from Skyvia IP: 40.118.246.204 to my JIRA server IP which is 10.100.159.209

Can you run the telnet command to 10.100.159.209 and check if you are able to connect? Let me know if you need additional details.

0
votes
shravanakumar ks posted this 13 December 2019

This is how I connecting with IP just in case if you need it. 

0
votes
shravanakumar ks posted this 16 December 2019

Mariia - Any update on the issue reported? As I said earlier, there is no issue from our end connecting to skyvia. Thanks !

0
votes
shravanakumar ks posted this 16 December 2019

Mariia - Any update? If this can't be resolved from your end, i am fine with it but need to know so that I can stop here and focus on other add-ons or scripts for automation. Thanks !

0
votes
Dmitriy Muzurov posted this 17 December 2019

Hello, 

Thank you for screenshots.

If we recognized your host name correctly, it's alvd-jira.us.manh.com.

This subsubdomain does not have an A or CNAME record, that means it's not pointed anywhere and can't be resolved.

Also, the IP 10.100.159.209 is a private one and can be used inside private networks only. It's not a public IP address.

Either make sure to supply a valid hostname for Jira server or use a public IP address for connecting.

Should you have any questions, do not hesitate to contact us back.

0
votes
shravanakumar ks posted this 5 weeks ago

Sorry for coming back late. 

I have setup one JIRA server in AWS cloud which has the public IP. However, I am still not able to establish a successful connection. Please see the attached doc for different screenshots. 

Let me know, if I am doing anything wrong. Thanks !

0
votes
shravanakumar ks posted this 5 weeks ago

I am able to establish connection to server successfully after opening the 8080 port in AWS security group. I will continue with my Restoration process in JIRA Server. 

Thanks anyway for your continued support.

0
votes
shravanakumar ks posted this 5 weeks ago

While restoration, I am getting the following error. 

ThisId;"OtherId";"Operation";"Error"

;"10000";"i";"Required column 'Issuetype_Id' is missing."

;"10001";"i";"Required column 'Issuetype_Id' is missing."

;"10002";"i";"Required column 'Issuetype_Id' is missing."

I only choose object 'Issues' while Backing up? Is there any depending obecjts that I need to select while Backing up for successful restoration? please advise. 

0
votes
Dmitriy Muzurov posted this 5 weeks ago

Hello,

Thank you for getting back to us.

The object Issues has several required columns for INSERT operation. These are Summary, Issuetype_Id (foreign key of IssueTypes), Project_Id (foreign key of Project) and Priority_Id (foreign key of Priority).

The error states that several records can't be inserted to Issues because there is no Issuetype_Id column.

Please fill up this column in your Jira and make a backup once again. Then it would be possible to restore.

Should you have any questions, do not hesitate to contact us back.

0
votes
shravanakumar ks posted this 5 weeks ago

Basically, I am looking at syncing (create, update and delete) one JIRA instance with another JIRA instance. 

I have taken a backup of all objects in one instance and restoring it in another instance which is resulting the same error.

The documentation of restore process is not clear to me. will you be able to assist what exactly needs to be done for my requirement? Thanks !

If you wish you can restore it in JIRA Server AWS and see the results. 

0
votes
Dmitriy Muzurov posted this 4 weeks ago

Hello,

Thank you for reply.

Restoring to another instance is done through INSERT operation, so the cause and the solution are the same.

You need 'Issuetype_Id' column to have values in it to successfully restore.

We are looking forward to hearing from you, should you have any questions.

0
votes
shravanakumar ks posted this 4 weeks ago

I don't see any 'issuetype_id' in the restoration process. Please see attached screens shot. 

0
votes
Dmitriy Muzurov posted this 4 weeks ago

Hi, 

Thank you for the screenshot.

The restoration process is configured to INSERT the selected records to the source without selecting a particular column.

The error states that several records can't be inserted to Issues because there are no values in Issuetype_Id column in the made backup.

In order to have those values in the backup, they should be created in the source which a backup is made from. Please check your Jira Issues and make sure all records have Issuetype_Id not blank. Once this column is set up, you need to make a new backup and move on to the restore operation.

Feel free to contact us back, should you have any questions.

0
votes
shravanakumar ks posted this 4 weeks ago

The 'Issuetype_id' column already seem to have values. please see attached screenshot. 

0
votes
shravanakumar ks posted this 4 weeks ago

0
votes
Dmitriy Muzurov posted this 3 weeks ago

Hello,

Thank you for screenshots.

It seems those are from another object IssueTypes though and not Issues.

We tested the restore on our side and got the record inserted to Issues successfully.

There are three issues reflected in your error log: with IDs 10000, 10001 and 10002.

Perhaps those records do not have Issuetype_Id. Please open Skyvia Query, select New SQL, then your Jira connection, paste and run this query:

SELECT t.*

FROM Issues AS t

WHERE t.Issuetype_Id IS NOT NULL AND t.Id IN ('10000','10001','10002')

This should return three records with specified IDs if all of them have Issuetype_Id.

We are looking forward to hearing from you.

0
votes
shravanakumar ks posted this 1 weeks ago

You may go ahead and close this ticket. Thanks !

0
votes
Dmitriy Muzurov posted this 1 weeks ago

Hi,

You are welcome.

Feel free to contact us back, should you require any further assistance.

Close