Hi Núria, What was the 'MaxQueryCostEstimationTime’ parameter set to previously and what did you increase it to , as the “ERR_CONTENT_DECODING_FAILED” error seem odd for a timeout parameter ?
Also, when you ran the query from isql how long does it take to execute and return results ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 28 Aug 2015, at 15:51, Nuria Queralt Rosinach <nquer...@imim.es> wrote: > > Hi Hugh, > > Problem solved! just increasing a bit the ' MaxQueryCostEstimationTime' > parameter in the configuration of the SPARQL service and the query works > perfectly fine :) > > Thank you very much for your always fast replies. > Best, > Núria > > On 08/28/2015 04:30 PM, Nuria Queralt Rosinach wrote: >> Hi Hugh, >> >> >> On 08/28/2015 02:56 PM, Hugh Williams wrote: >>> HI Núria, >>> >>> You reported the same error running a SPARQL-FED query last year, was this >>> resolved then as it is unclear from the thread ? >> >> Good memory! i managed to solve the problem in that case. This time it is >> not a FED. >>> What is the query currently being run is it a SPARQL-FED query also or a >>> query against the local instance ? >>> >> >> it is about a query against local data. Issues raised via the sparql >> endpoint when using DISTINCT in a SELECT query, or GROUP BY modifier: the >> same query gives output without using DISTINCT or GROUP BY in the SELECT >> query. >> >>> If the query runs from isql which executes queries as the “dba” (or >>> whatever user you login as) and fails via the HTTP , which I assume is the >>> /sparql endpoint, which runs as user “SPARQL”, >> >> yes >>> then most probably the roles assigned to both differ, thus you should check >>> was is assigned to both in the “System Admin -> User Accounts” section of >>> the Conductor and ensure the same SPARQL roles are assigned ie >>> SPARQL_SELECT, SPARQL_UPDATE, SPARQL_SPONGE, SPARQL_LOAD_SERVICE_DATA , see: >>> >>> >>> http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsupportedprotocolendpointuri >>> >>> <http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsupportedprotocolendpointuri> >>> >>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksDiscoverSPARQFedCapabilities >>> >>> <http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksDiscoverSPARQFedCapabilities> >> I checked, they differ: SPARQL user has the 'SPARQL_SELECT' role assigned, >> whereas the dba user does not have any role assigned... >> >> Thanks! >> Núria >>> >>> Best Regards >>> Hugh Williams >>> Professional Services >>> OpenLink Software, Inc. // http://www.openlinksw.com/ >>> <http://www.openlinksw.com/> >>> Weblog -- http://www.openlinksw.com/blogs/ >>> <http://www.openlinksw.com/blogs/> >>> LinkedIn -- http://www.linkedin.com/company/openlink-software/ >>> <http://www.linkedin.com/company/openlink-software/> >>> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> >>> Google+ -- http://plus.google.com/100570109519069333827/ >>> <http://plus.google.com/100570109519069333827/> >>> Facebook -- http://www.facebook.com/OpenLinkSoftware >>> <http://www.facebook.com/OpenLinkSoftware> >>> Universal Data Access, Integration, and Management Technology Providers >>> >>> >>> >>>> On 28 Aug 2015, at 12:33, Nuria Queralt Rosinach <nquer...@imim.es >>>> <mailto:nquer...@imim.es>> wrote: >>>> >>>> Dear all, >>>> >>>> I have a problem with a query that perfectly works via ISQL, but it does >>>> not via Web. The error i got is: Error code: ERR_CONTENT_DECODING_FAILED >>>> >>>> >>>> Virtuoso version implemented: >>>> OpenLink Virtuoso Server >>>> Version 07.10.3211-pthreads for Linux as of Nov 4 2014 >>>> >>>> Could you shed light on that problem? Many thanks in advance. >>>> >>>> Best regards, >>>> Núria >>>> -- >>>> ******************************************************************** >>>> Núria Queralt Rosinach >>>> Research Programme on Biomedical Informatics (GRIB) >>>> Department of Experimental and Health Sciences >>>> Universitat Pompeu Fabra >>>> IMIM (Hospital del Mar Medical Research Institute) >>>> C/Dr. Aiguader 88, 08003 >>>> Barcelona, Spain >>>> Tel.: +34 93 316 0536 (1536) >>>> E-mail: nquer...@imim.es <mailto:nquer...@imim.es> >>>> Skype IM: nuriaqr76 >>>> http://ibi.imim.es/ <http://ibi.imim.es/> >>>> ******************************************************************** >>>> ------------------------------------------------------------------------------ >>>> _______________________________________________ >>>> Virtuoso-users mailing list >>>> Virtuoso-users@lists.sourceforge.net >>>> <mailto:Virtuoso-users@lists.sourceforge.net> >>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> >>> >> >> -- >> ******************************************************************** >> Núria Queralt Rosinach >> Research Programme on Biomedical Informatics (GRIB) >> Department of Experimental and Health Sciences >> Universitat Pompeu Fabra >> IMIM (Hospital del Mar Medical Research Institute) >> C/Dr. Aiguader 88, 08003 >> Barcelona, Spain >> Tel.: +34 93 316 0536 (1536) >> E-mail: nquer...@imim.es <mailto:nquer...@imim.es> >> Skype IM: nuriaqr76 >> http://ibi.imim.es/ <http://ibi.imim.es/> >> ******************************************************************** > > -- > ******************************************************************** > Núria Queralt Rosinach > Research Programme on Biomedical Informatics (GRIB) > Department of Experimental and Health Sciences > Universitat Pompeu Fabra > IMIM (Hospital del Mar Medical Research Institute) > C/Dr. Aiguader 88, 08003 > Barcelona, Spain > Tel.: +34 93 316 0536 (1536) > E-mail: nquer...@imim.es <mailto:nquer...@imim.es> > Skype IM: nuriaqr76 > http://ibi.imim.es/ <http://ibi.imim.es/> > ******************************************************************** > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
