PM74330: NUMERIC OVERFLOW OCCURRED DURING COMPUTATION ERROR USING _ROUND WITH TERADATA ON LARGE NUMBER

APAR status

• Closed as fixed if next.

Error description

• Using the _round function against Teradata on a large number
  will fail with a "Numeric overflow occurred during computation"
  error.
  

Local fix

• modify the cogdmod_td.ini file
  (location in the Cognos bin folder)...
  N _round(%1n, %2n)=CASE WHEN (%1) < 0 THEN (CAST( ( (%1) * ( 10
  **
  (%2) ) - 0.5 ) AS INTEGER ) / ( 10 ** (%2) )) ELSE (CAST( ( (%1)
   * (
  10 ** (%2) ) + 0.5 ) AS INTEGER ) / ( 10 ** (%2) )) END;
  .
  to
  .
  N _round(%1n, %2n)=CASE WHEN (%1) < 0 THEN (CAST( ( (%1) * ( 10
  **
  (%2) ) - 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) ELSE (CAST( ( (%1)
  * ( 10
   ** (%2) ) + 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) END;
  .
  Also another spot just below that to ...
  N round(%1n, %2n)=CASE WHEN (%1) < 0 THEN (CAST( ( (%1) * ( 10 *
  * (%2)
   ) - 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) ELSE (CAST( ( (%1) * (
  10 **
  (%2) ) + 0.5 ) AS BIGINT ) / ( 10 ** (%2) )) END;
  .
  This needs to be done on FM and Dispatcher installs.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• RA21 PSN

     UP