IT44608: DAO EXCEPTION - QUERY JOBLOG COLLECTION USES MORE MEMORY THAN IS AVAILABLE FOR SUCH QUERIES

APAR status

• Closed as program error.

Error description

• When querying Job Log from the IBM Storage Protect Plus UI and
  using Job Log filter
  
  option 'Select All' the following window pops up when jumping
  to the last page:
    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:
  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 Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.15.1 and later.         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is fixed *
  * in IBM Spectrum Protect Plus level 10.1.15.3 and 10.1.16.    *
  * Note that this is subject to change at the discretion of IBM *
  ****************************************************************
  

Problem conclusion

• In IBM Spectrum Protect Plus before 10.1.15.3 and 10.1.16, the
  MongoDB sorting maximum memory value was kept at its default of
  30 MB. This memory value was insufficient for large SPP
  deployments, resulting in large queries failing with a memory
  exhaustion error. In IBM Spectrum Protect Plus 10.1.15.3 and
  10.1.16, this maximum memory value was increased to around 300
  MB, significantly reducing the chance that a large query will
  fail with a memory exhaustion error.
  

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