Hi Gerard, On 13-Dec-13 1:40 PM, Kuys, Gerard wrote:
Hi all,I try to do a conversion from a XML-oriented model to something more like RDF(S). At last I think I have found the right approach to do this transformation, however, I cannot check because Virtuoso (Open Source 6.1) does not let me. It returns the message below. I enlarged the values for estimated query time and query execution time in the virtuoso.ini file. What else can I do to make my query work?Thanks for any suggestions! Regards, Gerard Kuys ========= #====>> Virtuoso 42000 Error The estimated execution time 0 (sec) exceeds the limit of 4000000 (sec).
The error indicates "MaxQueryCostEstimationTime" parameter value in the SPARQL ini section is exceeded ( it is in seconds). We would recommend you to increase it ( and then restart the server just in case)
and try again the query. Please let us know if that worked for you. Best Regards, Rumi Kocis
#SPARQL query: PREFIX sioc: <http://rdfs.org/sioc/ns#> PREFIX sysont: <http://ns.ontowiki.net/SysOnt/> PREFIX ns2: <http://data.cbg.nl/a2a#> PREFIX xml: <http://www.w3.org/XML/1998/namespace> PREFIX ns1: <http://Mindbus.nl/A2A#> PREFIX ns0: <http://Mindbus.nl/RecordCollectionA2A#> PREFIX xsi: <http://www.w3.org/2001/XMLSchema-instance#> PREFIX foaf: <http://xmlns.com/foaf/spec/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT (CONCAT(?gebtype, "-", ?gebDatVal, "-", ?persVal) AS ?id) ?gebDatVal ?reltype ?geslVal ?vnaamVal ?anaamVal ?bronID ?archiefNr ?plaatsOnd ?bronsoort ?instellingsnaam WHERE { ?subColl ns1:Event ?geb . ?subColl ns1:Version ?versie . #?geb ns1:EventType ?gebtypeVeld . #?gebtypeVeld rdf:value ?gebtype . #?geb ns1:eid ?eid . ?geb ns1:EventDate ?gebDatumVeld . ?gebDatumVeld ns1:LiteralDate ?gebDatString . ?gebDatString rdf:value ?gebDatVal . ?subColl ns1:Person ?pers . ?pers ns1:pid ?persVal . ?pers ns1:Gender ?gesl . ?gesl rdf:value ?geslVal . ?pers ns1:PersonName ?persNaam . ?persNaam ns1:PersonNameLastName ?anaam . ?anaam rdf:value ?anaamVal . ?persNaam ns1:PersonNameFirstName ?vnaam . ?vnaam rdf:value ?vnaamVal . ?pers ns1:Age ?leeftVeld . OPTIONAL { ?leeftVeld rdf:value ?leeft } ?subColl ns1:RelationEP ?ep . ?ep ns1:EventKeyRef ?gebRef . ?ep ns1:PersonKeyRef ?persRef . ?ep ns1:RelationType ?relRef . ?relRef rdf:value ?reltype . ?gebRef rdf:value ?gebVal . ?persRef rdf:value ?persVal . ?subColl ns1:Source ?bron . ?bron ns1:RecordGUID ?guid . ?guid rdf:value ?guidVal . ?bron ns1:RecordIdentifier ?bronIDVeld . ?bronIDVeld rdf:value ?bronID . ?bron ns1:SourceDate ?bronDatum . ?bronDatum ns1:LiteralDate ?bronDatString . ?bronDatString rdf:value ?bronDatVal . ?bron ns1:SourcePlace ?plaatsVeld . ?plaatsVeld ns1:Place ?plaatsHouder . ?plaatsHouder rdf:value ?plaatsOnd . ?bron ns1:SourceType ?bronsoortVeld . ?bronsoortVeld rdf:value ?bronsoort . ?bron ns1:SourceReference ?bronAanduiding . ?bronAanduiding ns1:Archive ?archief. ?archief rdf:value ?archiefNr . ?bronAanduiding ns1:InstitutionName ?instelling . ?instelling rdf:value ?instellingsnaam . ?bronAanduiding ns1:DocumentNumber ?docNr . ?docNr rdf:value ?documentnummer . ?bronAanduiding ns1:Place ?bewaarplaats . ?bewaarplaats rdf:value ?bewaarplaatsnaam . ?bronAanduiding ns1:RegistryNumber ?bronCodeVeld . ?bronCodeVeld rdf:value ?bronCode . FILTER (?gebtype = "Geboorte") FILTER (?reltype = "Kind") } DisclaimerDit bericht met eventuele bijlagen is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Indien u niet de bedoelde ontvanger bent, wordt u verzocht de afzender te waarschuwen en dit bericht met eventuele bijlagen direct te verwijderen en/of te vernietigen. Het is niet toegestaan dit bericht en eventuele bijlagen te vermenigvuldigen, door te sturen, openbaar te maken, op te slaan of op andere wijze te gebruiken. Ordina N.V. en/of haar groepsmaatschappijen accepteren geen verantwoordelijkheid of aansprakelijkheid voor schade die voortvloeit uit de inhoud en/of de verzending van dit bericht.This e-mail and any attachments are confidential and are solely intended for the addressee. If you are not the intended recipient, please notify the sender and delete and/or destroy this message and any attachments immediately. It is prohibited to copy, to distribute, to disclose or to use this e-mail and any attachments in any other way. Ordina N.V. and/or its group companies do not accept any responsibility nor liability for any damage resulting from the content of and/or the transmission of this message.------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
