Hi Hugh,

The source of the error was a truncated database file on my developer 
desktop due to disk quota and a problem between my office chair and my 
desk ;)

Regards,
Jerven

On 2017-02-06 20:58, Hugh Williams wrote:
> 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
> 
> 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+  -- MAILSCANNER HAS DETECTED DEFINITE FRAUD IN THE WEBSITE AT
> "PLUS.GOOGLE.COM". DO _NOT_ TRUST THIS WEBSITE:
> http://plus.google.com/100570109519069333827/ [2]
> 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 [1]! http://sdm.link/slashdot
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> 
> 
> 
> Links:
> ------
> [1] http://slashdot.org
> [2] http://plus.google.com/100570109519069333827/
> ------------------------------------------------------------------------------
> 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

-- 
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

Reply via email to