On 3/17/15 2:21 PM, Eliza Chan wrote:
Hi,

Using isql, I managed to load some data using the following commands:

SQL> ld_dir('/usr/local/virtuoso-opensource/share/virtuoso/tmp', 'wcmcPeopleAddress.rdf', 'http://vitro.mannlib.cornell.edu/a/graph/wcmcPeople');

Done. -- 1 msec.
SQL> rdf_loader_run();

Done. -- 183 msec.

However, it was not able to load the second time even after clearing all the graph data.

SQL> SPARQL CLEAR GRAPH <http://vitro.mannlib.cornell.edu/a/graph/wcmcPeople>;
Connected to OpenLink Virtuoso
Driver: 07.20.3212 OpenLink Virtuoso ODBC Driver

Done. -- 2 msec.

SQL> ld_dir('/usr/local/virtuoso-opensource/share/virtuoso/tmp', 'wcmcPeopleAddress.rdf', 'http://vitro.mannlib.cornell.edu/a/graph/wcmcPeople');

Done. -- 0 msec.
SQL> rdf_loader_run();

Done. -- 1 msec.

As a result, the graph remained empty. Any reason why it's not able to reload?

Thank you so much for your help.

Regards,
Eliza

You left out one important step i.e., deleting records form the "load_list" table prior to your next load attempt.

So execute the following via SQL command-line or conductor UI:

-- empties the table. You can also simply add a WHERE clause to more selective about named graph iris to be removed.

delete from DB.DBA.load_list ;
ld_dir('/usr/local/virtuoso-opensource/share/virtuoso/tmp', 'wcmcPeopleAddress.rdf', 'http://vitro.mannlib.cornell.edu/a/graph/wcmcPeople') ;
rdf_loader_run();


--
Regards,

Kingsley Idehen 
Founder & CEO
OpenLink Software
Company Web: http://www.openlinksw.com
Personal Weblog 1: http://kidehen.blogspot.com
Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen
Twitter Profile: https://twitter.com/kidehen
Google+ Profile: https://plus.google.com/+KingsleyIdehen/about
LinkedIn Profile: http://www.linkedin.com/in/kidehen
Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this


Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to