Problem Note 68456: An error occurs when multiple SAS® Risk and Finance Workbench projects import scenarios at the same time
 |  |  |  |  |
In SAS Risk and Finance Workbench, the following error might occur in the user interface when you add a scenario in a SAS Risk and Finance Workbench project:
The request failed to complete due to internal server error
Remediation: Check the request to ensure it is valid. If so, contact your system administrator to help diagnose the issue.
Remediation: Check the request to ensure it is valid. If so, contact your system administrator to help diagnose the issue.
The SASRiskFinancWkbnchMidTier.log contains the following error:
2021-09-19 09:59:46,781 [tomcat-http--9] [bjpete7] bjpete7/-5488 ERROR
com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception
handling for request:
http://svcksa69901a4h.us.bank-dns.com:7982/SASRiskandFinanceWorkbench/rest/proje
cts/22/scenarios
org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result
size: expected 1, actual 2
at
org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessU
tils.java:74)
com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception
handling for request:
http://svcksa69901a4h.us.bank-dns.com:7982/SASRiskandFinanceWorkbench/rest/proje
cts/22/scenarios
org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result
size: expected 1, actual 2
at
org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessU
tils.java:74)
To reproduce this error, open multiple SAS Risk and Finance Workbench projects in multiple browser tabs and then add the same scenarios to these projects at the same time.
After you apply this hot fix, data corruption similar to this will be prevented.
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 Risk and Finance Workbench | Linux for x64 | 3.1 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M5 | ||||
A fix for this issue for SAS Risk and Finance Workbench 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4L.html#68456A fix for this issue for SAS Risk and Finance Workbench 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5N.html#68456
The following error occurs when you open SAS Risk and Finance Workbench in multiple browser tabs and try to import the same scenarios to multiple projects at the same time: "The request failed to complete due to internal server error..."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-10-08 13:08:46 |
| Date Created: | 2021-10-01 03:57:11 |