Problem Note 35839: Reclassification might cause user permission issues and optimization failures
Following reclassification in SAS® Markdown Optimization, SAS® High-Performance Markdown Optimization, SAS® Regular Price Optimization, or SAS® Promotion Optimization, the database table that controls user application component access is not correctly updated. If reclassification affects the ancestry of a user's root product or geography hierarchy access node, the access permission issues might result.
There are no error, warning, or note messages to indicate that a problem has occurred, but incorrect markdown calculations or fields might be displayed in the UI.
To circumvent this issue, you must manually remove authorizations (via the SAS® Merchandise Intelligence Plug-ins for SAS Management Console) at all lower hierarchy levels (i.e. authorize only at the highest hierarchy level) when read authorization occurs at multiple levels within a hierarchy after reclassification.
For example, if you had read authorization for a specific child at hierarchy level 7 and it is moved during reclass to a different level 6 parent for which you also have read authorization, then the application component access tables become incorrect. You cannot be given access at level 7, if you also have access at level 6.
NOTE: In SAS® High-Performance Markdown Optimization 4.3, this issue might manifest itself during optimization. Plans might fail to optimize and an error similar to the following is generated in your TKMI grid server log:
00:37:36 dimlq_2401161 : Error: dim load queue 'dimlq_2401161' encountered a fatal error
NOTE: The Hot Fix associated with this SAS Note ONLY fixes the issue that causes optimization to fail in SAS® High Performance Markdown Optimization 4.3.
Operating System and Release Information
| SAS System | SAS Regular Price Optimization | Microsoft Windows 2000 Advanced Server | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.2 | 9.2 TS2M2 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 for x64 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | 2012-07-17 09:40:23 |
| Date Created: | 2009-05-07 11:53:38 |
