Cache fails for the Teradata 15.10 v in TDV 7.0.3.00.18 while the same runs successfully in 6.2.7 version
book
Article ID: KB0083068
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
-
Description
Error details: Cache for "/shared/JnJ_/BSITDS/Calendar/Global Calendar W1" failed to refresh with reason: String index out of range: 19
Issue/Introduction
Cache fails for the Teradata 15.10 v in TDV 7.0.3.00.18 while the same runs successfully in 6.2.7 version
Resolution
Cache is failing while fetching the data from the ‘Timestamp’ column. In the query, Casting the timestamp column explicitly to timestamp resolves the issue. Also, this issue is fixed in 7.0.5 version