Re: [Virtuoso-users] isparql receives wrong response format

2014-05-09 Thread Hugh Williams
.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.w3.org/2001/sw/DataAccess/rf1/result2.xsd";> and I can't see how the request types can be changed in isparql, so will have to check with development to see if/how this can be done and why the change was made ... Best Regards Hu

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Hugh Williams
as all the fixes since the stable/7 release, as detailed at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw

Re: [Virtuoso-users] GRAPHS

2014-05-08 Thread Hugh Williams
d and does this occur if you start with an empty database ? 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

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Hugh Williams
ents between 7.0 and 7.1 query plan may or may not have changed, but can't say for sure ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.link

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

2014-05-08 Thread Hugh Williams
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

Re: [Virtuoso-users] Heartbleed bug and Virtuoso

2014-05-07 Thread Hugh Williams
Hi Kim, What is the version of Virtuoso being used used (virtuoso-t -?) and version of Linux being used ? Are you building using the Virtuoso open source develop/7 branch as detailed at; http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage Best Regards Hugh Williams

Re: [Virtuoso-users] isparql receives wrong response format

2014-05-07 Thread Hugh Williams
Hi Sebastian, What is the version of the iSPARQL VAD you have installed, as with version 1.29.28 the default query expands to the following for me ? query= select distinct ?Concept where {[] a ?Concept} LIMIT 100 format=application/rdf+xml Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] Virtuoso over a VM - question

2014-05-06 Thread Hugh Williams
ration, or is this an intermittent occurrence ? 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://t

Re: [Virtuoso-users] PROBLEM WITH HTTP_CLIENT

2014-05-05 Thread Hugh Williams
/databaseadmsrv.html#ptunemetricdiagsqlissues which may provide more information in the client side and possibly in the Virtuoso Server log as to why this http_client error is occurring. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.c

Re: [Virtuoso-users] seeing what parameters are in effect

2014-05-01 Thread Hugh Williams
, "UseAIO", &c_c_use_aio) == -1) c_c_use_aio = 0; if (cfg_getlong (pconfig, section, "AsyncQueueMaxThreads", &c_aq_max_threads) == -1) c_aq_max_threads = 10; Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http:

Re: [Virtuoso-users] R2RML PROBLEM

2014-04-30 Thread Hugh Williams
____ 0 Rows. -- 0 msec. SQL> 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/ Twit

Re: [Virtuoso-users] Incorrect query results with property paths and variable graphs (VOS 7.10.3207 Windows)

2014-04-30 Thread Hugh Williams
Hi Dominic, I see similar results testing against the latest develop/7 branch, 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

Re: [Virtuoso-users] load into graph specified by nquads

2014-04-29 Thread Hugh Williams
Hi Mark, Have you actually tried it, as the 3rd param will simply be ignored it is an nquad file, just as it would if there are "..graph" or "global.graph" which would override the ld_dir() 3rd param setting, we load nquad all the time with the bulk loader ... Best R

Re: [Virtuoso-users] Export TABLE to CSV

2014-04-28 Thread Hugh Williams
} } } else return 'No records or some error'; } So you are welcome to try it and let us know if it works for you ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. //

Re: [Virtuoso-users] Problem with building VOS from Github

2014-04-28 Thread Hugh Williams
Hi Barry, Note this issue building on Ubuntu 14.04 has been fixed: https://github.com/openlink/virtuoso-opensource/issues/160 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-24 Thread Hugh Williams
know what they report ... 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

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-24 Thread Hugh Williams
same pg Compilation: 0 msec 0 reads 0% read 0 messages 0% clw 4 Rows. -- 1 msec. SQL> Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.lin

Re: [Virtuoso-users] Describe without default graph give partial result

2014-04-23 Thread Hugh Williams
Hi Nicola, The procedures can be found in ~/libsrc/Wi/sparql.sql of a Virtuoso open source archive ie https://github.com/openlink/virtuoso-opensource/blob/develop/7/libsrc/Wi/sparql.sql Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Implicit ordering

