OHMPI And MS SQLServer - OPSException: MDM-MI-OPS695: Could not retrieve the TransactionObjects from the database (Doc ID 2020110.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Using OHMPI 2.0.7.1 or 2.0.9.1.
OHMPI is configured with SQL-Server as database system.
When trying to retrieve Transactions objects, this action fails with following error-message:

 

  ...
  OPSException: MDM-MI-OPS695: Could not retrieve the TransactionObjects from the database: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified., stack trace=
  com.sun.mdm.index.ops.TransactionMgrImpl.findTransactionLogs(TransactionMgrImpl.java:1099)
  com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.lookupTransactions(MasterControllerCoreImpl.java:2848)
  com.sun.mdm.index.ejb.master.MasterControllerCoreImpl.lookupTransactions(MasterControllerCoreImpl.java:2792)
  com.sun.mdm.index.ejb.master.MasterControllerEJB.lookupTransactions(MasterControllerEJB.java:1355)
  ...


From the GUI, this issue can be reproduced by following next steps:

 

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