Problem Note 37020: ERROR: "ORACLE execute error: ORA-01438: value larger than specified precision allowed for this column"
 |  |  |  |  |
When running SAS® Merchandise Intelligence, you may experience errors in your back-end job logs similar to the following:
ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed for this column.
When initial inventory is very small, this can cause very large values for metrics that involve division by the initial inventory value. These very large values then cannot be inserted into transaction tables because they exceed the defined precision. Some affected metrics include curr_sell_through_pct and base_sell_through_pct.
There is no workaround for this issue.
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 Markdown Optimization | Microsoft Windows 2000 Advanced Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows NT Workstation | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2008 | 3.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#037020| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-08-31 16:39:05 |
| Date Created: | 2009-08-28 08:22:37 |