Hi Howard, What files are in the directory your datasets are being loaded from ? The file in #2 below ie bulkLoad.sql, dbpedia.log etc. are not datasets and thus the load script would fail attempting to run these none datasets files. It looks as if you are loading the files from the same directory as your database files which the loader is attempting to load because of the "*.*" entry passed in the "ld_dir()" function . If the actually dataset files have loaded successfully then you should have the required DBpedia 3.5.1 data loaded. If you want to ensure a clean load, please create a separate directory with only the DBpedia specific datasets you want to load and load from that location.
Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 18 Jun 2010, at 13:56, Howard Lee wrote: > Hi Hugh: > > I would like to report my findings. I tried both 5.0.14 and 6.1.1 and I > still encountered the 23000 SR133 error. When I installed the latest > version, I blew away the old setup to make sure I did start from scratch. I > also have a few more observations: > > 1. When I run the bulk load script I see the following warning on procedure > load_grdf > > Warning 01V01: [Virtuoso Driver][Virtuoso Server]QW004: Incompatible types > VARCHAR (182) and INTEGER (189) in = for gr and <constant> > > 2. When I load the first .nt.gz data file, I get the following set of > messages. If I split the data files and load them in a few batches, the > messages disappear as I load the 2nd batch. This happens regardless of which > file I load first. > > bulkLoad.sql error 37000 SP029: TURTLE RDF loader, line 1: syntax error > dbpedia.log error 37000 SP029: TURTLE RDF loader, line 2: syntax error > dbpedia.trx error 42000 FA003: Access to '/vol2/dbpedia/dbpedia.trx' is > denied due to access control in ini file > dbpedia_data.db error 42000 FA003: Access to '/vol2/dbpedia/dbpedia_data.db' > is denied due to access control in ini file > dbpedia_data.lck error 37000 SP029: TURTLE RDF loader, line 2: syntax error > dbpedia_x.ini error 42000 FA003: Access to '/vol2/dbpedia/dbpedia_x.ini' is > denied due to access control in ini file > demo.tdb error 42000 FA003: Access to '/vol2/dbpedia/demo.tdb' is denied due > to access control in ini file > global.graph error 37000 SP029: TURTLE RDF loader, line 1: Undefined > namespace prefix at http://dbpedia.org > > 3. The 23000 SR133 error ONLY for page_links_en.nt.gz > > In spite of the errors that I am getting, i did forge ahead to load all the > files I wanted. And I manage to get a database that seems to contain most of > the data I need. However, because I am getting those error, i am doubts > about whether my database is as complete as it should. > > Appreciate any further suggestions. > > Regards > Howard > > > > > On Mon, Jun 14, 2010 at 5:33 AM, Hugh Williams <hwilli...@openlinksw.com> > wrote: > Hi Howard, > > The "SR133: Can not set NULL to not nullable column 'DB.DBA.RDF_QUAD.O'" > error is a known issue fixed in the latest Virtuoso 5.0.14 and 6.1.1 open > source and commercial builds, thus you need to upgrade your 5.0.12 open > source build currently being used. The latest open source build archives are > available from: > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/ > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 14 Jun 2010, at 04:00, Howard Lee wrote: > >> Hi: >> >> I have followed the instruction on >> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtBulkRDFLoaderExampleDbpedia >> and successfully loaded a few core datasets but ran into error >> "page_links_en.nt.gz error 23000 SR133: Can not set NULL to not nullable >> column 'DB.DBA.RDF_QUAD.O'". I converted all data files from .bz2 to .gz >> after downloading. I am running the opensource version of virtuoso 5.0.12 >> on ubuntu. >> >> Would appreciate any help. Thanx. >> >> Regards >> Howard >> >> ------------------------------------------------------------------------------ >> ThinkGeek and WIRED's GeekDad team up for the Ultimate >> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the >> lucky parental unit. See the prize list and enter to win: >> http://p.sf.net/sfu/thinkgeek-promo_______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > >
