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
