Hi Hugh, thanks for your precious help and support. I am going to download and try the Windows Virtuoso 7.2.1 prebuilt binary , I' ll tell you how it goes. In the mean time, I attach the schema of the table I'm trying to map and the log file. Thanks again. Best Regards,Francesco Balzano. Subject: Re: [Virtuoso-users] Problem generating views from Virtuoso Conductor From: hwilli...@openlinksw.com Date: Sat, 22 Aug 2015 03:02:21 +0100 CC: virtuoso-users@lists.sourceforge.net To: i_ba...@hotmail.it
Hi Francesco,
I tried the Windows Virtuoso 7.2.1 prebuilt binary from June 2015 and was able
to successfully create Linked Data Views of the Sample demo database we provide
successfully.
Thus what is the database you are seeking to created Linked Data Views off ?
Can you provide the schema of the tables at least such that we can attempt to
create locally ?
Please also provide a copy of your “virtuoso.log” file …
Best RegardsHugh WilliamsProfessional ServicesOpenLink Software, Inc. //
http://www.openlinksw.com/Weblog --
http://www.openlinksw.com/blogs/LinkedIn --
http://www.linkedin.com/company/openlink-software/Twitter --
http://twitter.com/OpenLinkGoogle+ --
http://plus.google.com/100570109519069333827/Facebook --
http://www.facebook.com/OpenLinkSoftwareUniversal Data Access, Integration, and
Management Technology Providers
On 19 Aug 2015, at 21:01, Francesco Balzu <i_ba...@hotmail.it> wrote:Hi Hugh,
thanks for your help and your time.
If I run DB.DBA.RDF_AUDIT_METADATA() I get this message (with each of the
allowed parameters):
Query result:STAT
VARCHARMSG
VARCHAR 00000 Reloading built-in metadata, this might fix some errors without
accurate reporting that they did exist 00000 Built-in metadata were reloaded
22023 SR528: Uninitialized property qmvColumnsFormKey in JSO instance
<sys:qmv-87989165e74248977150f5a68b057866> of type
<http://www.openlinksw.com/schemas/virtrdf#QuadMapValue> 42000 The previous
error can not be fixed automatically. Sorry.
The message is the same that I get if I try to generate linked data views from
Virtuoso Relational Database.Of course I can provide some test case, but I get
this message with each table in the database that I try to map. Anyway I
attached a .csv file that represents one of these tables. I imported this file
from Conductor : Database -> Import -> Upload file.
The version of Virtuoso is 07.20.3214 and I am running it on Windows. I
downloaded prebuilt binaries.
I don't know if I made something wrong, but the only change I made is to the
amount of used RAM. Anyway this problem occurs after a while I'm using
Virtuoso: initially I can also define my custom mappings and see them work, but
soon I am no more able to do this.
Thanks for your help.Best Regards,Francesco Balzano.
> Subject: Re: [Virtuoso-users] Problem generating views from Virtuoso Conductor
> From: hwilli...@openlinksw.com
> Date: Wed, 19 Aug 2015 12:16:20 +0100
> CC: virtuoso-users@lists.sourceforge.net
> To: i_ba...@hotmail.it
>
> Hi Francesco,
>
> Have you tried running the DB.DBA.RDF_AUDIT_METADATA() function which can
> check and repair corruption in the RDF Metadata as detailed at:
>
> http://docs.openlinksw.com/virtuoso/fn_rdf_audit_metadata.html
>
> If that does not resolve the problem then are you able to provide a test case
> for reproducing ?
>
> Also, what Virtuoso release is being used ?
>
> 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 17 Aug 2015, at 21:03, Francesco Balzu <i_ba...@hotmail.it> wrote:
> >
> > Hi !
> > I have the following problem with Virtuoso: when I open the "Views" tab
> > from Conductor and generate a mapping using the default mapping, I get the
> > following log
> >
> >
> > 22023 SR528: Uninitialized property qmvcColumnName in JSO instance
> > <sys:qmv-774944251d863e96af7ebee7ed051e3f-col-tbl0-"observationID"> of type
> > <http://www.openlinksw.com/schemas/virtrdf#QuadMapColumn>
> > 42000 The previous error can not be fixed automatically. Sorry.
> >
> > and no graph is created, except a graph with few rows containing the schema
> > of the mapping. Anyway, no row from the relational database is mapped.
> >
> > The first time I got this 'error' I reinstalled Virtuoso and everything was
> > fine, but after a while I still have the same problem of the first time.
> >
> > I uninstalled and reinstalled the r2rml vad package but nothing happened.
> > I tried to use the procedure DB.DBA.TTLP(...) as it is explained in the
> > documentation but I still get the same result.
> >
> > I tried to google it but I found nothing about this message, that's why I'm
> > asking you.
> >
> >
> > Any help would be appreciated!!
> >
> > Thanks for your time and availability.
> > Best regards,
> > Francesco Balzano.
> >
> >
> > ------------------------------------------------------------------------------
> > _______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
<sensori46.csv>
schema
Description: Binary data
Tue Aug 18 2015
15:09:12 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
15:09:12 WikiV version 0.6 from OpenLink Software
15:09:12 Support functions for WikiV collaboration tool
15:09:12 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
15:09:12 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
15:09:12 MediaWiki version 0.1 from OpenLink Software
15:09:12 Support functions for MediaWiki collaboration tool
15:09:12 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
15:09:12 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
15:09:12 CreoleWiki version 0.1 from OpenLink Software
15:09:12 Support functions for CreoleWiki collaboration tool
15:09:12 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
15:09:12 { Loading plugin 4: Type `plain', file `im' in `../hosting'
15:09:12 IM version 0.6 from OpenLink Software
15:09:12 Support functions for Image Magick 6.6.7
15:09:12 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
15:09:12 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
15:09:12 WBXML2 version 0.9 from OpenLink Software
15:09:12 Support functions for WBXML2 0.10.7 Library
15:09:12 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
15:09:12 OpenLink Virtuoso Universal Server
15:09:12 Version 07.20.3214-threads for Win64 as of Jun 24 2015
15:09:12 uses parts of OpenSSL, PCRE, Html Tidy
15:09:12 SQL Optimizer enabled (max 1000 layouts)
15:09:13 Compiler unit is timed at 0.000503 msec
15:09:17 Checkpoint started
15:09:17 Roll forward started
15:09:17 Roll forward complete
15:09:17 Checkpoint started
15:09:17 Checkpoint finished, log reused
15:09:17 Checkpoint started
15:09:17 Checkpoint finished, log reused
15:09:17 Checkpoint started
15:09:17 Checkpoint finished, log reused
15:09:18 Checkpoint started
15:09:18 Checkpoint finished, log reused
15:09:18 Checkpoint started
15:09:18 Checkpoint finished, log reused
15:09:18 PL LOG: Installing Virtuoso Conductor version 1.00.8746 (DAV)
15:09:18 Checkpoint started
15:09:18 Checkpoint finished, log reused
15:09:20 Checkpoint started
15:09:20 Checkpoint finished, log reused
15:09:21 Checkpoint started
15:09:21 Checkpoint finished, log reused
15:09:21 HTTP/WebDAV server online at 8890
15:09:21 Server online at 1111 (pid 7232)
15:32:33 PL LOG: Installing RDB2RDF support version 1.00.0003/2011-09-05 12:01
(DAV)
15:32:33 Checkpoint started
15:32:33 Checkpoint finished, log reused
15:32:34 Checkpoint started
15:32:34 Checkpoint finished, log reused
16:09:21 Checkpoint started
16:09:21 Checkpoint finished, log reused
16:13:55 * Monitor: Locks are held for a long time
20:51:24 Checkpoint started
20:51:25 Checkpoint finished, log reused
21:14:44 foreground window closed
Wed Aug 19 2015
15:30:48 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
15:30:48 WikiV version 0.6 from OpenLink Software
15:30:48 Support functions for WikiV collaboration tool
15:30:48 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
15:30:48 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
15:30:48 MediaWiki version 0.1 from OpenLink Software
15:30:48 Support functions for MediaWiki collaboration tool
15:30:48 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
15:30:48 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
15:30:48 CreoleWiki version 0.1 from OpenLink Software
15:30:48 Support functions for CreoleWiki collaboration tool
15:30:48 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
15:30:48 { Loading plugin 4: Type `plain', file `im' in `../hosting'
15:30:48 IM version 0.6 from OpenLink Software
15:30:48 Support functions for Image Magick 6.6.7
15:30:48 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
15:30:48 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
15:30:48 WBXML2 version 0.9 from OpenLink Software
15:30:48 Support functions for WBXML2 0.10.7 Library
15:30:48 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
15:30:49 OpenLink Virtuoso Universal Server
15:30:49 Version 07.20.3214-threads for Win64 as of Jun 24 2015
15:30:49 uses parts of OpenSSL, PCRE, Html Tidy
15:30:49 Database version 3126
15:30:49 Unlinked the temp db file virtuoso-temp.db as its size (12MB) was
greater than TempDBSize INI (10MB)
15:30:49 SQL Optimizer enabled (max 1000 layouts)
15:30:50 Compiler unit is timed at 0.000209 msec
15:30:52 Roll forward started
15:30:52 44 transactions, 3621 bytes replayed (100 %)
15:30:52 Roll forward complete
15:30:52 Checkpoint started
15:30:52 Checkpoint finished, log reused
15:30:53 HTTP/WebDAV server online at 8890
15:30:53 Server online at 1111 (pid 6968)
Wed Aug 19 2015
16:21:06 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
16:21:06 WikiV version 0.6 from OpenLink Software
16:21:06 Support functions for WikiV collaboration tool
16:21:06 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
16:21:06 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
16:21:06 MediaWiki version 0.1 from OpenLink Software
16:21:06 Support functions for MediaWiki collaboration tool
16:21:06 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
16:21:06 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
16:21:06 CreoleWiki version 0.1 from OpenLink Software
16:21:06 Support functions for CreoleWiki collaboration tool
16:21:06 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
16:21:06 { Loading plugin 4: Type `plain', file `im' in `../hosting'
16:21:06 IM version 0.6 from OpenLink Software
16:21:06 Support functions for Image Magick 6.6.7
16:21:06 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
16:21:06 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
16:21:06 WBXML2 version 0.9 from OpenLink Software
16:21:06 Support functions for WBXML2 0.10.7 Library
16:21:06 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
16:21:06 OpenLink Virtuoso Universal Server
16:21:06 Version 07.20.3214-threads for Win64 as of Jun 24 2015
16:21:06 uses parts of OpenSSL, PCRE, Html Tidy
16:21:06 Database version 3126
16:21:06 SQL Optimizer enabled (max 1000 layouts)
16:21:08 Compiler unit is timed at 0.000206 msec
16:21:09 Roll forward started
16:21:10 680 transactions, 574589 bytes replayed (100 %)
16:21:10 Roll forward complete
16:21:10 Error executing a server init statement : 22023: SR528: Uninitialized
property qmvColumnsFormKey in JSO instance
<sys:qmv-87989165e74248977150f5a68b057866> of type
<http://www.openlinksw.com/schemas/virtrdf#QuadMapValue> --
DB.DBA.RDF_QUAD_FT_UPGRADE ()
16:21:11 Checkpoint started
16:21:11 Checkpoint finished, log reused
16:21:11 HTTP/WebDAV server online at 8890
16:21:11 Server online at 1111 (pid 332)
17:23:55 Checkpoint started
17:23:56 Checkpoint finished, log reused
20:44:43 Checkpoint started
20:44:44 Checkpoint finished, log reused
21:13:12 foreground window closed
Wed Aug 19 2015
21:13:55 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
21:13:55 WikiV version 0.6 from OpenLink Software
21:13:55 Support functions for WikiV collaboration tool
21:13:55 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
21:13:55 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
21:13:55 MediaWiki version 0.1 from OpenLink Software
21:13:55 Support functions for MediaWiki collaboration tool
21:13:55 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
21:13:55 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
21:13:55 CreoleWiki version 0.1 from OpenLink Software
21:13:55 Support functions for CreoleWiki collaboration tool
21:13:55 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
21:13:55 { Loading plugin 4: Type `plain', file `im' in `../hosting'
21:13:55 IM version 0.6 from OpenLink Software
21:13:55 Support functions for Image Magick 6.6.7
21:13:55 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
21:13:55 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
21:13:55 WBXML2 version 0.9 from OpenLink Software
21:13:55 Support functions for WBXML2 0.10.7 Library
21:13:55 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
21:13:55 OpenLink Virtuoso Universal Server
21:13:55 Version 07.20.3214-threads for Win64 as of Jun 24 2015
21:13:55 uses parts of OpenSSL, PCRE, Html Tidy
21:13:55 Database version 3126
21:13:55 SQL Optimizer enabled (max 1000 layouts)
21:13:56 Compiler unit is timed at 0.000202 msec
21:13:58 Roll forward started
21:13:58 67 transactions, 660850 bytes replayed (100 %)
21:13:58 Roll forward complete
21:13:59 Error executing a server init statement : 22023: SR528: Uninitialized
property qmfOkForAnySqlvalue in JSO instance
<http://www.openlinksw.com/virtrdf-data-formats#default-iid-nullable> of type
<http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat> --
DB.DBA.RDF_QUAD_FT_UPGRADE ()
21:13:59 Checkpoint started
21:13:59 Checkpoint finished, log reused
21:13:59 HTTP/WebDAV server online at 8890
21:13:59 Server online at 1111 (pid 7092)
22:14:00 Checkpoint started
22:14:00 Checkpoint finished, log reused
22:28:59 foreground window closed
Mon Aug 24 2015
11:03:23 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
11:03:23 WikiV version 0.6 from OpenLink Software
11:03:23 Support functions for WikiV collaboration tool
11:03:23 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
11:03:23 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
11:03:23 MediaWiki version 0.1 from OpenLink Software
11:03:23 Support functions for MediaWiki collaboration tool
11:03:23 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
11:03:23 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
11:03:23 CreoleWiki version 0.1 from OpenLink Software
11:03:23 Support functions for CreoleWiki collaboration tool
11:03:23 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
11:03:23 { Loading plugin 4: Type `plain', file `im' in `../hosting'
11:03:23 IM version 0.6 from OpenLink Software
11:03:23 Support functions for Image Magick 6.6.7
11:03:23 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
11:03:23 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
11:03:23 WBXML2 version 0.9 from OpenLink Software
11:03:23 Support functions for WBXML2 0.10.7 Library
11:03:23 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
11:03:23 OpenLink Virtuoso Universal Server
11:03:23 Version 07.20.3214-threads for Win64 as of Jun 24 2015
11:03:23 uses parts of OpenSSL, PCRE, Html Tidy
11:03:23 Database version 3126
11:03:23 SQL Optimizer enabled (max 1000 layouts)
11:03:24 Compiler unit is timed at 0.000199 msec
11:03:26 Roll forward started
11:03:26 29 transactions, 2361 bytes replayed (100 %)
11:03:26 Roll forward complete
11:03:26 Error executing a server init statement : 22023: SR528: Uninitialized
property qmvColumnsFormKey in JSO instance
<sys:qmv-87989165e74248977150f5a68b057866> of type
<http://www.openlinksw.com/schemas/virtrdf#QuadMapValue> --
DB.DBA.RDF_QUAD_FT_UPGRADE ()
11:03:27 Checkpoint started
11:03:27 Checkpoint finished, log reused
11:03:27 HTTP/WebDAV server online at 8890
11:03:27 Server online at 1111 (pid 6888)
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
