OCIError: ORA-00001: unique constraint violated
Posted on 2014-09-18
I am having an unique constraint issue during insertion in ruby on rails app. (The insertion doesn't work all the time. It works occasionally though.) The error message is:
OCIError: ORA-00001: unique constraint (ABCSIGN_DBA.PK_ATTEND_IP) violated: INSERT INTO attend_ip (xxx, xxx, xxx, .........)
I checked constraints tab for the ATTEND_IP table in Oracle SQL Developer and I don't see any name "PK_ATTEND_IP". All the names are:
SYS_XXXXXX, SYS_XXXXXX, .....
and their types are all checking not null.
There are a few other DB tables, but they are not related to ATTEND_IP table.
Now, based on the error message, how do I find this unique constraint that might cause this issue on the database.
thanks in advance.