Cache target tables don't exist and cannot be created in TIBCO Data Virtualization
Article ID: KB0076515
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.0 and higher |
Description
Scenario:
An attempt to create a new cache for a view fails, and the "Error" field seen near the top of the Caching tab for the view in the Studio says:
"The resource '/<path of your caching data source>/<optional schema or catalog>/<name of the target table>' does not exist".
An attempt to create a new cache for a view fails, and the "Error" field seen near the top of the Caching tab for the view in the Studio says:
"The resource '/<path of your caching data source>/<optional schema or catalog>/<name of the target table>' does not exist".
Issue/Introduction
Cache target tables don't exist and cannot be created in TIBCO Data Virtualization
Resolution
For the view you want to cache, look for any optional indexes or foreign keys that were declared. See the "Indexes" and "Foreign Keys" tab in the Studio UI.
If there were any indexes or foreign keys declared with spaces in their names, that will cause a CREATE TABLE error when TDV runs the automatically generated ddl against your chosen caching database to create the target table for the cache.
Enabling the "Debug Output Enabled for Data Sources" option in the Studio's config UI may also confirm this issue as it logs the error in our /logs/cs_server.log when you attempt to execute our ddl or save the attempted cache configuration.
If there were any indexes or foreign keys declared with spaces in their names, that will cause a CREATE TABLE error when TDV runs the automatically generated ddl against your chosen caching database to create the target table for the cache.
Enabling the "Debug Output Enabled for Data Sources" option in the Studio's config UI may also confirm this issue as it logs the error in our /logs/cs_server.log when you attempt to execute our ddl or save the attempted cache configuration.
Feedback
Yes
No
Powered by
