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!