[Virtuoso-users] RDFGE error in version 07.20.3214

2015-09-09 Thread Nicola Vitucci
Hi all,

I tried to load a recent Wikidata dump [1] on Virtuoso v. 07.20.3214
(64-bit Linux OS), but I get the following error:

*** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: RDF box with a
geometry RDF type and a non-geometry content

Is GeoSPARQL not fully supported yet? If not, is there any temporary
workaround?

Thanks,

Nicola

[1]
https://dumps.wikimedia.org/wikidatawiki/entities/20150907/wikidata-20150907-all-BETA.ttl.gz

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] RDFGE error in version 07.20.3214

2015-09-09 Thread Hugh Williams
Hi Nicola,

Yes, Virtuoso open source does have geo spatial support including support for 
GeoSPARQL and OGC types . How are you loading this new wikidata “beta” dataset 
and do you know on which dataset or triple this error is occurring ?

We have loaded previous wikidata datasets which I would expect contained geo 
spatial data , so will have to download and try this new beta to see if problem 
can be reproduced locally …

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 Sep 2015, at 11:48, Nicola Vitucci  wrote:
> 
> Hi all,
> 
> I tried to load a recent Wikidata dump [1] on Virtuoso v. 07.20.3214
> (64-bit Linux OS), but I get the following error:
> 
> *** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: RDF box with a
> geometry RDF type and a non-geometry content
> 
> Is GeoSPARQL not fully supported yet? If not, is there any temporary
> workaround?
> 
> Thanks,
> 
> Nicola
> 
> [1]
> https://dumps.wikimedia.org/wikidatawiki/entities/20150907/wikidata-20150907-all-BETA.ttl.gz
> 
> --
> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> Get real-time metrics from all of your servers, apps and tools
> in one place.
> SourceForge users - Click here to start your Free Trial of Datadog now!
> http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
> ___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] RDFGE error in version 07.20.3214

2015-09-09 Thread Nicola Vitucci
Hi Hugh,

I tried to load it with the standard command:

ttlp_mt (file_to_string_output ('/path/to/file'), '', 'graphname')

The dataset is a single big Turtle file (not separate files as it used
to be), so right now I can't pinpoint the exact part which caused it to
fail. I'll try and investigate further as well.

Nicola

Il 09/09/2015 13:58, Hugh Williams ha scritto:
> Hi Nicola,
> 
> Yes, Virtuoso open source does have geo spatial support including
> support for GeoSPARQL and OGC types . How are you loading this new
> wikidata “beta” dataset and do you know on which dataset or triple this
> error is occurring ?
> 
> We have loaded previous wikidata datasets which I would expect contained
> geo spatial data , so will have to download and try this new beta to see
> if problem can be reproduced locally …
> 
> 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 Sep 2015, at 11:48, Nicola Vitucci > > wrote:
>>
>> Hi all,
>>
>> I tried to load a recent Wikidata dump [1] on Virtuoso v. 07.20.3214
>> (64-bit Linux OS), but I get the following error:
>>
>> *** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: RDF box with a
>> geometry RDF type and a non-geometry content
>>
>> Is GeoSPARQL not fully supported yet? If not, is there any temporary
>> workaround?
>>
>> Thanks,
>>
>> Nicola
>>
>> [1]
>> https://dumps.wikimedia.org/wikidatawiki/entities/20150907/wikidata-20150907-all-BETA.ttl.gz
>>
>> --
>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>> Get real-time metrics from all of your servers, apps and tools
>> in one place.
>> SourceForge users - Click here to start your Free Trial of Datadog now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
>> ___
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> 

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] RDFGE error in version 07.20.3214

2015-09-09 Thread Hugh Williams
Hi Nicola,

Ok, I am downloading the 7+GB file atm and will attempt a load …

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 Sep 2015, at 13:10, Nicola Vitucci  wrote:
> 
> Hi Hugh,
> 
> I tried to load it with the standard command:
> 
> ttlp_mt (file_to_string_output ('/path/to/file'), '', 'graphname')
> 
> The dataset is a single big Turtle file (not separate files as it used
> to be), so right now I can't pinpoint the exact part which caused it to
> fail. I'll try and investigate further as well.
> 
> Nicola
> 
> Il 09/09/2015 13:58, Hugh Williams ha scritto:
>> Hi Nicola,
>> 
>> Yes, Virtuoso open source does have geo spatial support including
>> support for GeoSPARQL and OGC types . How are you loading this new
>> wikidata “beta” dataset and do you know on which dataset or triple this
>> error is occurring ?
>> 
>> We have loaded previous wikidata datasets which I would expect contained
>> geo spatial data , so will have to download and try this new beta to see
>> if problem can be reproduced locally …
>> 
>> 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 Sep 2015, at 11:48, Nicola Vitucci >> >> wrote:
>>> 
>>> Hi all,
>>> 
>>> I tried to load a recent Wikidata dump [1] on Virtuoso v. 07.20.3214
>>> (64-bit Linux OS), but I get the following error:
>>> 
>>> *** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: RDF box with a
>>> geometry RDF type and a non-geometry content
>>> 
>>> Is GeoSPARQL not fully supported yet? If not, is there any temporary
>>> workaround?
>>> 
>>> Thanks,
>>> 
>>> Nicola
>>> 
>>> [1]
>>> https://dumps.wikimedia.org/wikidatawiki/entities/20150907/wikidata-20150907-all-BETA.ttl.gz
>>>  
>>> 
>>> 
>>> --
>>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>>> Get real-time metrics from all of your servers, apps and tools
>>> in one place.
>>> SourceForge users - Click here to start your Free Trial of Datadog now!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
>>> ___
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] XPath normalize-space function support

