Archives of the TeradataForum

Message Posted: Fri, 05 May 2006 @ 13:07:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Gurus ,

I am getting the following error message when running a Teradata query:

     Code = 2616.
     2616:  Numeric overflow occurred during computation.
     Output directed to Answer set window

Could this be due to a computation limit due to 32 bit processing on the numeric data type in Teradata? Is there any add-on support available for Teradata to handle summing large numbers of records for columns with a length of 18,2 (without having to resort to floating point which will cause rounding?

Here is the query:

     LOCKING TABLE PRODODSS.O_PSTEV_BAL FOR ACCESS
     SELECT OPV_ODT_INSTD_D,
            count(OPV_ODT_INSTD_D) AS THECOUNT,
            sum(OPV_FSVGS_BAL_A) AS OPV_FSVGS_BAL_A,
            sum(OPV_OAN_ACRB_MTD_A) AS OPV_OAN_ACRB_MTD_A,
            sum(OPV_OAN_ACRB_YTD_A) AS OPV_OAN_ACRB_YTD_A,
            sum(OPV_OAN_ADRB_MTD_A) AS OPV_OAN_ADRB_MTD_A,
            sum(OPV_OAN_ADRB_YTD_A) AS OPV_OAN_ADRB_YTD_A,
            sum(OPV_OAN_AGBL_MTD_A) AS OPV_OAN_AGBL_MTD_A,
            sum(OPV_OAN_AGBL_YTD_A) AS OPV_OAN_AGBL_YTD_A,
            sum(OPV_OAN_AGCB_MTD_A) AS OPV_OAN_AGCB_MTD_A,
            sum(OPV_OAN_AGCB_YTD_A) AS OPV_OAN_AGCB_YTD_A,
            sum(OPV_OAN_AGDB_MTD_A) AS OPV_OAN_AGDB_MTD_A,
            sum(OPV_OAN_AGDB_YTD_A) AS OPV_OAN_AGDB_YTD_A,
            sum(OPV_OAN_AVBL_MTD_A) AS OPV_OAN_AVBL_MTD_A,
            sum(OPV_OAN_AVBL_YTD_A) AS OPV_OAN_AVBL_YTD_A,
            sum(OPV_OAN_CLBAL_A) AS OPV_OAN_CLBAL_A,
            sum(OPV_OAN_CLCRB_A) AS OPV_OAN_CLCRB_A,
            sum(OPV_OAN_CLDRB_A) AS OPV_OAN_CLDRB_A,
            sum(OPV_OAN_FCRBL_A) AS OPV_OAN_FCRBL_A,
            sum(OPV_OAN_FDRBL_A) AS OPV_OAN_FDRBL_A,
            sum(OPV_OAN_FINBL_A) AS OPV_OAN_FINBL_A,
            sum(OPV_OAN_MMBAL_A) AS OPV_OAN_MMBAL_A,
            sum(OPV_OAN_UNCBL_A) AS OPV_OAN_UNCBL_A,
            sum(OPV_OBP_TCSTR_A) AS OPV_OBP_TCSTR_A,
            sum(OPV_OBP_TDSTR_A) AS OPV_OBP_TDSTR_A,
            sum(OPV_OBP_TOT_SGDF_A) AS OPV_OBP_TOT_SGDF_A,
            sum(OPV_OBP_TSTRN_A) AS OPV_OBP_TSTRN_A,
            sum(OPV_TRPKT_BAL_A) AS OPV_TRPKT_BAL_A
     FROM PRODODSS.O_PSTEV_BAL
     GROUP BY OPV_ODT_INSTD_D
     ORDER BY OPV_ODT_INSTD_D;

Is therer any remedy to over come this error, please suggets me.

Thanks & Regards,

Rao

	<Prev	Next>		<<First	<Prev	Next>	Last>>