2014-04-23 Thread Hugh Williams
ORDER BY clause implies that the optimizer may do whatever with the order, including different order for different runs of same query on same data. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-23 Thread Hugh Williams
Hi Bart, You still have not provided the "profile" for each query. You can do this by running "SET PROFILE ON/OFF" as did for the explain plans ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.c

Re: [Virtuoso-users] MaxCheckpointRemap parameter

2014-04-23 Thread Hugh Williams
ch and the default of 2000 could probably suffice in most cases ... 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/ Twitte

Re: [Virtuoso-users] When is a bulk load done?

2014-04-23 Thread Hugh Williams
ng more than one rdf_loader_run() > running. > > On Mon, Apr 21, 2014 at 10:52 PM, Hugh Williams > wrote: >> Hi Paul, >> >> Using the Virtuoso RDF Bulk Loader (rdf_loader_run) as you appear to be, the >> load is complete when all files in the load_list tab

Re: [Virtuoso-users] Describe without default graph give partial result

2014-04-23 Thread Hugh Williams
Thus you should specify the graphs or mode to use otherwise the graphs "guessed" might can be different than expected ie not the same as the select query ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog

[Virtuoso-users] LOADing SQL dump from POD & Fwd: LOAD TO VIRTUOSO (SQL DUMP)

2014-04-23 Thread Hugh Williams
load from MySQL to Virtuoso, although replication is not part of Virtuoso open source as it is a commercial only feature ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] Describe without default graph give partial result

2014-04-23 Thread Hugh Williams
Hi Nicola, Are you able to provide a use case for recreation ie against one of our live endpoint like dbpedia.org/sparql or lod.openlinksw.com/sparql or datasets for local recreation ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] When is a bulk load done?

2014-04-21 Thread Hugh Williams
om/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideLDMeterUtility 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

Re: [Virtuoso-users] Problem with building VOS from Github

2014-04-20 Thread Hugh Williams
Hi Barry, This issue is scheduled to be looked into by developed, there is a git issue logged for it at: https://github.com/openlink/virtuoso-opensource/issues/160 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-18 Thread Hugh Williams
ill be analysed by development ... 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/Ope

Re: [Virtuoso-users] Tips to prevent hanging TTLP_MT?

2014-04-18 Thread Hugh Williams
>> Also, at the time the TTLP load appear to hang I presume you can still >> access the server in which case what does the "status();" command reports as >> to the status of the server at that point ? How much memory is on the >> system and how much does the &quo

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-18 Thread Hugh Williams
PARQLQuery http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#EfficientSQL Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/compan

Re: [Virtuoso-users] Tips to prevent hanging TTLP_MT?

2014-04-18 Thread Hugh Williams
h does the "top" command report as being used by Virtuoso ? 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-softwa

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-17 Thread Hugh Williams
Bart, On 17 Apr 2014, at 15:42, Bart Vandewoestyne wrote: > On 2014-04-17 15:04, Hugh Williams wrote: >> Hi Bart, >> >> I note your Virtuoso version is reported as "Version >> 07.00.3203-pthreads for Linux as of Mar 26 2014" which despite having >>

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-17 Thread Hugh Williams
it, thus I suggest you update your binary to the latest develop/7 archive, as the have been many many query optimisation improvements since then: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage Best Regards Hugh Williams Professional Services OpenLink Sof

Re: [Virtuoso-users] Virtuoso 7: can't open "Web Application Server" tab

2014-04-16 Thread Hugh Williams
Hi Olga, Sounds like you are running a rather old v6 build (virtuoso-t -?) , try running the following to add the missing column required in latest builds: alter table WS.WS.SYS_DAV_RES add RES_SIZE integer Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] speeding up SPARQL query

2014-04-16 Thread Hugh Williams
aces which should be removed and the server restarted: > 2 buffers, 19878 used, > IndexTreeMaps = 64 >NumberOfBuffers = 200 >MaxDirtyBuffers = 150 > > [HTTPServer] Best Regards Hugh Williams Profes

Re: [Virtuoso-users] Objects of data properties are broken for QUAD maps/SPAQRL views

2014-04-15 Thread Hugh Williams
Hi Alex, The table schema and some sample data to load would be required for recreation. Also, did you create the RDFView mappings by hand or using the conductor Linked Data View wizard ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] REST Web Services

