You can translate the question and the replies:

Cache settings error.

Hi guys, new issue has been found regarding cache: because of unknown reasons Denodo cannot correctly enable caching on server (Server Configuration -> Cache) with error below after applying settings: > Operation completed with errors: > Error saving cache settings: Unexpected error accessing the server. Issue disappeared after several Denodo restarts and recreation of cache database. After that, error above is still visible, but caching works fine. Other error found in logs in the same period of time was: > /opt/denodo/logs/vdp/vdp.log:3120013 [RMI(3211)-10.111.111.222-1087] ERROR 2017-11-21T08:03:40.655 com.denodo.vdb.cache.jdbc.PatternQueryStorer [] - getNextQueryPatternId: Error accessing database: Sequence 'vdb_cache_querypattern' does not return next value
user
23-11-2017 05:33:07 -0500
code

1 Answer

Hi, The error, "com.denodo.vdb.cache.jdbc.PatternQueryStorer [] - getNextQueryPatternId: Error accessing database: Sequence 'vdb_cache_querypattern' does not return next value" could have occurred when Virtual DataPort is unable to update the 'vdb_cache_querypattern' metadata table in the cache database. When an external database is configured as cache database, Virtual DataPort creates metadata table in the cache database for managing the cache. Virtual DataPort requires space to store all the data in the cache database along with metadata. To overcome this error, you could reconfigure the memory allocated in the external database for caching and then configure it in Virtual DataPort as cache database. For more information, you could refer the Knowledge Base article, [Cache database size estimate](https://community.denodo.com/kb/view/document/Cache%20database%20size%20estimate?category=Operation). If you still face the same issue after re-configuring the cache database and if you are a customer with valid support user, you could raise a support ticket so that the Denodo support team can help you. Hope this helps !!
Denodo Team
24-11-2017 07:30:21 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here