SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 43644: Failure might occur when optimizing plans that are created for low-owned departments

DetailsHotfixAboutRate It

When using SAS® High-Performance Markdown Optimization, a failure might occur when optimizing plans that are created for low-owned departments.

While processing low-owned data during optimization, certain scenarios in low-owned data and in plan data might lead to the following errors in the tkmi.log file:

DEBUG - STDOUT: 12:58:20 c_geo_prod_owned_inv: ERROR: consumer thread 'c_geo_prod_owned_inv' encountered a fatal error
DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation)
DEBUG - STDOUT: 12:58:20 geo_prod_owned_inv  : ERROR: Assertion failed: ! this->pc_error, file /sas/wky/mva-m1tkmi43/di/src/input_adapter.c, line 660

The work-around for this issue is to enforce certain data conditions and configuration settings before running optimization, as follows:

Geo_prod_owned_inv Table

    If provided at the lowest level, records in this table must only be provided for active product/locations, i.e. they must have a matching active product/location in the geo_prod table.
    Corresponding records in the geo_prod table must satisfy the condition "sales_introduction_dt < sales_discontinued_dt", if sales_discontinued_dt is not missing.

Plans

    Members of a plan should contain all active product/location combinations within the scope of the plan.

Configuration Setting

    Set the global setting max_inmem_gps to “0” to ensure successful processing of the geo_prod_owned_inv data.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS High-Performance Markdown OptimizationLinux for x644.3_M14.3_M29.2 TS2M39.2 TS2M3
* 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.