Problem Note 46510: Java exception occurs when importing CCVs after incremental data load
 |  |  |  |  |
In SAS® OpRisk VaR, after you perform an incremental data load and then attempt to import cross-classification variables (CCVs), you might get a Java exception error similar to the one shown below. In addition, any covariance matrix in the CCV fails to load. However, the CCV mappings continue to successfully load in spite of the error message.
To create a new CCV export file from the originally exported CCV that can be loaded without errors, see the code provided in the Full Code tab.
Example of Java Exception
SEVERE: Nov 17, 2011 2:50:40 PM: An error occurred when the process created
'Identity Mapping'.
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.GeneratedMethodAccessor36.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.folder.FolderManager.createFolder(FolderManager.java:10
56)
at
com.sas.oprisk.var3.sasutil.ExportImportUtilities.importCCVs(ExportImportUtiliti
es.java:953)
at
com.sas.oprisk.var3.ui.app.ImportCCVItemTask$1.run(ImportCCVItemTask.java:142)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
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 | ||
Use this code to create a new CCV export file from the originally exported CCV that can be imported without errors.
- Create a temporary directory on your server (for example, c:\temp\unbix)
- Run the following macro in SAS using the exported CCV .bix file and a new target .bix file to use instead.
- Import the newly created CCV export file.
%macro ccvfix(tempDirectory=, bixSource=, bixTarget=);
/* create this temporary directory on your filesystem */
libname tempDir &tempDirectory;
filename bixSrc &bixSource;
filename bixTarg &bixTarget;
/* unbix to a temporary directory */
proc cimport
file = bixSrc
lib = tempDir;
run;
/* delete extraneous rows from var_folders */
proc sql noprint;
select version_uid
into :dataver
from tempDir.data_version;
delete from tempDir.var_folders
where org_structure_uid not EQ &dataver
;
quit;
/* re-bix files */
proc cport CONSTRAINT=YES DATECOPY
file = bixTarg
lib = tempDir;
run;
%mend ccvfix;
%ccvfix(
tempDirectory = 'c:\temp\unbix',
bixSource = 'c:\temp\ccv_cus_bl_sample42.bix',
bixTarget = 'c:\temp\fixed_ccv_cus_bl_sample42.bix'
);
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-05-18 14:54:31 |
| Date Created: | 2012-05-07 14:52:04 |