IT45421: DAO EXCEPTION - QUERY NOTIFICATION COLLECTION USES MORE MEMORY THAN IS AVAILABLE FOR SUCH QUERIES

APAR status

• Closed as program error.

Error description

• While clearing alerts in the IBM Storage Protect Plus UI's
  Alerts menu, an error pop-up window appears with the following
  error message.
  
  D A O Exception An error has occurred. See logs for more
  information
  
  
  In the IBM Storage Protect Plus virgo log the following error
  can be seen:
  [<timestamp>] ERROR http-nio-8082-exec-129
  c.s.dp.xsb.api.commons.exception.ExceptionMessageTranslator
  om.syncsort.dp.xsb.persistence.dao.XSBDAOException:
  com.mongodb.MongoException: Executor error during OP_QUERY find
  :: caused by :: errmsg: "Sort operation used more than the
  maximum 335544320 bytes of RAM. Add an index, or specify a
  smaller limit."
  
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.X
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All versions of IBM Spectrum Protect Plus.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * levels 10.1.16.1 and 10.1.17.                                *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• Before IBM Spectrum Protect Plus 10.1.16.1 and 10.1.17, the
  NOTIFICATION collection in MongoDB that stores alerts was not
  capped and, therefore, could grow indefinitely. If the
  collection grew too large, sorting the collection to display the
  alerts by newest first would result in an out-of-memory
  condition. Since IBM Spectrum Protect Plus 10.1.16.1 and
  10.1.17, the NOTIFICATION collection has been capped,
  prohibiting the out-of-memory condition during sorting. This
  ensures that an exception is not thrown when displaying all
  alerts to the user on the IBM Spectrum Protect Plus user
  interface.
  

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:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels