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

Jira project import very slow on step "Mapping and validating import data"

Hi!

We are trying to import one project from another instance with about 1M issues. The third step "Mapping and validating import data" takes unreasonably much time.

Specifically:
Extracting Project Data. Processing AO_C16815_ALERT_AO: Entity 8508552 of 63599285

I didn´t even notice when entity number went to 8500000 but after that we are 3 hours in and its still showing completion rate of 6%. Is this normal for a backup from big Jira instance? Shouldn't the import concentrate on one project only regardless of the dump file size?

I looked at processor usage and the process is using 100% of one cpu and the other 11 are essentially idle. Seems like a waste of resources.

Can anybody suggest possibilities to make project import faster?

Best regards,
Imre

2 answers

1 accepted

0 votes
Answer accepted

We solved this issue. This table is used by the Atlassian Diagnostics integration plugin and can become very big on larger instances. For import purposes we just deleted that table and project import was successful but for more permanent results there are options how to keep the table size under control. Several options are pointed out here: https://jira.atlassian.com/browse/JRASERVER-69138

Recommended solution in the long run however is to deal with the issues that produce large number of alerts upon which the daily analytics summary is generated. 

Best regards,
Imre

I have the same issue. The import of a single project with less than 400 issues takes hours and hours. It seems to get very slow at the step "Processing AO_C16815_ALERT_AO".

Afbeelding 8.pngHow can this be resolved?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

314 views 1 3
Join discussion

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