Clean Virtuoso 7 installation helped to get rid of the virtuoso.log errors.
I also figured out why the "Web Application Server" tab had this 'Error
when processing "/conductor/cont_page.vspx" page' message. That happens
when you create a new user folder under DAV directory, instead of DAV/home.
Regards,
Olga.
On Wed, Apr 16, 2014 at 2:16 PM, Hugh Williams <hwilli...@openlinksw.com>wrote:
> Hi Olga,
>
> Sounds like you are running a rather old v6 build (virtuoso-t -?) , try
> running the following to add the missing column required in latest builds:
>
> alter table WS.WS.SYS_DAV_RES add RES_SIZE integer
>
> 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 16 Apr 2014, at 17:42, Olga Medvedeva <omedved...@gmail.com> wrote:
>
> Hello,
>
> After updating from ver. 6.01.3127 to 7.10.3207 I'm getting an error when
> trying to open the "Web Application Server" tab.
> Message in conductor:
>
> Error
> when processing "/conductor/cont_page.vspx" page
> SQL State S0022
> SQL Message SQ200: No column RES_SIZE.
>
>
> From virtuoso.log file:
> ...
> 18:35:25 Database version 3126
> 18:35:25 Unlinked the temp db file
> /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso-temp.db as its
> size (52MB) was greater than TempDBSize INI (10MB)
> 18:35:25 SQL Optimizer enabled (max 1000 layouts)
> 18:35:26 Compiler unit is timed at 0.000219 msec
> 18:35:28 built-in procedure "repl_undot_name" overruled by the RDBMS
> 18:35:29 Error compiling stored procedure: 42S22: SQ062: No column
> N.RES_SIZE. -- #line 3999 "[executable]/dav.sql"
> create trigger SYS_DAV_RE
> 18:35:29 Error compiling stored procedure: 42S22: SQ062: No column
> O.RES_SIZE. -- #line 4091 "[executable]/dav.sql"
> create trigger SYS_DAV_RE
> 18:35:29 Error compiling stored procedure: 42S22: SQ063: No column
> RES_SIZE. -- #line 4548 "[executable]/dav.sql"
> create trigger SYS_DAV_RE
> ...
>
>
>
> This error somehow causes the problem with SPARQL data insertion. The same
> insert works fine on old server with Virtuoso ver. 6.01.3127.
>
> Thank you,
> Olga Medvedeva.
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/NeoTech_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
