Teradata Database Message 7484 - 17.10 - 7484 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.