Hi
I am using stardog with a virtual graph to an oracle DB (19.x), with an R2RML mapping. All queries except one that I introduced just now work fine.
The subject map with the query goes like this
rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, SIGNATUR, TITEL, PHYSISCHE_BESCHAFFENHEIT FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND ID_NR NOT IN (SELECT PARENT_ID_NR FROM MVK_OGD_VRZNG_ENHT_1)""" ];
rr:subjectMap [
rr:template "https://ld.example.org/Instantiation/{ID_NR}-i" ;
rr:class rico:Instantiation ;
];
This sql query does work in SQLcli or developer. The log entry in stardog.log is rather long, I'll post it below. The only thing I can see there is an oracle error (ORA-00904: "TRUE": invalid identifier). In my understanding, this refers to faulty column names, but mine are correct.
Anyone looking at this, do you have a clue what could be wrong?
Thanks for helping me out.
ERROR 2022-02-16 14:44:07,590 [stardog-user-5] com.complexible.stardog.QueryManager:exceptionTriggered(543): Error during execution of the query
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rico: <https://www.ica.org/standards/RiC/ontology#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT * {
GRAPH <virtual://scope-virtual> { ?s a rico:Instantiation . }
}
LIMIT 10
with query plan
prefix : <http://api.stardog.com/>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix stardog: <tag:stardog:api:>
From <https://ld.example.org/graph/ais-metadata>
VirtualGraphSql<virtual://scope-virtual> [#10] {
+─ RelNode=
+─ LogicalSort(fetch=[10])
+─ LogicalProject(ID_NR=[$143])
+─ LogicalFilter(condition=[AND(LIKE($145, '00000796390000548575%'), OR(=($160, 0), AND(<>($160, 0), IS NULL($164), >=($161, $160))))])
+─ LogicalJoin(condition=[=($162, $163)], joinType=[left])
+─ LogicalProject(TITEL=[$0], SIGNATUR=[$1], GEBURTSDATUM=[$2], TODESDATUM=[$3], STUFE=[$4], ENTSTEHUNGSZEITRAUM=[$5], DARIN=[$6], BILD_ANSICHT=[$7], FINDHILFSMITTEL=[$8], VE_ZUGANG_LINK=[$9], ERSCHLIESSUNGSGRAD=[$10], ARCHIVALIENART=[$11], FRUEHERE_STABS_SIGNATUR=[$12], ABSPIELDAUER=[$13], ANZAHL=[$14], LAUFMETER=[$15], ENTHAELT=[$16], VE_AKTENBILDNER_LINK=[$17], VE_ABLIEFERUNG_LINK=[$18], AKTENBILDNER_PROVENIENZ_TEXT=[$19], IDENTIFIKATION=[$20], VERWEISE=[$21], INHALT=[$22], KONTEXT=[$23], ORT=[$24], UMFANG=[$25], BEHAELTNISSE=[$26], BEHAELTNISTYP_HOEFLINGER=[$27], BIBLIOTHEKSKATALOG=[$28], VERWALTUNGSGESCHICHTE_BIOGRAFI=[$29], ZEITRAUM_DER_MATERIALZUSAMMENS=[$30], BESTANDSGESCHICHTE=[$31], INHALT_UND_INNERE_ORDNUNG=[$32], NEUZUGAENGE=[$33], ZUGANGS_UND_BENUTZUNGSBEDINGUN=[$34], RECHTSSTATUS=[$35], ZUGANGSBESTIMMUNGEN=[$36], COPYRIGHT_REPORDUKTIONSBESTIMM=[$37], SPRACHE=[$38], SACHVERWANDTE_UNTERLAGEN=[$39], AUFBEWAHRUNGSORT_DER_ORIGINALE=[$40], KOPIEN_BZW_REPRODUKTIONEN=[$41], VERWANDTE_VE_NICHT_IN_SCOPEARC=[$42], VERWANDTES_MATERIAL=[$43], ANMERKUNGEN=[$44], MASSSTAB=[$45], VERFERTIGERIN=[$46], AUSSTELLUNGSDATUM=[$47], UNTERZEICHNERIN=[$48], TECHNIK=[$49], ORIGINALTITEL_AUF_HUELLE=[$50], POSITIV_IN_SCHACHTEL=[$51], AKTEN_ZUM_AUFTRAG=[$52], REPRODUKTION=[$53], ALTE_SIGNATUREN=[$54], FORMAT_DER_UNTERLAGE=[$55], VERFERTIGER_ERSCHLOSSEN=[$56], ORIGINALBEZEICHNUNG=[$57], FORMAT_BILD_PLAN=[$58], ANMERKUNGEN_=[$59], VERTRAGSPARTNER=[$60], VERTRAGSGEGENSTAND=[$61], ARCHIVSIGEL=[$62], WIRKUNGSFELD=[$63], UMFANG_GESCHAETZT=[$64], ENTSTEHUNGSZEIT_SCHWERGEWICHT_=[$65], BEWERTUNG_UND_KASSATION=[$66], VEROEFFENTLICHUNGEN=[$67], PRIORITAETSKLASSE=[$68], DIREKTUEBERNAHME_VON_PROVENIEN=[$69], FORM_UND_INHALT=[$70], ORDNUNG_UND_KLASSIFIKATION=[$71], ENTSTEHUNGSZEITRAUM_STREUDATEN=[$72], FRUEHERE_SIGNATUR=[$73], ARCHIVGESCHICHTE=[$74], LITERATUR_BEST_INSG=[$75], FORMAT_NEGATIV_HOEFLINGER=[$76], NICHT_IDENTIFIZIERT=[$77], REPRO_HOEFLINGER=[$78], AUFNAHMEDATUM=[$79], REVISIONSDATUM=[$80], POSITIV_IN_ZEIGBUCH_NR=[$81], REPRO_NR_HOEFLINGER_=[$82], REPRO_NR_ANDERE=[$83], KOMMENTAR_ZUM_UMFANG=[$84], PHYSISCHE_BESCHAFFENHEIT=[$85], AUFTRAGGEBERIN=[$86], FORMAT_FOTONEGATIV=[$87], AUFNAHMERICHTUNG=[$88], AUFNAHMEHOEHE=[$89], VE_BEI_PROVENIENZSTELLE_VORHAN=[$90], VE_IM_ARCHIV_VORHANDEN=[$91], IMMATRIKULATIONSNUMMER_FLUGZEU=[$92], TYPENBEZEICHNUNG_FLUGZEUG=[$93], EINGANGSNUMMER_PLANARCHIV=[$94], EINGANGSNUMMER_PLANARCHIV_ZUSA=[$95], INHALT_=[$96], PHYSISCHE_BESCHREIBUNG=[$97], BESCHREIBSTOFF=[$98], FARBE_BILDBEARBEITUNG=[$99], HAUSNAME=[$100], EIGENTUEMER_1862=[$101], ALTE_HAUSNUMMER=[$102], ENTSTEHUNGSSTUFE=[$103], FORMALBEGRIFF_HOEFLINGER=[$104], REPRO=[$105], FORMAT_FOTO_BILD=[$106], TECHNIK_PLANARCHIV=[$107], ENTSTEHUNGSSTUFE_AUSWAHLLISTE=[$108], FORM_DER_DARSTELLUNG_AUSWAHLLI=[$109], WEBLINK=[$110], SIEGEL=[$111], VERMERK=[$112], SCHLAGWORT=[$113], AUTOR=[$114], EMPFAENGER=[$115], DOKUMENTART=[$116], GATTUNG=[$117], AV_MEDIUM=[$118], KONTROLLE=[$119], FORMAT_FILM=[$120], ABSPIELGESCHWINDIGKEIT=[$121], TRAEGERMATERIAL=[$122], BILDFORMAT_FILM=[$123], DIGITALISIERUNG=[$124], DIGITALISIERUNGSQUALITAET=[$125], FORMAT_VIDEO=[$126], ORIGINALDATIERUNG=[$127], AKTENZEICHEN=[$128], BEARBEITER_IN=[$129], FORMAT_TON=[$130], FILMELEMENT=[$131], CODIERUNG=[$132], DIGITALISAT=[$133], BENUTZUNGSHINWEIS=[$134], DIGITALISAT_VORHANDEN=[$135], GESCHICHTE=[$136], ORGANISATIONSZUGEHOERIGKEIT=[$137], DATENVOLUMEN_MB=[$138], ANZAHL_DATEIEN=[$139], FUNKTION_UND_AKTIVITAET=[$140], ALLGEMEINER_KONTEXT=[$141], VERWALTUNGSGESCHICHTE=[$142], ID_NR=[$143], PARENT_ID_NR=[$144], HIERARCHIE_PFAD=[$145], SCHUTZFRISTENDE=[$146], BASISDATUM_NM=[$147], BASISDATUM_ID=[$148], SCHUTZFRISTDAUER=[$149], BEWILLIGUNG_NM=[$150], BEWILLIGUNG_ID=[$151], PHYSISCHE_BENUETZBARKEIT_NM=[$152], PHYSISCHE_BENUETZBARKEIT_ID=[$153], ZUGAENGLICHKEIT_NM=[$154], ZUGAENGLICHKEIT_ID=[$155], SCHUTZFRISTKATEGORIE_NM=[$156], SCHUTZFRISTKATEGORIE_ID=[$157], ANZEIGEFORMULAR_NM=[$158], ANZEIGEFORMULAR_ID=[$159], $f0=[$160], $f1=[$161], ID_NR0=[$143])
+─ LogicalJoin(condition=[true], joinType=[inner])
+─ JdbcTableScan(table=[[WSD_STABS_SCP_ARCHIV_DBA, MVK_OGD_VRZNG_ENHT_1]])
+─ LogicalAggregate(group=[{}], agg#0=[COUNT()], agg#1=[COUNT($0)])
+─ LogicalProject(PARENT_ID_NR=[$144], $f1=[true])
+─ JdbcTableScan(table=[[WSD_STABS_SCP_ARCHIV_DBA, MVK_OGD_VRZNG_ENHT_1]])
+─ LogicalAggregate(group=[{0}], agg#0=[MIN($1)])
+─ LogicalProject(PARENT_ID_NR=[$144], $f1=[true])
+─ JdbcTableScan(table=[[WSD_STABS_SCP_ARCHIV_DBA, MVK_OGD_VRZNG_ENHT_1]])
+─ Query=
+─ SELECT "t1"."ID_NR"
+─ FROM (SELECT "MVK_OGD_VRZNG_ENHT_1"."TITEL", "MVK_OGD_VRZNG_ENHT_1"."SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."GEBURTSDATUM", "MVK_OGD_VRZNG_ENHT_1"."TODESDATUM", "MVK_OGD_VRZNG_ENHT_1"."STUFE", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEITRAUM", "MVK_OGD_VRZNG_ENHT_1"."DARIN", "MVK_OGD_VRZNG_ENHT_1"."BILD_ANSICHT", "MVK_OGD_VRZNG_ENHT_1"."FINDHILFSMITTEL", "MVK_OGD_VRZNG_ENHT_1"."VE_ZUGANG_LINK", "MVK_OGD_VRZNG_ENHT_1"."ERSCHLIESSUNGSGRAD", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVALIENART", "MVK_OGD_VRZNG_ENHT_1"."FRUEHERE_STABS_SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."ABSPIELDAUER", "MVK_OGD_VRZNG_ENHT_1"."ANZAHL", "MVK_OGD_VRZNG_ENHT_1"."LAUFMETER", "MVK_OGD_VRZNG_ENHT_1"."ENTHAELT", "MVK_OGD_VRZNG_ENHT_1"."VE_AKTENBILDNER_LINK", "MVK_OGD_VRZNG_ENHT_1"."VE_ABLIEFERUNG_LINK", "MVK_OGD_VRZNG_ENHT_1"."AKTENBILDNER_PROVENIENZ_TEXT", "MVK_OGD_VRZNG_ENHT_1"."IDENTIFIKATION", "MVK_OGD_VRZNG_ENHT_1"."VERWEISE", "MVK_OGD_VRZNG_ENHT_1"."INHALT", "MVK_OGD_VRZNG_ENHT_1"."KONTEXT", "MVK_OGD_VRZNG_ENHT_1"."ORT", "MVK_OGD_VRZNG_ENHT_1"."UMFANG", "MVK_OGD_VRZNG_ENHT_1"."BEHAELTNISSE", "MVK_OGD_VRZNG_ENHT_1"."BEHAELTNISTYP_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."BIBLIOTHEKSKATALOG", "MVK_OGD_VRZNG_ENHT_1"."VERWALTUNGSGESCHICHTE_BIOGRAFI", "MVK_OGD_VRZNG_ENHT_1"."ZEITRAUM_DER_MATERIALZUSAMMENS", "MVK_OGD_VRZNG_ENHT_1"."BESTANDSGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."INHALT_UND_INNERE_ORDNUNG", "MVK_OGD_VRZNG_ENHT_1"."NEUZUGAENGE", "MVK_OGD_VRZNG_ENHT_1"."ZUGANGS_UND_BENUTZUNGSBEDINGUN", "MVK_OGD_VRZNG_ENHT_1"."RECHTSSTATUS", "MVK_OGD_VRZNG_ENHT_1"."ZUGANGSBESTIMMUNGEN", "MVK_OGD_VRZNG_ENHT_1"."COPYRIGHT_REPORDUKTIONSBESTIMM", "MVK_OGD_VRZNG_ENHT_1"."SPRACHE", "MVK_OGD_VRZNG_ENHT_1"."SACHVERWANDTE_UNTERLAGEN", "MVK_OGD_VRZNG_ENHT_1"."AUFBEWAHRUNGSORT_DER_ORIGINALE", "MVK_OGD_VRZNG_ENHT_1"."KOPIEN_BZW_REPRODUKTIONEN", "MVK_OGD_VRZNG_ENHT_1"."VERWANDTE_VE_NICHT_IN_SCOPEARC", "MVK_OGD_VRZNG_ENHT_1"."VERWANDTES_MATERIAL", "MVK_OGD_VRZNG_ENHT_1"."ANMERKUNGEN", "MVK_OGD_VRZNG_ENHT_1"."MASSSTAB", "MVK_OGD_VRZNG_ENHT_1"."VERFERTIGERIN", "MVK_OGD_VRZNG_ENHT_1"."AUSSTELLUNGSDATUM", "MVK_OGD_VRZNG_ENHT_1"."UNTERZEICHNERIN", "MVK_OGD_VRZNG_ENHT_1"."TECHNIK", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALTITEL_AUF_HUELLE", "MVK_OGD_VRZNG_ENHT_1"."POSITIV_IN_SCHACHTEL", "MVK_OGD_VRZNG_ENHT_1"."AKTEN_ZUM_AUFTRAG", "MVK_OGD_VRZNG_ENHT_1"."REPRODUKTION", "MVK_OGD_VRZNG_ENHT_1"."ALTE_SIGNATUREN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_DER_UNTERLAGE", "MVK_OGD_VRZNG_ENHT_1"."VERFERTIGER_ERSCHLOSSEN", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALBEZEICHNUNG", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_BILD_PLAN", "MVK_OGD_VRZNG_ENHT_1"."ANMERKUNGEN_", "MVK_OGD_VRZNG_ENHT_1"."VERTRAGSPARTNER", "MVK_OGD_VRZNG_ENHT_1"."VERTRAGSGEGENSTAND", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVSIGEL", "MVK_OGD_VRZNG_ENHT_1"."WIRKUNGSFELD", "MVK_OGD_VRZNG_ENHT_1"."UMFANG_GESCHAETZT", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEIT_SCHWERGEWICHT_", "MVK_OGD_VRZNG_ENHT_1"."BEWERTUNG_UND_KASSATION", "MVK_OGD_VRZNG_ENHT_1"."VEROEFFENTLICHUNGEN", "MVK_OGD_VRZNG_ENHT_1"."PRIORITAETSKLASSE", "MVK_OGD_VRZNG_ENHT_1"."DIREKTUEBERNAHME_VON_PROVENIEN", "MVK_OGD_VRZNG_ENHT_1"."FORM_UND_INHALT", "MVK_OGD_VRZNG_ENHT_1"."ORDNUNG_UND_KLASSIFIKATION", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEITRAUM_STREUDATEN", "MVK_OGD_VRZNG_ENHT_1"."FRUEHERE_SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."LITERATUR_BEST_INSG", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_NEGATIV_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."NICHT_IDENTIFIZIERT", "MVK_OGD_VRZNG_ENHT_1"."REPRO_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMEDATUM", "MVK_OGD_VRZNG_ENHT_1"."REVISIONSDATUM", "MVK_OGD_VRZNG_ENHT_1"."POSITIV_IN_ZEIGBUCH_NR", "MVK_OGD_VRZNG_ENHT_1"."REPRO_NR_HOEFLINGER_", "MVK_OGD_VRZNG_ENHT_1"."REPRO_NR_ANDERE", "MVK_OGD_VRZNG_ENHT_1"."KOMMENTAR_ZUM_UMFANG", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BESCHAFFENHEIT", "MVK_OGD_VRZNG_ENHT_1"."AUFTRAGGEBERIN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FOTONEGATIV", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMERICHTUNG", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMEHOEHE", "MVK_OGD_VRZNG_ENHT_1"."VE_BEI_PROVENIENZSTELLE_VORHAN", "MVK_OGD_VRZNG_ENHT_1"."VE_IM_ARCHIV_VORHANDEN", "MVK_OGD_VRZNG_ENHT_1"."IMMATRIKULATIONSNUMMER_FLUGZEU", "MVK_OGD_VRZNG_ENHT_1"."TYPENBEZEICHNUNG_FLUGZEUG", "MVK_OGD_VRZNG_ENHT_1"."EINGANGSNUMMER_PLANARCHIV", "MVK_OGD_VRZNG_ENHT_1"."EINGANGSNUMMER_PLANARCHIV_ZUSA", "MVK_OGD_VRZNG_ENHT_1"."INHALT_", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BESCHREIBUNG", "MVK_OGD_VRZNG_ENHT_1"."BESCHREIBSTOFF", "MVK_OGD_VRZNG_ENHT_1"."FARBE_BILDBEARBEITUNG", "MVK_OGD_VRZNG_ENHT_1"."HAUSNAME", "MVK_OGD_VRZNG_ENHT_1"."EIGENTUEMER_1862", "MVK_OGD_VRZNG_ENHT_1"."ALTE_HAUSNUMMER", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSSTUFE", "MVK_OGD_VRZNG_ENHT_1"."FORMALBEGRIFF_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."REPRO", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FOTO_BILD", "MVK_OGD_VRZNG_ENHT_1"."TECHNIK_PLANARCHIV", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSSTUFE_AUSWAHLLISTE", "MVK_OGD_VRZNG_ENHT_1"."FORM_DER_DARSTELLUNG_AUSWAHLLI", "MVK_OGD_VRZNG_ENHT_1"."WEBLINK", "MVK_OGD_VRZNG_ENHT_1"."SIEGEL", "MVK_OGD_VRZNG_ENHT_1"."VERMERK", "MVK_OGD_VRZNG_ENHT_1"."SCHLAGWORT", "MVK_OGD_VRZNG_ENHT_1"."AUTOR", "MVK_OGD_VRZNG_ENHT_1"."EMPFAENGER", "MVK_OGD_VRZNG_ENHT_1"."DOKUMENTART", "MVK_OGD_VRZNG_ENHT_1"."GATTUNG", "MVK_OGD_VRZNG_ENHT_1"."AV_MEDIUM", "MVK_OGD_VRZNG_ENHT_1"."KONTROLLE", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FILM", "MVK_OGD_VRZNG_ENHT_1"."ABSPIELGESCHWINDIGKEIT", "MVK_OGD_VRZNG_ENHT_1"."TRAEGERMATERIAL", "MVK_OGD_VRZNG_ENHT_1"."BILDFORMAT_FILM", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISIERUNG", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISIERUNGSQUALITAET", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_VIDEO", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALDATIERUNG", "MVK_OGD_VRZNG_ENHT_1"."AKTENZEICHEN", "MVK_OGD_VRZNG_ENHT_1"."BEARBEITER_IN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_TON", "MVK_OGD_VRZNG_ENHT_1"."FILMELEMENT", "MVK_OGD_VRZNG_ENHT_1"."CODIERUNG", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISAT", "MVK_OGD_VRZNG_ENHT_1"."BENUTZUNGSHINWEIS", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISAT_VORHANDEN", "MVK_OGD_VRZNG_ENHT_1"."GESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."ORGANISATIONSZUGEHOERIGKEIT", "MVK_OGD_VRZNG_ENHT_1"."DATENVOLUMEN_MB", "MVK_OGD_VRZNG_ENHT_1"."ANZAHL_DATEIEN", "MVK_OGD_VRZNG_ENHT_1"."FUNKTION_UND_AKTIVITAET", "MVK_OGD_VRZNG_ENHT_1"."ALLGEMEINER_KONTEXT", "MVK_OGD_VRZNG_ENHT_1"."VERWALTUNGSGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."ID_NR", "MVK_OGD_VRZNG_ENHT_1"."PARENT_ID_NR", "MVK_OGD_VRZNG_ENHT_1"."HIERARCHIE_PFAD", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTENDE", "MVK_OGD_VRZNG_ENHT_1"."BASISDATUM_NM", "MVK_OGD_VRZNG_ENHT_1"."BASISDATUM_ID", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTDAUER", "MVK_OGD_VRZNG_ENHT_1"."BEWILLIGUNG_NM", "MVK_OGD_VRZNG_ENHT_1"."BEWILLIGUNG_ID", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BENUETZBARKEIT_NM", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BENUETZBARKEIT_ID", "MVK_OGD_VRZNG_ENHT_1"."ZUGAENGLICHKEIT_NM", "MVK_OGD_VRZNG_ENHT_1"."ZUGAENGLICHKEIT_ID", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTKATEGORIE_NM", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTKATEGORIE_ID", "MVK_OGD_VRZNG_ENHT_1"."ANZEIGEFORMULAR_NM", "MVK_OGD_VRZNG_ENHT_1"."ANZEIGEFORMULAR_ID", "t0"."$f0", "t0"."$f1", "MVK_OGD_VRZNG_ENHT_1"."ID_NR" "ID_NR0"
+─ FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1",
+─ (SELECT COUNT(*) "$f0", COUNT("PARENT_ID_NR") "$f1"
+─ FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1" "MVK_OGD_VRZNG_ENHT_10") "t0") "t1"
+─ LEFT JOIN (SELECT "PARENT_ID_NR", MIN(TRUE) "$f1"
+─ FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1" "MVK_OGD_VRZNG_ENHT_11"
+─ GROUP BY "PARENT_ID_NR") "t3" ON "t1"."ID_NR0" = "t3"."PARENT_ID_NR"
+─ WHERE "t1"."HIERARCHIE_PFAD" LIKE '00000796390000548575%' AND ("t1"."$f0" = 0 OR "t1"."$f0" <> 0 AND ("t3"."$f1" IS NULL AND "t1"."$f1" >= "t1"."$f0"))
+─ FETCH NEXT 10 ROWS ONLY
+─ Vars=
+─ ?s <- TEMPLATE(https://ld.example.org/Instantiation/{ID_NR/0}-i)
}
against database ais-dev
com.complexible.stardog.plan.eval.operator.OperatorException: Unable to execute virtual graph query. SQL string: SELECT "t1"."ID_NR"
FROM (SELECT "MVK_OGD_VRZNG_ENHT_1"."TITEL", "MVK_OGD_VRZNG_ENHT_1"."SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."GEBURTSDATUM", "MVK_OGD_VRZNG_ENHT_1"."TODESDATUM", "MVK_OGD_VRZNG_ENHT_1"."STUFE", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEITRAUM", "MVK_OGD_VRZNG_ENHT_1"."DARIN", "MVK_OGD_VRZNG_ENHT_1"."BILD_ANSICHT", "MVK_OGD_VRZNG_ENHT_1"."FINDHILFSMITTEL", "MVK_OGD_VRZNG_ENHT_1"."VE_ZUGANG_LINK", "MVK_OGD_VRZNG_ENHT_1"."ERSCHLIESSUNGSGRAD", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVALIENART", "MVK_OGD_VRZNG_ENHT_1"."FRUEHERE_STABS_SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."ABSPIELDAUER", "MVK_OGD_VRZNG_ENHT_1"."ANZAHL", "MVK_OGD_VRZNG_ENHT_1"."LAUFMETER", "MVK_OGD_VRZNG_ENHT_1"."ENTHAELT", "MVK_OGD_VRZNG_ENHT_1"."VE_AKTENBILDNER_LINK", "MVK_OGD_VRZNG_ENHT_1"."VE_ABLIEFERUNG_LINK", "MVK_OGD_VRZNG_ENHT_1"."AKTENBILDNER_PROVENIENZ_TEXT", "MVK_OGD_VRZNG_ENHT_1"."IDENTIFIKATION", "MVK_OGD_VRZNG_ENHT_1"."VERWEISE", "MVK_OGD_VRZNG_ENHT_1"."INHALT", "MVK_OGD_VRZNG_ENHT_1"."KONTEXT", "MVK_OGD_VRZNG_ENHT_1"."ORT", "MVK_OGD_VRZNG_ENHT_1"."UMFANG", "MVK_OGD_VRZNG_ENHT_1"."BEHAELTNISSE", "MVK_OGD_VRZNG_ENHT_1"."BEHAELTNISTYP_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."BIBLIOTHEKSKATALOG", "MVK_OGD_VRZNG_ENHT_1"."VERWALTUNGSGESCHICHTE_BIOGRAFI", "MVK_OGD_VRZNG_ENHT_1"."ZEITRAUM_DER_MATERIALZUSAMMENS", "MVK_OGD_VRZNG_ENHT_1"."BESTANDSGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."INHALT_UND_INNERE_ORDNUNG", "MVK_OGD_VRZNG_ENHT_1"."NEUZUGAENGE", "MVK_OGD_VRZNG_ENHT_1"."ZUGANGS_UND_BENUTZUNGSBEDINGUN", "MVK_OGD_VRZNG_ENHT_1"."RECHTSSTATUS", "MVK_OGD_VRZNG_ENHT_1"."ZUGANGSBESTIMMUNGEN", "MVK_OGD_VRZNG_ENHT_1"."COPYRIGHT_REPORDUKTIONSBESTIMM", "MVK_OGD_VRZNG_ENHT_1"."SPRACHE", "MVK_OGD_VRZNG_ENHT_1"."SACHVERWANDTE_UNTERLAGEN", "MVK_OGD_VRZNG_ENHT_1"."AUFBEWAHRUNGSORT_DER_ORIGINALE", "MVK_OGD_VRZNG_ENHT_1"."KOPIEN_BZW_REPRODUKTIONEN", "MVK_OGD_VRZNG_ENHT_1"."VERWANDTE_VE_NICHT_IN_SCOPEARC", "MVK_OGD_VRZNG_ENHT_1"."VERWANDTES_MATERIAL", "MVK_OGD_VRZNG_ENHT_1"."ANMERKUNGEN", "MVK_OGD_VRZNG_ENHT_1"."MASSSTAB", "MVK_OGD_VRZNG_ENHT_1"."VERFERTIGERIN", "MVK_OGD_VRZNG_ENHT_1"."AUSSTELLUNGSDATUM", "MVK_OGD_VRZNG_ENHT_1"."UNTERZEICHNERIN", "MVK_OGD_VRZNG_ENHT_1"."TECHNIK", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALTITEL_AUF_HUELLE", "MVK_OGD_VRZNG_ENHT_1"."POSITIV_IN_SCHACHTEL", "MVK_OGD_VRZNG_ENHT_1"."AKTEN_ZUM_AUFTRAG", "MVK_OGD_VRZNG_ENHT_1"."REPRODUKTION", "MVK_OGD_VRZNG_ENHT_1"."ALTE_SIGNATUREN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_DER_UNTERLAGE", "MVK_OGD_VRZNG_ENHT_1"."VERFERTIGER_ERSCHLOSSEN", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALBEZEICHNUNG", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_BILD_PLAN", "MVK_OGD_VRZNG_ENHT_1"."ANMERKUNGEN_", "MVK_OGD_VRZNG_ENHT_1"."VERTRAGSPARTNER", "MVK_OGD_VRZNG_ENHT_1"."VERTRAGSGEGENSTAND", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVSIGEL", "MVK_OGD_VRZNG_ENHT_1"."WIRKUNGSFELD", "MVK_OGD_VRZNG_ENHT_1"."UMFANG_GESCHAETZT", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEIT_SCHWERGEWICHT_", "MVK_OGD_VRZNG_ENHT_1"."BEWERTUNG_UND_KASSATION", "MVK_OGD_VRZNG_ENHT_1"."VEROEFFENTLICHUNGEN", "MVK_OGD_VRZNG_ENHT_1"."PRIORITAETSKLASSE", "MVK_OGD_VRZNG_ENHT_1"."DIREKTUEBERNAHME_VON_PROVENIEN", "MVK_OGD_VRZNG_ENHT_1"."FORM_UND_INHALT", "MVK_OGD_VRZNG_ENHT_1"."ORDNUNG_UND_KLASSIFIKATION", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEITRAUM_STREUDATEN", "MVK_OGD_VRZNG_ENHT_1"."FRUEHERE_SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."LITERATUR_BEST_INSG", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_NEGATIV_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."NICHT_IDENTIFIZIERT", "MVK_OGD_VRZNG_ENHT_1"."REPRO_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMEDATUM", "MVK_OGD_VRZNG_ENHT_1"."REVISIONSDATUM", "MVK_OGD_VRZNG_ENHT_1"."POSITIV_IN_ZEIGBUCH_NR", "MVK_OGD_VRZNG_ENHT_1"."REPRO_NR_HOEFLINGER_", "MVK_OGD_VRZNG_ENHT_1"."REPRO_NR_ANDERE", "MVK_OGD_VRZNG_ENHT_1"."KOMMENTAR_ZUM_UMFANG", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BESCHAFFENHEIT", "MVK_OGD_VRZNG_ENHT_1"."AUFTRAGGEBERIN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FOTONEGATIV", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMERICHTUNG", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMEHOEHE", "MVK_OGD_VRZNG_ENHT_1"."VE_BEI_PROVENIENZSTELLE_VORHAN", "MVK_OGD_VRZNG_ENHT_1"."VE_IM_ARCHIV_VORHANDEN", "MVK_OGD_VRZNG_ENHT_1"."IMMATRIKULATIONSNUMMER_FLUGZEU", "MVK_OGD_VRZNG_ENHT_1"."TYPENBEZEICHNUNG_FLUGZEUG", "MVK_OGD_VRZNG_ENHT_1"."EINGANGSNUMMER_PLANARCHIV", "MVK_OGD_VRZNG_ENHT_1"."EINGANGSNUMMER_PLANARCHIV_ZUSA", "MVK_OGD_VRZNG_ENHT_1"."INHALT_", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BESCHREIBUNG", "MVK_OGD_VRZNG_ENHT_1"."BESCHREIBSTOFF", "MVK_OGD_VRZNG_ENHT_1"."FARBE_BILDBEARBEITUNG", "MVK_OGD_VRZNG_ENHT_1"."HAUSNAME", "MVK_OGD_VRZNG_ENHT_1"."EIGENTUEMER_1862", "MVK_OGD_VRZNG_ENHT_1"."ALTE_HAUSNUMMER", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSSTUFE", "MVK_OGD_VRZNG_ENHT_1"."FORMALBEGRIFF_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."REPRO", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FOTO_BILD", "MVK_OGD_VRZNG_ENHT_1"."TECHNIK_PLANARCHIV", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSSTUFE_AUSWAHLLISTE", "MVK_OGD_VRZNG_ENHT_1"."FORM_DER_DARSTELLUNG_AUSWAHLLI", "MVK_OGD_VRZNG_ENHT_1"."WEBLINK", "MVK_OGD_VRZNG_ENHT_1"."SIEGEL", "MVK_OGD_VRZNG_ENHT_1"."VERMERK", "MVK_OGD_VRZNG_ENHT_1"."SCHLAGWORT", "MVK_OGD_VRZNG_ENHT_1"."AUTOR", "MVK_OGD_VRZNG_ENHT_1"."EMPFAENGER", "MVK_OGD_VRZNG_ENHT_1"."DOKUMENTART", "MVK_OGD_VRZNG_ENHT_1"."GATTUNG", "MVK_OGD_VRZNG_ENHT_1"."AV_MEDIUM", "MVK_OGD_VRZNG_ENHT_1"."KONTROLLE", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FILM", "MVK_OGD_VRZNG_ENHT_1"."ABSPIELGESCHWINDIGKEIT", "MVK_OGD_VRZNG_ENHT_1"."TRAEGERMATERIAL", "MVK_OGD_VRZNG_ENHT_1"."BILDFORMAT_FILM", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISIERUNG", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISIERUNGSQUALITAET", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_VIDEO", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALDATIERUNG", "MVK_OGD_VRZNG_ENHT_1"."AKTENZEICHEN", "MVK_OGD_VRZNG_ENHT_1"."BEARBEITER_IN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_TON", "MVK_OGD_VRZNG_ENHT_1"."FILMELEMENT", "MVK_OGD_VRZNG_ENHT_1"."CODIERUNG", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISAT", "MVK_OGD_VRZNG_ENHT_1"."BENUTZUNGSHINWEIS", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISAT_VORHANDEN", "MVK_OGD_VRZNG_ENHT_1"."GESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."ORGANISATIONSZUGEHOERIGKEIT", "MVK_OGD_VRZNG_ENHT_1"."DATENVOLUMEN_MB", "MVK_OGD_VRZNG_ENHT_1"."ANZAHL_DATEIEN", "MVK_OGD_VRZNG_ENHT_1"."FUNKTION_UND_AKTIVITAET", "MVK_OGD_VRZNG_ENHT_1"."ALLGEMEINER_KONTEXT", "MVK_OGD_VRZNG_ENHT_1"."VERWALTUNGSGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."ID_NR", "MVK_OGD_VRZNG_ENHT_1"."PARENT_ID_NR", "MVK_OGD_VRZNG_ENHT_1"."HIERARCHIE_PFAD", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTENDE", "MVK_OGD_VRZNG_ENHT_1"."BASISDATUM_NM", "MVK_OGD_VRZNG_ENHT_1"."BASISDATUM_ID", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTDAUER", "MVK_OGD_VRZNG_ENHT_1"."BEWILLIGUNG_NM", "MVK_OGD_VRZNG_ENHT_1"."BEWILLIGUNG_ID", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BENUETZBARKEIT_NM", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BENUETZBARKEIT_ID", "MVK_OGD_VRZNG_ENHT_1"."ZUGAENGLICHKEIT_NM", "MVK_OGD_VRZNG_ENHT_1"."ZUGAENGLICHKEIT_ID", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTKATEGORIE_NM", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTKATEGORIE_ID", "MVK_OGD_VRZNG_ENHT_1"."ANZEIGEFORMULAR_NM", "MVK_OGD_VRZNG_ENHT_1"."ANZEIGEFORMULAR_ID", "t0"."$f0", "t0"."$f1", "MVK_OGD_VRZNG_ENHT_1"."ID_NR" "ID_NR0"
FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1",
(SELECT COUNT(*) "$f0", COUNT("PARENT_ID_NR") "$f1"
FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1" "MVK_OGD_VRZNG_ENHT_10") "t0") "t1"
LEFT JOIN (SELECT "PARENT_ID_NR", MIN(TRUE) "$f1"
FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1" "MVK_OGD_VRZNG_ENHT_11"
GROUP BY "PARENT_ID_NR") "t3" ON "t1"."ID_NR0" = "t3"."PARENT_ID_NR"
WHERE "t1"."HIERARCHIE_PFAD" LIKE '00000796390000548575%' AND ("t1"."$f0" = 0 OR "t1"."$f0" <> 0 AND ("t3"."$f1" IS NULL AND "t1"."$f1" >= "t1"."$f0"))
FETCH NEXT 10 ROWS ONLY
at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:114) ~[stardog-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:30) ~[stardog-7.7.3.jar:?]
at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.7.3.jar:?]
at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.util.AutoCloseOperator.computeNext(AutoCloseOperator.java:139) ~[stardog-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.util.AutoCloseOperator.computeNext(AutoCloseOperator.java:27) ~[stardog-7.7.3.jar:?]
at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.7.3.jar:?]
at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.util.OpBasedBindingSetIteration.computeNext(OpBasedBindingSetIteration.java:117) ~[stardog-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.util.OpBasedBindingSetIteration.computeNext(OpBasedBindingSetIteration.java:38) ~[stardog-7.7.3.jar:?]
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-30.1.1-jre.jar:?]
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-30.1.1-jre.jar:?]
at com.complexible.common.base.CloseableIterator$2.computeNext(CloseableIterator.java:84) ~[stardog-utils-common-7.7.3.jar:?]
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-30.1.1-jre.jar:?]
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-30.1.1-jre.jar:?]
at com.complexible.common.rdf.query.IteratorAsTupleQueryResult.computeNext(IteratorAsTupleQueryResult.java:98) ~[stardog-utils-rdf-7.7.3.jar:?]
at com.complexible.common.rdf.query.IteratorAsTupleQueryResult.computeNext(IteratorAsTupleQueryResult.java:24) ~[stardog-utils-rdf-7.7.3.jar:?]
at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-30.1.1-jre.jar:?]
at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-30.1.1-jre.jar:?]
at com.stardog.stark.query.ClosingSpliterator.forEachRemaining(ClosingSpliterator.java:37) ~[stardog-stark-query-api-7.7.3.jar:?]
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
at com.stardog.stark.query.io.QueryResultWriters.write(QueryResultWriters.java:140) ~[stardog-stark-query-io-7.7.3.jar:?]
at com.stardog.stark.query.io.QueryResultWriters.write(QueryResultWriters.java:126) ~[stardog-stark-query-io-7.7.3.jar:?]
at com.complexible.stardog.protocols.http.server.ProtocolUtils.writeTupleResponse(ProtocolUtils.java:728) ~[stardog-protocols-http-server-7.7.3.jar:?]
at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:620) ~[stardog-protocols-http-server-7.7.3.jar:?]
at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:589) ~[stardog-protocols-http-server-7.7.3.jar:?]
at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:547) ~[stardog-protocols-http-server-7.7.3.jar:?]
at com.complexible.stardog.protocols.http.server.SPARQLProtocol.executeQuery(SPARQLProtocol.java:238) ~[stardog-protocols-http-server-7.7.3.jar:?]
at com.complexible.stardog.protocols.http.server.SPARQLProtocol.post(SPARQLProtocol.java:162) ~[stardog-protocols-http-server-7.7.3.jar:?]
at com.stardog.http.server.undertow.jaxrs.ExtractRoutes.lambda$handleIt$5(ExtractRoutes.java:192) ~[stardog-protocols-http-server-7.7.3.jar:?]
at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120) [shiro-core-1.7.1.jar:1.7.1]
at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108) [shiro-core-1.7.1.jar:1.7.1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: com.complexible.stardog.StardogException: Unable to execute virtual graph query. SQL string: SELECT "t1"."ID_NR"
FROM (SELECT "MVK_OGD_VRZNG_ENHT_1"."TITEL", "MVK_OGD_VRZNG_ENHT_1"."SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."GEBURTSDATUM", "MVK_OGD_VRZNG_ENHT_1"."TODESDATUM", "MVK_OGD_VRZNG_ENHT_1"."STUFE", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEITRAUM", "MVK_OGD_VRZNG_ENHT_1"."DARIN", "MVK_OGD_VRZNG_ENHT_1"."BILD_ANSICHT", "MVK_OGD_VRZNG_ENHT_1"."FINDHILFSMITTEL", "MVK_OGD_VRZNG_ENHT_1"."VE_ZUGANG_LINK", "MVK_OGD_VRZNG_ENHT_1"."ERSCHLIESSUNGSGRAD", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVALIENART", "MVK_OGD_VRZNG_ENHT_1"."FRUEHERE_STABS_SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."ABSPIELDAUER", "MVK_OGD_VRZNG_ENHT_1"."ANZAHL", "MVK_OGD_VRZNG_ENHT_1"."LAUFMETER", "MVK_OGD_VRZNG_ENHT_1"."ENTHAELT", "MVK_OGD_VRZNG_ENHT_1"."VE_AKTENBILDNER_LINK", "MVK_OGD_VRZNG_ENHT_1"."VE_ABLIEFERUNG_LINK", "MVK_OGD_VRZNG_ENHT_1"."AKTENBILDNER_PROVENIENZ_TEXT", "MVK_OGD_VRZNG_ENHT_1"."IDENTIFIKATION", "MVK_OGD_VRZNG_ENHT_1"."VERWEISE", "MVK_OGD_VRZNG_ENHT_1"."INHALT", "MVK_OGD_VRZNG_ENHT_1"."KONTEXT", "MVK_OGD_VRZNG_ENHT_1"."ORT", "MVK_OGD_VRZNG_ENHT_1"."UMFANG", "MVK_OGD_VRZNG_ENHT_1"."BEHAELTNISSE", "MVK_OGD_VRZNG_ENHT_1"."BEHAELTNISTYP_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."BIBLIOTHEKSKATALOG", "MVK_OGD_VRZNG_ENHT_1"."VERWALTUNGSGESCHICHTE_BIOGRAFI", "MVK_OGD_VRZNG_ENHT_1"."ZEITRAUM_DER_MATERIALZUSAMMENS", "MVK_OGD_VRZNG_ENHT_1"."BESTANDSGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."INHALT_UND_INNERE_ORDNUNG", "MVK_OGD_VRZNG_ENHT_1"."NEUZUGAENGE", "MVK_OGD_VRZNG_ENHT_1"."ZUGANGS_UND_BENUTZUNGSBEDINGUN", "MVK_OGD_VRZNG_ENHT_1"."RECHTSSTATUS", "MVK_OGD_VRZNG_ENHT_1"."ZUGANGSBESTIMMUNGEN", "MVK_OGD_VRZNG_ENHT_1"."COPYRIGHT_REPORDUKTIONSBESTIMM", "MVK_OGD_VRZNG_ENHT_1"."SPRACHE", "MVK_OGD_VRZNG_ENHT_1"."SACHVERWANDTE_UNTERLAGEN", "MVK_OGD_VRZNG_ENHT_1"."AUFBEWAHRUNGSORT_DER_ORIGINALE", "MVK_OGD_VRZNG_ENHT_1"."KOPIEN_BZW_REPRODUKTIONEN", "MVK_OGD_VRZNG_ENHT_1"."VERWANDTE_VE_NICHT_IN_SCOPEARC", "MVK_OGD_VRZNG_ENHT_1"."VERWANDTES_MATERIAL", "MVK_OGD_VRZNG_ENHT_1"."ANMERKUNGEN", "MVK_OGD_VRZNG_ENHT_1"."MASSSTAB", "MVK_OGD_VRZNG_ENHT_1"."VERFERTIGERIN", "MVK_OGD_VRZNG_ENHT_1"."AUSSTELLUNGSDATUM", "MVK_OGD_VRZNG_ENHT_1"."UNTERZEICHNERIN", "MVK_OGD_VRZNG_ENHT_1"."TECHNIK", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALTITEL_AUF_HUELLE", "MVK_OGD_VRZNG_ENHT_1"."POSITIV_IN_SCHACHTEL", "MVK_OGD_VRZNG_ENHT_1"."AKTEN_ZUM_AUFTRAG", "MVK_OGD_VRZNG_ENHT_1"."REPRODUKTION", "MVK_OGD_VRZNG_ENHT_1"."ALTE_SIGNATUREN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_DER_UNTERLAGE", "MVK_OGD_VRZNG_ENHT_1"."VERFERTIGER_ERSCHLOSSEN", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALBEZEICHNUNG", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_BILD_PLAN", "MVK_OGD_VRZNG_ENHT_1"."ANMERKUNGEN_", "MVK_OGD_VRZNG_ENHT_1"."VERTRAGSPARTNER", "MVK_OGD_VRZNG_ENHT_1"."VERTRAGSGEGENSTAND", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVSIGEL", "MVK_OGD_VRZNG_ENHT_1"."WIRKUNGSFELD", "MVK_OGD_VRZNG_ENHT_1"."UMFANG_GESCHAETZT", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEIT_SCHWERGEWICHT_", "MVK_OGD_VRZNG_ENHT_1"."BEWERTUNG_UND_KASSATION", "MVK_OGD_VRZNG_ENHT_1"."VEROEFFENTLICHUNGEN", "MVK_OGD_VRZNG_ENHT_1"."PRIORITAETSKLASSE", "MVK_OGD_VRZNG_ENHT_1"."DIREKTUEBERNAHME_VON_PROVENIEN", "MVK_OGD_VRZNG_ENHT_1"."FORM_UND_INHALT", "MVK_OGD_VRZNG_ENHT_1"."ORDNUNG_UND_KLASSIFIKATION", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSZEITRAUM_STREUDATEN", "MVK_OGD_VRZNG_ENHT_1"."FRUEHERE_SIGNATUR", "MVK_OGD_VRZNG_ENHT_1"."ARCHIVGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."LITERATUR_BEST_INSG", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_NEGATIV_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."NICHT_IDENTIFIZIERT", "MVK_OGD_VRZNG_ENHT_1"."REPRO_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMEDATUM", "MVK_OGD_VRZNG_ENHT_1"."REVISIONSDATUM", "MVK_OGD_VRZNG_ENHT_1"."POSITIV_IN_ZEIGBUCH_NR", "MVK_OGD_VRZNG_ENHT_1"."REPRO_NR_HOEFLINGER_", "MVK_OGD_VRZNG_ENHT_1"."REPRO_NR_ANDERE", "MVK_OGD_VRZNG_ENHT_1"."KOMMENTAR_ZUM_UMFANG", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BESCHAFFENHEIT", "MVK_OGD_VRZNG_ENHT_1"."AUFTRAGGEBERIN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FOTONEGATIV", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMERICHTUNG", "MVK_OGD_VRZNG_ENHT_1"."AUFNAHMEHOEHE", "MVK_OGD_VRZNG_ENHT_1"."VE_BEI_PROVENIENZSTELLE_VORHAN", "MVK_OGD_VRZNG_ENHT_1"."VE_IM_ARCHIV_VORHANDEN", "MVK_OGD_VRZNG_ENHT_1"."IMMATRIKULATIONSNUMMER_FLUGZEU", "MVK_OGD_VRZNG_ENHT_1"."TYPENBEZEICHNUNG_FLUGZEUG", "MVK_OGD_VRZNG_ENHT_1"."EINGANGSNUMMER_PLANARCHIV", "MVK_OGD_VRZNG_ENHT_1"."EINGANGSNUMMER_PLANARCHIV_ZUSA", "MVK_OGD_VRZNG_ENHT_1"."INHALT_", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BESCHREIBUNG", "MVK_OGD_VRZNG_ENHT_1"."BESCHREIBSTOFF", "MVK_OGD_VRZNG_ENHT_1"."FARBE_BILDBEARBEITUNG", "MVK_OGD_VRZNG_ENHT_1"."HAUSNAME", "MVK_OGD_VRZNG_ENHT_1"."EIGENTUEMER_1862", "MVK_OGD_VRZNG_ENHT_1"."ALTE_HAUSNUMMER", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSSTUFE", "MVK_OGD_VRZNG_ENHT_1"."FORMALBEGRIFF_HOEFLINGER", "MVK_OGD_VRZNG_ENHT_1"."REPRO", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FOTO_BILD", "MVK_OGD_VRZNG_ENHT_1"."TECHNIK_PLANARCHIV", "MVK_OGD_VRZNG_ENHT_1"."ENTSTEHUNGSSTUFE_AUSWAHLLISTE", "MVK_OGD_VRZNG_ENHT_1"."FORM_DER_DARSTELLUNG_AUSWAHLLI", "MVK_OGD_VRZNG_ENHT_1"."WEBLINK", "MVK_OGD_VRZNG_ENHT_1"."SIEGEL", "MVK_OGD_VRZNG_ENHT_1"."VERMERK", "MVK_OGD_VRZNG_ENHT_1"."SCHLAGWORT", "MVK_OGD_VRZNG_ENHT_1"."AUTOR", "MVK_OGD_VRZNG_ENHT_1"."EMPFAENGER", "MVK_OGD_VRZNG_ENHT_1"."DOKUMENTART", "MVK_OGD_VRZNG_ENHT_1"."GATTUNG", "MVK_OGD_VRZNG_ENHT_1"."AV_MEDIUM", "MVK_OGD_VRZNG_ENHT_1"."KONTROLLE", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_FILM", "MVK_OGD_VRZNG_ENHT_1"."ABSPIELGESCHWINDIGKEIT", "MVK_OGD_VRZNG_ENHT_1"."TRAEGERMATERIAL", "MVK_OGD_VRZNG_ENHT_1"."BILDFORMAT_FILM", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISIERUNG", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISIERUNGSQUALITAET", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_VIDEO", "MVK_OGD_VRZNG_ENHT_1"."ORIGINALDATIERUNG", "MVK_OGD_VRZNG_ENHT_1"."AKTENZEICHEN", "MVK_OGD_VRZNG_ENHT_1"."BEARBEITER_IN", "MVK_OGD_VRZNG_ENHT_1"."FORMAT_TON", "MVK_OGD_VRZNG_ENHT_1"."FILMELEMENT", "MVK_OGD_VRZNG_ENHT_1"."CODIERUNG", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISAT", "MVK_OGD_VRZNG_ENHT_1"."BENUTZUNGSHINWEIS", "MVK_OGD_VRZNG_ENHT_1"."DIGITALISAT_VORHANDEN", "MVK_OGD_VRZNG_ENHT_1"."GESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."ORGANISATIONSZUGEHOERIGKEIT", "MVK_OGD_VRZNG_ENHT_1"."DATENVOLUMEN_MB", "MVK_OGD_VRZNG_ENHT_1"."ANZAHL_DATEIEN", "MVK_OGD_VRZNG_ENHT_1"."FUNKTION_UND_AKTIVITAET", "MVK_OGD_VRZNG_ENHT_1"."ALLGEMEINER_KONTEXT", "MVK_OGD_VRZNG_ENHT_1"."VERWALTUNGSGESCHICHTE", "MVK_OGD_VRZNG_ENHT_1"."ID_NR", "MVK_OGD_VRZNG_ENHT_1"."PARENT_ID_NR", "MVK_OGD_VRZNG_ENHT_1"."HIERARCHIE_PFAD", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTENDE", "MVK_OGD_VRZNG_ENHT_1"."BASISDATUM_NM", "MVK_OGD_VRZNG_ENHT_1"."BASISDATUM_ID", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTDAUER", "MVK_OGD_VRZNG_ENHT_1"."BEWILLIGUNG_NM", "MVK_OGD_VRZNG_ENHT_1"."BEWILLIGUNG_ID", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BENUETZBARKEIT_NM", "MVK_OGD_VRZNG_ENHT_1"."PHYSISCHE_BENUETZBARKEIT_ID", "MVK_OGD_VRZNG_ENHT_1"."ZUGAENGLICHKEIT_NM", "MVK_OGD_VRZNG_ENHT_1"."ZUGAENGLICHKEIT_ID", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTKATEGORIE_NM", "MVK_OGD_VRZNG_ENHT_1"."SCHUTZFRISTKATEGORIE_ID", "MVK_OGD_VRZNG_ENHT_1"."ANZEIGEFORMULAR_NM", "MVK_OGD_VRZNG_ENHT_1"."ANZEIGEFORMULAR_ID", "t0"."$f0", "t0"."$f1", "MVK_OGD_VRZNG_ENHT_1"."ID_NR" "ID_NR0"
FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1",
(SELECT COUNT(*) "$f0", COUNT("PARENT_ID_NR") "$f1"
FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1" "MVK_OGD_VRZNG_ENHT_10") "t0") "t1"
LEFT JOIN (SELECT "PARENT_ID_NR", MIN(TRUE) "$f1"
FROM "WSD_STABS_SCP_ARCHIV_DBA"."MVK_OGD_VRZNG_ENHT_1" "MVK_OGD_VRZNG_ENHT_11"
GROUP BY "PARENT_ID_NR") "t3" ON "t1"."ID_NR0" = "t3"."PARENT_ID_NR"
WHERE "t1"."HIERARCHIE_PFAD" LIKE '00000796390000548575%' AND ("t1"."$f0" = 0 OR "t1"."$f0" <> 0 AND ("t3"."$f1" IS NULL AND "t1"."$f1" >= "t1"."$f0"))
FETCH NEXT 10 ROWS ONLY
at com.complexible.stardog.virtual.vega.rdbms.RdbmsRelExecutor.lambda$execute$0(RdbmsRelExecutor.java:61) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.rdbms.RdbmsRelExecutor$1.getResult(RdbmsRelExecutor.java:107) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.VirtualServiceQuery.execute(VirtualServiceQuery.java:237) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.VirtualServiceQuery.evaluate(VirtualServiceQuery.java:259) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:100) ~[stardog-7.7.3.jar:?]
... 34 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-9.0.43.jar:?]
at com.sun.proxy.$Proxy231.executeQuery(Unknown Source) ~[?:?]
at com.complexible.stardog.virtual.vega.rdbms.RdbmsRelExecutor$1.getResult(RdbmsRelExecutor.java:89) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.VirtualServiceQuery.execute(VirtualServiceQuery.java:237) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.VirtualServiceQuery.evaluate(VirtualServiceQuery.java:259) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:100) ~[stardog-7.7.3.jar:?]
... 34 more
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: "TRUE": invalid identifier
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369) ~[ojdbc10-19.12.0.0.jar:19.12.0.0.0]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-9.0.43.jar:?]
at com.sun.proxy.$Proxy231.executeQuery(Unknown Source) ~[?:?]
at com.complexible.stardog.virtual.vega.rdbms.RdbmsRelExecutor$1.getResult(RdbmsRelExecutor.java:89) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.VirtualServiceQuery.execute(VirtualServiceQuery.java:237) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.virtual.vega.VirtualServiceQuery.evaluate(VirtualServiceQuery.java:259) ~[stardog-virtual-core-7.7.3.jar:?]
at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:100) ~[stardog-7.7.3.jar:?]
... 34 more