This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Question
The Pusrge execution summary Operation is having expericieng issue since 5 days ago, before were working fine without issue.
Duering hte execution you can see the following error message:
Could not acquire lock: 9javmasudvmfsoznzm8z
Answer
According to the errors
General.log // Windows
2018-08-31 10:39:39,381 [1_WorkerExecutionThread-10_6569618551] (SqlExceptionHelper.java:144) WARN - SQL Error: 1, SQLState: 23000
2018-08-31 10:39:39,382 [1_WorkerExecutionThread-10_6569618551] (SqlExceptionHelper.java:146) ERROR - ORA-00001: unique constraint (HPOO.UQ_OO_RUNTIME_VALUE_STORE_KEY) violated
General.log // Linux
2018-09-03 12:00:03,058 [1_WorkerExecutionThread-13_6724588288] (SqlExceptionHelper.java:144) WARN - SQL Error: 1, SQLState: 23000
2018-09-03 12:00:03,058 [1_WorkerExecutionThread-13_6724588288] (SqlExceptionHelper.java:146) ERROR - ORA-00001: unique constraint (HPOO.UQ_OO_RUNTIME_VALUE_STORE_KEY) violated
Excecution.log
2018-08-29 06:02:31,479 [scoreWorkerScheduler-1] (RetryTemplate.java:39) ERROR - Try #2 failed on:
Look for OO_RUN_VALUE_STORE if there is data, truncate it