The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Syntax Error During Creation of Caching Table


Jyothsna Nayak

Recommended Posts

The error keeps reoccurring.

 

As a workaround , I manually created the tables in the cache storage database. Then I reintrospected the datasource so the new tables were recognized by TDV. Lastly, I specified "Choose tables for caching" during the caching of a view. This allowed me to select the tables from the datasource. Caching was completed successfully.

 

note: TDV does a cross check of the manually created table to confirm that the columns match the column set of the view. If there are differences, an error is thrown. It also gives us an option to recreate the table.

Link to comment
Share on other sites

So far there is no solution to this error.

As a workaround , I manually created the tables in the cache storage database. Then I reintrospected the datasource so the new tables were recognized by TDV. Lastly, I specified "Choose tables for caching" during the caching of a view. Thisallowed me to selectthe tablesfrom the datasource. Caching was completed successfully.

note: TDV does a cross check of the manually created table to confirm that the columns match the column set of the view. If there are differences, an error is thrown. It also gives us an option to recreate the table.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...