user13755008 wrote:According to what you posted UK columns are:
Even dropping and creating the constraint again didn't work. Any ideas out there?. Thanks
So why you are showing us results of:
ODBID_EQP OBJECT_NUM INTERFACE START_DATE
select * from nc3.hsrp_track where <font color=red size=3>odbid</font>= 87820678;and not
select * from nc3.hsrp_track where <font color=red size=3>odbid_eqp</font>= 87820377;Anyway, row you are trying to insert has:
ODBID_EQP = 87820377 OBJECT_NUM = '1' INTERFACE = 'Serial0/0' START_DATE = '2013-01-18'
and post result.
select count(*) from nc3.hsrp_track where ODBID_EQP = 87820377 and OBJECT_NUM = '1' and INTERFACE = 'Serial0/0' and START_DATE = '2013-01-18'