NullPointerException When Trying To Configure A Search Using SystemObject Instead Of SystemSBR (Doc ID 2290795.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

When query.xml (and mefa.xml) are configured to do searches against the system objects, rather than the more typical SBR in OHMPI 4.0.1.1, the following error occurs.

Jun 06, 2017 10:09:08 AM net.java.hulp.i18n.Logger severe
SEVERE: MDM-MI-MSC582: MasterControllerImpl encountered a ProcessingException: name=com.sun.mdm.index.matching.MatchingException, message=MDM-MI-MAT511: QueryManager execution failed: com.sun.mdm.index.query.QMException: MDM-MI-QUE546: execute() failed: java.lang.NullPointerException, stack trace=
com.sun.mdm.index.matching.MatchEngineControllerImpl.findMatch(MatchEngineControllerImpl.java:341)
com.sun.mdm.index.matching.MatchEngineControllerImpl.findMatch(MatchEngineControllerImpl.java:186)
com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.searchEnterpriseObject(MasterControllerCoreImpl.java:3680)
com.sun.mdm.index.ejb.master.MasterControllerEJB.searchEnterpriseObject(MasterControllerEJB.java:610)
...

This was working in the earlier version of  OHMPI such as OHMPI 1.1.8.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Change the Blocker Search part of query.xml using Netbeans:
  SystemSBR - >SystemObject

2) Generate Master Index file
3) Clean and build
4) Redeploy
5) Try to search using the Blocker-Search

Get the following message:
 We apologize there is an error in the page. The server encountered unexpected condition which prevented it from fulfilling the request. Please contact system administrator or Login again.

Check the stacktrace:

weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
at com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.throwProcessingException(MasterControllerCoreImpl.java:5922)
at com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.searchEnterpriseObject(MasterControllerCoreImpl.java:3748)
at com.sun.mdm.index.ejb.master.MasterControllerEJB.searchEnterpriseObject(MasterControllerEJB.java:610)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Truncated. see log file for complete stacktrace
Caused By: com.sun.mdm.index.matching.MatchingException: MDM-MI-MAT511: QueryManager execution failed: com.sun.mdm.index.query.QMException: MDM-MI-QUE546: execute() failed: java.lang.NullPointerException
at com.sun.mdm.index.matching.MatchEngineControllerImpl.findMatch(MatchEngineControllerImpl.java:341)
at com.sun.mdm.index.matching.MatchEngineControllerImpl.findMatch(MatchEngineControllerImpl.java:186)
at com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.searchEnterpriseObject(MasterControllerCoreImpl.java:3680)
at com.sun.mdm.index.ejb.master.MasterControllerEJB.searchEnterpriseObject(MasterControllerEJB.java:610)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Truncated. see log file for complete stacktrace
Caused By: com.sun.mdm.index.query.QMException: MDM-MI-QUE546: execute() failed: java.lang.NullPointerException
at com.sun.mdm.index.query.QueryManagerImpl.execute(QueryManagerImpl.java:169)
at com.sun.mdm.index.matching.MatchEngineControllerImpl.retrieveBlock(MatchEngineControllerImpl.java:538)
at com.sun.mdm.index.matching.MatchEngineControllerImpl.findMatch(MatchEngineControllerImpl.java:274)
at com.sun.mdm.index.matching.MatchEngineControllerImpl.findMatch(MatchEngineControllerImpl.java:186)
at com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.searchEnterpriseObject(MasterControllerCoreImpl.java:3680)
Truncated. see log file for complete stacktrace
Caused By: java.lang.NullPointerException
at com.sun.mdm.index.query.QPath$SubQPath.createSubQuery(QPath.java:712)
at com.sun.mdm.index.query.QPath.createConditions(QPath.java:157)
at com.sun.mdm.index.query.SingleQPath.createSQL(SingleQPath.java:200)
at com.sun.mdm.index.query.SingleQueryParser.createSQL(SingleQueryParser.java:155)
at com.sun.mdm.index.query.SingleQueryParser.parse(SingleQueryParser.java:141)
Truncated. see log file for complete stacktrace

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.