Exporting Huge Bill of Materials(BOMs) In .Axml Format Fails with Error:'ORA-01403: no data found' When Option 'All Levels' Is Selected (Doc ID 3014742.1)

Last updated on APRIL 04, 2024

Applies to:

Symptoms

Exporting to .axml with all level BOMs fails with error.
Same error is seen when trying to download all levels of BOM as .axml from custom code.

Call APIException.getRootCause() for details.
Root Cause exception :javax.transaction.TransactionRolledbackException: BEA1-0FA079404AD034C34FF7;
nested exception is: weblogic.transaction.RollbackException: (ContentDataSource_agileDomain, XAException.XA_HEURHAZ HeuristicHazard,
(javax.transaction.xa.XAException: ORA-01403: no data found))



The issue can be reproduced at will with the following steps:

Use Case 1:
1. Login to Agile Web Client - http(s)://<FQDN>:<port>/Agile/PLMServlet
2. Go to a part object with huge BOM.
3. Click on Actions Menu | Export.
4. Select .axml format and BOM | All levels in Export wizard.
5. Click Export.
6. Export fails with error.

Use Case 2:
1. Run a custom code to download the BOM with 'All levels' in .axml format.
2. Code also fails with the same error.

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.