2014-04-15 Thread Hugh Williams
Hi Ricardo, Have your reviewed the documentation below on publishing stored procedures as web services: http://docs.openlinksw.com/virtuoso/expwsmodules.html#expwsmodules Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Objects of data properties are broken for QUAD maps/SPAQRL views

2014-04-12 Thread Hugh Williams
Hi Alex, Are you able to provide a simple test case for recreation of this issue ? 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

Re: [Virtuoso-users] problems loading Virtuos on Google cloud

2014-04-09 Thread Hugh Williams
Andrejs, On 9 Apr 2014, at 12:17, Andrejs Abele wrote: > Hi Hugh, > 1. yes it was client side loader that crashes [Hugh] Why does the java client app crash if all it is really doing is activate the "rdf_loader_run()" function on the Virtuoso server ? > 2. we run only one loader, to keep our

Re: [Virtuoso-users] problems loading Virtuos on Google cloud

2014-04-08 Thread Hugh Williams
Andrejs, On 8 Apr 2014, at 22:36, Andrejs Abele wrote: > Hi Hugh, > Thank you for your comments. > When the loader fails, I continue from the point it failed. > I want to clarify, that virtuoso server, was not crashing, but the loader. [Hugh] So it is your client side loader program that is cra

Re: [Virtuoso-users] virtuoso service stops

2014-04-07 Thread Hugh Williams
t; 'Total' . } } }; Done. -- 68 msec. SQL> But then I don't have your data, thus what datasets do you have loaded and are they available for public download ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. //

Re: [Virtuoso-users] problems loading Virtuos on Google cloud

2014-04-07 Thread Hugh Williams
nitor the load rates of the Virtuoso RDF Bulk loader process as detailed at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideLDMeterUtility and should show how the load rates decrease as all the buffers are consumed and data is having to be swapped to

Re: [Virtuoso-users] Virtuoso crash when try to delete a huge graph

2014-04-05 Thread Hugh Williams
" set in the INI file, in fact please provide the output of running the command ... 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/

Re: [Virtuoso-users] Virtuoso SPARQL response limit

2014-04-04 Thread Hugh Williams
L endpoint: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtSPARQLEndpointProtection Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.li

Re: [Virtuoso-users] Sparql http update request with multiple update statements

2014-04-03 Thread Hugh Williams
for authentication and will then allow you to perform write operations, see the following docs for more details: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideSPARQLEndpoints Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] MaxCheckpointRemap set correct?

2014-04-01 Thread Hugh Williams
Hi Bart, It is the physical database size as the NumberOfBuffers is a memory param and the database size is the size on disk, where the checkpoint it committing the data to ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] NumberOfBuffers confusion

2014-04-01 Thread Hugh Williams
Bart, On 1 Apr 2014, at 12:04, Bart Vandewoestyne wrote: > On 2014-04-01 11:35, Hugh Williams wrote: >> Hi Bart, >> >> You should set the NumberOfBuffers based on the amount of free memory >> available on the system , thus about 7.1GB * 0.66 / 8K (each buffer

Re: [Virtuoso-users] NumberOfBuffers confusion

2014-04-01 Thread Hugh Williams
Hi Bart, You should set the NumberOfBuffers based on the amount of free memory available on the system , thus about 7.1GB * 0.66 / 8K (each buffer is 8K) = 585750 buffers ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Source quality (qs=...) values for SPARQL result variants in content negotiation

2014-03-30 Thread Hugh Williams
Hi Dorian, Currently the Virtuoso SPARQL endpoint expects one value in this header and always prefers to use the ‘format’ url parameter. Development are working on a fix to allow such accept headers and I shall notify when it is available ... Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] getting large SPARQL result sets

2014-03-24 Thread Hugh Williams
Hi Jakub, For a stable/consistent pagination, ORDER BY is always necessary. Even if data are constant and statistics of indexes are not refreshed between fetching different pages, the optimizer can chose different ordering depending on number of rows to skip and return. Best Regards Hugh

Re: [Virtuoso-users] Strange result from SPARQL function st_within

2014-03-23 Thread Hugh Williams
Hi Frans, I am seeking confirmation from development on this ... 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

