On 10/12/16 12:24 PM, Safran, Tracy (NIH/NCI) [C] 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> >
If you are using the security features of the commercial edition then this boils down to you target named graph potentially being set to private. So yes, this is security configuration related, as long as target named-graph rather than structure of query is source of the query solution anomaly. Simple cleanup sequence: -- Remove <http://NCIT_NG1> from Private Named Graphs Group, should it be currently set to Private DB.DBA.RDF_GRAPH_GROUP_DEL ('http://www.openlinksw.com/schemas/virtrdf#PrivateGraphs','http://NCIT_NG1') ; -- Clearout perms set for 'nobody' DB.DBA.RDF_ALL_USER_PERMS_DEL ('nobody') ; -- Read privileges for 'nobody' on 'world' (public) named graphs DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 1, 0); -- Graph Security Rules Sanity Check RDF_GRAPH_SECURITY_AUDIT ( 0 ) ; [1] http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFGraphsSecurity Kingsley > > > > > > *From: *"Safran , Tracy (NIH/NCI) [C]" <safr...@mail.nih.gov> > *Date: *Tuesday, October 11, 2016 at 8:59 PM > *To: *Kingsley Idehen <kide...@openlinksw.com>, > "virtuoso-users@lists.sourceforge.net" > <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> > *Date: *Tuesday, October 11, 2016 at 6:17 PM > *To: *"virtuoso-users@lists.sourceforge.net" > <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 > -- 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 > -- 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 > -- massive 30 Billion+ LOD Cloud Cache > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software (Home Page: http://www.openlinksw.com) > > Weblogs (Blogs): > Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ > <http://www.openlinksw.com/blog/%7Ekidehen/> > Blogspot Blog: http://kidehen.blogspot.com > Medium Blog: https://medium.com/@kidehen > > Profile Pages: > Pinterest: https://www.pinterest.com/kidehen/ > Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen > Twitter: https://twitter.com/kidehen > Google+: https://plus.google.com/+KingsleyIdehen/about > LinkedIn: http://www.linkedin.com/in/kidehen > > Web Identities (WebID): > Personal: http://kingsley.idehen.net/dataspace/person/kidehen#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://sdm.link/slashdot > > > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Regards, Kingsley Idehen Founder & CEO OpenLink Software (Home Page: http://www.openlinksw.com) Weblogs (Blogs): Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ Blogspot Blog: http://kidehen.blogspot.com Medium Blog: https://medium.com/@kidehen Profile Pages: Pinterest: https://www.pinterest.com/kidehen/ Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen Twitter: https://twitter.com/kidehen Google+: https://plus.google.com/+KingsleyIdehen/about LinkedIn: http://www.linkedin.com/in/kidehen Web Identities (WebID): Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
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