PM59718: WHEN USING A DATABASE CACHE, RESULTS CHANGE FROM NOT USING A CACHE.

APAR status

• Closed as program error.

Error description

• When using a database cache, results change from not using a
  cache.
  
  The problem is when a cache is used, the cache is created with
  generic types such as real for numerics.  If a stream is
  expecting integer data, the real data could fundamentally change
  its behavior.  Consider the case where a field is set up as 11,2
  and two entries zero out when summed together.  Such as 25.25
  and -25.25.  If this data is stored as a real and then the sum
  aggregated together, they may not zero out.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of in-database caches with numeric datatypes           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When using a database cache, results change from not using a *
  * cache.                                                       *
  *                                                              *
  * The problem is when a cache is used, the cache is created    *
  * with                                                         *
  * generic types such as real for numerics.  If a stream is     *
  * expecting integer data, the real data could fundamentally    *
  * change                                                       *
  * its behavior.  Consider the case where a field is set up as  *
  * 11,2                                                         *
  * and two entries zero out when summed together.  Such as      *
  * 25.25                                                        *
  * and -25.25.  If this data is stored as a real and then the   *
  * sum                                                          *
  * aggregated together, they may not zero out.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Modeler 14.2 FP3 or 15.0 to resolve this problem. *
  ****************************************************************
  

Problem conclusion

• Upgrade to Modeler 14.2 FP3 or 15.0 to resolve this problem.
  

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

  SPSS MODELER SV

• Fixed component ID

  5725A65MS

Applicable component levels

• RE20 PSY

     UP