cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL error Violation of PRIMARY KEY constraint

Hello, does anyone have an idea what might be causing on how to fix error:

"Failed: Failed to do rollup from  - Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object . The duplicate key value is "

It stated happening for one of my data rolloup server task recently. I noticed there are some entries in the community about this particular problem in the past but with no clear solution

1 Reply
Siu
Employee
Employee
Report Inappropriate Content
Message 2 of 2

Re: SQL error Violation of PRIMARY KEY constraint

Hello, 

Reason why this issue is happening sound to be clear from the error message. Now we need to know what exactly the value is and from which table it comes from. I would suggest to open a ticket with support to investigate this issue further. 

You can try purging the data from roll-up and performing a new roll-up and see if the problem still remains. 

Was my reply helpful?
If you find this post useful, Please give it a Kudos! Also, Please don't forget to select "Accept as a solution" if this reply resolves your query!

Thank You,

Siushan M.
You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use our Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from product experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by employees.
Join the Community
Join the Community