SUPPORT / SAMPLES & SAS NOTES
Problem Note 64296: Estimation fails with "Error: invalid status grid detected during model data aggregation for prod/geo/date_sk..."
 |  |  |  |  |
Estimation might fail in the SAS® Revenue Optimization Suite with an error similar to the following:
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : Error: invalid status grid detected during model data aggregation for prod/geo/date_sk <prod_hier_sk>/<geo_hier_sk>/<date_sk>
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : STATUS GRID prod/geo <prod_hier_sk>/<geo_hier_sk>:
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : ------- AGGREGATED STATUS GRID -------
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : <date_sk> - <date_sk> I
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : <date_sk> - <date_sk> A
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : --------------------------------------
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : ERROR: Assertion failed: FALSE, file /sas/dev/mva-f4ro52/di/src/md_manager.c, line 2435
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : Error: job 'MG_<model_group_id>_MD_AGG_p-<n>_g<n_n>' encountered a fatal error
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> :
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : STATUS GRID prod/geo <prod_hier_sk>/<geo_hier_sk>:
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : ------- AGGREGATED STATUS GRID -------
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : <date_sk> - <date_sk> I
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : <date_sk> - <date_sk> A
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : --------------------------------------
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : ERROR: Assertion failed: FALSE, file /sas/dev/mva-f4ro52/di/src/md_manager.c, line 2435
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> : Error: job 'MG_<model_group_id>_MD_AGG_p-<n>_g<n_n>' encountered a fatal error
<HH:MM:SS> MG_<model_group_id>_MD_AGG_p-<n>_g<n_n> :
The error is likely to occur in the following scenario:
- The USE_MODEL_GP_STATUS model specification is enabled.
- There are stores that were once active, but are now inactive.
The workaround for this issue is to disable the USE_MODEL_GP_STATUS model specification (set USE_MODEL_GP_STATUS to 0).
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||||