Teradata Database Message 7576 - 7576 - Analytics Database - Teradata Vantage

Message

Numeric overflow in UDF/XSP/UDM involving result argument for %TVMID.%FLDID.

Explanation

This error indicates that the UDF/XSP/UDM has produced a result that is out of range for the given returned data type. All FLOAT, DECIMAL, DATE (TIMESTAMP etc.) and INTERVAL types will get this error if they produce a value that is not with in the valid range of the type it is returning. For example a DECIMAL(2,1) can only return values between -99.9 and 99.9. Anything outside of that range will produce this error. In a like manner DATE and TIMESTAMP types must produce a valid timestamp. For example the month must be in the range of 1-12. The day of the month must be in the valid range for the given month and so on. For INTERVAL types the value must conform to the precision of the defined INTERVAL. For example INTERVAL YEAR(2) can only return an interval between -99 and 99 years.

Generated By

The interpretative instruction processor.

For Whom

End User.

Notes

None

Remedy

Resubmit the request after either fixing the UDF/XSP/UDM code or changing the returned data type to accommodate the result.