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://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/
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 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
Skype IM: nuriaqr76
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


--
********************************************************************
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
Skype IM: nuriaqr76
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
Skype IM: nuriaqr76
http://ibi.imim.es/
********************************************************************

------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to