Dondon22 Respected Contributor.
Respected Contributor.
325 views

ERROR - ORA-00001: unique constraint (OOAPPADMIN.UQ_OO_RUNTIME_VALUE_STORE_KEY) violated

Hi!

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

Rgds,

Don

In IT there is no Magic, just Logic ^_^
0 Likes
1 Reply
Micro Focus Expert
Micro Focus Expert

Re: ERROR - ORA-00001: unique constraint (OOAPPADMIN.UQ_OO_RUNTIME_VALUE_STORE_KEY) violated

Hi,

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,

Vlad

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.