1 Topic by Tony Witts

  • Tony Witts
  • Member
  • Offline
  • From: Kent & Medway BRC
  • Registered: 08-04-2009
  • Posts: 20

Topic: Violation of PRIMARY KEY constraint 'PK_SURVEY'.

Hello,
I've been getting a Violation of PRIMARY KEY constraint 'PK_SURVEY'. message when trying to add new surveys.

"Violation of PRIMARY KEY constraint 'PK_SURVEY'. Cannot insert duplicate key in object 'dbo.SURVEY'."

I am running version 6.30.0.291

Has anyone else run into this one, and how do i fix it?
Cheers
Tony

2 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Violation of PRIMARY KEY constraint 'PK_SURVEY'.

Hi Tony

Sounds like the Last_Key table has got out of sync for some reason. Have you tried updating the table via 'Tools -> Update Last Key' to see if that fixes the problem?

Andy

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk

3 Reply by Tony Witts

  • Tony Witts
  • Member
  • Offline
  • From: Kent & Medway BRC
  • Registered: 08-04-2009
  • Posts: 20

Re: Violation of PRIMARY KEY constraint 'PK_SURVEY'.

Thanks Andy, that worked a treat! I'd not spotted that button before!
Tony