Hi Tracy, If you are having the problem with a Virtuoso commercial release then best log and online support case with us at:
http://support.openlinksw.com/support/online-support.vsp
<http://support.openlinksw.com/support/online-support.vsp>
detailing the issue and what version (virtuoso-iodbc-t -?) is being used etc.
The open source version (virtuoso-t -?) would also be useful to see for
comparison ...
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 12 Oct 2016, at 17:24, Safran, Tracy (NIH/NCI) [C] <safr...@mail.nih.gov>
> wrote:
>
> More information: If I query the open-source version of Virtuoso, loaded
> with the same set of graphs, it returns results. I suspect there is
> something in the configuration or security of the commercial that is not
> letting this return. I am not really sure where to look to debug this.
>
> Tracy M. Safran
> Programmer Analyst - EVS support
> Frederick National Laboratory for Cancer Research
> Leidos Biomedical Research, Inc.
> Ph: 240-276-5172
> tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov>
>
>
> From: "Safran , Tracy (NIH/NCI) [C]" <safr...@mail.nih.gov
> <mailto:safr...@mail.nih.gov>>
> Date: Tuesday, October 11, 2016 at 8:59 PM
> To: Kingsley Idehen <kide...@openlinksw.com <mailto:kide...@openlinksw.com>>,
> "virtuoso-users@lists.sourceforge.net
> <mailto:virtuoso-users@lists.sourceforge.net>"
> <virtuoso-users@lists.sourceforge.net
> <mailto:virtuoso-users@lists.sourceforge.net>>
> Subject: Re: [Virtuoso-users] Problem with advanced queries
>
> I am not getting any error, just an empty class list. (<class 'list'>: [] )
> The same dataset is loaded into Stardog, for the sake of comparison, and the
> exact same query returns results.
>
>
> Tracy M. Safran
> Programmer Analyst - EVS support
> Frederick National Laboratory for Cancer Research
> Leidos Biomedical Research, Inc.
> Ph: 240-276-5172
> tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov>
>
>
> From: Kingsley Idehen <kide...@openlinksw.com <mailto:kide...@openlinksw.com>>
> Date: Tuesday, October 11, 2016 at 6:17 PM
> To: "virtuoso-users@lists.sourceforge.net
> <mailto:virtuoso-users@lists.sourceforge.net>"
> <virtuoso-users@lists.sourceforge.net
> <mailto:virtuoso-users@lists.sourceforge.net>>
> Subject: Re: [Virtuoso-users] Problem with advanced queries
>
> On 10/11/16 4:37 PM, Safran, Tracy (NIH/NCI) [C] wrote:
>> I am having problems doing some slightly advanced queries against http. A
>> simple query works but other queries don’t. Is there a deeper issue with
>> permissions or indexes that I need to look into?
>>
>> Example: This works.
>>
>> SELECT *
>> FROM <http://NCIT_NG1> <http://ncit_ng1/> where { ?s ?p ?o } LIMIT 50
>>
>> But this does not (note: prefix left out for brevity)
>> SELECT ?subject ?role ?object
>> WHERE {
>> ?subject rdfs:subClassOf ?an .
>> ?an owl:onProperty ?role .
>> ?an owl:someValuesFrom ?object .
>> ?subject rdfs:subClassOf* ncit:Gene
>> }
>> ORDER BY asc(?subject)
>>
>> Tracy M. Safran
>> Programmer Analyst - EVS support
>> Frederick National Laboratory for Cancer Research
>> Leidos Biomedical Research, Inc.
>> Ph: 240-276-5172
>> tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov>
> I assume you are getting:
>
> Virtuoso 37000 Error TR...: transitive start not given ?
>
> You need to add some qualification to the query to optimize for unknowns such
> as db size and available memory.
>
> Examples:
>
> 1.
> http://dbpedia.org/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
>
> <http://dbpedia.org/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on>
> -- DBpedia Static
>
> 2.
> http://dbpedia-live.openlinksw.com/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
>
> <http://dbpedia-live.openlinksw.com/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on>
> -- DBpedia Live
>
> 3.
> http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27umbel%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on
>
> <http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0A++++WHERE+%7B%0D%0A%0D%0A%0D%0A++++++++%3Fsubject+a+owl%3AClass+.%0D%0A++++++++%3Fobject+a+owl%3AClass+.%0D%0A++++++++%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0A++++++++filter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27umbel%27%29%29%0D%0A++++++++%7D%0D%0A%0D%0A++++ORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100&format=text%2Fx-html%2Btr&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000&debug=on>
> -- massive 30 Billion+ LOD Cloud Cache
> --
> Regards,
>
> Kingsley Idehen
> Founder & CEO
> OpenLink Software (Home Page: http://www.openlinksw.com
> <http://www.openlinksw.com/>)
>
> Weblogs (Blogs):
> Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
> <http://www.openlinksw.com/blog/~kidehen/>
> Blogspot Blog: http://kidehen.blogspot.com <http://kidehen.blogspot.com/>
> Medium Blog: https://medium.com/@kidehen <https://medium.com/@kidehen>
>
> Profile Pages:
> Pinterest: https://www.pinterest.com/kidehen/
> <https://www.pinterest.com/kidehen/>
> Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
> <https://www.quora.com/profile/Kingsley-Uyi-Idehen>
> Twitter: https://twitter.com/kidehen <https://twitter.com/kidehen>
> Google+: https://plus.google.com/+KingsleyIdehen/about
> <https://plus.google.com/+KingsleyIdehen/about>
> LinkedIn: http://www.linkedin.com/in/kidehen
> <http://www.linkedin.com/in/kidehen>
>
> Web Identities (WebID):
> Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
> <http://kingsley.idehen.net/dataspace/person/kidehen#this>
> :
> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
> <http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this>
>
> ------------------------------------------------------------------------------
> 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>
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
