Hi Rob,
Ah, it must be a bif: (built-in-function) vs sql: (Virtuoso PL) function change
then as there were some changes for SPARQL 1.1 compliance in this area in 2012,
so use the sql: prefix instead:
SQL> sparql delete from <http://sample/> {
`bif:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> };
*** Error 37000: VD [Virtuoso Server]SQ074: Line 1: SP031: SPARQL compiler:
Unknown function bif:rdf_make_iid_of_qname()
at line 2 of Top-Level:
sparql delete from <http://sample/> {
`bif:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> }
SQL> sparql delete from <http://sample/> {
`sql:rdf_make_iid_of_qname('http://localhost:8890')` <p> <o3a> };
Done. -- 5 msec.
SQL>
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 7 Feb 2014, at 09:49, Rob Vesse <rve...@yarcdata.com> wrote:
> As the original error message I posted implies I am attempting to use the
> function via SPARQL hence the bif: prefix and why the error comes from the
> SPARQL compiler
>
>>> OpenLink.Data.Virtuoso.VirtuosoException : Virtuoso Error:
>>> SQL_ERRORSQLSTATE: 37000Message: [Virtuoso .NET Data Provider][Virtuoso
>>> Server]SQ074: Line 7: SP031: SPARQL compiler: Unknown function
>>> bif:rdf_make_iid_of_qname()
>
> I.e. I am making a SPASQL query/update
>
> Rob
>
> From: Hugh Williams <hwilli...@openlinksw.com>
> Date: Thursday, 6 February 2014 17:36
> To: Rob Vesse <rve...@yarcdata.com>
> Cc: "virtuoso-users@lists.sourceforge.net"
> <virtuoso-users@lists.sourceforge.net>
> Subject: Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer supported?
>
>> Hi Rob,
>>
>> I downloaded the same Window 32bit installer from the VOS download site and
>> the function does exist and is found whether fully qualified or not:
>>
>> C:\virtuoso-opensource-x86-20131211\virtuoso-opensource\database>..\bin\virtuoso-t
>> -?
>> Virtuoso Open Source Edition (multi threaded)
>> Version 6.1.7.3127-threads as of Dec 11 2013
>> Compiled for Win32 (i686-generic-win-32)
>> Copyright (C) 1998-2013 OpenLink Software
>>
>> C:\>cd virtuoso-opensource-x86-20131211\virtuoso-opensource\bin\
>>
>> C:\virtuoso-opensource-x86-20131211\virtuoso-opensource\bin>.\isql 1111
>> Connected to OpenLink Virtuoso
>> Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>> SQL> select count(*) from RDF_QUAD where G =
>> rdf_make_iid_of_qname('http://localhost:8890/DAV');
>> count
>> INTEGER
>> _______________________________________________________________________________
>>
>> 0
>>
>> 1 Rows. -- 0 msec.
>> SQL> select count(*) from RDF_QUAD where G =
>> DB.DBA.rdf_make_iid_of_qname('http://localhost:8890/DAV');
>> count
>> INTEGER
>> _______________________________________________________________________________
>>
>> 0
>>
>> 1 Rows. -- 0 msec.
>> SQL> status('');
>> REPORT
>> VARCHAR
>> _______________________________________________________________________________
>>
>> OpenLink Virtuoso Server
>> Version 06.01.3127-threads for Win64 as of Dec 11 2013
>> Started on: 2014/02/06 17:53 GMT+00
>>
>> I also tested the 32bit installer and it also exists there as well:
>>
>> C:\virtuoso-opensource-x64-20131211\virtuoso-opensource\database>..\bin\virtuoso-t
>> -?
>> Virtuoso Open Source Edition (multi threaded)
>> Version 6.1.8.3127-threads as of Dec 11 2013
>> Compiled for Win64 (x86_64-generic-win-64)
>> Copyright (C) 1998-2013 OpenLink Software
>>
>> C:\virtuoso-opensource-x64-20131211\virtuoso-opensource\database>..\bin\isql
>> 1111
>> Connected to OpenLink Virtuoso
>> Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>> SQL> select count(*) from RDF_QUAD where G =
>> rdf_make_iid_of_qname('http://local
>> host:8890/DAV');
>> count
>> INTEGER
>> _______________________________________________________________________________
>>
>> 0
>>
>> 1 Rows. -- 31 msec.
>> SQL> status('');
>> REPORT
>> VARCHAR
>> _______________________________________________________________________________
>>
>> OpenLink Virtuoso Server
>> Version 06.01.3127-threads for Win64 as of Dec 11 2013
>> Started on: 2014/02/06 16:53 GMT+00
>>
>> Thus I am curious and confused as to how you are calling this via the
>> ADO.Net Provider such that it is not located ?
>>
>> 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 6 Feb 2014, at 14:09, Rob Vesse <rve...@yarcdata.com> wrote:
>>
>>> Hugh
>>>
>>> Virtuoso Open Source Edition (multi threaded)
>>> Version 6.1.7.3127-threads as of Dec 11 2013
>>> Compiled for Win32 (i686-generic-win-32)
>>> Copyright (C) 1998-2013 OpenLink Software
>>>
>>> Which is interesting because the fact that your build is 6.1.8 and from a
>>> day after mine implies that development found issues with 6.1.7 and did a
>>> rebuild
>>>
>>> Btw this was a pre-built Windows binary downloaded from the VOS wiki so
>>> those links should be checked and updated if relevant
>>>
>>> Rob
>>>
>>>
>>> From: Hugh Williams <hwilli...@openlinksw.com>
>>> Date: Thursday, 6 February 2014 12:44
>>> To: Rob Vesse <rve...@yarcdata.com>
>>> Cc: "virtuoso-users@lists.sourceforge.net"
>>> <virtuoso-users@lists.sourceforge.net>
>>> Subject: Re: [Virtuoso-users] bif:rdf_make_iid_of_qname() no longer
>>> supported?
>>>
>>>> Hi Rob,
>>>>
>>>> What is the specific version of v6 you are using as I just tested with my
>>>> 6.1.8 build from latest git stable/6 branch:
>>>>
>>>> $ ../bin/virtuoso-t -?
>>>> Virtuoso Open Source Edition (Row Store) (multi threaded)
>>>> Version 6.1.8-rc1.3127-pthreads as of Dec 12 2013
>>>> Compiled for Darwin (x86_64-apple-darwin12.3.0)
>>>> Copyright (C) 1998-2013 OpenLink Software
>>>>
>>>> and the function does exist:
>>>>
>>>> SQL> status('');
>>>> REPORT
>>>> VARCHAR
>>>> _______________________________________________________________________________
>>>>
>>>> OpenLink Virtuoso Server
>>>> Version 06.01.3127-pthreads for Darwin as of Dec 12 2013
>>>> Started on: 2014/02/06 12:29 GMT+00
>>>>
>>>> Database Status:
>>>> File size 515899392, 62976 pages, 22921 free.
>>>> 10000 buffers, 9309 used, 0 dirty 0 wired down, repl age 0 0 w. io 0
>>>> w/crsr.
>>>> Disk Usage: 9335 reads avg 0 msec, 0% r 0% w last 0 s, 93 writes,
>>>> 93 read ahead, batch = 94. Autocompact 0 in 0 out, 0% saved.
>>>> Gate: 117 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
>>>> Log = /usr/local/vos-6/database/virtuoso.trx, 155 bytes
>>>> 39955 pages have been changed since last backup (in checkpoint state)
>>>> Current backup timestamp: 0x0000-0x00-0x00
>>>> Last backup date: unknown
>>>> Clients: 1 connects, max 1 concurrent
>>>> RPC: 6 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads (0%), 0
>>>> second brk=9
>>>> Checkpoint Remap 76 pages, 0 mapped back. 0 s atomic time.
>>>> DB master 62976 total 22921 free 76 remap 0 mapped back
>>>> temp 768 total 763 free
>>>>
>>>> Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
>>>> Currently 1 threads running 0 threads waiting 0 threads in vdb.
>>>> Pending:
>>>>
>>>> 23 Rows. -- 8 msec.
>>>> SQL> rdf_make_iid_of_qname();
>>>>
>>>> *** Error 07S01: [Virtuoso Driver][Virtuoso Server]SR183: Required
>>>> argument qname (no 1) not supplied to DB.DBA.RDF_MAKE_IID_OF_QNAME
>>>> at line 3 of Top-Level:
>>>> rdf_make_iid_of_qname()
>>>> SQL> select count(*) from RDF_QUAD where G =
>>>> rdf_make_iid_of_qname('http://localhost:8890/DAV');
>>>> count
>>>> INTEGER
>>>> _______________________________________________________________________________
>>>>
>>>> 0
>>>>
>>>> 1 Rows. -- 879 msec.
>>>> SQL>
>>>>
>>>> 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 6 Feb 2014, at 09:38, Rob Vesse <rve...@yarcdata.com> wrote:
>>>>
>>>>> Hi All
>>>>>
>>>>> I've run into an issue with after upgrading to a recent Virtuoso 6
>>>>> installation to reproduce a user reported bug in my Virtuoso integration.
>>>>> That bug was an easy fix but in running regression testing one of my
>>>>> tests for an unrelated feature no longer functions.
>>>>>
>>>>> Essentially the problem seems to be that the bif:rdf_make_iid_of_qname()
>>>>> is no longer supported, I get the following error from the Virtuoso
>>>>> compiler:
>>>>>
>>>>> OpenLink.Data.Virtuoso.VirtuosoException : Virtuoso Error:
>>>>> SQL_ERRORSQLSTATE: 37000Message: [Virtuoso .NET Data Provider][Virtuoso
>>>>> Server]SQ074: Line 7: SP031: SPARQL compiler: Unknown function
>>>>> bif:rdf_make_iid_of_qname()
>>>>>
>>>>> This worked fine in past versions of Virtuoso and is still detailed in
>>>>> your documentation at
>>>>> http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulfunc
>>>>> so I am little confused. Did you guys intentionally remove this function
>>>>> or is this a bug?
>>>>>
>>>>> For reference the version of Virtuoso I am using is as follows:
>>>>>
>>>>> Version: 06.01.3127
>>>>> Build: Dec 11 2013
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Rob
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Managing the Performance of Cloud-Based Applications
>>>>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>>>>> Read the Whitepaper.
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
>>>>> Virtuoso-users mailing list
>>>>> Virtuoso-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>
>>> ------------------------------------------------------------------------------
>>> Managing the Performance of Cloud-Based Applications
>>> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
>>> Read the Whitepaper.
>>> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
