New data does not load when cache refresh is done in Tibco Data Virtualization (TDV), but it returns as success
book
Article ID: KB0081825
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
7.0.6
Description
There is no error that occurs, the cache refresh returns as successful, but the new data never gets uploaded. However, an exception is thrown in the cs_server_task.log. ERROR 2017-01-19 21:20:37.003 -0600 TriggerManager - User "cacheownertest" has insufficient rights to perform this operation. Required rights: "ACCESS_TOOLS". User has "NONE" rights.
Issue/Introduction
There is no error that occurs during cache refresh. It returns as successful, but the new data never gets uploaded.
Resolution
The associated owner must have the appropriate rights (at least ACCESS_TOOLS) in order to succeed. Issue generally happens when cached query is deployed from one environment into another, leading to the change of the cache owner.