PCM_OP_AR_EVENT_ADJUSTMENT performance
(Doc ID 2987485.1)
Last updated on NOVEMBER 28, 2023
Applies to:
Oracle Communications Billing and Revenue Management - Version 12.0.0.7.0 and laterInformation in this document applies to any platform.
Symptoms
While executing PCM_OP_AR_EVENT_ADJUSTMENT for high volume events (>100K), the user is getting PIN_ERR_STREAM_EOF error in multi-thread application (MTA) and there are no errors encountered in connection manager (CM) logs. The user is calling this opcode from a customized MTA, which is picking data altogether (Ex : 200K events) and splitting into 10K quantity (20 iterations) and calling PCM_OP_AR_EVENT_ADJUSTMENT for 10K events in each iteration without committing. The transaction is finally committed once all 20 iterations are committed. It has been observed that up until 100K (10 iterations), the system is able to hold data. However, after 100k events, it is throwing PIN_ERR_STREAM_EOF in MTA logs and MTA gets terminated.
ERROR
-----------------------
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. For single account with more than 200k adjustment events, split these 200k events into 10k events and start calling PCM_OP_AR_EVENT_ADJUSTMENT with custom code.
2. Failed at 120k events while processing
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 |
Cause |
Solution |
References |