Hi to all again
I have the following problem. When I try to validate my R2RML script in my
Virtuoso installation I get the following error.
SQL> DB.DBA.OVL_VALIDATE ('http://temp/testR2RML', '
http://www.w3.org/ns/r2rml#OVL-nosuch');
SUBJ SEVERITY MESSAGE
VARCHAR VARCHAR VARCHAR
_______________________________________________________________________________
NULL Error Nothing to validate, graph <http://temp/testR2RML> is
totally empty
NULL Info There may be more errors but the validation is interrupted
The R2RML graph 'http://temp/testR2RML' is of course not empty. It contains
59 triples. At the e-mail bottom there is its content.
I tried the R2RML example basic.sql provided by OpenLink Software in
http://docs.openlinksw.com/virtuoso/r2rmlhow/
and the error issued is the same.
SQL> load ./bin/basic.sql;
Connected to OpenLink Virtuoso
Driver: 07.20.3217 OpenLink Virtuoso ODBC Driver
Done. -- 26 msec.
Done. -- 1 msec.
Done. -- 3 msec.
Done. -- 1 msec.
Done. -- 5 msec.
STATE MESSAGE
VARCHAR VARCHAR
____________________________________________________________
___________________
00000 IRI class <r2rml:virt02-cd094728ae072cd2cc3245397877e360> has been
defined (inherited from rdfdf:sql-integer-uri-nullable)
00000 Literal class <r2rml:virt02-6fb9323fc3b6ca1f11fba499de44d6a8> has
been defined (inherited from rdfdf:sql-integer-literal-nullable)
00000 Quad storage <http://www.openlinksw.com/sch
emas/virtrdf#DefaultQuadStorage> is flagged as being edited
00000 Quad map <http://temp/product> has been created and added to the <
http://www.openlinksw.com/schemas/virtrdf#DefaultQuadStorage>
00000 Quad map <http://temp/product> has been created and added to the <
http://www.openlinksw.com/schemas/virtrdf#DefaultQuadStorage>
22023 No table "R2RML"."TEST"."PRODUCT" (alias tbl0) in database, please
check spelling and character case
00000 Reloading built-in metadata, this might fix some errors without
accurate reporting that they did exist
00000 Built-in metadata were reloaded (2475 triples)
00000 Metadata from system graph are cached in memory-resident JSOs
(JavaScript Objects)
9 Rows. -- 497 msec.
s p o
VARCHAR VARCHAR VARCHAR
____________________________________________________________
___________________
0 Rows. -- 1 msec.
SQL>
SQL>
SQL> DB.DBA.OVL_VALIDATE ('http://temp/product-nosuch', '
http://www.w3.org/ns/r2rml#OVL');
SUBJ SEVERITY MESSAGE
VARCHAR VARCHAR VARCHAR
____________________________________________________________
___________________
NULL Error Nothing to validate, graph <http://temp/product-nosuch>
is totally empty
NULL Info There may be more errors but the validation is interrupted
2 Rows. -- 7 msec.
SQL> DB.DBA.OVL_VALIDATE ('http://temp/product', '
http://www.w3.org/ns/r2rml#OVL-nosuch');
SUBJ SEVERITY MESSAGE
VARCHAR VARCHAR VARCHAR
____________________________________________________________
___________________
NULL Error Nothing to validate, graph <http://temp/product> is
totally empty
NULL Info There may be more errors but the validation is interrupted
2 Rows. -- 7 msec.
SQL> SPARQL SELECT count(*) from <http://temp/product> WHERE {?s ?p ?o};
callret-0
INTEGER
____________________________________________________________
___________________
17
1 Rows. -- 4 msec.
The example basic.sql has a further error 'No table "R2RML"."TEST"."PRODUCT"
' despite the table does exist, but in my understanding it should not
affect the validation of the R2RML graph.
Furthermore, the example uses the graph 'http://temp/product-nosuch' that
does not exists in my triple store. But even with http://temp/product the
result is the same.
I execute ISQL with the following command.
./bin/isql 1111 test test
where test is a dba user
There is something wrong but I do not know what... something missing in the
tripleMaps?
Thanks!
Cheers
Beppe
----------------------------------
SQL> SPARQL SELECT * FROM <http://temp/testR2RML> WHERE {?s ?p ?o};
s
p
o
LONG
VARCHAR
LONG
VARCHAR
LONG VARCHAR
_______________________________________________________________________________
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/ns/r2rml#TriplesMap
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
http://www.w3.org/1999/02/22-rdf-syntax-ns#type
http://www.w3.org/ns/r2rml#TriplesMap
nodeID://b39746
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39748
nodeID://b39749
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39751
nodeID://b39752
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39754
nodeID://b39755
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39757
nodeID://b39761
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39763
nodeID://b39764
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39766
nodeID://b39767
http://www.w3.org/ns/r2rml#objectMap
nodeID://b39769
nodeID://b39758
http://www.w3.org/ns/r2rml#child
SUBSTANCES_ID
nodeID://b39745
http://www.w3.org/ns/r2rml#class
http://test.com/semantic_webgate/dataset/pesticides/resource/Substance
nodeID://b39760
http://www.w3.org/ns/r2rml#class
http://test.com/semantic_webgate/dataset/pesticides/resource/SubstanceLang
nodeID://b39751
http://www.w3.org/ns/r2rml#column
SUBSTANCES_CODE
nodeID://b39748
http://www.w3.org/ns/r2rml#column
SUBSTANCES_ID
nodeID://b39763
http://www.w3.org/ns/r2rml#column
SUBSTANCES_LNG_ID
nodeID://b39754
http://www.w3.org/ns/r2rml#column
SUBSTANCES_MEMBEROF
nodeID://b39766
http://www.w3.org/ns/r2rml#column
SUBSTANCES_NAME
nodeID://b39765
http://www.w3.org/ns/r2rml#constant
http://www.w3.org/2000/01/rdf-schema#label
nodeID://b39750
http://www.w3.org/ns/r2rml#constant
http://test.com/semantic_webgate/dataset/pesticides/resource/substanceCode
nodeID://b39747
http://www.w3.org/ns/r2rml#constant
http://test.com/semantic_webgate/dataset/pesticides/resource/substanceId
nodeID://b39762
http://www.w3.org/ns/r2rml#constant
http://test.com/semantic_webgate/dataset/pesticides/resource/substanceLangId
nodeID://b39753
http://www.w3.org/ns/r2rml#constant
http://test.com/semantic_webgate/dataset/pesticides/resource/substance_memberof
nodeID://b39756
http://www.w3.org/ns/r2rml#constant
http://test.com/semantic_webgate/dataset/pesticides/resource/substance_of_substanceLang
nodeID://b39768
http://www.w3.org/ns/r2rml#constant
http://test.com/semantic_webgate/dataset/pesticides/resource/substanceLang_has_substance
nodeID://b39745
http://www.w3.org/ns/r2rml#graph
http://test.com/semantic_webgate/dataset/pesticides/resource
nodeID://b39760
http://www.w3.org/ns/r2rml#graph
http://test.com/semantic_webgate/dataset/pesticides/resource
nodeID://b39757
http://www.w3.org/ns/r2rml#joinCondition
nodeID://b39758
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/ns/r2rml#logicalTable
nodeID://b39744
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
http://www.w3.org/ns/r2rml#logicalTable
nodeID://b39759
nodeID://b39758
http://www.w3.org/ns/r2rml#parent
SUBSTANCES_ID
nodeID://b39757
http://www.w3.org/ns/r2rml#parentTriplesMap
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
nodeID://b39746
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39747
nodeID://b39749
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39750
nodeID://b39752
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39753
nodeID://b39755
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39756
nodeID://b39761
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39762
nodeID://b39764
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39765
nodeID://b39767
http://www.w3.org/ns/r2rml#predicateMap
nodeID://b39768
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39746
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39749
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39752
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39755
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39761
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39764
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
http://www.w3.org/ns/r2rml#predicateObjectMap
nodeID://b39767
http://temp/testR2RML#TriplesMapSUBSTANCES
http://www.w3.org/ns/r2rml#subjectMap
nodeID://b39745
http://temp/testR2RML#TriplesMapSUBSTANCES_LANG
http://www.w3.org/ns/r2rml#subjectMap
nodeID://b39760
nodeID://b39744
http://www.w3.org/ns/r2rml#tableName
SUBSTANCES
nodeID://b39759
http://www.w3.org/ns/r2rml#tableName
SUBSTANCES_LANG
nodeID://b39744
http://www.w3.org/ns/r2rml#tableOwner
test
nodeID://b39759
http://www.w3.org/ns/r2rml#tableOwner
test
nodeID://b39744
http://www.w3.org/ns/r2rml#tableSchema
DB
nodeID://b39759
http://www.w3.org/ns/r2rml#tableSchema
DB
nodeID://b39760
http://www.w3.org/ns/r2rml#template
http://test.com/semantic_webgate/dataset/pesticides/resource/substanceLang-{SUBSTANCES_LNG_ID}
nodeID://b39745
http://www.w3.org/ns/r2rml#template
http://test.com/semantic_webgate/dataset/pesticides/resource/substance-{SUBSTANCES_ID}
nodeID://b39769
http://www.w3.org/ns/r2rml#template
http://test.com/semantic_webgate/dataset/pesticides/resource/substance-{SUBSTANCES_ID}
nodeID://b39745
http://www.w3.org/ns/r2rml#termType
http://www.w3.org/ns/r2rml#IRI
nodeID://b39760
http://www.w3.org/ns/r2rml#termType
http://www.w3.org/ns/r2rml#IRI
nodeID://b39769
http://www.w3.org/ns/r2rml#termType
http://www.w3.org/ns/r2rml#IRI
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
