Teradata Database Message 7484 - 7484 - Analytics Database - Teradata Vantage

Message

Division by Zero occured while calculating the given OLAP function(s).

Explanation

This error is returned when Division by Zero occurs while calculating OLAP statistical functions like Mlinreg. For Mlinreg function this error indicates that the Window width is less than or equal to the number of Non Unique Sort keys. i.e., No. of rows with same sort key \>= Window Width mentioned.

Generated By

STPSTATFN

For Whom

USER

Notes

None

Remedy

For Mlinreg function check the table given for calculating the function. Try changing the Window width and also check the table so that no. of non unique sort keys are not greater than or equal to Window width value.