Hi,
I'm having trouble deleting an experiment from our 1.5.1 XNAT
database.
Here's what I did:
- In a subject detail page, in the actions box on the right: Add
experiment -> chose ECG as modality, click submit
- enter a name for the experiment, then click submit a second time
- Realized that I need to add my data under a different modality, so
trying to delete the (empty except for metadata) experiment I just
created. For that, I use the cissors 'Delete' in the action box of the
subject page.
- then I get a pop-up with the different experiments of this subject
listed, and at the right for each a grey box saying 'Waiting...'. I
don't understand how this interface may work, but if one clicks
'delete at the bottom', it deletes the topmost item, the empty
experiment I just created. Mission accomplished.
However, a colleague of mine did the same a few days ago, and that
data cannot be deleted in this way. The cissors in the delete
procedure as above, make that the 'waiting...' button changes in an
error button
Also, clicking on this empty experiment produces a box with
"We are unable to provide the requested data. Either you have
encountered a link to erroneous data, or this user account (kfclaes)
does not have access to this data. Please login with a different
account or contact the source of the data to gain access."
Same for other users with administrator rights like 'admin'
Another thing I tried is to delete this data somehow from the database
directly using pgAdmin (the GUI). In the delete-box of the XNAT
interface I found an ID of this ECG-experiment to be removed. However,
I did not find this string in the xnat_ecgsessiondata table (under
databases - schemas - public - tables in pgadmin). I found the same
string ('MRPneuroscience_E00004' in my case) under
xnat_eegsessiondata, deleted that row, but that deleted other (EEG)
data in the XNAT interface. Apparently these strings are not unique
somehow.
So summarizing my questions:
- how does the delete-interface work?
- how can it happen that some empty experiment cannot be deleted
(bug?) ?
- if absolutely necessary, how to directly edit the database to
correct the problem.
Thank you,
Kasper, neuroscience project, UGent
www.ugent.be/neuroscience