openbudgets / rudolf

rudolf is the stepbrother of babbage for RDF datasets
1 stars 0 forks source link

Sparql Query Timeout #20

Closed schmaluk closed 7 years ago

schmaluk commented 7 years ago

Might be related to missing datasets in the triplestore again. Im creating this issue even so, since Im not sure about the rootcause:

php artisan model:load global leads to:

[EasyRdf_Exception]                                                                                                                                                 
  HTTP request for SPARQL query failed: Virtuoso 42000 Error The estimated execution time 998 (sec) exceeds the limit of 600 (sec).                                   
  SPARQL query:                                                                                                                                                       
  PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX qb: <http://purl.org/linked-data/cube#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX xro: <http://purl.org/xro/ns#> 
SELECT DISTINCT ?extensionProperty ?shortName ?dataType ?label WHERE { { 
SELECT DISTINCT ?extensionProperty ?extension WHERE { { 
SELECT ?value WHERE { ?observation a qb:Observation . ?slice qb:observation ?observation ; <http://data.openbudgets.eu/ontology/dsd/bonn-budget/dimension/functionalClassification> ?value . } LIMIT 1 } ?value ?extensionProperty ?extension . } } ?extensionProperty rdfs:label ?label . BIND (datatype(?extension) AS ?dataType) BIND (REPLACE(str(?extensionProperty), '^.*(#|/)', "") AS ?shortName) }                          

If I know whats wrong on my side, I can try to fix it. Thanks