You can translate the question and the replies:

Error modifying view: View names not available

Hi , I am creating simple derived view from 2 base views , while enabling cache on the derived view i'm getting "Error modifying view: View names not available" error . Thanks for your help in advance....!
user
21-09-2020 16:09:18 -0400

1 Answer

Hi, Generally, this error may occurs when the user configured for managing the Cache Database doesn't have enough privileges in order to create a new table for caching the view, this could happen if the user only has READ permissions. The user configured in the cache setting would need privileges over the Cache Database in order to create or drop tables, indexes and also to insert and read information from those tables. So make sure the user has all the necessary privileges. For more details, you can refer to [Best Practices to Maximize Performance III: Caching](https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20III:%20Caching?category=Best+practices) knowledge base article You can also refer to similar Q&A [here](https://community.denodo.com/answers/question/details?questionId=9060g0000004FQpAAM&title=Cache+-+Error+modifying+view%3A+View+names+not+available), which explains in detail about other possible solutions for this issue. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
22-09-2020 08:29:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here