SPAGOBI-1888 - Worksheet : Screen frozen during export if filter is mandatory

[KnowageServiceAcc]

Details

Key	Value
Key	SPAGOBI-1888
Type	Bug
Status	Open
Priority	Major
Resolution
Affects	4.2, 5.0.0
Fix
Components	SERVER/AdHoc/Worksheet
Labels	export, worksheet

People

Key	Value
Assignee	Alberto Ghedin
Reporter	WEILL guillaume

Dates

Key	Value
Created	2014-10-07T18:36:36.000+0200
Updated	2014-10-09T18:14:51.000+0200
Resolved	n.d.

Description

If you try to export a worksheet to xls with several sheets based on mandatory parameters, nothinh happens. A message should tell to the user that some parameters are not filled.

Comments

Alberto Ghedin added a comment - 2014-10-09T16:49:39.712+0200

Can’t reproduce. Can you attach the template of a simple document?

WEILL guillaume added a comment - 2014-10-09T18:14:51.101+0200

Sorry, I was wrong, screen is not frozen. Screen is not frozen, you are redirected to the sheet which waits for parameters and nothing happens on the screen. The problem occurs when you try to export some chart (pie chart for example) without filling parameters.

In dev tools, a error is printed (client side): Uncaught TypeError: Cannot read property 'getSVG' of null qbe-all-4.1.0.js:14 Ext.extend.exportContent qbe-all-4.1.0.js:14 Ext.extend.exportContent qbe-all-4.1.0.js:13 Ext.extend.exportContent qbe-all-4.1.0.js:13 Ext.extend.exportRenderedContent qbe-all-4.1.0.js:13 Ext.extend.doExportContent qbe-all-4.1.0.js:13 Ext.extend.exportContent qbe-all-4.1.0.js:13(anonymous function)

No logs in server. I guess the error occurs before calling the server.

If I try to export it a second time, an alert popup is displayed with : Sorry, we cannot perform this operation.

Important thing, if you check each sheet before trying to exporting (without filling parameters), the popup alert correctly appears.

So, the problem appears only if you do not fill mandatory filters AND do not look at the sheet.

Following the template (Repartition is a pie chart which need to fill filters) :

<?xml version="1.0" encoding="ISO-8859-1"?>

