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

Last updated on JULY 26, 2017

Applies to:

Oracle Healthcare Master Person Index - Version 4.0.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 4.0.1.1 version, Master Index Main Component

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

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