LRM Run Skey Issue While Executing ALM and LRM Batches parallelly (Doc ID 2911256.1)

Last updated on NOVEMBER 27, 2022

Applies to:

Symptoms

While click on "Create" or "Execute Batch" in Run Management Screen, Getting below error

Under LRM -> Run Management -> Run execution parameters -> while Click on "Create Batch" or "Execute" it's throwing an error "Error occurred while creating batch, Please check log for details" in UI

As per LRM.log:

[INFO ] [WEB] [RunManagementController.executeRM: ] *********************BATCH CREATION FAILED*************************

[INFO ] [WEB] [RunManagementController.executeRM: ] Batch Creation Failed

[INFO ] [WEB] [RunManagementController.executeRM: ] Batch creation / Execution returnVal

..{"errorCode":null,"errorResponse":null,"jsonData":"{15067}"}

As per PR2Service log from Webserver:

Caused by: Error : 1, Position : 0, Sql = INSERT INTO dim_run(N_RUN_SKEY,V_RUN_ID, FIC_MIS_DATE, D_RECORD_START_DATE, D_RECORD_END_DATE,

F_LATEST_RECORD_INDICATOR, V_RUN_EXECUTION_ID, N_VERSION_NUMBER, V_UNIQUE_ID,V_EXECUTION_DESCRIPTION, V_VERSION_DESCRIPTION, V_RUN_STATUS, V_RUN_MAIN_ID,

V_RUN_MAIN_DESC, V_RUN_DESC, N_RUN_TYPE_SKEY) VALUES (:1 , :2 , :3 , :4 , :5, :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 ), OriginalSql

= INSERT INTO dim_run(N_RUN_SKEY, V_RUN_ID, FIC_MIS_DATE,D_RECORD_START_DATE, D_RECORD_END_DATE, F_LATEST_RECORD_INDICATOR,V_RUN_EXECUTION_ID, N_VERSION_NUMBER, V_UNIQUE_ID, V_EXECUTION_DESCRIPTION,V_VERSION_DESCRIPTION, V_RUN_STATUS, V_RUN_MAIN_ID, V_RUN_MAIN_DESC,V_RUN_DESC, N_RUN_TYPE_SKEY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?), Error Msg = ORA-00001: unique constraint (OFSAAATM.PK_511) violated

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.