Hi Jonathan,
What are the actual errors returned, please provide the output of running the
query "select * from DB.DBA.LOAD_LIST where ll_error” ?
To force the reload of a dataset you need to set its “ll_status” in the
“load_list” table to “0”, as there status is probably now set “1” indicating
they loaded with an error, so with a query something like:
update load_list set set ll_state = 0 where ll_state = 1
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 21 Nov 2014, at 09:41, Jonathan Cheseaux <cheseauxjonat...@gmail.com>
> wrote:
>
> Hi all,
>
> I've imported DBpedia in Virtuoso but noticed that some files were corrupted
> by issuing this query :
>
> "select * from DB.DBA.LOAD_LIST where ll_error"
>
> It shows 4 results, where apparently the import wasn't successful for the
> entire data. As the incriminating lines are displayed, I openned those files
> and corrected them (mainly syntax issues or truncated files).
>
> Then I tried to commit this changes and reupload these datasets (or at least
> the part of the file that wasn't imported due to these errors). I've read the
> documentation, but I haven't found how to do so.
>
> I tried to call again "rdf_loader_run();" in iSQL but it doesn't seem to see
> my changes to these files as it used the log file I guess.
>
> Is there a way to tell the Bulk loader that he can retry to import thoses
> files ?
>
> Also another question, I tried to delete and recreate this DBA.LOAD_LIST and
> called "rdf_loader_run();" again, the effect was to re-import everything that
> was listed in this graph (DBpedia files). As each files were imported twice,
> does Virtuoso duplicate the triples or just override them ?
>
> Thanks for your help,
> Jonathan.
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