2015-09-09 Thread Lorena Etcheverry

thanks Hugh for your prompt reply

this query results in an error SP031: SPARQL compiler: Function name 
"bif:normalize-space" contains invalid characters; this may be an 
attempt of bypassing security restrictions


prefix rdfh: 
SELECT bif:normalize-space(?s_city)
FROM 
WHERE{
?supplier a rdfh:supplier.
?supplier rdfh:s_city ?s_city.
}


and this one also gives an error

prefix rdfh: 

SELECT bif:contains(?s_city, '4')
FROM 
WHERE{
?supplier a rdfh:supplier.
?supplier rdfh:s_city ?s_city.
}


Virtuoso 22023 Error SR468: contains() can not be called as plain built-in 
function, it's a macro handled by SQL compiler



Maybe the bif: prefix is badly defined?

regards
lorena



On 09/09/15 00:33, Hugh Williams wrote:

Hi Lorena,

What is the actual query you are executing using  the “bif:” prefix 
 that is resulting in the "SP031: SPARQL compiler: Function name 
"bif:normalize-space" contains invalid characters; this may be an 
attempt of bypassing security restrictions” error ?


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 8 Sep 2015, at 21:50, Lorena Etcheverry > wrote:


Hi

I'd like to use this  function
http://www.w3.org/TR/xpath-functions/#func-normalize-space in a SPARQL
query in Virtuoso 7.
Is it available?
If I declare the prefix fn  as
prefix fn: 
and then use the function as

fn:normalize-space(str(?s))

I retrieve the following error

Virtuoso 42001 Error SR185: Undefined procedure 
DB.DBA.http://www.w3.org/2005/xpath-functionsnormalize-space.



I've also found a function with the same name and behavior in Virtuoso
documentation
(http://docs.openlinksw.com/virtuoso/xpf_normalize_space.html).
Is it possible to use this function in a SPARQL query?
I've tried to use it with the prefix bif, but I also get an error

Virtuoso 37000 Error SP031: SPARQL compiler: Function name 
"bif:normalize-space" contains invalid characters; this may be an 
attempt of bypassing security restrictions


best regards,

Lorena





--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net 


https://lists.sourceforge.net/lists/listinfo/virtuoso-users




--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Re: [Virtuoso-users] RDFGE error in version 07.20.3214

2015-09-09 Thread Hugh Williams
Hi Nicola,

I have been able to recreate this issue loading the wikidata beta dataset and 
have reported to development to look into …

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 Sep 2015, at 13:44, Hugh Williams  wrote:
> 
> Hi Nicola,
> 
> Ok, I am downloading the 7+GB file atm and will attempt a load …
> 
> 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 Sep 2015, at 13:10, Nicola Vitucci > > wrote:
>> 
>> Hi Hugh,
>> 
>> I tried to load it with the standard command:
>> 
>> ttlp_mt (file_to_string_output ('/path/to/file'), '', 'graphname')
>> 
>> The dataset is a single big Turtle file (not separate files as it used
>> to be), so right now I can't pinpoint the exact part which caused it to
>> fail. I'll try and investigate further as well.
>> 
>> Nicola
>> 
>> Il 09/09/2015 13:58, Hugh Williams ha scritto:
>>> Hi Nicola,
>>> 
>>> Yes, Virtuoso open source does have geo spatial support including
>>> support for GeoSPARQL and OGC types . How are you loading this new
>>> wikidata “beta” dataset and do you know on which dataset or triple this
>>> error is occurring ?
>>> 
>>> We have loaded previous wikidata datasets which I would expect contained
>>> geo spatial data , so will have to download and try this new beta to see
>>> if problem can be reproduced locally …
>>> 
>>> 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 Sep 2015, at 11:48, Nicola Vitucci 
 >> wrote:
 
 Hi all,
 
 I tried to load a recent Wikidata dump [1] on Virtuoso v. 07.20.3214
 (64-bit Linux OS), but I get the following error:
 
 *** Error 42000: [Virtuoso Driver][Virtuoso Server]RDFGE: RDF box with a
 geometry RDF type and a non-geometry content
 
 Is GeoSPARQL not fully supported yet? If not, is there any temporary
 workaround?
 
 Thanks,
 
 Nicola
 
 [1]
 https://dumps.wikimedia.org/wikidatawiki/entities/20150907/wikidata-20150907-all-BETA.ttl.gz
  
 
 
 --
 Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
 Get real-time metrics from all of your servers, apps and tools
 in one place.
 SourceForge users - Click here to start your Free Trial of Datadog now!
 http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140 
 
 ___
 Virtuoso-users mailing list
 Virtuoso-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> 
> --
> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> Get real-time metrics from all of your servers, apps and tools
> in one place.
> SourceForge users - Click here to start 

[Virtuoso-users] saving results to a file

2015-09-09 Thread Davis, Daniel (NIH/NLM) [C]
When I run the statement below in an ISQL command prompt, I get as a result a 
BLOB of 225899 chars.

SPARQL define output:format "NT" CONSTRUCT { ?s ?p ?o } FROM 
 WHERE { ?s ?p ?o };

I'm not quite sure how to use string_to_file() with a query like this...

Dan Davis, Systems/Applications Architect (Contractor),
Office of Computer and Communications Systems,
National Library of Medicine, NIH

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users