Scheduled eazyBi import problems

Dear all

I was wondering if anyone else has experienced the same and can offer help to resolve the issue.

If a scheduled scan is undertaken e.g. every 3 hours OR a timed scan e.g. at 6 am every day then the data is not imported correctly i.e. missing data or completely empty. If however I do a manual import everything is OK. This seems very strange. Any ideas?

Obviously I want to schedule imports so that users graphs etc are up to date when they look at them rather than relying on someone to do an import.

 

Many thanks

Nick

 

 

 

5 answers

Hi Nick,

This should not be the case. The regular import should be importing / updating issues in the same way as manual import.

To help us assist you with this issue, could you please send the following information to support@eazybi.com 

  • what is your JIRA version
  • what eazyBI version do you have installed
  • from JIRA home directory log/eazybi-web.log and log/eazybi-queues.log files

I am sorry for the troubles this has been causing to you!
Lauma / support@eazybi.com

I am facing the same issue and I have sent a support request to eazyBI support.

We have recently started facing this issue in Production.

Please help us resolve this issue at the earliest.

Hi All

we are facing the same issue .

@Karanpreet Kaur  @NickW   did you get any solution for this problem.

 

we opened a support ticket for this but they asked to change settings of MySQL which did not solve our problem.

I was wondering is this a bug or only we facing this problem.

 

Any help will be appreciated .

 

 

Heman 

Hi Heman,

We tried below steps and it resolved the issue.

  • Re-index JIRA
  • Go to Analyze tab and click Empty button for Issues cube (it will delete just imported data but all created reports and calculated members will remain)
  • Return to Source Data tab and click Import to start new re-import of all data.

Thanks,

Karan

Hello,

 

We are also having a similar problem. Manual import works just fine, while the scheduled ones (at any interval) fail.

In the eazyBI log files we see:

2017-06-18 09:30:00 -0400 INFO: [regular_job] Can't acquire lock for RegularJob id=3
2017-06-18 09:40:00 -0400 INFO: [regular_job] Can't acquire lock for RegularJob id=2
2017-06-18 09:40:00 -0400 INFO: [regular_job] Can't acquire lock for RegularJob id=3

Was any solution found for this?

 

Thank you.

For people seeing this and having installed 4.5.3 Data Center version of eazyBI that supports running on JIRA data center better. 

There is an option inside the settings section in eazyBI interface where you can dedicate a node in the JIRA data center cluster to handle the jobs.

I waited for some time seeing "Waiting in queue" and researched a bit. Then I found the specific parameter and entered a node. Stopped the import and retried and all worked,

Just a stupid mistake but good to have it here for the record. :) 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

394 views 0 9
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you