Jyothsna Nayak Posted October 4, 2019 Share Posted October 4, 2019 I am creating cache tables and getting a persistant parse error. There is minimal input passed from our end - schema_name, prefix and number of tables. There are no blank spaces in what I have typed. Any idea why TDV is throwing a syantax error Link to comment Share on other sites More sharing options...
Motsu Aboshi Posted October 4, 2019 Share Posted October 4, 2019 Can you post a representative DDL Link to comment Share on other sites More sharing options...
Jyothsna Nayak Posted October 4, 2019 Author Share Posted October 4, 2019 Unfortunately the DDL does not get generated to check for any syntax errors. Error is thrown during DDL generation, not during the execution. Thanks, Link to comment Share on other sites More sharing options...
Jyothsna Nayak Posted October 7, 2019 Author Share Posted October 7, 2019 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 More sharing options...
Jyothsna Nayak Posted October 7, 2019 Author Share Posted October 7, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now