Scheduled eazyBi import problems

Question

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

Gisli Petur Hinriksson · Answer

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. :)

Cristina_Abunei · Answer

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.

Karanpreet Kaur · Answer

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