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 !
