Cannot create cache due to issues in the refresh schedule
You created a cache for a virtual view but a query might not use this cache in its execution.
Symptoms
When you create a cache and set up a refresh schedule by selecting Sunday as the day of the week to refresh the cache, the cache creation fails.
You see the following
error:
Cache creation failed: The request was invalid. Invalid refresh schedule. Causes
The Data Virtualization console cannot use Sunday as the day of the week to refresh the cache.
Resolving the problem
To solve this issue, don't select Sunday as the day of the week to refresh the cache.