SUPPORT / SAMPLES & SAS NOTES
Usage Note 18669: Key fields have null values when loaded by dataload
 |  |  |  |  |
This issue pertains to the dataload feature of the administration component of SAS® OpRisk Monitor 3.3.
When creating data in Excel for batch loading into SAS OpRisk Monitor 3.3, if you have an empty value in a cell for a key field, that empty value was loaded as a null key field in the data for that Excel row (record).
One way to know if this situation has occurred is to use the dimension browser. When you browse to look at the dimension you just loaded, you will get a null pointer exception.
This issue is resolved by applying SAS OpRisk Monitor 3.3 hotfix 33ORM01.
Select 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 Monitor | Microsoft Windows 2000 Server | 1.5 | |||
| Microsoft Windows XP Professional | 1.5 | |||||
| Microsoft Windows 2000 Professional | 1.5 | |||||
| Microsoft Windows 2000 Datacenter Server | 1.5 | |||||
| 64-bit Enabled AIX | 1.5 | |||||
| Solaris | 1.5 | |||||
| 64-bit Enabled Solaris | 1.5 | |||||
| Microsoft Windows 2000 Advanced Server | 1.5 | |||||
| AIX | 1.5 | |||||