« Varios curls for fedora RDF (REST interface) | Main | Switch in UDC Media filter. »

items in DSAPCE with in_archive =f and withdrawn = f

Problem

Louise told me that the following two purls produced an error when accessed:
http://purl.umn.edu/114817
http://purl.umn.edu/113790

The cause

It turns our that both in_archive and withdrawn are set to false.
dspace_sr=> select * from handle where handle = 113790;
 handle_id | handle | resource_type_id | resource_id 
-----------+--------+------------------+-------------
     51427 | 113790 |                2 |       53352


dspace_sr=> select * from item where item_id = 53352;

 item_id | submitter_id | in_archive | withdrawn |       last_modified        | owning_collection 
---------+--------------+------------+-----------+----------------------------+-------------------
   53352 |         2680 | f          | f         | 2011-08-25 12:58:34.912-05 |                  
(1 row)
I think that both variables should not be set to f.

The solution

Set withdrawn to t and the Louise can resubmit the metadata:
UPDATE item SET withdrawn = 'T' WHERE item_id = 53352;

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)