Hi Hugh,
I suspected that the solution was to grant execute for this function, but
just in case...I granted this privilege to 'SPARQL' user and now i have the
typical message:
Virtuoso S1T00 Error SR171: Transaction timed out
basically, the query i am trying to perform is something like:
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX ...
INSERT
{
GRAPH <http://example.cat>
{
?s a vocab:sth .
?sth foaf:name ?name .
}
GRAPH ?anotherGraph
{
_:bn foaf:name "case" .
}
}
USING <http://source.cat>
WHERE
{
?s foaf:name ?name .
BIND(iri(concat(str(?sth),"_",str(?name))) as ?s)
BIND(iri(concat(str(?s),"_data")) as ?anotherGraph)
}
2014/1/21 Hugh Williams <hwilli...@openlinksw.com>
> Hi Núria,
>
> As for the other function you should be able to grant execute ... to get
> around this:
>
> GRANT EXECUTE ON DB.DBA.L_O_LOOK TO "SPARQL"
>
> We have had a report of this error before and is should have been fixed,
> thus can you please confirm the steps, you performed to get this error and
> confirm the version and build date of the Virtuoso server being used
> (virtuoso-t -? ) ...
>
>
The steps were:
1. Installation of Virtuoso server from develop/7 branch in github
2. Loading our rdf data into the triple store without problems
3. Query the prior query in the Virtuoso sparql endpoint
4. An the following error message come up:
Virtuoso 42000 Error SR186: No permission to execute procedure
DB.DBA.SPARQL_INSERT_QUAD_DICT_CONTENT with user ID 106, group ID 106
Solved granting the function with execute privilege.
and the version and the build date of the server is:
Virtuoso Open Source Edition (Column Store) (multi threaded)
Version 7.0.1-dev.3207-pthreads as of Jan 9 2014
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2013 OpenLink Software
thanks!
nuria
> 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 21 Jan 2014, at 11:37, "QUERALT ROSINACH, NÚRIA" <nuria.quer...@upf.edu>
> wrote:
>
> > Hi all,
> >
> > I am trying to do an Insert of data in a Virtuoso server v7.0.1, but the
> following error appeared:
> >
> > Virtuoso 42000 Error SR186: No permission to execute dpipe
> DB.DBA.L_O_LOOK with user ID 106, group ID 106
> >
> > Any idea on how to overcome this? Any help it'll be very welcome!
> >
> > Many thanks in advance!
> >
> > Kind regards,
> > núria
> >
> > --
> > ********************************************************************
> > Núria Queralt Rosinach
> > Research Programme on Biomedical Informatics (GRIB)
> > Department of Experimental and Health Sciences
> > Universitat Pompeu Fabra
> > IMIM (Hospital del Mar Medical Research Institute)
> > C/Dr. Aiguader 88, 08003
> > Barcelona, Spain
> > Tel.: +34 93 316 0536
> > E-mail: nuria.quer...@upf.edu
> > http://ibi.imim.es/
> > ********************************************************************
> >
> ------------------------------------------------------------------------------
> > CenturyLink Cloud: The Leader in Enterprise Cloud Services.
> > Learn Why More Businesses Are Choosing CenturyLink Cloud For
> > Critical Workloads, Development Environments & Everything In Between.
> > Get a Quote or Start a Free Trial Today.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk_______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
--
********************************************************************
Núria Queralt Rosinach
Research Programme on Biomedical Informatics (GRIB)
Department of Experimental and Health Sciences
Universitat Pompeu Fabra
IMIM (Hospital del Mar Medical Research Institute)
C/Dr. Aiguader 88, 08003
Barcelona, Spain
Tel.: +34 93 316 0536
E-mail: nuria.quer...@upf.edu
http://ibi.imim.es/
********************************************************************
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
