Problem Note 34505: An exception might occur in SAS® Markdown Optimization when you open a plan to view products by style or color
 |  |  |  |  |
When you open a plan to view products by style or color in SAS Markdown Optimization, the following exception might occur:
org.hibernate.exception.DataException
The following error might appear in the SAS® Data Integration Studio log:
ERROR com.sas.solutions.di.server - Exception thrown during the invocation of
method com.sas.solutions.di.server.mdo.MDOService.getPlanDetailsByProduct.
org.hibernate.exception.DataException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
(Compiled Code))
.....
Caused by: java.sql.SQLException: ORA-01476: divisor is equal to zero.
This error occurs when season_to_dt_sales_units value is 0 in the data for a product or location in the list.
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® for x64 | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#034505| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-02-11 14:02:06 |
| Date Created: | 2009-01-16 09:58:17 |