Teradata Database Message 7842 - 7842 - Analytics Database - Teradata Vantage

Message

Java XSP/UDF returned an invalid interval in format or data of %TVMID.%FLDID.

Explanation

This error occurs when an JIL module detects an interval string with invalid format is returned.

Generated By

JIL modules.

For Whom

End User's Java Class.

Notes

The returned interval string has to be in a format like '-yyyy-mm-dd hh:mm:ss.sssss' (referring to External Representation of Intervals in the Chapter 4 SQL Reference: Data Types and Literals).

Remedy

Correct the interval string in Java class, regenerate jar file, reinstall jar and resubmit the request.