Problem Note 64123: Batch Scheduler might not import the .AIN files as expected.
In SAS® Merchandise Allocation, the Batch Scheduler might not import the .AIN files as expected. This issue is likely to occur when the merchandise/dimension sets assigned to the saved Batch Scheduler rule are deleted. If you delete a dimension set in Dimension Manager that is used in the Batch Scheduler, then the AIN load fails.
The following exception might be generated in the catalina log:
java.util.NoSuchElementException…
[ERROR] [] com.marketmax.allocation.jdbc.MMAXAllocationJDBC - Exception getting the parent merch id for merch id 26223 at level -1
java.sql.SQLSyntaxErrorException: ORA-00904: "LV": invalid identifier…
The exception might be generated in the MAXDATA.ALLOC_INTERFACE_LOG table:
Error While Saving Allocation Definition
To work around this issue, merchandise sets that exist in the batch scheduler should not be deleted from Dimension Manager.
Operating System and Release Information
SAS System | SAS Merchandise Allocation | Microsoft Windows Server 2012 R2 Std | 3.9 | 4.2 | 9.4 TS1M4 | 9.4 TS1M5 |
64-bit Enabled AIX | 3.9 | 4.2 | 9.4 TS1M4 | 9.4 TS1M5 |
Linux for x64 | 3.9 | 4.2 | 9.4 TS1M4 | 9.4 TS1M5 |
*
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: | 2019-05-02 14:00:29 |
Date Created: | 2019-04-29 10:40:12 |