Re: [Virtuoso-users] {Disarmed} Re: SQ156: Internal Optimized compiler error : sqlo table has no index in

2017-02-09 Thread Hugh Williams 
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  
> 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 ". 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
>>> 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
>>> >> >{?subject a
>>> > . 
>>> ?target a
>>> >> > . ?subject
>>> > 
>>> ?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 


smime.p7s
Description: S/MIME cryptographic signature
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Sl

Re: [Virtuoso-users] {Disarmed} Re: SQ156: Internal Optimized compiler error : sqlo table has no index in

2017-02-09 Thread Jerven Tjalling Bolleman 
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
>>  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
>> {?subject a
>>  . ?target a
>>  . ?subject
>>  ?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