SUPPORT / SAMPLES & SAS NOTES
Problem Note 43208: An 'Invalid value "" for column' error message occurs when using dataload
 |  |  |  |  |
In SAS® Enterprise GRC, you might encounter an error message similar to the following if you dataload a record that has a custom field column and the value for the custom field is null.
Invalid value "" for column:
Type of Loss (event.x_loss_type_cd)
at
com.sas.oprisk.framework.server.dataload.LoaderUtils.throwInvalidValue
(LoaderUtils.java:349)
at
com.sas.oprisk.server.dataload.CustomFieldHelper.
validateCustFieldOptionValue(CustomFieldHelper.java:230)
at
com.sas.oprisk.server.dataload.CustomFieldHelper.loadCustFields
(CustomFieldHelper.java:190)
at
com.sas.oprisk.server.dataload.CustomFieldHelper.loadCustFields
(CustomFieldHelper.java:145)
at
com.sas.oprisk.server.dataload.CustomFieldHelper.loadCustFields
(CustomFieldHelper.java:124)
at
com.sas.oprisk.server.dataload.OpRiskEventLoader.updateObject
(OpRiskEventLoader.java:304)
at
com.sas.oprisk.server.dataload.OpRiskEventLoader$EventEntryProcessor.
processEntry(OpRiskEventLoader.java:98)
at
com.sas.oprisk.framework.server.dataload.EntryProcessor.process
(EntryProcessor.java:60)
at
com.sas.oprisk.server.dataload.OpRiskEventLoader.load
(OpRiskEventLoader.java:124)
at
com.sas.oprisk.server.dataload.LoaderInvocationProcessor.invokeLoad
(LoaderInvocationProcessor.java:74)
at
com.sas.oprisk.server.dataload.AddDataDriver.invokeLoaders
(AddDataDriver.java:182)
at
com.sas.oprisk.server.dataload.AbstractDataLoadDriver.loadData
(AbstractDataLoadDriver.java:195)
at
com.sas.oprisk.server.dataload.AddDataDriver.doRun(AddDataDriver.java:86)
at
com.sas.oprisk.server.cli.CommandLineTool.run(CommandLineTool.java:187)
at
com.sas.oprisk.server.dataload.AddDataDriver.main(AddDataDriver.java:81)
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 Enterprise GRC | Windows 7 Enterprise 32 bit | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.31 | 9.2 TS2M2 | 9.3 TS1M0 | ||