Problem Note 60980: SAS Merchandise Intelligence Client generates error: 'java.lang.NumberFormatException: For input string: "n,nn"'
 |  |  |  |  |
The SAS® Merchandise Intelligence Client might generate the following error in the distudio.log file:
java.lang.NumberFormatException: For input string: "n,nn"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1222)
at java.lang.Double.parseDouble(Double.java:510)
at com.sas.solutions.di.server.api.core.AttributeFactory.createAttributeValue(AttributeFactory.java:44)
at com.sas.solutions.di.server.dm.AttributeServiceBase.getCustomAttributeValues(AttributeServiceBase.java:480)
at com.sas.solutions.di.server.dm.AttributeServiceBase.getCustomAttributeValues(AttributeServiceBase.java:407)
This error occurs when a decimal custom attribute that was loaded in a SAS session where the locale uses a comma as a decimal separator is displayed in the client. Attribute values are stored in the PRODUCT_ATTRIBUTES and GEOGRAPHY_ATTRIBUTES tables as character data even when the attribute is defined as a decimal attribute (ATTR_TYPE=1). In a locale where commas are used as decimal separators, these values are stored as "n,nn." The error is generated when the client attempts to convert that string to a decimal number for display.
To work around this issue, all data values for decimal custom attributes in the PRODUCT_ATTRIBUTES and GEOGRAPHY_ATTRBUTE must be stored as "n.nn". The jobs that load data into these tables should be run using a locale that uses a period as the decimal separator. For simplified implementations, the jobs that might be impacted are Load_STG2DM_Geo_attribute_values and Load_STG2DM_Prod_attribute_values. For classic implementations, the jobs that might be impacted are Load_STG2DM_Product_attributes and Load_STG2DM_Geography_attributes.
The middle-tier and client locale settings determine whether a comma or period is used as a decimal separator when the data is displayed.
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 Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 3.2_M4 | 9.3 TS1M2 | ||||
| Linux for x64 | 3.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Pack Optimization | Microsoft® Windows® for x64 | 3.2_M4 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 3.2_M4 | 9.3 TS1M2 | ||||
| Linux for x64 | 3.2_M4 | 9.3 TS1M2 | ||||