PUMAdb : Delete Experiment Help

Your session is inactive. Login


Contents


Description

This page describes how to delete experiments from the database and what to do if you encounter error messages when deleting an experiment. Only the owner of the assay/result-set (experimenter) can delete the record from the database. You can only delete experiments for which you are listed as the experimenter.

Selecting an Experiment For Deletion

There are two ways to select an experiment you want to delete from the main page:

With either method, selecting an experiment from the list of experiments does not delete it immediately. Instead, it takes you to a confirmation page where you can add comments about the experiment you are about to delete, or cancel the deletion if you wish.

The Deletion Screen

The normal deletion screen looks like this:

Deleting experiment from database:

Slide Name'AKShuaitest3'
Experiment Name'AKShuaitest3'
Channel 1 Description'AKShuaitest3'
Channel 2 Description'AKShuaitest3'
Category'AKtest'
Subcategory'AKtest'
Experiment ID1882
Deleting access information...
Deleting description...
Deleting normalization value...
Deleting results(there are 8832 to be deleted)...
1000
2000
3000
4000
5000
6000
7000
8000
9000
Deleting from experiment table...
Moving files...
Moving 1882.dat to deleted directory...
Moving 1882_ch1.scn to deleted directory...
Moving 1882_ch2.scn to deleted directory...
Moving 1882_grid.sag to deleted directory...

Experiment 'AKShuaitest3' has been successfully deleted.

The number of spots to be deleted is the number of spots in the print for this experiment. The program then reports that it is deleting spots with numbers less than 1000 (2000, etc.) until it finishes all spots for the experiment.

Common Error Messages

Common errors and possible solutions are listed below. If you get errors not on this list, please contact the MicroArray Database Curators at array@princeton.edu. Any information you can provide about what caused the error and how to fix it would be helpful.


Deleting experiment from database:

Slide Name'AKShuaitest3'
Experiment Name'AKShuaitest3'
Channel 1 Description'AKShuaitest3'
Channel 2 Description'AKShuaitest3'
Category'AKtest'
Subcategory'AKtest'
Experiment ID1882
Deleting access information...
Deleting description...
Deleting normalization value...
Deleting results...
Deleting from experiment table...
Rolling back database...
An error occurred :
DBD::Oracle::db do failed: ORA-00001: unique constraint (PROD.PK_EXPT_DELETION_EXPTID) violated (DBD ERROR: OCIStmtExecute) at /ora5/app/oracle/local/mad/cgi-bin/nph-deleteExperiment.pl line 187.
The most common reason for this error is that you tried to simultaneously delete the same experiment in two different windows. The deletion in the other window was probably successful.

Check whether this experiment is still in the database using the "Advanced Results Search" on the database main page. If the experiment is still in the database and you got this message, please email the MicroArray Database Curators at array@princeton.edu. In your mail, please include the error message, date and time of the error, and any other information you have about what may have caused it.