My Oracle Support Banner

DIM_RUN_SEQUENCE Does Not Take Into Account The Max N_run_skey Value when LRM Run is executed (Doc ID 2844737.1)

Last updated on FEBRUARY 07, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

LRM Contractual/BAU Run execution failed with the below.

From LRM.log(Deployed Path):

[INFO ] [WEB]  [OFSAAIService.createBatch] null
com.ofs.aai.service.OFSAAServiceException: null
    at com.ofs.aai.service.run.RunService.fireRun(RunService.java:2122) ~[aai-rrf-service.jar:?]
    at com.ofs.aai.service.run.RunService.extendedService(RunService.java:1898) ~[aai-rrf-service.jar:?]
    at com.ofs.lrm.aai.OFSAAIService.createBatch(OFSAAIService.java:330) ~[lrm.jar:?]
    at com.ofs.lrm.common.RunExecution.createBatch(RunExecution.java:1133) ~[lrm.jar:?]
    at com.ofs.lrm.controller.RunManagementController.executeRM(RunManagementController.java:1138) ~[lrm.jar:?]

From OFSAAErr.log(Deployed Path)

[ERROR] [$LOG_INSTANCE]  [NA] [NA] PR2 Persistance Exception :
com.ofs.aai.pr2.global.PR2PersistanceException: java.sql.SQLException: Could not execute sql command - Original message: ORA-00001: unique constraint (OFSAEPM.PK_329) violated

    at com.ofs.aai.pr2.view.adapter.ManageRunAdapter.createDimRunEntry(ManageRunAdapter.java:1311) ~[aai-rrf.jar:?]
    at com.ofs.aai.pr2.view.adapter.ManageRunAdapter.handleManageRunRequest(ManageRunAdapter.java:762) ~[aai-rrf.jar:?]
    at com.ofs.aai.pr2.view.adapter.ManageRunAdapter.addRunExec(ManageRunAdapter.java:379) ~[aai-rrf.jar:?]
    at com.ofs.aai.pr2.service.adapter.FireRunAdapter.invokeRunService(FireRunAdapter.java:238) ~[aai-rrf.jar:?]
    at com.ofs.aai.service.run.RunService.fireRun(RunService.java:2115) ~[aai-rrf-service.jar:?]
    at com.ofs.aai.service.run.RunService.extendedService(RunService.java:1898) ~[aai-rrf-service.jar:?]
    at com.ofs.lrm.aai.OFSAAIService.createBatch(OFSAAIService.java:330) ~[lrm.jar:?]
    at com.ofs.lrm.common.RunExecution.createBatch(RunExecution.java:1133) ~[lrm.jar:?]
    at com.ofs.lrm.controller.RunManagementController.executeRM(RunManagementController.java:1138) ~[lrm.jar:?]

Caused by: java.sql.SQLException: Could not execute sql command - Original message: ORA-00001: unique constraint (OFSAEPM.PK_329) violated

    at com.ofs.aai.database.OFSAAPreparedStatementDecorator.executeUpdate(OFSAAPreparedStatementDecorator.java:895) ~[aai-core.jar:?]
    at com.ofs.aai.pr2.view.adapter.ManageRunAdapter.createDimRunEntry(ManageRunAdapter.java:1268) ~[aai-rrf.jar:?]

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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