Usage Note 18692: LOADXLS spreadsheet load command is failing with ClassNotFound exception
This issue applies to SAS® OpRisk Monitor 3.3 spreadsheet load command
loadxls.bat and loadxls.sh.
SAS OpRisk Monitor data can be loaded from a CSV file, and from an Excel
spreadsheet (XLS file).
A necessary jar file for spreadsheet loading is missing. It is
poi-2.5.1-final-20040804.jar.
This jar file is correctly in the Web Application already. This only
applies to the data administration component that has the dataload batch
scripts.
To know if you have this problem, go into the database administration
directory that matters to your version (Oracle9, or PostgreSQL for
example). Run the addxlsdata.cmd (Windows) or addxlsdata.sh (UNIX)
script.
The script will fail with a ClassNotFound exception.
To resolve this situation, install SAS OpRisk Monitor hotfix 33ORM01.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS OpRisk Monitor | Microsoft Windows XP Professional | 1.5 | | | |
| Microsoft Windows 2000 Server | 1.5 | | | |
| Microsoft Windows 2000 Professional | 1.5 | | | |
| Microsoft Windows 2000 Advanced Server | 1.5 | | | |
| Microsoft Windows 2000 Datacenter Server | 1.5 | | | |
| Solaris | 1.5 | | | |
| 64-bit Enabled AIX | 1.5 | | | |
| 64-bit Enabled Solaris | 1.5 | | | |
| AIX | 1.5 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2006-11-27 14:47:05 |
| Date Created: | 2006-10-02 17:10:51 |
