Hi Tom, > I'm trying to update a lot of communities and collections that were set up > prior to our HANDLE being assigned. So according to the "cookbook" I'm doing: > > update-handle-prefix 123456789 10420 (10420 being the new HANDLE number) > > After seeing how many items are being updated and selecting "yes," the > all-too-familiar-by-now string of Java errors: > > Is this YAOI (yet another Oracle incompatibility)? I'm tempted to go into the > database and manually write some SQL commands to update the tables. Is that > even an option? After the metadatavalues table is updated, what else has to be > done?
After the metadatavalues table has been updated, all that happens is the search and browse indexes are rebuilt, but this can be run manually using [dspace]/bin/index-update The query that is failing is: UPDATE metadatavalue SET text_value= (SELECT 'http://hdl.handle.net/' || handle FROM handle WHERE handle.resource_id=item_id AND handle.resource_type_id=2) WHERE text_value LIKE 'http://hdl.handle.net/%'; If you are able to find out what is causing the error by running it directly, please post your solution and we'll get the script updated. Many thanks, Stuart _________________________________________________________________ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _________________________________________________________________ ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
