APList Diagnostic Fails on Java Heap Error (Doc ID 1667064.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Business Suite Diagnostics - Version 12.1.3 and later
Information in this document applies to any platform.
APList Diagnostic Fails on Java Heap Error

ODX-0060: SQL has not been executed as table or view does not exist (ORA-00942 returned)
Error executing element "sql" with the name "SQL_115_AX" Error in the sql statement: "SELECT event_id FROM AX_EVENTS WHERE application_id = 200 AND event_type like 'NON_CASH%' AND event_field1 = :1 AND NVL(org_id, -99)= :2 UNION SELECT event_id FROM AX_EVENTS WHERE application_id = 200 AND ( event_type like 'CASH%' OR event_type like 'FUTURE%' ) AND event_field1 IN ( SELECT check_id FROM AP_INVOICE_PAYMENTS_ALL WHERE invoice_id = :3 ) AND NVL(org_id, -99) = :4" with the bind values: "'174120', '82', '174120', '82'".


ERROR - ODX-0467: Unable to execute the if expression due to invalid variable in test attribute: $SQL_115_AX.
ACTION - If the XML file for this test was delivered by Oracle Support Services, contact the support representative for assistance
General Ledger

Symptoms

Tried running diagnostic, which fails with 'Test aborted. No downloadable report got generated.'

Log file generated on server $INST_TOP/logs/oam/diagnostics/logs following error is noticed.

java.lang.OutOfMemoryError: Java heap space
at java.lang.String.toCharArray(String.java:2726)
at oracle.apps.fnd.oam.diagnostics.dao.LogDAO.insertLegacyReport(LogDAO.java:385)
at oracle.apps.fnd.oam.diagnostics.exec.LegacyTestExecution.insertReport(LegacyTestExecution.java:61)
at oracle.apps.fnd.oam.diagnostics.exec.LegacyJavaTestExecution.execute(LegacyJavaTestExecution.java:106)
at oracle.apps.fnd.oam.diagnostics.exec.WorkerThread.run(WorkerThread.java:49)
at java.lang.Thread.run(Thread.java:619)

so i uploaded this file and the OD_report log file generated by the diag request

Changes

 NONE

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