Hi Ricardo,
What is the version of virtuoso being used and on what OS , running virtuoso-t
-? will return this info ?
Running the procedure against a sample database completes successfully:
SQL> CREATE VIEW Dados_Facturas_Electricidade AS SPARQL { SELECT ?observation
?contador ?recordTime ( fn:hours-from-dateTime(?recordTime) ) AS ?type
?quantidade ?valor ?iva ?total FROM
<http://lsm.deri.ie/OpenIoT/sensordata#> WHERE { ?observation
<http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?contador . ?record
<http://lsm.deri.ie/ont/lsm.owl#isObservedPropertyOf> ?observation .
?record
<http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?recordTime .
?record <http://lsm.deri.ie/ont/lsm.owl#value> ?quantidade .
?record <http://www.w3.org/2000/01/rdf-schema#label> 'Quantidade' .
{ ?record1
<http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?recordTime .
?record1 <http://lsm.deri.ie/ont/lsm.owl#value> ?valor . ?record1
<http://www.w3.org/2000/01/rdf-schema#label> 'Valor' .
} . { ?record2
<http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?recordTime .
?record2 <http://lsm.deri.ie/ont/lsm.owl#value> ?iva . ?record2
<http://www.w3.org/2000/01/rdf-schema#label> 'IVA' .
} . { ?record3
<http://purl.oclc.org/NET/ssnx/ssn#observationResultTime> ?recordTime .
?record3 <http://lsm.deri.ie/ont/lsm.owl#value> ?total . ?record3
<http://www.w3.org/2000/01/rdf-schema#label> '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. // 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 7 Apr 2014, at 16:02, Ricardo Mendes <ricardo.men...@izone-ks.pt> wrote:
> Hello,
>
> I’m trying to create a view with the output of a query SPARQL, but the
> virtuoso service stops. The output log gives:
>
> 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x60acc2]
> 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x60f41c]
> 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x62acb1]
> 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x62bf3d]
> 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x5da315]
> 13:23:34 GPF: Dkalloc.c:705 av fill and list not in sync, likely double free
>
> The query is :
>
> CREATE VIEW Dados_Facturas_Electricidade AS SPARQL {
> SELECT ?observation ?contador ?recordTime (
> fn:hours-from-dateTime(?recordTime) ) AS ?type ?quantidade ?valor ?iva
> ?total
> FROM <http://lsm.deri.ie/OpenIoT/sensordata#>
> WHERE
> {
> ?observation <http://purl.oclc.org/NET/ssnx/ssn#observedBy> ?contador
> .
> ?record <http://lsm.deri.ie/ont/lsm.owl#isObservedPropertyOf>
> ?observation .
> ?record <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime>
> ?recordTime .
> ?record <http://lsm.deri.ie/ont/lsm.owl#value> ?quantidade .
> ?record <http://www.w3.org/2000/01/rdf-schema#label> 'Quantidade' .
>
> {
> ?record1 <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime>
> ?recordTime .
> ?record1 <http://lsm.deri.ie/ont/lsm.owl#value> ?valor .
> ?record1 <http://www.w3.org/2000/01/rdf-schema#label> 'Valor' .
>
> } .
> {
> ?record2 <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime>
> ?recordTime .
> ?record2 <http://lsm.deri.ie/ont/lsm.owl#value> ?iva .
> ?record2 <http://www.w3.org/2000/01/rdf-schema#label> 'IVA' .
>
> } .
> {
> ?record3 <http://purl.oclc.org/NET/ssnx/ssn#observationResultTime>
> ?recordTime .
> ?record3 <http://lsm.deri.ie/ont/lsm.owl#value> ?total .
> ?record3 <http://www.w3.org/2000/01/rdf-schema#label> 'Total' .
>
> }
> }
> }
>
> Regards
>
> ------------------------------------------------------------------------------
> Put Bad Developers to Shame
> Dominate Development with Jenkins Continuous Integration
> Continuously Automate Build, Test & Deployment
> Start a new project now. Try Jenkins in the cloud.
> http://p.sf.net/sfu/13600_Cloudbees_APR_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
