Problem Note 70389: Data Source Substitution fails on a validation comparison in SAS® Visual Investigator with the error "The flow "flux sub" could not be executed"
 |  |  |  |  |
SAS® Visual Investigator 10.8.1 HF3 introduced a new feature for the manual loading of data sources in CAS, "Retaining Flow Source Data in CAS."
When implementing this feature with source data in Oracle, the flow fails to run. As a result, the following error message occurs in the VSD log:
This issue is specific to the Oracle database defining the columns as uppercase. The casing is preserved in the data object. However, the data source substitution code fails in our validation on a casing comparison.
Workaround
To circumvent this issue, make the Oracle database table define the columns in lowercase.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator (on SAS Viya 3.x) | Linux for x64 | 10.8 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.8. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_8_home.html#70389| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2023-09-20 16:09:45 |
| Date Created: | 2023-09-14 05:46:11 |