{"catalogue":{"queries":[{"id":"q1","name":"query-q1","description":"query-q1","distinct":false,"isNestedExpression":false,"relationsRoles":[],"graph":[],"fields":[{"alias":"DECSORTANT ID","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.DECSORTANT_ID","entity":"QBE DECSORTANT 2","field":"DECSORTANT ID","longDescription":"QBE DECSORTANT 2 : DECSORTANT ID","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"FLUX SERVICE ID","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.FLUX_SERVICE_ID","entity":"QBE DECSORTANT 2","field":"FLUX SERVICE ID","longDescription":"QBE DECSORTANT 2 : FLUX SERVICE ID","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Service Type","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Type","entity":"QBE DECSORTANT 2","field":"Service Type","longDescription":"QBE DECSORTANT 2 : Service Type","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Service Nom","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Nom","entity":"QBE DECSORTANT 2","field":"Service Nom","longDescription":"QBE DECSORTANT 2 : Service Nom","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Service Dept","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Dept","entity":"QBE DECSORTANT 2","field":"Service Dept","longDescription":"QBE DECSORTANT 2 : Service Dept","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"MO Nom","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.MO_Nom","entity":"QBE DECSORTANT 2","field":"MO Nom","longDescription":"QBE DECSORTANT 2 : MO Nom","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"MO Type","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.MO_Type","entity":"QBE DECSORTANT 2","field":"MO Type","longDescription":"QBE DECSORTANT 2 : MO Type","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Annee","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Annee","entity":"QBE DECSORTANT 2","field":"Annee","longDescription":"QBE DECSORTANT 2 : Annee","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Tonnage","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Tonnage","entity":"QBE DECSORTANT 2","field":"Tonnage","longDescription":"QBE DECSORTANT 2 : Tonnage","group":"","order":"","funct":"NONE","iconCls":"measure","nature":"measure"},{"alias":"Dechet","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dechet","entity":"QBE DECSORTANT 2","field":"Dechet","longDescription":"QBE DECSORTANT 2 : Dechet","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Precision","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Precision","entity":"QBE DECSORTANT 2","field":"Precision","longDescription":"QBE DECSORTANT 2 : Precision","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Filiere traitement","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Filiere_traitement","entity":"QBE DECSORTANT 2","field":"Filiere traitement","longDescription":"QBE DECSORTANT 2 : Filiere traitement","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Type","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Type","entity":"QBE DECSORTANT 2","field":"Dest Type","longDescription":"QBE DECSORTANT 2 : Dest Type","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Service","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Service","entity":"QBE DECSORTANT 2","field":"Dest Service","longDescription":"QBE DECSORTANT 2 : Dest Service","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Service Type","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Service_Type","entity":"QBE DECSORTANT 2","field":"Dest Service Type","longDescription":"QBE DECSORTANT 2 : Dest Service Type","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Presta Nom","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Presta_Nom","entity":"QBE DECSORTANT 2","field":"Dest Presta Nom","longDescription":"QBE DECSORTANT 2 : Dest Presta Nom","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Presta Type","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Presta_Type","entity":"QBE DECSORTANT 2","field":"Dest Presta Type","longDescription":"QBE DECSORTANT 2 : Dest Presta Type","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Dept","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Dept","entity":"QBE DECSORTANT 2","field":"Dest Dept","longDescription":"QBE DECSORTANT 2 : Dest Dept","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest Commune","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Commune","entity":"QBE DECSORTANT 2","field":"Dest Commune","longDescription":"QBE DECSORTANT 2 : Dest Commune","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"},{"alias":"Dest CodeInsee","visible":true,"include":true,"type":"datamartField","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_CodeInsee","entity":"QBE DECSORTANT 2","field":"Dest CodeInsee","longDescription":"QBE DECSORTANT 2 : Dest CodeInsee","group":"","order":"","funct":"NONE","iconCls":"attribute","nature":"attribute"}],"filters":[],"expression":{},"havings":[],"subqueries":[]}]},"version":7} {"sheets":[{"name":"Donnees","sheetLayout":"layout-headerfooter","header":{"title":"<div align=\"left\"><font size=\"4\" color=\"99CCFF\" face=\"verdana\"><u><b><font color=\"808080\">Tableau de suivi et d'analyse des tonnages dits <font color=\"808080\">\"S</font>ortants</font></b></u></font><font size=\"4\">\"<br></font></div>","img":null,"position":"left"},"filters":{"filters":[{"selection":"multivalue","mandatory":"no","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Annee","alias":"Annee","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"selection":"multivalue","mandatory":"no","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Dept","alias":"Service Dept","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"selection":"multivalue","mandatory":"no","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Dept","alias":"Dest Dept","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"selection":"multivalue","mandatory":"no","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Service_Type","alias":"Dest Service Type","iconCls":"attribute","nature":"attribute","values":"[]","valid":true}],"position":"top"},"content":{"designer":"Table","visibleselectfields":[{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Type","alias":"Service Type","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Nom","alias":"Service Nom","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Dept","alias":"Service Dept","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.MO_Nom","alias":"MO Nom","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.MO_Type","alias":"MO Type","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Annee","alias":"Annee","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Tonnage","alias":"Tonnage","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dechet","alias":"Dechet","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Precision","alias":"Precision","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Filiere_traitement","alias":"Filiere traitement","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Type","alias":"Dest Type","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Service","alias":"Dest Service","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Service_Type","alias":"Dest Service Type","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Presta_Nom","alias":"Dest Presta Nom","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Presta_Type","alias":"Dest Presta Type","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Dept","alias":"Dest Dept","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_Commune","alias":"Dest Commune","iconCls":"attribute","nature":"attribute","values":"[]","valid":true},{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Dest_CodeInsee","alias":"Dest CodeInsee","iconCls":"attribute","nature":"attribute","values":"[]","valid":true}]},"footer":{"title":"<font size=\"2\" color=\"808080\" face=\"verdana\">Les tonnages dits \"Sortants\" sont les tonnages prod<span style=\"background-color: rgb(255, 255, 255);\">uits par les collectes OMR, les </span>collectes sélectives, les déchèteries, les aires de déchets verts et les installations de transfert-tri-traitement de déchets.<br><span style=\"background-color: rgb(204, 255, 255);\">Fonctionnalité particuliè</span><span style=\"background-color: rgb(204, 255, 255);\">re</span> : cliquez sur une en-tête de colonne pour masquer/afficher un ou plusieurs champs<br></font><font size=\"2\" color=\"808080\" face=\"verdana\"><font face=\"verdana\"><span style=\"background-color: rgb(255, 204, 153);\">Fonctionnalité en attente </span>: cliquez sur une en-tête de colonne pour trier le contenu d'un champs</font><br>Rapport réalisé à partir des données disponibles dans l'outil régional déchets.<br></font>","img":"GIP_2012_Color-200 - Copie.png","position":"right"},"filtersOnDomainValues":[{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Type","alias":"Service Type","iconCls":"attribute","nature":"attribute","values":"[\"Collecte OM et collectes sélectives\",\"Compostage\",\"Tri\",\"Incinération avec valorisation énergétique\",\"Transit\",\"Stockage en ISDND-Installations de stockage de déchets non dangereux\",\"Incinération sans valorisation énergétique\",\"Centre d apport volontaire\",\"Déchèterie\",\"Maturation de mâchefers\"]"}]},{"name":"Repartition","sheetLayout":"layout-headerfooter","header":{"title":"<font size=\"4\" color=\"99CCFF\" face=\"verdana\"><u><b><font color=\"808080\">Répartition des tonnage<font color=\"808080\">s di<font color=\"808080\">ts \"Sortants\" par maître d'ouvrage</font></font></font></b></u></font><font size=\"4\"></font>","position":""},"filters":{"filters":[{"selection":"singlevalue","mandatory":"yes","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Annee","alias":"Annee","iconCls":"attribute","nature":"attribute","values":"[\"2005\",\"2006\",\"2007\",\"2008\",\"2009\",\"2010\",\"2011\",\"2012\",\"2013\",\"2014\",\"2015\",\"1987\",\"1988\",\"1989\",\"1990\",\"1991\",\"1992\",\"1993\",\"1994\",\"1995\",\"1996\",\"1997\",\"1998\",\"1999\",\"2000\",\"2001\",\"2002\",\"2003\",\"2004\"]"},{"selection":"singlevalue","mandatory":"yes","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Dept","alias":"Service Dept","iconCls":"attribute","nature":"attribute","values":"[]"},{"selection":"singlevalue","mandatory":"yes","id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Type","alias":"Service Type","iconCls":"attribute","nature":"attribute","values":"[]"}],"position":"left"},"content":{"designer":"Pie Chart","showvalues":true,"showlegend":false,"showpercentage":true,"colors":["#4572A7","#DB843D","#56AFC7","#80699B","#89A54E","#AA4643","#50B432","#1EA6E0","#DDDF00","#ED561B","#64E572","#9C9C9C","#4EC0B1","#C3198E","#6B976B","#B0AF3D","#E7913A","#82AEE9","#7C3454","#A08C1F","#84D3D1","#586B8A","#B999CC"],"category":{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.MO_Nom","alias":"MO Nom","iconCls":"attribute","nature":"attribute","values":"[]"},"series":[{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Tonnage","alias":"Tonnage","iconCls":"measure","nature":"measure","funct":"SUM","seriename":"Tonnage","color":"#4572A7","showcomma":true,"precision":2,"suffix":""}]},"footer":{"title":"<font size=\"1\" color=\"808080\" face=\"verdana\"><font size=\"2\">Les tonnages dits <font color=\"808080\">\"S</font>ortants\" sont les tonnages prod<span style=\"background-color: rgb(255, 255, 255);\">uits par les collectes OMR, les </span>collectes sélectives, les déchèteries, les aires de déchets verts et les installations de transfert-tri-traitement de déchets.<br></font></font><font size=\"1\" color=\"808080\" face=\"verdana\"><font size=\"2\"><font size=\"2\" color=\"808080\"><span style=\"background-color: rgb(204, 255, 255);\"><font face=\"verdana\">Critères obligatoires<span style=\"background-color: rgb(255, 255, 255);\"> : le renseignement des filtres est obligatoire - chaque filtre ne peut recevoir qu'une valeur</span></font></span></font><font size=\"2\" color=\"808080\"><br></font>Rapport réalisé à partir des données disponibles dans l'outil régional déchets<font color=\"808080\">.</font></font><br></font>","img":"GIP_2012_Color-200 - Copie.png","position":"right"},"filtersOnDomainValues":[{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Annee","alias":"Annee","iconCls":"attribute","nature":"attribute","values":"[\"2005\",\"2006\",\"2007\",\"2008\",\"2009\",\"2010\",\"2011\",\"2012\",\"2013\",\"2014\",\"2015\",\"1987\",\"1988\",\"1989\",\"1990\",\"1991\",\"1992\",\"1993\",\"1994\",\"1995\",\"1996\",\"1997\",\"1998\",\"1999\",\"2000\",\"2001\",\"2002\",\"2003\",\"2004\"]"}]}],"globalFilters":[{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Annee","alias":"Annee","funct":"NONE","iconCls":"attribute","nature":"attribute","values":"[\"2005\",\"2006\",\"2007\",\"2008\",\"2009\",\"2010\",\"2011\",\"2012\",\"2013\",\"2014\",\"2015\",\"1987\",\"1988\",\"1989\",\"1990\",\"1991\",\"1992\",\"1993\",\"1994\",\"1995\",\"1996\",\"1997\",\"1998\",\"1999\",\"2000\",\"2001\",\"2002\",\"2003\",\"2004\"]","precision":"","options":{}}],"fieldsOptions":[{"id":"it.eng.spagobi.meta.Qbe_decsortant_2:compId.Service_Type","alias":"Service Type","funct":"NONE","iconCls":"attribute","nature":"attribute","values":"[]","precision":"","options":{"attributePresentation":"both"}}],"version":2}