On 2/9/17 11:15 AM, Beppe Mazzola wrote: > 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.
This is a known issue that has been resolved in a newer release.
Expect an update to the develop branch (if using the open source
edition) in the coming week.
We also making a commercial edition maintenance release that fixes this
issue too.
Regards,
Kingsley
>
>
> SQL> DB.DBA.OVL_VALIDATE ('http://temp/testR2RML',
> 'http://www.w3.org/ns/r2rml#OVL-nosuch'
> <http://www.w3.org/ns/r2rml#OVL-nosuch%27>);
> 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/
> <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/schemas/virtrdf#DefaultQuadStorage
> <http://www.openlinksw.com/schemas/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
> <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
> <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' <http://www.w3.org/ns/r2rml#OVL%27>);
> 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'
> <http://www.w3.org/ns/r2rml#OVL-nosuch%27>);
> 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}
> <http://test.com/semantic_webgate/dataset/pesticides/resource/substanceLang-%7BSUBSTANCES_LNG_ID%7D>
> nodeID://b39745
>
> http://www.w3.org/ns/r2rml#template
>
> http://test.com/semantic_webgate/dataset/pesticides/resource/substance-{SUBSTANCES_ID}
> <http://test.com/semantic_webgate/dataset/pesticides/resource/substance-%7BSUBSTANCES_ID%7D>
> nodeID://b39769
>
> http://www.w3.org/ns/r2rml#template
>
> http://test.com/semantic_webgate/dataset/pesticides/resource/substance-{SUBSTANCES_ID}
> <http://test.com/semantic_webgate/dataset/pesticides/resource/substance-%7BSUBSTANCES_ID%7D>
> 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
--
Regards,
Kingsley Idehen
Founder & CEO
OpenLink Software (Home Page: http://www.openlinksw.com)
Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen
Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen
Web Identities (WebID):
Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
:
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ 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
