IZ85252: "BMXAA4210E - DATABASE ERROR NUMBER 1797 HAS OCCURRED. ORA-01797: THIS OPERATOR MUST BE FOLLOWED BY ANY OR ALL"

APAR status

• Closed as program error.

Error description

• In create desktop requistion application,
  requisition line items I am
  trying to select an item from 'select value' lookup.  I get the
  following message
  "BMXAA4210E - Database error number 1797 has occurred.
  ORA-01797: this operator must be followed by ANY or ALL"
  I also get this message when I try to select an item from Go to
  Item
  master, return with value option.
  But I am able to select an item from go to Inventory option.
  
  from client:
  psdi.app.mr.FldMRLineItemnum class is not customized.  We are
  using
  outofbox Maximo class file.
  
  Based on my investigation, it's a bug in LocationService.class.
  
  In LocationService.class, getStoreLocations method, if you look
  at third
  line where clause, you can see "type =" statement.  This
  statement
  causes problem when you have synonymn of storeroom location type
  in
  LOCTYPE synonymdomain domain.  When you do not have synonym of
  storeroom
  location type, we do not have this problem.
  
              public MboSetRemote getStoreLocations(UserInfo
  userInfo)
  throws MXException, RemoteException
      {
          String type = "STOREROOM";
          String loctype =
  getMaximoDD().getTranslator().toExternalList("LOCTYPE", type);
          String where = (new StringBuilder()).append("type =
  (").append(loctype).append(") and (disabled = :no)").toString();
  
  
  This method is getting invoked in findAndSetStoreLoc method of
  psdi.app.mr.FldMRLineItemnum class.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Maximo users                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: In Desktop Requisitions - Create        *
  *                      Requisition application, "BMXAA4210E -  *
  *                      DATABASE ERROR NUMBER 1797 HAS          *
  *                      OCCURRED. ORA-01797: THIS OPERATOR MUST *
  *                      BE FOLLOWED BY ANY OR ALL." is          *
  *                      encountered when using Select Value     *
  *                      lookup to return an item to the         *
  *                      'Requisition Line Items' table window   *
  *                      and the LOCTYPE domain has a synonym    *
  *                      value for the STOREROOM loctype. The    *
  *                      error text following "BMXAA4210E -      *
  *                      DATABASE ERROR NUMBER ..." will differ  *
  *                      depending on database platform. This    *
  *                      problem occurs on all database          *
  *                      platforms.                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  In Desktop Requisitions - Create Requisition application,
  "BMXAA4210E - DATABASE ERROR NUMBER 1797 HAS OCCURRED.
  ORA-01797: THIS OPERATOR MUST BE FOLLOWED BY ANY OR ALL." is
  encountered.
  

Problem conclusion

• In Desktop Requisitions - Create Requisition application user
  is able to use the Select Value lookup to return an item to the
  'Requisition Line Items' table window whether or not the
  LOCTYPE domain has a synonym value for the STOREROOM loctype.
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.1.1.8 - BS
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  WORK ORDER TRAC

• Fixed component ID

  5724R46WO

Applicable component levels

• R711 PSY

     UP