I am scehuling the VDPcache job, I can select the datasource, views to be cache from the denodo db. I have added two views by choosing load process for each one as 'Non-incremental' . While manually started the job it end up with error '[Unexpected error creating a connection: Pool not open]'
I can run the same as VDP job with query parameter with no error. Could you help on finding for the reason for error and solution.
Report: 0
Report for job 'cache_job':
Start Time: Wed Mar 10 16:58:33 CST 2021
End Time: Wed Mar 10 17:00:43 CST 2021
Datasource (extraction): null
General Errors: []
Initialization Errors: []
Handler Errors: {}
General Warnings: []
Retry count: 0
Should re-execute job: false
ServerInfo: null
Extracted Docs: 806090
Extractor Errors: []
Extractor Warnings: []
Query: select * from db.view_name CONTEXT('cache_preload'='true', 'cache_wait_for_load'='true', 'cache_return_query_results'='false', 'cache_invalidate'='all_rows', 'cache_atomic_operation'='true') TRACE
Load Process Name: db.view_name
Cached Docs: 0
Cache Errors: [Unexpected error creating a connection: Pool not open]
Execution Errors: {}
Execution Warnings: {}
Execution Success: {}
Combinations: null
Load Processes Reports:
