• Sign In
  1. Messages

duplicate key violates unique constraint

CPAS Forum (Inactive)

View Message

view list print
duplicate key violates unique constraint oliversc  2006-10-27 11:31
Status: Closed
 
Dear all,

in the MS2 module, when uploading data that was previously analyzed by the IPP from Insilicos, I get the following eror message:
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "uq_ms2peptidesdata_fractionscancharge"
I have attached the log file as well as the interact.xml file for further information.
We use CPAS version 1.6; the data was analyzed by mascot using the IPI mosue database and then validated by IPP (pepXML, PeptideProphet).

I would greatly appreciate any help!

Thanks a lot for your support!
Oliver
 
 
adam responded:  2006-10-29 09:17
The problem is likely that you have two spectra with start_scan=1970 and charge=2. Perhaps this was intentional and legitimate (the end_scan is different for the two spectrum_querys), but at the moment CPAS uses start_scan and charge as the unique constraint, which causes the constraint violation.

Simple solution would be to delete one of the spectrum_query sections with start_scan=1970. Long-term solution is to modify CPAS to handle multiple-scan observations (or hire LabKey to do this).
 
adam responded:  2007-01-03 14:52