PM46602: Running batch refresh causes 'Overflow' error and stops when updating CQ links in a large database because of malformed query

APAR status

• Closed as program error.

Error description

• - Running a batch refresh on a large database can cause an
  'Overflow' error and stop the processing.  This is because the
  query used to update the ClearQuest links is malformed and needs
  additional filters.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  USERS AFFECTED:
  - Users of the RequisitePro-ClearQuest integration running a
  RequisitePro-ClearQuest batch refresh operation.
  
  PROBLEM DESCRIPTION
  - When a batch refresh operation occurs, it loads into memory
  more data than it needs when updating the links.
  In databases with many requirements this could cause the Batch
  Refresh to load too much data and then cause an overflow,
  showing an Overflow message in the Batch Refresh log file.
  

Problem conclusion

• Batch Refresh code was updated to reduce the amount of data
  loaded into memory and prevent an overflow.
  The fix for this APAR was included in RequisitePro version
  7.1.1.8, 7.1.2.5 and 7.1.3.1.
  

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

  REQUISITEPRO WI

• Fixed component ID

  5724G3900

Applicable component levels

• R701 PSN

     UP