Build Number 35337.10
Build OS Windows Server 2008 R2
Version 14.30
---------------------------------------
Hello
After restoring the LabKey-Db on our testserver, an error raised after trying import specimen.
---------- ERROR ---------------
500: Unexpected server error
SqlExecutor.execute(); SQL []; Violation of PRIMARY KEY constraint 'PK_ParticipantVisit'. Cannot insert duplicate key in object 'study.ParticipantVisit'. The duplicate key value is (270615a9-5e94-1031-8d2b-04451a238e40, 4190513, 2.0000).; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_ParticipantVisit'. Cannot insert duplicate key in object 'study.ParticipantVisit'. The duplicate key value is (270615a9-5e94-1031-8d2b-04451a238e40, 4190513, 2.0000).
org.springframework.dao.DataIntegrityViolationException: SqlExecutor.execute(); SQL []; Violation of PRIMARY KEY constraint 'PK_ParticipantVisit'. Cannot insert duplicate key in object 'study.ParticipantVisit'. The duplicate key value is (270615a9-5e94-1031-8d2b-04451a238e40, 4190513, 2.0000).; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_ParticipantVisit'. Cannot insert duplicate key in object 'study.ParticipantVisit'......
---------------------------------
Also when I deleted the duplicated keys in 'study.ParticipantVisit' or tried to import different specimens, the error contained always the same key (270615a9-5e94-1031-8d2b-04451a238e40, 4190513, 2.0000) It doesn't matter wheter it exists or not.
Matthiew Bellw advised me to publishe the problem here in Developers forum. Hope you have a hint.
Lukas |