My favorites | Sign in
Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 400: sparql query processing erronous
1 person starred this issue and may be notified of changes. Back to list
 
Reported by joerg.unbehauen, May 11, 2009
Executing certain queries using the sparql query editor or the
index.php/sparql method fails. seems as if this happens while the graphs
uris are inserted into a query. Just passing them to the backing virtuoso
does not yield this problem.



query :

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rev: <http://purl.org/stuff/rev#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bsbm: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT ?productLabel ?offer ?price ?vendor ?vendorTitle ?review ?revTitle 
       ?reviewer ?revName ?rating1 ?rating2
WHERE { 
	<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1> rdfs:label ?productLabel .
    OPTIONAL {
        ?offer bsbm:product
<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1>
.
		?offer bsbm:price ?price .
		?offer bsbm:vendor ?vendor .
		?vendor rdfs:label ?vendorTitle .
        ?vendor bsbm:country <http://downlode.org/rdf/iso-3166/countries#DE> .
        ?offer dc:publisher ?vendor . 
        ?offer bsbm:validTo ?date .
        FILTER (?date >
"2008-06-20T00:00:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> )
    }
    OPTIONAL {
	?review bsbm:reviewFor
<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1>
.
	?review rev:reviewer ?reviewer .
	?reviewer foaf:name ?revName .
	?review dc:title ?revTitle .
    OPTIONAL { ?review bsbm:rating1 ?rating1 . }
    OPTIONAL { ?review bsbm:rating2 ?rating2 . } 
    }
}




the error message, please note the multiple where clauses, this is not the
query inserted.

MalformedQuery: SPARQL Error: [unixODBC][OpenLink][Virtuoso iODBC
Driver][Virtuoso Server]SQ074: Line 41: SP030: SPARQL compiler, line 0:
Only '(' and 'DISTINCT' are allowed after COUNT keyword in SPARQL
expression at 'F' at '' immediately before end of statement (37000)<br
/>Query:  define output:format "RDF/XML" PREFIX rdfs:
<http://www.w3.org/2000/01/rdf-schema#>
PREFIX rev: <http://purl.org/stuff/rev#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX bsbm: <http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/vocabulary/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT ?productLabel ?offer ?price ?vendor ?vendorTitle ?review ?revTitle 
       ?reviewer ?revName ?rating1 ?rating2
WHERE { 
	<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1> rdfs:label ?productLabel .
    OPTIONAL {
        ?offer bsbm:product
<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1>
.
		?offer bsbm:price ?price .
		?offer bsbm:vendor ?vendor .
		?vendor rdfs:label ?vendorTitle .
        ?vendor bsbm:country <http://downlode.org/rdf/iso-3166/count
FROM <http://ns.ontowiki.net/SysOnt/>

FROM <http://localhost/OntoWiki/Config/
FROM <http://klappstuhlclub.de/model>
FROM <http://semantic-web.at/sweet/>
WHERE { 
	<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1> rdfs:label ?productLabel .
    OPTIONAL {
        ?offer bsbm:product
<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1>
.
		?offer bsbm:price ?price .
		?offer bsbm:vendor ?vendor .
		?vendor rdfs:label ?vendorTitle .
        ?vendor bsbm:country <http://downlode.org/rdf/iso-3166/countries#DE> .
        ?offer dc:publisher ?vendor . 
        ?offer bsbm:validTo ?date .
        FILTER (?date >
"2008-06-20T00:00:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> )
    }
    OPTIONAL {
	?review bsbm:reviewFor
<http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer1/Product1>
.
	?review rev:reviewer ?reviewer .
	?reviewer foaf:name ?revName .
	?review dc:title ?revTitle .
    OPTIONAL { ?review bsbm:rating1 ?rating1 . }
    OPTIONAL { ?review bsbm:rating2 ?rating2 . } 
    }
} 
Comment 1 by norman.heino, May 25, 2009
(No comment was entered for this change.)
Status: Accepted
Owner: norman.heino
Comment 2 by sebastian.dietzold, Jun 12, 2009
(No comment was entered for this change.)
Owner: cwei...@cweiske.de
Comment 3 by sebastian.dietzold, Jun 19, 2009
(No comment was entered for this change.)
Status: New
Comment 4 by sebastian.dietzold, Jun 22, 2009
(No comment was entered for this change.)
Labels: Milestone-OntoWiki-0.9
Comment 5 by sebastian.dietzold, Jun 26, 2009
after meeting with netresearch moved to 0.9.5
Labels: Milestone-OntoWiki-0.9.5
Comment 6 by sebastian.dietzold, Oct 01, 2009
(No comment was entered for this change.)
Owner: rollxx
Comment 7 by sebastian.dietzold, Oct 23, 2009
(No comment was entered for this change.)
Labels: Component-QueryProcessor
Sign in to add a comment

Hosted by Google Code