Web ADI Performance and Out of Memory issues seen when uploading large amounts of data (Doc ID 2506299.1)

Last updated on DECEMBER 10, 2024

Applies to:

Symptoms

When using BNE Profile BNE: Enable OOXML Standard being set to Yes.

Web ADI Performance for Create Document and Upload functionality improves as the performance does not depend on the Client PC desktop capacity, when being set.

The performance for the Web ADI Upload and Create Document functionality is better when using the Middle Tier server capacity.

If there are issues seen with the Web ADI Uploads related to Performance or Create Document taking time to build the Integrator, then you will need to look into Fine Tuning the Middle Tier's resources.

If the Middle Tier is not sized correctly to handle the added functionality of the BNE Profile BNE: Enable OOXML Standard being set to Yes you can experience overall Web Server/Middle Tier Performance degradation when Server is under load.

This is mainly seen when uploading large amounts of Data in the Web ADI Integrator containing many Rows and even Columns and can occur during times of month end.

Changes

Setting Profile BNE: Enable OOXML Standard = Yes

If the profile option, BNE: Enable OOXML Standard, would be set No, testing the same amount of rows and data would not be able to upload and the desktop Excel will probably hang.

Then, the cause of the problem is not that BNE: Enable OOXML Standard is set to Yes.

The cause would be related to the Middle Tiers needing to be fine tuned.

Cause

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