IT39376: REST API QUERY FAILS: SORT OPERATION USED MORE THAN THE MAXIMUM 33554432 BYTES OF RAM. ADD AN INDEX, OR SPECIFY A SMALLER LIMIT

APAR status

• Closed as program error.

Error description

• Running a REST API call api/endeavour/log in IBM Spectrum
  Protect Plus can fail with the following error found in the
  virgo log:
  
  <timestamp> ERROR ...
  com.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 33554432 bytes of RAM. Add an index, or specify a
  smaller limit."
  
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect Plus 10.1.7 and later
  
  | MDVREGR 10.1.6.0-TIV_5737SPLUS |
  
  Additional Keywords: SPP, SPPLUS, TS005928722, REST API
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.17, 10.1.8, 10.1.9 and  *
  * 10.1.10.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.11. Note that this is subject to change at the          *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• A MongoDB index has been added for the LOG collection, which
  will reduce the memory required to sort queries of the
  api/endeavour/log endpoint.
  

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

• Platform Other
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels