Hi Hugh,
On 08/28/2015 06:46 PM, Hugh Williams wrote:
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 ?
I increased from 9x10**3 to 9x10**6
I got directly the virtuoso error message executing the query from our
endpoint but specifying the virtuoso port in the browser, in order to
avoid the apache server. then the message error from virtuoso was that
the estimation execution time was too short. the error message
"ERR_CONTENT_DECODING_FAILED" come from apache i guess, as it does not
know how to serve the error message from virtuoso?
Also, when you ran the query from isql how long does it take to
execute and return results ?
144552 msec
best,
n
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
<mailto: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://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
<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/
********************************************************************
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
