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

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