ERROR - ORA-00001: unique constraint (OOAPPADMIN.UQ_OO_RUNTIME_VALUE_STORE_KEY) violated
This error keeps on appearing in general.log... I want to know what it is about? How to fix it?
Thanks in Advance...
2017-11-12 06:45:10,615 [http-nio-8443-exec-6] (BatchingBatch.java:141) ERROR - HHH000315: Exception executing batch [could not execute batch]
2017-11-12 06:45:10,943 [http-nio-8443-exec-16] (SqlExceptionHelper.java:144) WARN - SQL Error: 1, SQLState: 23000
2017-11-12 06:45:10,943 [http-nio-8443-exec-16] (SqlExceptionHelper.java:146) ERROR - ORA-00001: unique constraint (OOAPPADMIN.UQ_OO_RUNTIME_VALUE_STORE_KEY) violated
Based on the details given it seems to be a content lock that has not been released, yet something keeps trying to acquire it. In the OO_RUNTIME_VALUE_STORE table the content locks are kept and it seems like something is trying to write an entry for something that already exists.
Stop all schedules, clear the contents of the table and see when the error pops up again.
Hope this helps,