Operación Purge Execution Sumary - Error

  • KM03252363
  • 24-Sep-2018
  • 24-Sep-2018

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Customer is experiencing problem when he tried to use his Purge Execution Summary According the logs there is an error message vHPOO.UQ_OO_RUNTIME_VALUE_STORE_KEY in General logs and Execution log

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