• Sign In
×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!
  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