ORA-600 [QMNFAEXEC:MAXTNODES] ON XMLQUERY WITH MORE THAN 510 COLUMNS

(Doc ID 2401701.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version, Internals Errors (ORA-600 & ORA-7445)

When attempting to run

select con.global_id
, XMLCast(XMLQuery('/Content/TEST001001' passing con.content_xml returning content) as varchar2(10)) TEST001
, XMLCast(XMLQuery('/Content/TEST002001' passing con.content_xml returning content) as varchar2(10)) TEST002
, XMLCast(XMLQuery('/Content/TEST003001' passing con.content_xml returning content) as varchar2(10)) TEST003
.
, XMLCast(XMLQuery('/Content/TEST509001' passing con.content_xml returning content) as varchar2(1)) TEST509
, XMLCast(XMLQuery('/Content/TEST510001' passing con.content_xml returning content) as varchar2(1)) TEST510
, XMLCast(XMLQuery('/Content/TEST511001' passing con.content_xml returning content) as varchar2(1)) TEST511
-- het probleem op 12c ontstaat na 510 XML queries
from endeca.end_frg_content_data_tmp con

the following error occurs.

ERROR
-----------------------
ORA-00600: internal error code, arguments: [qmnfaExec:maxtnodes], [513], [], [], [], [], [], [], [], [], [], []

Changes

 

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