EazyBI - Error when drill through issues

[Thomas AUVRAY]

Hi there, 

I really love EAZYBI plugin but recently I am facing issue which is very inconvenient. 

When I select the "Drill through issues" button, very often, this pop-up is displaying : 

I initialy thought this was due to large number of issues, but : 

- It also happened with just 5 or 6 issues

- On this page I see that even with 919 issues, everything is working and very quickly. 

I tried to check logs files and understand where the problem can be. This is what I found : 

### CLICK ON THE "DRILL THROUGHT ISSUE" BUTTON ###

2019-12-12 10:19:39 +0100 INFO: [B97C2819:7d569ae8] Started POST "/plugins/servlet/eazybi/eazy/accounts/3/cubes/ALL%20TEAMs%20-%20ALL%20JIRA/query" for 78.232.200.38 at 2019-12-12 09:19:39 +0000
2019-12-12 10:19:39 +0100 INFO: [B97C2819:7d569ae8] Processing by EazyCube::QueriesController#create as JSON
2019-12-12 10:19:39 +0100 INFO: [B97C2819:7d569ae8] Parameters: {"_json"=>[{"type"=>"pivot_table", "page"=>["[Issue Type].[Ticket]", "[Etablissement].[BAZ78 - Le Nôble Age - Clinique de Bazincourt (SSR)]", "[Status].[Clos]"], "columns"=>{"dimensions"=>[{"name"=>"Time", "include"=>"[Time].[(S-1)]", "preserve_order"=>true}]}, "rows"=>{"dimensions"=>[{"name"=>"Type de problème", "include"=>"[Type de problème].[Hardware]", "preserve_order"=>true}, {"name"=>"Catégorie de problème", "include"=>"[Catégorie de problème].[Terminal]", "preserve_order"=>true}, {"name"=>"Constat", "include"=>"[Constat].[PING KO]", "preserve_order"=>true}, {"name"=>"Bug identifié", "include"=>"[Bug identifié].[Terminal KO, OK après reboot manuel]", "preserve_order"=>true}, {"include"=>"[Issue].[Issue].Members", "preserve_order"=>true}], "nonempty"=>true, "filter"=>{"conditions"=>[{"expression"=>["[Time].[(S-1)]"], "operator"=>"<>", "value"=>"0"}]}}}], "account_id"=>"3", "cube_id"=>"ALL TEAMs - ALL JIRA"}

### ERROR POP-UP APPEARS ###

2019-12-12 10:19:54 +0100 INFO: [B97C2819:7d569ae8] Completed 200 OK in 14868ms (Views: 1.1ms | ActiveRecord: 3.4ms)

On my browser I see that the request seems to Timeout at 5s :

So at 5s the pop-up said that an error occured, but at 14s one 200 success code appear on logfile.

I don't see some errors in others logfiles. 

Two questions so : 

- Why is my request on 3 issues takes more than 14s ? 

- Why is EAZYBI so impatient?

Maybe @eazyBI Support can be very helpfull on that ? 

Thanks a lot in advance for your help !

[Nick Menere]

Hi Shawn,

You can do this by:

1. Add a "Issue Transitioned" trigger
2. Add a condition to check for the issue status. You can use either the JQL condition or the Compare Condition.
   1. For JQL simply run an jql like: status = Done
   2. For Compare Condition, use a value a like {{issue.status.name}} and compare against that.
3. Then add an "Edit Issue" action
   1. In the advanced section use the following (substituting your custom field id)
      

      {
          "fields": {
              "customfield_10506": "{{#increment}}{{issue.fields.customfield_10506}}{{/increment}}"
          }
      }

This will increment the count of the field. Note. this will only work for text customfields and not number custom fields. (I'm still trying to figure out how to do that.

Cheers,

Nick

[Santosh Maurya]

Nick,

This worked for me... thanks..