Teradata Database Message 9104 - 9104 - Analytics Database - Teradata Vantage

Message

Invalid Period arithmetic operation. %VSTR

Explanation

An error was generated during Period arithmetic operation. The exact message is given within VSTR. a) For arithmetic operation where one operand has PERIOD(TIME) and the other operand is an interval, the result beginning bound must be less than the result ending bound. For example, this can occur when adding or subtracting an interval that causes one element of the result to go past 24 hours and be modulo 24 hours but the other element of the result does not. b) For period of element type DATE/TIMESTAMP the resulting ending bound value of a period arithmetic operation must not be equal to the UNTIL_CHANGED value.

Generated By

Period constructor function.

For Whom

End User.

Notes

None

Remedy

Correct the Period arithmetic expression/bound values and re-submit.