Skip to Content

Unique constraint violated

Jul 19, 2017 at 09:48 PM


avatar image


Could not execute 'call bhavya.zz_get_series1' in 715 ms 746 µs . [301]: unique constraint violated: search table error: "BHAVYA"."ZZ_GET_SERIES1": line 34 col 1 (at pos 851): [301] (range 3) unique constraint violated exception: unique constraint violated: TrexUpdate failed on table 'BHAVYA:AFS_BASE.KPI.TABLES::DB_WEEK_SERIES' with error: unique constraint violation in self check for table BHAVYA:AFS_BASE.KPI.TABLES::DB_WEEK_SERIESen, constraint='REPORT_DATE', udiv='2017-07-18', pos=145110; indexname=_SYS_TREE_CS_#17759941_#0_#P0, rc=55

10 |10000 characters needed characters left characters exceeded

So, you got an error message... so what?

Without any further context, all anyone can do is to google it - so can you. How about you do some pre-work on your problems yourself (that's also true for your other questions).


I tried googling it first. I didn't find the answer and then I post my question here.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Anjali Chimnani
Jul 23, 2017 at 07:22 PM

Hi Bhavya,

The error unique constraint violated. It usually comes when there is data in your table and the report or procedure or operation that you are performing tries to insert similar data to a column marked with unique constraint.

Can you check if the above is a possibility in your database or if not describe your scenario a bit so that we could solve it?

Thank you.

Best Regards,


Show 2 Share
10 |10000 characters needed characters left characters exceeded

That's right. I was having same data and that's why it was throwing an error.


I deleted the previous data and executed again and it worked fine.