Problem Note 66427: Testing, publishing, or running a DATA step scenario in SAS® Visual Investigator fails when the database is Oracle18
 |  |  |  |  |
When you test, publish, or run a DATA step scenario, and your database is Oracle18, you might encounter errors depending on the usage activity.
When publishing and running the scenario, you can see a error like the following in the sas-viya-vsd-service-default log:
2020-07-07 15:33:10.820 ERROR 13 — [TaskExecutor-11] c.s.f.vsd.service.job.JobFailureService : videmo@@acme(81d99756) [8e4ff9787c572ef0] java.util.concurrent.CompletionException: java.lang.NullPointerException
On your screen, you also see the message "The test of flow flow-name scenario scenario-name failed."
When you click Close, you can see an error similar to the following:
2020-07-07 15:38:21.877 ERROR 13 — [nio-8080-exec-5] com.sas.fcs.vsd.rest.FlowController : videmo@@acme(19ee6603) [aadf77e9277b2183] org.springframework.orm.ObjectOptimisticLockingFailureException: Object of class [com.sas.fcs.vsd.domain.Flow] with identifier [96a20090-fc22-4db0-a8c2-871148bd8bda]: optimistic locking failed; nested exception is org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : com.sas.fcs.vsd.domain.Flow#96a20090-fc22-4db0-a8c2-871148bd8bda
2020-07-07 15:38:21.878 ERROR 13 — [nio-8080-exec-5] com.sas.commons.rest.ExceptionLog : videmo@@acme(19ee6603) [aadf77e9277b2183] com.sas.fcs.vsd.exception.ServiceException: The service request could not be completed.
In the sas-viya-vsd-service-default log, you also see an error like the following:
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.6 | 10.7 | Viya | Viya |
An update for this issue is available for SAS Visual Investigator 10.6. 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_6_home.html#66427| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-05-06 14:01:49 |
| Date Created: | 2020-08-05 09:21:40 |