SUPPORT / SAMPLES & SAS NOTES
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 | ||||