You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@marmotta.apache.org by "Bohms, H.M. (Michel)" <mi...@tno.nl> on 2015/12/16 15:47:26 UTC

sparql issue

Strange issue:
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX odysseus: <http://marmotta.tno.nl:8080/marmotta/context/>
PREFIX cmo: <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl#>
PREFIX depc: <http://www.modelservers.org/public/ontologies/odysseus/depc.ttl#>
SELECT ?ProfileSignal ?signalid ?value ?valueType ?timestamp
FROM odysseus:manchestertest
 WHERE
{

  {
    ?ProfileSignal a depc:ProfileSignal .
    ?ProfileSignal depc:signalID ?signalid .
    ?ProfileSignal depc:hasTimePointSignal ?tps .
    ?tps cmo:energy ?value .
#    ?tps depc:timeStamp ?timestamp .
    {
      FILTER (?signalid = "1771"^^xsd:int).
    }
    bind ("depc:eFlow" as ?valueType)
  }
}

Gives results, but uncommenting # gives no results!

Reproducible at: http://marmotta.tno.nl:8080/marmotta/sparql/admin/squebi.html#?query=PREFIX%20rdf:%20%3Chttp:%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%20%0APREFIX%20xsd:%20%3Chttp:%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%20%0APREFIX%20odysseus:%20%3Chttp:%2F%2Fmarmotta.tno.nl:8080%2Fmarmotta%2Fcontext%2F%3E%20%0APREFIX%20cmo:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fcmo%2Fcmo.ttl%23%3E%20%0APREFIX%20depc:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fodysseus%2Fdepc.ttl%23%3E%20%0ASELECT%20%3FProfileSignal%20%3Fsignalid%20%3Fvalue%20%3FvalueType%20%3Ftimestamp%20%0AFROM%20odysseus:manchestertest%20%0A%20WHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3FProfileSignal%20a%20depc:ProfileSignal%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:signalID%20%3Fsignalid%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:hasTimePointSignal%20%3Ftps%20.%20%0A%20%20%20%20%3Ftps%20cmo:energy%20%3Fvalue%20.%20%0A%20%23%20%20%20%3Ftps%20depc:timeStamp%20%3Ftimestamp%20.%20%0A%20%20%20%20%7B%20%0A%20%20%20%20%20%20FILTER%20(%3Fsignalid%20%3D%20%221771%22%5E%5Exsd:int).%20%0A%20%20%20%20%7D%20%0A%20%20%20%20bind%20(%22depc:eFlow%22%20as%20%3FvalueType)%20%0A%20%20%7D%20%0A%0A&writer=browse


Any idea/hint welcome!
Thx a lot, Michel Bohms/Erwin Somers, TNO





Dr. ir. H.M. (Michel) Bohms
Sr. Research Scientist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel.bohms@tno.nl<ma...@tno.nl>

Location<http://www.tno.nl/locaties/DTM>



[cid:image001.gif@01D13814.44D42430]<http://www.tno.nl/>

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.

RE: sparql issue

Posted by "Bohms, H.M. (Michel)" <mi...@tno.nl>.
And also, do I need an account to login to jira to create the issue?



Dr. ir. H.M. (Michel) Bohms
Sr. Research Scientist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel.bohms@tno.nl<ma...@tno.nl>

Location<http://www.tno.nl/locaties/DTM>



[cid:image001.gif@01D13838.03B56A80]<http://www.tno.nl/>

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.



From: Michel Böhms [mailto:michel.bohms@gmail.com]
Sent: woensdag 16 december 2015 19:21
To: users@marmotta.apache.org
Subject: Re: sparql issue

