No table rdf_obj error

[Raihan Ul Islam]

I am trying the example query from http://linkedgeodata.org/OSM. using http://linkedgeodata.org/sparql

As for example 

Prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
Prefix ogc: <http://www.opengis.net/ont/geosparql#>
Prefix geom: <http://geovocab.org/geometry#>
Prefix lgdo: <http://linkedgeodata.org/ontology/>

Select ?school ?schoolLabel ?coffeeShop ?coffeeShopLabel
From <http://linkedgeodata.org> {
  ?school
    a lgdo:School ;
    rdfs:label ?schoolLabel ;
    geom:geometry [
      ogc:asWKT ?schoolGeo
    ] .
    
  ?coffeeShop
    a lgdo:CoffeeShop ;
    rdfs:label ?coffeeShopLabel ;
    geom:geometry [
      ogc:asWKT ?coffeeShopGeo
    ] .

  Filter (
    bif:st_intersects (?schoolGeo, bif:st_point (4.892222, 52.373056), 5) &&
    bif:st_intersects (?coffeeShopGeo, ?schoolGeo, 1)
  ) .
}

In response i am getting "Virtuoso S0002 Error SQ200: No table rdf_obj"

Can anybody tell me what is the error ?

THanks in advance for the help

Best Regards

Raihan

[Hugh Williams]

Hi Raihan,

We have seen occurrences of this error running Geo spatial queries in the past, which was fixed last year, thus what is the build date of the Virtuoso 7.1 instance running on the linkedgeodata.org/sparql  site ? As we have the Linked Geo Data datasets loaded into our LOD Cloud Cache server (http://lod.openlinksw.com) which is running the recently released Virtuoso 7.2 version and your query does run successfully against it, see:

http://bit.ly/1vF19L5

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

--
You received this message because you are subscribed to the Google Groups "Linked Geo Data" group.
To unsubscribe from this group and stop receiving emails from it, send an email to linked-geo-da...@googlegroups.com.
To post to this group, send email to linked-...@googlegroups.com.
Visit this group at http://groups.google.com/group/linked-geo-data.
For more options, visit https://groups.google.com/d/optout.

[Claus Stadler]

Hi Hugh,

Since I first encountered this error some months ago, I have in the meantime tried out at least 5 increasingly newer versions of VOS so far - including 7.2.0_p1 from source forge and the latest is develop/7 from today (2015 March 31) - and i get "no table rdf_obj" with all of them on many queries (mostly generated by Facete2)
On the LOD cache it seems it was indeed fixed,

So please make the fix available in the open source version as well :)

For example, this query fails on http://linkedgeodata.org/sparql (its not running the version I compiled today; but as I said, it doesn't make a difference)

Select Distinct ?s {?cc_s <http://geovocab.org/geometry#geometry> ?s . ?cc_s <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> ?fv_1 . ?s <http://www.opengis.net/ont/geosparql#asWKT> ?w . Filter(<bif:st_intersects>(?w, <bif:st_geomFromText>("POLYGON((0 45,90 45,90 90,0 90,0 45))"))) .}

As mentioned below, some queries from http://linkedgeodata.org/OSM still fail and I know that at some point in the past (before upgrading to develop/7) they actually all worked.

Thanks and Cheers,
Claus

-- 
Dipl. Inf. Claus Stadler
Department of Computer Science, University of Leipzig
Research Group: http://aksw.org/
Workpage & WebID: http://aksw.org/ClausStadler
Phone: +49 341 97-32260

[Claus Stadler]

Hi again,

It seems I was fooled by a chaching issue, and 7.2.0_p1 works, but the lastest develop7 does not - anyawy I will investigate this closer and report back...

Cheers,
Claus