Import From Excel Spreadsheet Java Concurrent Program Erroring With JAVA.LANG.OUTOFMEMORYERROR (Doc ID 1073268.1)

Last updated on MAY 06, 2016

Applies to:

Oracle Advanced Product Catalog - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
EGOIJAVA

Symptoms

In Product Information Management (PIM), when attempting to import items using 'Import from Excel' conncurrent program EGOIJAVA, the below error occurs.

Error
Jan 4, 2010 10:24:11 PM oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space

at oracle.jdbc.driver.NumberCommonAccessor.getBytes(NumberCommonAccessor.java:3301)
at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:552)
at oracle.jbo.domain.Number$1facClass.createDatum(Number.java:103)...


What is working
Bouncing the server allows for some time like uploading up to 25K items.
But the error happens again after reaching 25K item total.

Steps
The issue can be reproduced at will with the following steps.
1. Select Oracle Development Manager Responsibility
2. Select Advanced Search under Item
3. Enter search and display criteria and click on search
4. The item data is displayed
5. Select "Export all items to excel"
6. Excel opens with data populated
7. Updated some attribute values for all the items
8. Select "Upload" in excel
9. Upload the data with New Item Request = No and submit the request immediately
10. Concurrent "EGO Spreadsheet Java Concurrent Program" gets submitted
11. The concurrent program "EGO Spreadsheet Java Concurrent Program" completes with error.

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