Hi Jerven, Does the same error occur when the query is run against the /sparql endpoint or isql ie not via the JDBC Driver ?
Also, are you able to get the query “profile” or “sparql_to_sql_text” for the
query as detailed at:
https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
<https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery>
What version of Virtuoso is being used, is it a latest 07.20.3217 build ?
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 6 Feb 2017, at 16:08, Jerven Tjalling Bolleman <jerven.bolleman@sib.swiss>
> wrote:
>
> Dear Virtuoso users,
>
> I am getting an new error from virtuoso, during development of a new
> feature
>
>
> SPARQL execute failed:[SELECT (COUNT(?target) AS ?targets) { GRAPH
> <http://sparql.uniprot.org/uniprot>{?subject a
> <http://purl.uniprot.org/core/MRNA> . ?target a
> <http://biohackathon.org/resource/faldo#ExactPosition> . ?subject
> <http://purl.uniprot.org/core/author> ?target .}}]
>
> Exception:virtuoso.jdbc4.VirtuosoException: SQ156: Internal Optimized
> compiler error : sqlo table has no index in sqldf.c:3777.
> Please report the statement compiled.
>
>
> Regards,
> Jerven
>
> --
> Jerven Tjalling Bolleman
> SIB | Swiss Institute of Bioinformatics
> CMU - 1, rue Michel Servet - 1211 Geneva 4
> t: +41 22 379 58 85 - f: +41 22 379 58 58
> Jerven.Bolleman@sib.swiss - http://www.sib.swiss
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
