My Oracle Support Banner

ESI Issue- Unable To Successfully Prepare The Program For Publishing (Doc ID 2565411.1)

Last updated on APRIL 07, 2021

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 5.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 5.2.0.0.0 version, Framework Administrator IBFA

ESI issue- Unable to successfully prepare the program for publishing

Create srp fails with the following error -
java.lang.Exception: Error: Unable to successfully prepare the program for publishing. [usp_Q_RM_PREPARE_PROGRAM_TABLES] failed :Cannot Execute SQL Command: Transaction (Process ID 78) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  Running Cleanup Routines Program Inputs..
  Running Cleanup Routines Global Results..
  Running Cleanup Routines Calculated Variables..
  at com.oracle.ins.ru.sr.softservice.esi.EsiRateManager.createSRP(EsiRateManager.java:2316)
  at com.nationwide.pc.pricing.rip.service.impl.InsbridgeIntegrationServiceImpl.createSRP(InsbridgeIntegrationServiceImpl.java:513)
  ... 3 more


 

ERROR
-----------------------
java.lang.Exception: Error: Unable to successfully prepare the program for publishing. [usp_Q_RM_PREPARE_PROGRAM_TABLES] failed :Cannot Execute SQL Command: Transaction (Process ID 78) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
  Running Cleanup Routines Program Inputs..
  Running Cleanup Routines Global Results..
  Running Cleanup Routines Calculated Variables..
  at com.oracle.ins.ru.sr.softservice.esi.EsiRateManager.createSRP(EsiRateManager.java:2316)
  at com.nationwide.pc.pricing.rip.service.impl.InsbridgeIntegrationServiceImpl.createSRP(InsbridgeIntegrationServiceImpl.java:513)
  ... 3 more



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot publish a program via ESI.

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.