Syntax Error During Creation of Caching Table

[Jyothsna Nayak]

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

[Motsu Aboshi]

Can you post a representative DDL

[Jyothsna Nayak]

Unfortunately the DDL does not get generated to check for any syntax errors. 

 

Error is thrown during DDL generation, not during the execution.

 

Thanks,

[Jyothsna Nayak]

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.

[Jyothsna Nayak]

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.