Re: [Virtuoso-users] Strange result from SPARQL function st_within

2014-03-20 Thread Hugh Williams
ctionality will be extended in the next release. I hope this answers your question. Genarally, if you can provide some sample data and the queries being run it would help in understanding of the issue being reported ... Best Regards Hugh Williams Professional Services OpenLink Sof

Re: [Virtuoso-users] Geo SPARQL support

2014-03-19 Thread Hugh Williams
some live sample queries for the geometries support at: http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#(1) Note, you need to be using Virtuoso 7.1+ open source or commercial ... Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] xsd:boolean in Virtuoso 7

2014-03-17 Thread Hugh Williams
Frans, On 17 Mar 2014, at 15:53, Frans Knibbe | Geodan wrote: > On 2013-11-08 7:37, Quentin wrote: >> Is it likely that Virtuoso 7 will come to support xsd:boolean without >> integer conversion? >> >> > A good question. I have just noticed that when I import boolean literals > they are conve

Re: [Virtuoso-users] Problem loading geographical data

2014-03-17 Thread Hugh Williams
tus(''); REPORT VARCHAR ___ OpenLink Virtuoso Server Version 07.10.3208-pthreads for Linux as of Mar 11 2014 Started on: 2014-03-17 17:36 GMT+1 Best Regards Hugh Williams Professional Services OpenLink S

Re: [Virtuoso-users] Execute RDF_GEO_FILL() on specific graph

2014-03-10 Thread Hugh Williams
"), 256, 257, 0, 1))); } } ; Note this function is for single server, different one would be required for cluster. Will make a documentation tip about this as it seems a useful function ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // ht

Re: [Virtuoso-users] sparql INSERT with URI fragments not working

2014-03-10 Thread Hugh Williams
Hi Rob, You are correct, thanks for pointing that out ... 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

Re: [Virtuoso-users] Property functions in Virtuoso

2014-03-10 Thread Hugh Williams
Hi Alex Have you looked at the Star Schema bench mark which creates OLAP queries using SPARQL ? http://people.aifb.kit.edu/bka/ssb-benchmark/ Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] sparql INSERT with URI fragments not working

2014-03-09 Thread Hugh Williams
Hi Jaana, I have been able to recreate this issue and 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

Re: [Virtuoso-users] Property functions in Virtuoso

2014-03-09 Thread Hugh Williams
e for your use case ? 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

Re: [Virtuoso-users] Literals, STR() in FILTER and query plan

2014-03-09 Thread Hugh Williams
1 Some other text 1 Rows. -- 0 msec. SQL> In fact even in the sample profile output you provided you can see there compilation time for the first query is 13msec vs 1msec f

Re: [Virtuoso-users] ODBC architecture mismatch error using Virtuoso 07.10.3207

2014-03-08 Thread Hugh Williams
hat will be done .. Regards Hugh > Jean-Baptiste Pressac > Traitement et analyse de bases de données > Centre de Recherche Bretonne et Celtique > UMS 3554 > 20 rue Duquesne > CS 93837 > 29238 Brest cedex 3 > > tel : +33 (0)2 98 01 68 95 > fax : +33 (0)2 98 01 63 93 > Le 0

Re: [Virtuoso-users] Freebase bulk loading is sluggish

2014-03-06 Thread Hugh Williams
Hi Can you please provide a copy of your virtuoso.ini file and the output of running the "status();" command from isql ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw

Re: [Virtuoso-users] ODBC architecture mismatch error using Virtuoso 07.10.3207

2014-03-05 Thread Hugh Williams
Hi Jean-Baptiste, So the 7.1 ODBC Driver which is 64bit does work with your 64bit Apache/PHP version, whereas the 7.0 ODBC driver which should also be 64bit is giving the windows 193 system error ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] Arrow keys in isql/Linux

2014-03-04 Thread Hugh Williams
#Configuring It is not enabled by default due to licensing issues on some OS'es ... 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/ope

Re: [Virtuoso-users] compiling virtuoso-7 on FreeBSD 9.2 stops with flex errors

2014-03-04 Thread Hugh Williams
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

Re: [Virtuoso-users] splt_and_decode

