Forum Stats

  • 3,824,876 Users
  • 2,260,435 Discussions
  • 7,896,336 Comments

Discussions

unique contstarint

User_E03DK
User_E03DK Member Posts: 46 Green Ribbon

Hi I have a t02( colume1 number,colum2 number,colum3 number,column4 number) like i created and also i created composit primary on those columns.

we usually inset data into that table which are getting data from sap team. when i inserting the data, we are getting unique constarint error. but no duplicate values when i checked. even though some values getting unique constraint errors.


other than composit primary key and composit unique ,is there any chance to get unique constriant error. surely no duplicate values.

Answers

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 3,834 Silver Crown

    No chance unless you try to insert a duplicate. It would be very strange that there is a bug on such a common feature.

    Please post the complete table definition (including Primary and Unique Keys) and the exact error message so we can figure out what the problem is,