Stanford MicroArray Database
WORLD
  Password   
Sign Out

SMD : Help : Experiment Deletion Help
 

Help : Experiment Deletion Help

Contents

Description

This page describes how to delete experiments from SMD and what to do if you encounter error messages when deleting an experiment. You can only delete experiments for which you are listed as the experimenter. Collaborators cannot delete experiments even if they are the experimenter. If you are a collaborator, you must ask your contact in a Local Laboratory to delete experiments for you.

Selecting an Experiment For Deletion

There are two ways to select an experiment you want to delete from the SMD main page:
  • You can select "Delete Experiment" from the "Edit/Delete Data" Menu in the lower right-hand corner. This gives you a list of experiments you are allowed to delete.
  • If you Click on "Advanced Results Search" in the upper left-hand corner and select experiments you want to see, you will be given the option to delete any experiment for which you are the experimenter.

    • 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@genome.stanford.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/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 SMD main page. If the experiment is still in the database and you got this message, please email the MicroArray Database Curators at array@genome.stanford.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.

    Please send comments or questions to: array@genome.stanford.edu