Large File Imports Are Not Working : JBO-29000: Unexpected exception caught (Doc ID 1959355.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Trading Community Model - Version 11.1.9.2.0 and later
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.9.1.0 version, File Import/Export

Account Import are not working with large file

Account import is successful with smaller files, but if we import a file with over 15,000-20,000 records, the job errors out. Import fails with status of "Unsuccessful." Import output status page shows 0 Load or Format errors, and does not generate a log or other file.

ERROR
-----------------------
ERROR The process fails to load data into import interface tables. Cause: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: javax.transaction.InvalidTransactionException, msg=Attempt to resume an inactive transaction: BEA1-114BEE8F88D8BC0E6A77
oracle.jbo.server.uniqueid.UniqueIdHelper.resumeJTATransaction(UniqueIdHelper.java:220)
oracle.jbo.server.uniqueid.UniqueIdHelper.getNextId(UniqueIdHelper.java:116)
oracle.jbo.server.uniqueid.UniqueIdHelper.getUniqueId(UniqueIdHelper.java:57)
oracle.jbo.server.uniqueid.UniqueIdHelper$getUniqueId.call(Unknown Source)
bc4j.oracle_apps_fnd_applcore_favRecentItems_model_entity_RecentItemsEO_RecentItemsId_Expression.gs.run(bc4j.oracle_apps_fnd_applcore_favRecentItems_model_entity_RecentItemsEO_RecentItemsId_Expression.gs.groovy:1)
oracle.jbo.ExprEval.internalEvaluateGroovyScript(ExprEval.java:1859)
oracle.jbo.server.EntityImpl.initDefaultExpressionAttributes(EntityImpl.java:1116)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Do normal import of Account object using csv.
2. See attached screenshots for more details.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer has 700,000 - 1,000,000 accounts to import and/or update. They need to be able to do this in bulk with large files.

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