Cannot insert duplicate key in object 'study.ParticipantVisit'

LabKey Support Forum (Inactive)
Cannot insert duplicate key in object 'study.ParticipantVisit' lukas streit  2015-04-29 05:37
Status: Closed
 
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
 
 
Jon (LabKey DevOps) responded:  2015-05-05 23:11
Hi Lukas,

I believe the issue you're seeing may have been fixed in LabKey 15.1. Do you have any plans on upgrading at this time?

Regards,

Jon