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
