XQuery fails with ORA-600 arguments: [qmnfaAddXPathTONFAPOS1] on 11.2.0.2.0 (Doc ID 1379958.1)

Last updated on NOVEMBER 23, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

After upgrade from 11.2.0.1 to 11.2.0.2 one of our XQueries fails with the following error

SQL> SELECT t.PT21fc8b00d3da, t.PT6132d9c6ffe3, t.PT82c1b97804fd,
...
FROM SEARCH_DATA, XMLTABLE('$C/ROOT' PASSING
SEARCH_DATA.SEARCH_EXTENSION AS "C" COLUMNS PTec4c8ab28b09 VARCHAR(100) PATH 'CAST_CREDIT_APPLICATION.CREDIT_APPLICATION_IDASVARCHAR_32__[1]' ,
PT21fc8b00d3da INTEGER PATH 'CREDIT_APPLICATION.CREDIT_APPLICATION_SEQ[1]' ,
PT6132d9c6ffe3 VARCHAR(100) PATH 'PERSON_NAME.LAST_NAMECONCATCONCATPERSON_NAME.FIRST_NAME_ASAPPLICANT_NAME[1]' ,
PERSONPERSONNOTETXT VARCHAR(100) PATH 'PERSON.PERSON_NOTE_TXT[1]' ,
PRODUCTTYPEPRODUCTTYPECD VARCHAR(100) PATH 'PRODUCT_TYPE.PRODUCT_TYPE_CD[1]' ,
PT5aece93b25eb VARCHAR(100) PATH 'CAST_CREDIT_PROD_CAT_ORIGNTN.PRODUCT_CATEGORY_ORIGNTN_IDASVARCHAR_32__[1]' ,
PT75fbd871e5d8 VARCHAR(100) PATH 'CREDIT_APPLICATION.CREDIT_APPLICATION_TYPE_CD[1]' ,
PTa9ffd04dc278 VARCHAR(100) PATH 'CREDIT_APPLICATION.CREDIT_APPL_CHANNEL_TYPE_CD[1]' ,
PARTYPHONEPHONENUM VARCHAR(100) PATH 'PARTY_PHONE.PHONE_NUM[1]' ,
PTb6f23a05cca5 VARCHAR(100) PATH 'CAST_CREDIT_APPLICATION.APPL_SOURCE_SVC_PRVDR_PARTY_IDASVARCHAR_32__[1]' ,
PT82c1b97804fd TIMESTAMP PATH 'CREDIT_APPLICATION.CREDIT_APPLICATION_DTTM[1]' ,
PTa6e8cd67c6e1 VARCHAR(100) PATH 'CREDIT_APPLICATION.CREDIT_APPLICATION_STATUS_CD[1]' ,
PTbe4f106d4740 VARCHAR(100) PATH 'CAST_CREDIT_APPLICATION.CREATED_BY_USER_IDASVARCHAR_32__[1]' ,
CREDITDETAILADVANCEAMT DECIMAL(22 , 3) PATH 'CREDIT_DETAIL.ADVANCE_AMT[1]' ,
PT9e13ed336051 TIMESTAMP PATH 'CREDIT_APPLICATION.STATUS_CHANGE_DTTM[1]' ,
PT29a9f568a854 VARCHAR(100) PATH 'CAST_CREDIT_APPLICATION.LOAN_OFFICER_IDASVARCHAR_32__[1]' ,
CUSTAPPLICANTCUSTOMERTYPECD VARCHAR(100) PATH 'CUST_APPLICANT.CUSTOMER_TYPE_CD[1]' ,
PTc6e22882b9fc VARCHAR(100) PATH 'CAST_CREDIT_APPLICATION.PROCESSING_CLIENT_PARTY_IDASVARCHAR_32__[1]' ,
PERSONNAMEFIRSTNAME VARCHAR(100) PATH 'PERSON_NAME.FIRST_NAME[1]' ,
PERSONNAMELASTNAME VARCHAR(100) PATH 'PERSON_NAME.LAST_NAME[1]' ) as t
WHERE SEARCH_DATA.TENANT_CD='FI_BASE_TENANT'
ORDER BY t.PT21fc8b00d3da ASC
/

SQL> SELECT t.PT21fc8b00d3da, t.PT6132d9c6ffe3, t.PT82c1b97804fd,
t.PT29a9f568a854, t.PTec4c8ab28b09, t.PERSONPERSONNOTETXT,
t.PRODUCTTYPEPRODUCTTYPECD, t.PT5aece93b25eb, t.PT75fbd871e5d8,
@ t.PTa9ffd04dc278, t.PARTYPHONEPHONENUM, t.CREDITDETAILADVANCEAMT
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qmnfaAddXPathTONFAPOS1], [], []

The created trace file shows following error stack

qmnfaAddXPathToNFA qmnfaPrepareXPaths qerxpCreateNFAs qerxpAllocate
qknRwsAllocateTree qknRwsAllocateTree qknRwsAllocateTree qknDoRwsAllocate
qkaTraverseQknDescendents ....

Changes

Database has been upgraded from 11.2.0.1 to 11.2.0.2

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