Problem Note 39920: The error "Can't Save DTO" occurs in the SAS® Merchandise Planning KPI Set Editor when you are formatting a KPI
The error "Can’t save DTO" occurs in the KPI Set Editor. This error occurs when you format a KPI for a task, save it, remove the KPI, and save the task again.
To resolve this issue, run the following database script using SQL*Plus:
DROP TRIGGER maxdata.tr_wlksw_bef_d;
DROP TRIGGER maxdata.tr_wlks_bef_d;
DROP TRIGGER maxdata.tr_wldfw_bef_d;
DROP TRIGGER maxdata.tr_wldf_bef_d;
The script fixes the problem by dropping the following four triggers:
- maxdata.tr_wlksw_bef_d;
- maxdata.tr_wlks_bef_d;
- maxdata.tr_wldfw_bef_d;
- maxdata.tr_wldf_bef_d;
Operating System and Release Information
SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | Microsoft Windows Server 2003 Enterprise Edition | 6.1.3M3 | 6.4 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
64-bit Enabled AIX | 6.1.3M3 | 6.4 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
64-bit Enabled Solaris | 6.1.3M3 | 6.4 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
SAS System | SAS Merchandise Assortment Planning | Microsoft Windows Server 2003 Enterprise Edition | 6.1.3M3 | 6.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
64-bit Enabled AIX | 6.1.3M3 | 6.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
64-bit Enabled Solaris | 6.1.3M3 | 6.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2010-07-23 10:00:22 |
Date Created: | 2010-06-07 14:23:28 |