ok, I'll do that
in the meantime, where can I increase the default (linux version)?
(although unlikely it is a time issue, removing the # doesnt change the situation that much :)
thx a lot Michel

2015-12-16 16:33 GMT+01:00 Sergio Fernández <wi...@apache.org>>:
Hi Michael,

I doesn't give no results, the query execution gets aborted because it exceeds the timeout (by default 60s). I guess it could be an issue handling xsd:dateTime literals.

Please, report the details to jira, with a sample dataset if possible, and we'll try to find the issue.

Cheers,

On Wed, Dec 16, 2015 at 3:47 PM, Bohms, H.M. (Michel) <mi...@tno.nl>> wrote:
Strange issue:
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#<http://www.w3.org/1999/02/22-rdf-syntax-ns>>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#<http://www.w3.org/2001/XMLSchema>>
PREFIX odysseus: <http://marmotta.tno.nl:8080/marmotta/context/>
PREFIX cmo: <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl#<http://www.modelservers.org/public/ontologies/cmo/cmo.ttl>>
PREFIX depc: <http://www.modelservers.org/public/ontologies/odysseus/depc.ttl#<http://www.modelservers.org/public/ontologies/odysseus/depc.ttl>>
SELECT ?ProfileSignal ?signalid ?value ?valueType ?timestamp
FROM odysseus:manchestertest
 WHERE
{

  {
    ?ProfileSignal a depc:ProfileSignal .
    ?ProfileSignal depc:signalID ?signalid .
    ?ProfileSignal depc:hasTimePointSignal ?tps .
    ?tps cmo:energy ?value .
#    ?tps depc:timeStamp ?timestamp .
    {
      FILTER (?signalid = "1771"^^xsd:int).
    }
    bind ("depc:eFlow" as ?valueType)
  }
}

Gives results, but uncommenting # gives no results!

Reproducible at: http://marmotta.tno.nl:8080/marmotta/sparql/admin/squebi.html#?query=PREFIX%20rdf:%20%3Chttp:%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%20%0APREFIX%20xsd:%20%3Chttp:%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%20%0APREFIX%20odysseus:%20%3Chttp:%2F%2Fmarmotta.tno.nl:8080%2Fmarmotta%2Fcontext%2F%3E%20%0APREFIX%20cmo:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fcmo%2Fcmo.ttl%23%3E%20%0APREFIX%20depc:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fodysseus%2Fdepc.ttl%23%3E%20%0ASELECT%20%3FProfileSignal%20%3Fsignalid%20%3Fvalue%20%3FvalueType%20%3Ftimestamp%20%0AFROM%20odysseus:manchestertest%20%0A%20WHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3FProfileSignal%20a%20depc:ProfileSignal%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:signalID%20%3Fsignalid%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:hasTimePointSignal%20%3Ftps%20.%20%0A%20%20%20%20%3Ftps%20cmo:energy%20%3Fvalue%20.%20%0A%20%23%20%20%20%3Ftps%20depc:timeStamp%20%3Ftimestamp%20.%20%0A%20%20%20%20%7B%20%0A%20%20%20%20%20%20FILTER%20(%3Fsignalid%20%3D%20%221771%22%5E%5Exsd:int).%20%0A%20%20%20%20%7D%20%0A%20%20%20%20bind%20(%22depc:eFlow%22%20as%20%3FvalueType)%20%0A%20%20%7D%20%0A%0A&writer=browse


Any idea/hint welcome!
Thx a lot, Michel Bohms/Erwin Somers, TNO





Dr. ir. H.M. (Michel) Bohms
Sr. Research Scientist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel.bohms@tno.nl<ma...@tno.nl>

Location<http://www.tno.nl/locaties/DTM>



[cid:image001.gif@01D13838.03B56A80]<http://www.tno.nl/>

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.






--
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 6602747925<tel:%2B43%206602747925>
e: sergio.fernandez@redlink.co<ma...@redlink.co>
w: http://redlink.co<http://redlink.co/>

Re: sparql issue

Posted by Sergio Fernández <wi...@apache.org>.
On Wed, Dec 16, 2015 at 7:21 PM, Michel Böhms <mi...@gmail.com>
wrote:

> ok, I'll do that
> in the meantime, where can I increase the default (linux version)?
>

Setting the "sparql.timeout" configuration with the maximum time in seconds
(default is 60).


-- 
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 6602747925
e: sergio.fernandez@redlink.co
w: http://redlink.co

Re: sparql issue

Posted by Michel Böhms <mi...@gmail.com>.
ok, I'll do that
in the meantime, where can I increase the default (linux version)?
(although unlikely it is a time issue, removing the # doesnt change the
situation that much :)
thx a lot Michel

2015-12-16 16:33 GMT+01:00 Sergio Fernández <wi...@apache.org>:

> Hi Michael,
>
> I doesn't give no results, the query execution gets aborted because it
> exceeds the timeout (by default 60s). I guess it could be an issue handling
> xsd:dateTime literals.
>
> Please, report the details to jira, with a sample dataset if possible, and
> we'll try to find the issue.
>
> Cheers,
>
> On Wed, Dec 16, 2015 at 3:47 PM, Bohms, H.M. (Michel) <michel.bohms@tno.nl
> > wrote:
>
>> Strange issue:
>>
>> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
>>
>> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
>>
>> PREFIX odysseus: <http://marmotta.tno.nl:8080/marmotta/context/>
>>
>> PREFIX cmo: <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl#>
>>
>> PREFIX depc: <
>> http://www.modelservers.org/public/ontologies/odysseus/depc.ttl#>
>>
>> SELECT ?ProfileSignal ?signalid ?value ?valueType ?timestamp
>>
>> FROM odysseus:manchestertest
>>
>>  WHERE
>>
>> {
>>
>>
>>
>>   {
>>
>>     ?ProfileSignal a depc:ProfileSignal .
>>
>>     ?ProfileSignal depc:signalID ?signalid .
>>
>>     ?ProfileSignal depc:hasTimePointSignal ?tps .
>>
>>     ?tps cmo:energy ?value .
>>
>> #    ?tps depc:timeStamp ?timestamp .
>>
>>     {
>>
>>       FILTER (?signalid = "1771"^^xsd:int).
>>
>>     }
>>
>>     bind ("depc:eFlow" as ?valueType)
>>
>>   }
>>
>> }
>>
>>
>>
>> Gives results, but uncommenting # gives no results!
>>
>>
>>
>> Reproducible at:
>> http://marmotta.tno.nl:8080/marmotta/sparql/admin/squebi.html#?query=PREFIX%20rdf:%20%3Chttp:%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%20%0APREFIX%20xsd:%20%3Chttp:%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%20%0APREFIX%20odysseus:%20%3Chttp:%2F%2Fmarmotta.tno.nl:8080%2Fmarmotta%2Fcontext%2F%3E%20%0APREFIX%20cmo:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fcmo%2Fcmo.ttl%23%3E%20%0APREFIX%20depc:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fodysseus%2Fdepc.ttl%23%3E%20%0ASELECT%20%3FProfileSignal%20%3Fsignalid%20%3Fvalue%20%3FvalueType%20%3Ftimestamp%20%0AFROM%20odysseus:manchestertest%20%0A%20WHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3FProfileSignal%20a%20depc:ProfileSignal%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:signalID%20%3Fsignalid%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:hasTimePointSignal%20%3Ftps%20.%20%0A%20%20%20%20%3Ftps%20cmo:energy%20%3Fvalue%20.%20%0A%20%23%20%20%20%3Ftps%20depc:timeStamp%20%3Ftimestamp%20.%20%0A%20%20%20%20%7B%20%0A%20%20%20%20%20%20FILTER%20(%3Fsignalid%20%3D%20%221771%22%5E%5Exsd:int).%20%0A%20%20%20%20%7D%20%0A%20%20%20%20bind%20(%22depc:eFlow%22%20as%20%3FvalueType)%20%0A%20%20%7D%20%0A%0A&writer=browse
>>
>>
>>
>>
>>
>> Any idea/hint welcome!
>>
>> Thx a lot, Michel Bohms/Erwin Somers, TNO
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Dr. ir. H.M. (Michel) Bohms
>> Sr. Research Scientist
>> Structural Reliability
>>
>> T +31 (0)88 866 31 07
>> M +31 (0)63 038 12 20
>> E michel.bohms@tno.nl
>>
>> Location <http://www.tno.nl/locaties/DTM>
>>
>>
>>
>> <http://www.tno.nl/>
>>
>> This message may contain information that is not intended for you. If you
>> are not the addressee or if this message was sent to you by mistake, you
>> are requested to inform the sender and delete the message. TNO accepts no
>> liability for the content of this e-mail, for the manner in which you use
>> it and for damage of any kind resulting from the risks inherent to the
>> electronic transmission of messages.
>>
>>
>>
>
>
>
> --
> Sergio Fernández
> Partner Technology Manager
> Redlink GmbH
> m: +43 6602747925
> e: sergio.fernandez@redlink.co
> w: http://redlink.co
>

Re: sparql issue

Posted by Sergio Fernández <wi...@apache.org>.
Really? Then no idea... Have you changed anything in the data?
Some server logs (both marmotta and postgres) may help.

On Wed, Dec 16, 2015 at 7:37 PM, Bohms, H.M. (Michel) <mi...@tno.nl>
wrote:

> Weird, when I NOW do the same: no time out!
>
>
>
> So must be related with other server activity?
>
>
>
>
>
> Dr. ir. H.M. (Michel) Bohms
> Sr. Research Scientist
> Structural Reliability
>
> T +31 (0)88 866 31 07
> M +31 (0)63 038 12 20
> E michel.bohms@tno.nl
>
> Location <http://www.tno.nl/locaties/DTM>
>
>
>
> <http://www.tno.nl/>
>
> This message may contain information that is not intended for you. If you
> are not the addressee or if this message was sent to you by mistake, you
> are requested to inform the sender and delete the message. TNO accepts no
> liability for the content of this e-mail, for the manner in which you use
> it and for damage of any kind resulting from the risks inherent to the
> electronic transmission of messages.
>
>
>
> *From:* Sergio Fernández [mailto:wikier@apache.org]
> *Sent:* woensdag 16 december 2015 16:34
> *To:* users@marmotta.apache.org
> *Subject:* Re: sparql issue
>
>
>
> Hi Michael,
>
>
>
> I doesn't give no results, the query execution gets aborted because it
> exceeds the timeout (by default 60s). I guess it could be an issue handling
> xsd:dateTime literals.
>
>
>
> Please, report the details to jira, with a sample dataset if possible, and
> we'll try to find the issue.
>
>
>
> Cheers,
>
>
>
> On Wed, Dec 16, 2015 at 3:47 PM, Bohms, H.M. (Michel) <mi...@tno.nl>
> wrote:
>
> Strange issue:
>
> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#
> <http://www.w3.org/1999/02/22-rdf-syntax-ns>>
>
> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#
> <http://www.w3.org/2001/XMLSchema>>
>
> PREFIX odysseus: <http://marmotta.tno.nl:8080/marmotta/context/>
>
> PREFIX cmo: <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl#
> <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl>>
>
> PREFIX depc: <
> http://www.modelservers.org/public/ontologies/odysseus/depc.ttl#
> <http://www.modelservers.org/public/ontologies/odysseus/depc.ttl>>
>
> SELECT ?ProfileSignal ?signalid ?value ?valueType ?timestamp
>
> FROM odysseus:manchestertest
>
>  WHERE
>
> {
>
>
>
>   {
>
>     ?ProfileSignal a depc:ProfileSignal .
>
>     ?ProfileSignal depc:signalID ?signalid .
>
>     ?ProfileSignal depc:hasTimePointSignal ?tps .
>
>     ?tps cmo:energy ?value .
>
> #    ?tps depc:timeStamp ?timestamp .
>
>     {
>
>       FILTER (?signalid = "1771"^^xsd:int).
>
>     }
>
>     bind ("depc:eFlow" as ?valueType)
>
>   }
>
> }
>
>
>
> Gives results, but uncommenting # gives no results!
>
>
>
> Reproducible at:
> http://marmotta.tno.nl:8080/marmotta/sparql/admin/squebi.html#?query=PREFIX%20rdf:%20%3Chttp:%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%20%0APREFIX%20xsd:%20%3Chttp:%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%20%0APREFIX%20odysseus:%20%3Chttp:%2F%2Fmarmotta.tno.nl:8080%2Fmarmotta%2Fcontext%2F%3E%20%0APREFIX%20cmo:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fcmo%2Fcmo.ttl%23%3E%20%0APREFIX%20depc:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fodysseus%2Fdepc.ttl%23%3E%20%0ASELECT%20%3FProfileSignal%20%3Fsignalid%20%3Fvalue%20%3FvalueType%20%3Ftimestamp%20%0AFROM%20odysseus:manchestertest%20%0A%20WHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3FProfileSignal%20a%20depc:ProfileSignal%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:signalID%20%3Fsignalid%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:hasTimePointSignal%20%3Ftps%20.%20%0A%20%20%20%20%3Ftps%20cmo:energy%20%3Fvalue%20.%20%0A%20%23%20%20%20%3Ftps%20depc:timeStamp%20%3Ftimestamp%20.%20%0A%20%20%20%20%7B%20%0A%20%20%20%20%20%20FILTER%20(%3Fsignalid%20%3D%20%221771%22%5E%5Exsd:int).%20%0A%20%20%20%20%7D%20%0A%20%20%20%20bind%20(%22depc:eFlow%22%20as%20%3FvalueType)%20%0A%20%20%7D%20%0A%0A&writer=browse
>
>
>
>
>
> Any idea/hint welcome!
>
> Thx a lot, Michel Bohms/Erwin Somers, TNO
>
>
>
>
>
>
>
>
>
> Dr. ir. H.M. (Michel) Bohms
> Sr. Research Scientist
> Structural Reliability
>
> T +31 (0)88 866 31 07
> M +31 (0)63 038 12 20
> E michel.bohms@tno.nl
>
> Location <http://www.tno.nl/locaties/DTM>
>
>
>
> <http://www.tno.nl/>
>
> This message may contain information that is not intended for you. If you
> are not the addressee or if this message was sent to you by mistake, you
> are requested to inform the sender and delete the message. TNO accepts no
> liability for the content of this e-mail, for the manner in which you use
> it and for damage of any kind resulting from the risks inherent to the
> electronic transmission of messages.
>
>
>
>
>
>
>
> --
>
> Sergio Fernández
> Partner Technology Manager
> Redlink GmbH
> m: +43 6602747925
> e: sergio.fernandez@redlink.co
> w: http://redlink.co
>



-- 
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 6602747925
e: sergio.fernandez@redlink.co
w: http://redlink.co

RE: sparql issue

Posted by "Bohms, H.M. (Michel)" <mi...@tno.nl>.
Weird, when I NOW do the same: no time out!

So must be related with other server activity?



Dr. ir. H.M. (Michel) Bohms
Sr. Research Scientist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel.bohms@tno.nl<ma...@tno.nl>

Location<http://www.tno.nl/locaties/DTM>



[cid:image001.gif@01D13839.2B3CEF00]<http://www.tno.nl/>

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.



From: Sergio Fernández [mailto:wikier@apache.org]
Sent: woensdag 16 december 2015 16:34
To: users@marmotta.apache.org
Subject: Re: sparql issue

Hi Michael,

I doesn't give no results, the query execution gets aborted because it exceeds the timeout (by default 60s). I guess it could be an issue handling xsd:dateTime literals.

Please, report the details to jira, with a sample dataset if possible, and we'll try to find the issue.

Cheers,

On Wed, Dec 16, 2015 at 3:47 PM, Bohms, H.M. (Michel) <mi...@tno.nl>> wrote:
Strange issue:
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#<http://www.w3.org/1999/02/22-rdf-syntax-ns>>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#<http://www.w3.org/2001/XMLSchema>>
PREFIX odysseus: <http://marmotta.tno.nl:8080/marmotta/context/>
PREFIX cmo: <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl#<http://www.modelservers.org/public/ontologies/cmo/cmo.ttl>>
PREFIX depc: <http://www.modelservers.org/public/ontologies/odysseus/depc.ttl#<http://www.modelservers.org/public/ontologies/odysseus/depc.ttl>>
SELECT ?ProfileSignal ?signalid ?value ?valueType ?timestamp
FROM odysseus:manchestertest
 WHERE
{

  {
    ?ProfileSignal a depc:ProfileSignal .
    ?ProfileSignal depc:signalID ?signalid .
    ?ProfileSignal depc:hasTimePointSignal ?tps .
    ?tps cmo:energy ?value .
#    ?tps depc:timeStamp ?timestamp .
    {
      FILTER (?signalid = "1771"^^xsd:int).
    }
    bind ("depc:eFlow" as ?valueType)
  }
}

Gives results, but uncommenting # gives no results!

Reproducible at: http://marmotta.tno.nl:8080/marmotta/sparql/admin/squebi.html#?query=PREFIX%20rdf:%20%3Chttp:%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%20%0APREFIX%20xsd:%20%3Chttp:%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%20%0APREFIX%20odysseus:%20%3Chttp:%2F%2Fmarmotta.tno.nl:8080%2Fmarmotta%2Fcontext%2F%3E%20%0APREFIX%20cmo:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fcmo%2Fcmo.ttl%23%3E%20%0APREFIX%20depc:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fodysseus%2Fdepc.ttl%23%3E%20%0ASELECT%20%3FProfileSignal%20%3Fsignalid%20%3Fvalue%20%3FvalueType%20%3Ftimestamp%20%0AFROM%20odysseus:manchestertest%20%0A%20WHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3FProfileSignal%20a%20depc:ProfileSignal%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:signalID%20%3Fsignalid%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:hasTimePointSignal%20%3Ftps%20.%20%0A%20%20%20%20%3Ftps%20cmo:energy%20%3Fvalue%20.%20%0A%20%23%20%20%20%3Ftps%20depc:timeStamp%20%3Ftimestamp%20.%20%0A%20%20%20%20%7B%20%0A%20%20%20%20%20%20FILTER%20(%3Fsignalid%20%3D%20%221771%22%5E%5Exsd:int).%20%0A%20%20%20%20%7D%20%0A%20%20%20%20bind%20(%22depc:eFlow%22%20as%20%3FvalueType)%20%0A%20%20%7D%20%0A%0A&writer=browse


Any idea/hint welcome!
Thx a lot, Michel Bohms/Erwin Somers, TNO





Dr. ir. H.M. (Michel) Bohms
Sr. Research Scientist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
E michel.bohms@tno.nl<ma...@tno.nl>

Location<http://www.tno.nl/locaties/DTM>



[cid:image001.gif@01D13839.2B3CEF00]<http://www.tno.nl/>

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.






--
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 6602747925
e: sergio.fernandez@redlink.co<ma...@redlink.co>
w: http://redlink.co<http://redlink.co/>

Re: sparql issue

Posted by Sergio Fernández <wi...@apache.org>.
Hi Michael,

I doesn't give no results, the query execution gets aborted because it
exceeds the timeout (by default 60s). I guess it could be an issue handling
xsd:dateTime literals.

Please, report the details to jira, with a sample dataset if possible, and
we'll try to find the issue.

Cheers,

On Wed, Dec 16, 2015 at 3:47 PM, Bohms, H.M. (Michel) <mi...@tno.nl>
wrote:

> Strange issue:
>
> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
>
> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
>
> PREFIX odysseus: <http://marmotta.tno.nl:8080/marmotta/context/>
>
> PREFIX cmo: <http://www.modelservers.org/public/ontologies/cmo/cmo.ttl#>
>
> PREFIX depc: <
> http://www.modelservers.org/public/ontologies/odysseus/depc.ttl#>
>
> SELECT ?ProfileSignal ?signalid ?value ?valueType ?timestamp
>
> FROM odysseus:manchestertest
>
>  WHERE
>
> {
>
>
>
>   {
>
>     ?ProfileSignal a depc:ProfileSignal .
>
>     ?ProfileSignal depc:signalID ?signalid .
>
>     ?ProfileSignal depc:hasTimePointSignal ?tps .
>
>     ?tps cmo:energy ?value .
>
> #    ?tps depc:timeStamp ?timestamp .
>
>     {
>
>       FILTER (?signalid = "1771"^^xsd:int).
>
>     }
>
>     bind ("depc:eFlow" as ?valueType)
>
>   }
>
> }
>
>
>
> Gives results, but uncommenting # gives no results!
>
>
>
> Reproducible at:
> http://marmotta.tno.nl:8080/marmotta/sparql/admin/squebi.html#?query=PREFIX%20rdf:%20%3Chttp:%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%20%0APREFIX%20xsd:%20%3Chttp:%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%20%0APREFIX%20odysseus:%20%3Chttp:%2F%2Fmarmotta.tno.nl:8080%2Fmarmotta%2Fcontext%2F%3E%20%0APREFIX%20cmo:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fcmo%2Fcmo.ttl%23%3E%20%0APREFIX%20depc:%20%3Chttp:%2F%2Fwww.modelservers.org%2Fpublic%2Fontologies%2Fodysseus%2Fdepc.ttl%23%3E%20%0ASELECT%20%3FProfileSignal%20%3Fsignalid%20%3Fvalue%20%3FvalueType%20%3Ftimestamp%20%0AFROM%20odysseus:manchestertest%20%0A%20WHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3FProfileSignal%20a%20depc:ProfileSignal%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:signalID%20%3Fsignalid%20.%20%0A%20%20%20%20%3FProfileSignal%20depc:hasTimePointSignal%20%3Ftps%20.%20%0A%20%20%20%20%3Ftps%20cmo:energy%20%3Fvalue%20.%20%0A%20%23%20%20%20%3Ftps%20depc:timeStamp%20%3Ftimestamp%20.%20%0A%20%20%20%20%7B%20%0A%20%20%20%20%20%20FILTER%20(%3Fsignalid%20%3D%20%221771%22%5E%5Exsd:int).%20%0A%20%20%20%20%7D%20%0A%20%20%20%20bind%20(%22depc:eFlow%22%20as%20%3FvalueType)%20%0A%20%20%7D%20%0A%0A&writer=browse
>
>
>
>
>
> Any idea/hint welcome!
>
> Thx a lot, Michel Bohms/Erwin Somers, TNO
>
>
>
>
>
>
>
>
>
> Dr. ir. H.M. (Michel) Bohms
> Sr. Research Scientist
> Structural Reliability
>
> T +31 (0)88 866 31 07
> M +31 (0)63 038 12 20
> E michel.bohms@tno.nl
>
> Location <http://www.tno.nl/locaties/DTM>
>
>
>
> <http://www.tno.nl/>
>
> This message may contain information that is not intended for you. If you
> are not the addressee or if this message was sent to you by mistake, you
> are requested to inform the sender and delete the message. TNO accepts no
> liability for the content of this e-mail, for the manner in which you use
> it and for damage of any kind resulting from the risks inherent to the
> electronic transmission of messages.
>
>
>



-- 
Sergio Fernández
Partner Technology Manager
Redlink GmbH
m: +43 6602747925
e: sergio.fernandez@redlink.co
w: http://redlink.co