Hi Jerven,

Thanks for the update, glad to hear you found the cause of the problem …

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 9 Feb 2017, at 13:35, Jerven Tjalling Bolleman <Jerven.Bolleman@sib.swiss> 
> wrote:
> 
> 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 <http://plus.google.com/>". DO _NOT_ TRUST THIS WEBSITE:
>> http://plus.google.com/100570109519069333827/ 
>> <http://plus.google.com/100570109519069333827/> [2]
>> Facebook -- http://www.facebook.com/OpenLinkSoftware 
>> <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 <mailto: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 
>>> <http://sparql.uniprot.org/uniprot>>{?subject a
>>> <http://purl.uniprot.org/core/MRNA <http://purl.uniprot.org/core/MRNA>> . 
>>> ?target a
>>> <http://biohackathon.org/resource/faldo#ExactPosition 
>>> <http://biohackathon.org/resource/faldo#ExactPosition>> . ?subject
>>> <http://purl.uniprot.org/core/author <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 <mailto:Jerven.Bolleman@sib.swiss> - 
>>> http://www.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://slashdot.org/> [1]! 
>>> http://sdm.link/slashdot <http://sdm.link/slashdot>
>>> _______________________________________________
>>> 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>
>> Links:
>> ------
>> [1] http://slashdot.org <http://slashdot.org/>
>> [2] http://plus.google.com/100570109519069333827/ 
>> <http://plus.google.com/100570109519069333827/>
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org <http://slashdot.org/>! 
>> http://sdm.link/slashdot <http://sdm.link/slashdot>
>> _______________________________________________
>> 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>
> 
> -- 
> 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 <mailto:Jerven.Bolleman@sib.swiss> - 
> http://www.sib.swiss <http://www.sib.swiss/>

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

Reply via email to