ASO RESOURCE USAGE CONFLICT ERROR (1270095) SPECIFIED LOAD BUFFER (Doc ID 2936031.1)

Last updated on MAY 04, 2023

Applies to:

Symptoms

On : 11.1.2.4.220 version, Integration

ASO Resource usage Conflict between data loads executed outside of FDMEE and FDMEE one: Many Failures

Use case:

1. Run dataload from Planning by launching BR in RUNJava mode

2. Each RUNJava is calling a BAT file that will execute a MXL file

3. One MXL file will perform a clear then a dataload

4. MXL is written so it is possible to execute several dataloads in parallel (resource_usage [0.05] for example, and also buffer_id is modified from the default which is 1 and lastly wait_for_resources is put everytime)

5. FDMEE can be used by other users in Self-Service mode to perform other dataloads

6. FDMEE cannot be changed for buffer_id, nor for wait_for_resources and nor for resource_usage size which is always 1

7. In the logs some situations where resource_usage aren't available for end-users inside Planning, or for some FDMEE end-users

8. FDMEE will do 20 attempts before failing

9. Due to high concurrency, user go up to 10000 attempts before having a buffer_id and/or a resource_usage free

Example here:

*Local*GLGlob*Finance*Florence_Marie@SGSMSAD*17560*Info*(1003099)*Buffer id *[1]* initialized with options: *resource_usage[1.00], aggregate_sum, ignore_missings

*Local*GLGlob*Finance*Florence_Marie@SGSMSAD*17560*Info*(1013166)*Received Command *[Import]* from user *[Florence_Marie@SGSMSAD]* using *[AIF0938.rul]

*Local*GLGlob*Finance*Florence_Marie@SGSMSAD*17560*Info*(1003053)*Data Load Elapsed Time with [AIF0938.rul] : [0.01] seconds

*Local*GLGlob*Finance*BAdmin@Native Directory*7984*Info*(1270107)*The specified data load buffer resource usage *[0.05]* exceeds the *[0]* resources currently available. Essbase is waiting for resources to become available

*Local*GLGlob*Finance*BAdmin@Native Directory*7984*Error*(1270095)*Specified load buffer resource usage *[0.05]* is above currently available value *[0]

ERROR

-----------------------

1270095

Error*(1270095)*Specified load buffer resource usage *[0.05]* is above currently available value *[0]

Changes

Cause

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