2014-03-04 Thread Hugh Williams
'test+test+test'; return split_and_decode(‘test+test+test',0,'%+'); } which returns: SQL> select test.test.testUrlDecode1 (); testUrlDecode1 VARCHAR ___ test test test 1 Rows. -- 0 msec. SQ

Re: [Virtuoso-users] Startup error on stable7

2014-03-01 Thread Hugh Williams
Hi Quentin, You can use the DB.DBA.RDF_AUDIT_METADATA() to check and attempt to repair any issue found in the RDF meta data ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

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

2014-03-01 Thread Hugh Williams
select count(*) from RDF_QUAD table option (index RDF_QUAD) select count(*) from RDF_QUAD table option (index RDF_QUAD_POGS) select count(*) from RDF_QUAD table option (index RDF_QUAD_SP) If you can provide a lcopy of the DB file it can be checked. ... Best Regards Hugh W

Re: [Virtuoso-users] Exception thrown when deleting existing user

2014-03-01 Thread Hugh Williams
,'badpassword'); test.test.testUserDrop(1) }; Done. -- 1 msec. SQL> test.test.testUserDrop(); Done. -- 2 msec. SQL> user_drop('testUser'); Done. -- 2 msec. SQL> Will ask development to check why the might be occurring via the Conductor ... Best Regards Hugh Williams Pr

Re: [Virtuoso-users] splt_and_decode

2014-03-01 Thread Hugh Williams
Hi Quinten, I am checking this with development ... 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

Re: [Virtuoso-users] how to find path

2014-03-01 Thread Hugh Williams
Hi Nikunj, A Virtuoso transitive query can provide the path length between nodes in a graph as detailed in the examples at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtsubClassOfOrientedSubsumptionTransitiveOptions Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] URI resources redirection to fct page

2014-03-01 Thread Hugh Williams
#AncmozTocId313638 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

Re: [Virtuoso-users] Erratum inside Virtuoso Tips and Tricks wiki page

2014-02-27 Thread Hugh Williams
Hi Julien, Thanks for pointing this out, I have correct the page .. 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

Re: [Virtuoso-users] example using new geo capabilities with polygons

2014-02-21 Thread Hugh Williams
... 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

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

2014-02-20 Thread Hugh Williams
ass> . ?S ?P ?O . }}; Done. -- 42 msec. SQL> SQL> status(''); REPORT VARCHAR ___ OpenLink Virtuoso Server Version 07.10.3207-pthreads for Darwin as of Feb 18 2014 Started on: 2014-02-21 03:17 GMT+0 Which s

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

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

2014-02-20 Thread Hugh Williams
ul to enabling additional tracing on the the Virtuoso server with the "trace_on()" command and see if any errors are logged that might provide more information, see: http://docs.openlinksw.com/virtuoso/fn_trace_on.html Then provide a copy of your virtuoso.log file for revie

[Virtuoso-users] Announcing OpenLink Virtuoso Open-Source Edition, Version 7.1.0

2014-02-18 Thread Hugh Williams
enlinksw.com/oatdemo> * Interactive SPARQL Demo: <http://demo.openlinksw.com/isparql/> OpenLink Data Explorer (Firefox extension for RDF browsing): * Home Page: <http://ode.openlinksw.com/> Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http:/

Re: [Virtuoso-users] Problems with federated queries in virtuoso v7

2014-02-18 Thread Hugh Williams
develop/7 or coincidentally he official open source 7.1 stable/7 release was made yesterday, thus you could build from that branch also to get the latest updates, and retest to see if the query now runs ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] (no subject)

2014-02-17 Thread Hugh Williams
Tuning In particular you should set the "NumberOfBuffers" param to match the size of available memory for use by Virtuoso and restart the database for the settings to take effect ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.op

Re: [Virtuoso-users] character encoding error for uri/iri

2014-02-15 Thread Hugh Williams
Hi Roland, We have seen occurrence of this problem before with SPARQ_FED queries, thus it is scheduled to be looked into. Will let you know when we have a fix .. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog

Re: [Virtuoso-users] Error when INSERT a triple with large literal: "Value of ANY type column too long"

