Difference between revisions of "S440.01 nl"

From wikibase-docker
S440.01 nl
Jump to navigation Jump to search
Line 16: Line 16:
 
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
 
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
 
     BIND(IRI(REPLACE(?LinkNL, '^(.+)$', ?LinkNL)) AS ?LinkNL).
 
     BIND(IRI(REPLACE(?LinkNL, '^(.+)$', ?LinkNL)) AS ?LinkNL).
     BIND(IF(BOUND(?LinkNL), IRI(REPLACE(?LinkNL, "\\$", ?LinkNL)) , ?_value) AS ?value)
+
     concat("[",?LinkNL," Test]".
 
     ?Dist wdt:P308 ?Code .
 
     ?Dist wdt:P308 ?Code .
 
     ?Dist wdt:P307  ?Grootte .
 
     ?Dist wdt:P307  ?Grootte .

Revision as of 12:19, 6 April 2023

Sorry, the SPARQL server sent an error. (see details with parameter log=2)

Error #sparql :Error query  : PREFIX wd: <http://external-wikibase-statbel-wikibase/entity/>
PREFIX wdt: <http://external-wikibase-statbel-wikibase/prop/direct/>
PREFIX p: <http://external-wikibase-statbel-wikibase/prop/>
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/>
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/>
SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?LinkNL ?OpmerkingLabel
WHERE
{
     ?Dataset wdt:P1 wd:Q2624 .
     ?Dataset wdt:P299 wd:Q11945 .
     ?Dataset wdt:P303 ?Jaar .  
     ?Dataset wdt:P311 ?Nummer .
     ?Dataset wdt:P305 ?Dist .
     OPTIONAL {?Dataset wdt:P56 ?Opmerking .}
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
     BIND(IRI(REPLACE(?LinkNL, '^(. )$', ?LinkNL)) AS ?LinkNL).
     concat("[",?LinkNL," Test]".
     ?Dist wdt:P308 ?Code .
     ?Dist wdt:P307  ?Grootte .
     ?Dist wdt:P54  ?Taal .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
ORDER BY ASC(?JaarLabel) ASC(?Nummer)
Error endpoint: https://wdqs-new-wikibase-statbel-external.aks-prod.internal.economie.fgov.be/proxy/wdqs/bigdata/namespace/wdq/sparql
Error http_response_code: 400
Error message: SPARQL-QUERY: queryStr=PREFIX wd: <http://external-wikibase-statbel-wikibase/entity/>
PREFIX wdt: <http://external-wikibase-statbel-wikibase/prop/direct/>
PREFIX p: <http://external-wikibase-statbel-wikibase/prop/>
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/>
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/>
SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?LinkNL ?OpmerkingLabel
WHERE
{
     ?Dataset wdt:P1 wd:Q2624 .
     ?Dataset wdt:P299 wd:Q11945 .
     ?Dataset wdt:P303 ?Jaar .  
     ?Dataset wdt:P311 ?Nummer .
     ?Dataset wdt:P305 ?Dist .
     OPTIONAL {?Dataset wdt:P56 ?Opmerking .}
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
     BIND(IRI(REPLACE(?LinkNL, '^(. )$', ?LinkNL)) AS ?LinkNL).
     concat("[",?LinkNL," Test]".
     ?Dist wdt:P308 ?Code .
     ?Dist wdt:P307  ?Grootte .
     ?Dist wdt:P54  ?Taal .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
ORDER BY ASC(?JaarLabel) ASC(?Nummer)
java.util.concurrent.ExecutionException: org.openrdf.query.MalformedQueryException: Encountered " "concat" "concat "" at line 17, column 6.
Was expecting one of:
    "(" ...
    "{" ...
    "}" ...
    "[" ...
    <NIL> ...
    <ANON> ...
    "optional" ...
    "graph" ...
    "minus" ...
    "filter" ...
    "true" ...
    "false" ...
    "bind" ...
    "service" ...
    "values" ...
    "include" ...
    "let" ...
    "<<" ...
    <Q_IRI_REF> ...
    <PNAME_NS> ...
    <PNAME_LN> ...
    <BLANK_NODE_LABEL> ...
    <VAR1> ...
    <VAR2> ...
    <INTEGER> ...
    <INTEGER_POSITIVE> ...
    <INTEGER_NEGATIVE> ...
    <DECIMAL> ...
    <DECIMAL_POSITIVE> ...
    <DECIMAL_NEGATIVE> ...
    <DOUBLE> ...
    <DOUBLE_POSITIVE> ...
    <DOUBLE_NEGATIVE> ...
    <STRING_LITERAL1> ...
    <STRING_LITERAL2> ...
    <STRING_LITERAL_LONG1> ...
    <STRING_LITERAL_LONG2> ...
    
	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.util.concurrent.FutureTask.get(FutureTask.java:206)
	at com.bigdata.rdf.sail.webapp.BigdataServlet.submitApiTask(BigdataServlet.java:292)
	at com.bigdata.rdf.sail.webapp.QueryServlet.doSparqlQuery(QueryServlet.java:678)
	at com.bigdata.rdf.sail.webapp.QueryServlet.doPost(QueryServlet.java:275)
	at com.bigdata.rdf.sail.webapp.RESTServlet.doPost(RESTServlet.java:269)
	at com.bigdata.rdf.sail.webapp.MultiTenancyServlet.doPost(MultiTenancyServlet.java:195)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
	at org.wikidata.query.rdf.blazegraph.throttling.ThrottlingFilter.doFilter(ThrottlingFilter.java:320)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
	at org.wikidata.query.rdf.blazegraph.throttling.SystemOverloadFilter.doFilter(SystemOverloadFilter.java:82)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
	at ch.qos.logback.classic.helpers.MDCInsertingServletFilter.doFilter(MDCInsertingServletFilter.java:49)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
	at org.wikidata.query.rdf.blazegraph.filters.QueryEventSenderFilter.doFilter(QueryEventSenderFilter.java:93)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
	at org.wikidata.query.rdf.blazegraph.filters.ClientIPFilter.doFilter(ClientIPFilter.java:43)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
	at org.wikidata.query.rdf.blazegraph.filters.RealAgentFilter.doFilter(RealAgentFilter.java:33)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1340)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1242)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
	at org.eclipse.jetty.server.Server.handle(Server.java:503)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:364)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.openrdf.query.MalformedQueryException: Encountered " "concat" "concat "" at line 17, column 6.
Was expecting one of:
    "(" ...
    "{" ...
    "}" ...
    "[" ...
    <NIL> ...
    <ANON> ...
    "optional" ...
    "graph" ...
    "minus" ...
    "filter" ...
    "true" ...
    "false" ...
    "bind" ...
    "service" ...
    "values" ...
    "include" ...
    "let" ...
    "<<" ...
    <Q_IRI_REF> ...
    <PNAME_NS> ...
    <PNAME_LN> ...
    <BLANK_NODE_LABEL> ...
    <VAR1> ...
    <VAR2> ...
    <INTEGER> ...
    <INTEGER_POSITIVE> ...
    <INTEGER_NEGATIVE> ...
    <DECIMAL> ...
    <DECIMAL_POSITIVE> ...
    <DECIMAL_NEGATIVE> ...
    <DOUBLE> ...
    <DOUBLE_POSITIVE> ...
    <DOUBLE_NEGATIVE> ...
    <STRING_LITERAL1> ...
    <STRING_LITERAL2> ...
    <STRING_LITERAL_LONG1> ...
    <STRING_LITERAL_LONG2> ...
    
	at com.bigdata.rdf.sail.sparql.Bigdata2ASTSPARQLParser.parseQuery2(Bigdata2ASTSPARQLParser.java:400)
	at com.bigdata.rdf.sail.webapp.QueryServlet$SparqlQueryTask.call(QueryServlet.java:741)
	at com.bigdata.rdf.sail.webapp.QueryServlet$SparqlQueryTask.call(QueryServlet.java:695)
	at com.bigdata.rdf.task.ApiTaskForIndexManager.call(ApiTaskForIndexManager.java:68)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	... 1 more
Caused by: com.bigdata.rdf.sail.sparql.ast.ParseException: Encountered " "concat" "concat "" at line 17, column 6.
Was expecting one of:
    "(" ...
    "{" ...
    "}" ...
    "[" ...
    <NIL> ...
    <ANON> ...
    "optional" ...
    "graph" ...
    "minus" ...
    "filter" ...
    "true" ...
    "false" ...
    "bind" ...
    "service" ...
    "values" ...
    "include" ...
    "let" ...
    "<<" ...
    <Q_IRI_REF> ...
    <PNAME_NS> ...
    <PNAME_LN> ...
    <BLANK_NODE_LABEL> ...
    <VAR1> ...
    <VAR2> ...
    <INTEGER> ...
    <INTEGER_POSITIVE> ...
    <INTEGER_NEGATIVE> ...
    <DECIMAL> ...
    <DECIMAL_POSITIVE> ...
    <DECIMAL_NEGATIVE> ...
    <DOUBLE> ...
    <DOUBLE_POSITIVE> ...
    <DOUBLE_NEGATIVE> ...
    <STRING_LITERAL1> ...
    <STRING_LITERAL2> ...
    <STRING_LITERAL_LONG1> ...
    <STRING_LITERAL_LONG2> ...
    
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.generateParseException(SyntaxTreeBuilder.java:9722)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.jj_consume_token(SyntaxTreeBuilder.java:9589)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.GroupGraphPattern(SyntaxTreeBuilder.java:1971)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.WhereClause(SyntaxTreeBuilder.java:1013)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.SelectQuery(SyntaxTreeBuilder.java:377)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.Query(SyntaxTreeBuilder.java:328)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.QueryContainer(SyntaxTreeBuilder.java:216)
	at com.bigdata.rdf.sail.sparql.ast.SyntaxTreeBuilder.parseQuery(SyntaxTreeBuilder.java:32)
	at com.bigdata.rdf.sail.sparql.Bigdata2ASTSPARQLParser.parseQuery2(Bigdata2ASTSPARQLParser.java:336)
	... 7 more

Error number: 0
Error message: 

Error data: Array
(
    [query] => PREFIX wd: <http://external-wikibase-statbel-wikibase/entity/>
PREFIX wdt: <http://external-wikibase-statbel-wikibase/prop/direct/>
PREFIX p: <http://external-wikibase-statbel-wikibase/prop/>
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/>
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/>
SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?LinkNL ?OpmerkingLabel
WHERE
{
     ?Dataset wdt:P1 wd:Q2624 .
     ?Dataset wdt:P299 wd:Q11945 .
     ?Dataset wdt:P303 ?Jaar .  
     ?Dataset wdt:P311 ?Nummer .
     ?Dataset wdt:P305 ?Dist .
     OPTIONAL {?Dataset wdt:P56 ?Opmerking .}
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
     BIND(IRI(REPLACE(?LinkNL, '^(. )$', ?LinkNL)) AS ?LinkNL).
     concat("[",?LinkNL," Test]".
     ?Dist wdt:P308 ?Code .
     ?Dist wdt:P307  ?Grootte .
     ?Dist wdt:P54  ?Taal .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
ORDER BY ASC(?JaarLabel) ASC(?Nummer)
    [output] => xml
    [Accept] => application/sparql-results+xml
)