ESdat Forums
»
Forums
»
ESdat
»
Combine compound error occurring with a leached_reg
 Rank: Advanced Member
Groups: Registered
Posts: 79
|
The combined compound is coming up with a primary key error. It seems to be stopping on a Leached_reg result. I noticed if i change it to Reg then it trips an error on a different Sample. Any thoughts on what could be causing this? error = 31280 Violation of PRIMARY KEY Constraint 'PK_Chemistry_Results' cannot insert duplicate key in object 'dbo.Chemistry_Results
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 79
|
I have narrowed down the cause of the error further. If I run the Combined compounds with 'For non-detects use DL' = 0 I get no error. If I run it with DL = 0.5 i get primary key error.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hi Justin, Could we get the lab report that is generating this issue, along with your combined compounds reference values and also a screen shot of your combined compounds settings? Best if you can send that to support. Warwick
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 79
|
Can do - I'll check everything again and if the error still occurs will send through report
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Combine compound error occurring with a leached_reg
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.