Thanks for the reply. It is good to know the function was not missing. Here is a repost of what I sent to the SMW mailing list.
Turns out I was missing this role on the SPARQL account: GRANT execute on DB.DBA.L_O_LOOK to "SPARQL"; I was able to process the property page after that. I am now running into another error from a particular page but that's a separate issue (two errors in fact - one where a very long page with hundreds of semantic properties results in a SQ query with more than 1000 lines in Virtuoso, and one where the SPARQL query fails because some values in the wiki page are not properly escaped by SMW). - Laurent Alquier On Sun, Aug 9, 2015 at 4:45 PM, Hugh Williams <hwilli...@openlinksw.com> wrote: > > Hi Laurent, > > The “DB.DBA.SPARQL_INSERT_DICT_CONTENT to SPARQL_UPDATE” function is built > into the binary and this not displayed as part for the database schema. > > If as indicated you have performed the require grants for SPARQL_UPDATE > privileges, then please enable tracing on the Virtuoso server to see what > query is being executed that is failing using the “trace_on()” function as > detailed at: > > http://docs.openlinksw.com/virtuoso/fn_trace_on.html > > Best Regards > Hugh Williams > Professional Services > OpenLink Software, Inc. // http://www.openlinksw.com/ > Weblog -- http://www.openlinksw.com/blogs/ > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > Twitter -- http://twitter.com/OpenLink > Google+ -- http://plus.google.com/100570109519069333827/ > Facebook -- http://www.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > On 3 Aug 2015, at 23:37, Laurent Alquier <lalqu...@gmail.com> wrote: > > Hello > > I am troubleshooting an issue as I am trying to connect a Virtuoso > instance to Semantic Mediawiki (latest SMW with Virtuoso Community Edition > 7.2.1 binaries on windows). > > The PHP script to refresh semantic mediawiki properties throws an 'Error > 500: Query refused' on the first SPARQL UPDATE query. > > This seems to be pointing to access control issues. > > I applied recommended roles to the SPARQL account, in particular on > DB.DBA.SPARQL_INSERT_DICT_CONTENT as suggested here: > > > https://github.com/SemanticMediaWiki/SemanticMediaWiki/blob/master/build/travis/virtuoso-sparql-permission.sql > > I tried looking for that procedure in the Database tab of Conductor > (logged in as dba) and I couldn't find it. > > Is it normal this package is missing from the Database tab? > If not, is it part of a package I forgot to install or something I > obviously overlooked? > > -- > - Laurent Alquier > http://www.linfa.net > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > -- - Laurent Alquier http://www.linfa.net
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
