Problem Note 53807: DI_TRANS.PURGE_QUERY does not have an entry for RPO_GEO_PROD_AGG table
The SAS® Regular Price Optimization DI_TRANS.PURGE_QUERY table might not contain an entry where the TABLE_NM is RPO_GEO_PROD_AGG. If there is no entry for RPO_GEO_PROD_AGG, then this table is not purged when the %DI_MAINTAIN_JOB is run.
To workaround this issue, run the following code in a SAS® session where the SAS® Merchandise Intelligence libraries are allocated:
proc sql;
insert into di_trans.purge_query
(table_nm, database_nm, purge_order, num_days_preserved, purge_frequency, purge_query_txt, partition_flg, app_nm)
values ('RPO_GEO_PROD_AGG','RBDMS', 2, 921, 30, '%di_purge_rpo_geo_prod_agg(libref=di_trans);', 0, 'RPO');
quit;
Operating System and Release Information
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2_M2 | 5.4 | 9.3 TS1M2 | 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: | 2014-08-12 11:18:29 |
| Date Created: | 2014-08-01 09:12:07 |
