Re: [Virtuoso-users] Transaction error in lod cache endpoint

Hugh Williams Sat, 20 Aug 2016 12:47:51 -0700

Hi Ghislain,

I get the same error when run against LOD, but different error when run against LGD:

Virtuoso 22023 Error GEO..: Function st_distance() expects a geometry of type 1 as argument 0, not geometry of type 2


SPARQL query:

#output-format:text/html
define sql:signal-void-variables 1 define input:default-graph-uri <http://linkedgeodata.org> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX dbpo: <http://dbpedia.org/ontology/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX lgdo: <http://linkedgeodata.org/ontology/>
PREFIX geom: <http://geovocab.org/geometry#>
PREFIX ogc: <http://www.opengis.net/ont/geosparql#>

SELECT DISTINCT ?v ?label ?pgv
WHERE {?v geom:geometry/ogc:asWKT ?pgv ; rdfs:label ?label. 
FILTER (bif:st_distance(?pgv, bif:st_point(2.92528, 47.38241)) < 2)
} 
 limit 100

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 18 Aug 2016, at 08:31, Ghislain ATEMEZING <ghislain.atemez...@gmail.com> wrote:

Hi Hugh,
Thanks for looking into it...
Yes, that particular query works fine in Linkedgeodata endpoint.
However, if you change the point to be (2.92528, 47.38241) you get the same issue. See query here [2]

Ghislain
[2] https://gist.github.com/gatemezing/633755c913287f5431f476046a902240

El mié., 17 ago. 2016 a las 19:29, Hugh Williams (<hwilli...@openlinksw.com>) escribió:
HI Ghislain,

I get the same error, we are looking into it …

Note the query does run against http://linkedgeodata.org/sparql

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 17 Aug 2016, at 08:44, Ghislain ATEMEZING <ghislain.atemez...@gmail.com> wrote:

Hi,

I've just tried this query [1] in the LOD cache http://lod.openlinksw.com/sparql .
Unfortunately I get this error: "Virtuoso 4000X Error SR176: Transaction rolled back due to previous SQL error"
What I am missing?

TIA
Ghislain

[1] https://gist.github.com/gatemezing/28ed5e8d01f65f32a818c433817412cd
--
-------
"Love all, trust a few, do wrong to none" (W. Shakespeare)
Web: http://atemezing.org
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

--
-------
"Love all, trust a few, do wrong to none" (W. Shakespeare)
Web: http://atemezing.org

------------------------------------------------------------------------------

_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Transaction error in lod cache endpoint

Reply via email to