Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Theresa  
#1 Posted : Saturday, April 20, 2013 2:46:46 PM(UTC)
Theresa
Rank: Member

Reputation:

Groups: Registered
Posts: 11
Location: Calgary

Hello,

 I'm trying to use post-import custom calculation 10 to convert nitrate as N to nitrate as NO3-. I am receiving the error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again.'

Some of my results do have both nitrate as N and nitrate as NO3 from the raw lab data but most of them only have nitrate as N. I don't need ESdat to calculate and overwrite the locations where the nitrate as NO3 data already exists. I looked at the raw query and it looks like it is only supposed to operate on samplecodes where the parameter to be calculated is null so I'm wondering if something else is causing this message? What else should I look for?

 Thank you,

Theresa

Warwick Wood  
#2 Posted : Saturday, April 20, 2013 8:21:37 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Theresa,

The post import calc is designed to operate as you describe (calculate Nitrate as NO3 from Nitrate as N, only where Nitrate as NO3 doesnt already exist for that sample).

I've tested that calc with a mix of some samples with Nitrate as NO3, and some without, and can't replicate the error.  Would you be able to zip and send a database illustrating what you are seeing to support@ESdat.com ?

Many thanks,

Warwick

 

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.