Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I am trying to pull Jira data in ETL tool azure data factory but the tables are not loading it's tim

sudhir kumar rai
July 5, 2022

We are trying to extract JIRA data like Issues, Ticket details from ETL tool called Azure Data Factory through JIRA connector, We are successfully created the coonection but tables are not loading it is getting timed out.

image.png

1 answer

1 accepted

4 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 7, 2017

Short answer is that you will get a completely broken index, and you will need to re-index the system in full again.

A little more detail:

Imagine the process as "throw away the index, then read each issue from the database in turn and build an index record for it". 

If you shut the service down, it will finish the issue it is currently doing and stop.  You will end up with some issues indexed and others not.

If you kill it from the outside, you don't give it a chance to shut down cleanly, so you could get a corrupted index record as well as the partial index.  If you're using a HSQL or H2 database, this can (rarely) render your JIRA unusable (but you shouldn't be using them for production systems).  With real databases, the worst case is a few garbled index entries on top of the issues you've not indexed.

Suggest an answer

Log in or Sign up to answer