'No Key Was Generated' Error Popup For Final Bill For SA With Active Deposit In CC&B V2.4.0.3 (Doc ID 2244550.1)

Last updated on MARCH 20, 2017

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 to 2.4.0.3.0 [Release 2.4]
Information in this document applies to any platform.

Symptoms

On : 2.4.0.3.0 version, ENV - Environment

'No key was generated' error popup for final bill for SA with active deposit in CC&B v2.4.0.3

We are in the testing phase of upgrading from CC&B v2.2.0 9 to v2.4.0.3. When a user creates a final bill for a Service Agreement with an active deposit, an exception popup should appear that says "Active Deposit SA exists for Account 2492720000", where the account number is dynamic. In our 2.4 environment, we receive a popup message that states "No key was generated" instead. Additional information and a trace file will be attached.

ERROR
-----------------------
WALDS2 - 918818-50993-1 2017-01-27 11:28:29,831 [Parent Reader:Thread-33] INFO (support.context.FrameworkSession) (Server Message)
Category: 25
Number: 11304
Call Sequence: ;CIPZKEYG;CIPZADTA;CIPBBLRR
Program Name: CIPBBLRR
Text: No key was generated.
Description:
Table:
Field:


WALDS2 - 918818-50993-1 2017-01-27 11:28:28,716 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN (support.service.ServiceReplayExecuter) Attempt #1 of calling service for change failed - will attempt replay up to 1 more time
com.splwg.shared.common.ApplicationWarning:
  Active Deposit SA exists for Account 2492720000.

WALDS2 - 918818-50993-1 2017-01-27 11:28:29,815 [Remote JVM:1 Thread 3] INFO (COBOL.CIPZKEYG) *** WARNING: EITHER TABLE/ID CI_AUDIT_K /AUDIT_ID IS GETTING FULL OR NEEDS TUNING.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When a user creates a final bill for a Service Agreement with an active deposit, an exception popup should appear that says "Active Deposit SA exists for Account 2492720000", where the account number is dynamic.
2. In our 2.4 environment, we receive a popup message that states "No key was generated" instead.


SYMPTOMS
--------------
1. From the log file, we can see that the audit in enabled as CIPZADTA is showing in the log file.
2. The error message should report properly with the random SA number but it was not, showing error "no key generated" instead.
3. The log file shows the expected error message as a warning - "com.splwg.shared.common.ApplicationWarning: Active Deposit SA exists for Account 2492720000." " *** WARNING:  EITHER TABLE/ID CI_AUDIT_K/AUDIT_ID  IS GETTING FULL OR NEEDS TUNING."


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see expected error message.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms