Problem Note 65171: The message "IllegalArgumentException" occurs when two separate SAS® Risk and Finance Workbench projects execute in parallel
 |  |  |  |  |
When two separate SAS Risk and Finance Workbench projects execute in parallel and use the SAS Risk and Finance Workbench application programming interface (API) to obtain values from the same worksheet, the following exception might occur:
2019-11-03 17:08:40,592 [tomcat-http--9] [cmukher] cmukher/6239 ERROR com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception handling for request:
https://ifrsdevmid.paas.bmogc.net:8343/SASRiskandFinanceWorkbench/rest/projects/ 239/sheets/byName?exportValueTypes=TN&sheetName=Waterfall_Config_Retail&outputFi lename=_YTHRV.xlsx&filterLiKey=BMO&ticket=ST-15119-aq7sg4hiyoDAgoOGQOXt-cas
java.lang.IllegalArgumentException: A property with this name already exists in the custom properties
at org.apache.poi.POIXMLProperties$CustomProperties.add(POIXMLProperties.java:501)
at org.apache.poi.POIXMLProperties$CustomProperties.addProperty(POIXMLProperties.ja va:522)
at com.sas.stress.rest.services.ReportService.newSheetNameAdded(ReportService.java: 193)
at com.sas.risk.output.SheetIterator.validExcelSheetName(SheetIterator.java:671)
at com.sas.risk.output.SheetIterator.nextSheet(SheetIterator.java:99)
at com.sas.risk.output.SheetIterator.<init>(SheetIterator.java:92)
https://ifrsdevmid.paas.bmogc.net:8343/SASRiskandFinanceWorkbench/rest/projects/ 239/sheets/byName?exportValueTypes=TN&sheetName=Waterfall_Config_Retail&outputFi lename=_YTHRV.xlsx&filterLiKey=BMO&ticket=ST-15119-aq7sg4hiyoDAgoOGQOXt-cas
java.lang.IllegalArgumentException: A property with this name already exists in the custom properties
at org.apache.poi.POIXMLProperties$CustomProperties.add(POIXMLProperties.java:501)
at org.apache.poi.POIXMLProperties$CustomProperties.addProperty(POIXMLProperties.ja va:522)
at com.sas.stress.rest.services.ReportService.newSheetNameAdded(ReportService.java: 193)
at com.sas.risk.output.SheetIterator.validExcelSheetName(SheetIterator.java:671)
at com.sas.risk.output.SheetIterator.nextSheet(SheetIterator.java:99)
at com.sas.risk.output.SheetIterator.<init>(SheetIterator.java:92)
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 | Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M5 | ||
| Linux 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#65171A 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#65171
When two separate SAS Risk and Finance Workbench projects execute in parallel and use the RFW API to get values from the same worksheet, you might see this message: "ERROR com.sas.stress.rest.controller.ControllerExceptionHandler - Generic exception handling...java.lang.IllegalArgumentException..."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-12-13 12:34:51 |
| Date Created: | 2019-11-26 02:48:13 |