VBD service does not work while the Node is working
Visual Business Director (VBD) service does not work; however, the Node is working.
Caused by: org.springframework.remoting.RemoteAccessException: Could not access HTTP invoker remote service at [http://<hostname>:<port>/vbd/service/vbdService]; nested exception is java.net.SocketTimeoutException: Read timed out
Steps to Reproduce
Run a Marketing Campaign.
The data was partitioned which caused the issue and VBD read time-out exceptions.
The VBD Cache eviction resulted in degraded performance till the Actuals dataset was updated.
Here's the explanation for the reported behavior:
The PR_DATA_IH_FACT table has a large number of rows (91725495 = ~ 91 million records) which impacted the VBD performance. Hence, this must be reduced.
For cache eviction which is 12 Hrs out-of-the-box, the cache must be loaded for VBD. This impacted other operations till the cache is updated. Perform the following local-change to increase the VBD cache timeout and insert a row in the pr_data_vbd_config database table,
Use the vbd.datasource.eviction.timeout property and a value in milliseconds.