2014-02-14 Thread Hugh Williams
Hi Enrico, OK, I have reported this to development to check and advise how best this can/should be done ... Is your work part of the original Fusepool or the new Fusepool P3 project ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Problem with property paths

2014-02-13 Thread Hugh Williams
Hi Nikun, We are looking into this and will report back when there is an update or fix from development ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http

Re: [Virtuoso-users] Error when INSERT a triple with large literal: "Value of ANY type column too long"

2014-02-13 Thread Hugh Williams
you should be able to pass this query to Virtuoso as a string in an application ... BTW, why was your graph call "FusepoolTest" , are you involved in the Fusepool EU project ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.o

Re: [Virtuoso-users] Crash of virtuoso 7 stable + better bulk loading from api's

2014-02-13 Thread Hugh Williams
.uniprot.org/pub/databases/uniprot/current_release/rdf/go.rdf.gz and I can load here to try recreate your problem with develop/7 ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blo

Re: [Virtuoso-users] Virtuoso 7 test failing

2014-02-13 Thread Hugh Williams
Note, you can change the default port used for the build, by passing "--with-port(=NUMBER)SQL port ( default)" to configure when setting up the build environment ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlin

Re: [Virtuoso-users] Issue with xsd:duration datatype

2014-02-10 Thread Hugh Williams
Hi Julien, This does not appear to be supported still in the latest builds, thus I have requested and update from development as to when it will be added ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] Error when INSERT a triple with large literal: "Value of ANY type column too long"

2014-02-10 Thread Hugh Williams
actual version and build date of the Virtuoso being used (virtuoso-t -?) ... 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

Re: [Virtuoso-users] Problem with property paths

2014-02-10 Thread Hugh Williams
/VirtTipsAndTricksSPARQL11PropertyPaths 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

Re: [Virtuoso-users] JDBC sqlexception thrown for not implemented methods instead of SQLFeatureNotSupportedException

2014-02-10 Thread Hugh Williams
Hi Jerven, Thanks for the suggestion, we shall schedule to implement this in the JDBC Driver ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http

Re: [Virtuoso-users] Crash when abusing multiple results sets in a procedure

2014-02-08 Thread Hugh Williams
class s2 name s2 2 Rows. -- 4 msec. SQL> Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openl

Re: [Virtuoso-users] deleting large graph > crash vos7

2014-02-07 Thread Hugh Williams
Hi Roland, Glad to here log_enable(3) enabled the large graph to be deleted ... 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

Re: [Virtuoso-users] deleting large graph > crash vos7

2014-02-07 Thread Hugh Williams
Having said that the server still should not have crashed and if anything hang when the system runs out of memory or possibly warn that the operation cannot be completed ideally ... What version are you running (virtuoso-t -?) ? Best Regards Hugh Williams Professional Services OpenLink Software

Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer supported?

2014-02-07 Thread Hugh Williams
of_qname('http://localhost:8890')` }; callret-0 VARCHAR ___ Delete from <http://sample/>, 1 (or less) triples -- done 1 Rows. -- 127 msec. SQL> Best Regards Hugh Williams Professional Services OpenLink Sof

Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer supported?

2014-02-07 Thread Hugh Williams
> sparql delete from <http://sample/> { `sql:rdf_make_iid_of_qname('http://localhost:8890')` }; Done. -- 5 msec. SQL> Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/bl

Re: [Virtuoso-users] The array extend is less than requested

2014-02-07 Thread Hugh Williams
Hi Nicola, You can run the command virtuoso-t -? to get the full version and build date ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http

Re: [Virtuoso-users] The array extend is less than requested

2014-02-06 Thread Hugh Williams
Hi Nicola, Which Virtuoso server type single server or cluster are you using and also the version, as the error message implies you are running on a cluster which is not supported in open source ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer supported?

2014-02-06 Thread Hugh Williams
OpenLink Virtuoso Server Version 06.01.3127-threads for Win64 as of Dec 11 2013 Started on: 2014/02/06 16:53 GMT+00 Thus I am curious and confused as to how you are calling this via the ADO.Net Provider such that it is not located ? Best Regards Hugh Williams Professional Services OpenLink

<    1   2   3   4   5   6   7   8   9   10   >