Problem Note 59661: The MAXDATA.CONFIG_QUERY_SYNTAX database query does not include Version_ID
The SAS® Merchandise Allocation MAXDATA.CONFIG_QUERY_SYNTAX database query does not include Version_ID. If there is no Version_ID, then Allocation worksheets might seed with incorrect data.
To work around this issue, run the following update query in the database:
UPDATE MAXDATA.CONFIG_QUERY_SYNTAX SET QUERY_WHERE = 'WHERE m.cube_id = %CUBE_ID AND version_id=%HASHKEY_ID ORDER BY merch_level DESC'
WHERE QUERY_TYPE = 'ALLOC_ATTR_LG';
Operating System and Release Information
| SAS System | SAS Merchandise Allocation | Microsoft® Windows® for x64 | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 |
| Linux for x64 | 3.6 | 3.7 | 9.4 TS1M4 | 9.4 TS1M3 |
*
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: | 2017-01-11 11:47:17 |
| Date Created: | 2017-01-10 11:41:19 |
