PCM_OP_AR_EVENT_ADJUSTMENT performance (Doc ID 2987485.1)

Last updated on NOVEMBER 28, 2023

Applies to:

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

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