Re: [Virtuoso-users] Virtuoso 7 query intermittently failing to return results

2014-02-20 Thread Quentin
Hi Hugh, I hadn't, I'd forgotten the name of the audit functions. I ran the backup->null test described under database recovery and that gave no indication of a problem. Running the audit now as below, it returned '0' and rerunning the query still failed to return triples with the SPO pattern i

Re: [Virtuoso-users] Inline sparql in pl-sql

2014-02-20 Thread Hugh Williams
Hi Quentin, Testing against the stable/7 branch release this week as part of the Virtuoso 7.1 open source release I do not encounter the crash you report: Driver: 07.10.3207 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit.

Re: [Virtuoso-users] Virtuoso 7 query intermittently failing to return results

2014-02-20 Thread Hugh Williams
Hi Quentin, Have you tried running the DB.DBA.RDF_AUDIT_METADATA() function which can check for and repair RDF metadata corruption, as detailed at: http://docs.openlinksw.com/virtuoso/fn_rdf_audit_metadata.html Best Regards Hugh Williams Professional Services OpenLink Software, Inc.

Re: [Virtuoso-users] Function db.dba.ttlp does not save XML datatype

2014-02-20 Thread Hugh Williams
Hi Enrico, The fix will typically make its way to the git develop/7 branch when available. You can track updates to this branch with the following atom RSS feed: https://github.com/openlink/virtuoso-opensource/commits/develop%2F7.atom Best Regards Hugh Williams Professional Services Ope

Re: [Virtuoso-users] Function db.dba.ttlp does not save XML datatype

2014-02-20 Thread Enrico Daga
Hi Rumi, thank you for your feedback. (I guess you did not refer to the 7.1 release, right? I tested it in any case but our problems are still there...) Looking forward a notice about the XML issue then. Thank you! Enrico On 19 February 2014 12:02, Rumi wrote: > Hi Enrico, > > On 18-Feb-14

Re: [Virtuoso-users] LOD Cloud Cache

2014-02-20 Thread Timothy Lebo
Kingsley, Thanks for the background on how things are added manually when they hit your radar, for verifying that the default graph is the union, and for the pointer to adding inference. I’ll go have fun playing with the cache now :-) Regards, Tim On Feb 20, 2014, at 3:02 PM, Kingsley Idehen

Re: [Virtuoso-users] LOD Cloud Cache

2014-02-20 Thread Kingsley Idehen
On 2/20/14 2:44 PM, Timothy Lebo wrote: Virtuoso, I’m using the LOD Cloud Cache [1] as a sample of the LOD Cloud, and wanted to make sure that I was using it to its full potential. Thanks for such a useful resource. Could you comment on the following? A) What portion of Linked Data is in the

[Virtuoso-users] LOD Cloud Cache

2014-02-20 Thread Timothy Lebo
Virtuoso, I’m using the LOD Cloud Cache [1] as a sample of the LOD Cloud, and wanted to make sure that I was using it to its full potential. Thanks for such a useful resource. Could you comment on the following? A) What portion of Linked Data is in the cache? i.e., what methodology is used to l

Re: [Virtuoso-users] 7.1 /sparql unavailable (compression, character encoding problems)

2014-02-20 Thread Hugh Williams
Hi Tim, I have checked with chrome, safari, firefox & opera and all load and allow me to execute queries via the http://localhost:8890/sparql endpoint. Is anything reported in your "virtuoso.log" when encountering these errors using the various browsers ? It might also be useful to enabling ad

[Virtuoso-users] 7.1 /sparql unavailable (compression, character encoding problems)

2014-02-20 Thread Timothy Lebo
Virtuoso, I was curious if anybody has reported the following behavior with 7.1, which does not appear for me with 6.0 and 6.1 (I don’t have any 7.0 instances). Requesting curl -L /sparql returns HTML (a Good Thing). The Bad: When loading /sparql in Chrome, it reports "This webpage is not a

[Virtuoso-users] Exception thrown when deleting existing user

2014-02-20 Thread Quentin
Two interesting but ultimately trivial errors. The documentation merely has USER_CREATE() but this will error if the schema context is not DB.DBA. A trivial enough issue. create procedure test.test.testUserDrop ( ) { DB.DBA.USER_CREATE('testUser','badpassword'); }; test.test.testUserDrop(); use

[Virtuoso-users] splt_and_decode

2014-02-20 Thread Quentin
I'm not sure whether this is an error but percent-decoding isn't getting + encoded spaces. create procedure test.test.testUrlDecode ( ) returns VARCHAR { declare test VARCHAR; test :='test+test+test'; return split_and_decode(test,0,'%'); } Query result:testUrlDecode VARCHAR test+test+test The

[Virtuoso-users] Inline sparql in pl-sql

2014-02-20 Thread Quentin
Hi, This is an interesting problem that was confusing me for a while. The below function attempts to write four triples to one graph. Only two of them are written to the target graph, the other two end up in a strange place. No exception is thrown and the debug log is gives no indication that a