Problem Note 46848: A Java exception occurs when you try to save a bucket proxy scenario
 |  |  |  |  |
In SAS® OpRisk VaR, a Java exception might occur when you attempt to save a new bucket proxy scenario. The specific problem is with the internal key sequence that is used for saving the data set.
SEVERE: Mar 28, 2012 11:13:21 AM: An error occurred when the scenario was saved. java.sql.SQLException: Unable to execute update for an undetermined reason. SQL passthru expression contained these errors: at com.sas.rio.MVALocalizedError.throwLocalizedException(MVALocalizedError.java:201) at com.sas.rio.MVAStatement.executeUpdate(MVAStatement.java:673) at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sas.oprisk.var3.sasutil.StatementProxy.invoke(StatementProxy.java:138) at $Proxy3.executeUpdate(Unknown Source) at com.sas.oprisk.var3.core.scenario.ScenarioManager.saveLocalBucketDefinition(ScenarioManager.java:1554) at com.sas.oprisk.var3.core.scenario.ScenarioManager.saveLocalEffectBucket(ScenarioManager.java:1392) at com.sas.oprisk.var3.core.scenario.ScenarioManager.saveLocalEffect(ScenarioManager.java:1480) at com.sas.oprisk.var3.core.scenario.ScenarioManager.saveLocalEvent(ScenarioManager.java:1375) at com.sas.oprisk.var3.core.scenario.ScenarioManager.saveScenarioEvent(ScenarioManager.java:1244) at com.sas.oprisk.var3.ui.app.SaveAsFiniTask.doOnBackgroundThread(SaveAsFiniTask.java:472) at com.sas.analytics.cmp.utilities.CMPTask.construct(CMPTask.java:114) at com.sas.analytics.cmp.utilities.CMPSwingWorker.run(CMPSwingWorker.java:207) at java.lang.Thread.run(Unknown Source) INFO: Mar 28, 2012 11:14:02 AM: The item was not saved.
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 OpRisk VaR | Microsoft® Windows® for 64-Bit Itanium-based Systems | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux on Itanium | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
A fix for this issue for SAS OpRisk VaR 4.2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/E78.html#46848A fix for this issue for SAS OpRisk VaR 4.21 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G66.html#46848| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-06-21 09:49:51 |
| Date Created: | 2012-06-20 09:18:34 |