Problem Note 48254: The nightly %TKMI_JOB_RO etl_end_service task truncates GEO_PROD_AGG and GEO_PROD_MTS tables
 |  |  |  |  |
The SAS® Markdown Optimization %TKMI_JOB_RO etl_end_service run with the option NIGHTLY=1 might generate the following messages in the MerchIntelGridSvr.log file:
YYYY-MM-DD HH:MM:SS,mmm [pool-n-thread-n] DEBUG - SQL: truncate table geo_prod_agg YYYY-MM-DD HH:MM:SS,mmm [pool-n-thread-n] DEBUG - SQL: truncate table geo_prod_mts
The workaround for this issue is to modify your nightly batch optimization process to save a copy of DI_DM2.GEO_PROD_AGG and DI_DM2.GEO_PROD_MTS to another location. Then after the %TKMI_JOB_RO etl_end_service completes copy the tables back to their original location. Afterward, be sure to run the Oracle maintenance job in order to regenerate the table statistics. Failure to do so might result in slower query performance.
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 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 | ||
A fix for this issue for SAS Revenue Optimization 5.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H63.html#48254A fix for this issue for SAS SizeOptimization 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H78.html#48254| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2015-11-05 14:06:45 |
| Date Created: | 2012-10-24 11:14:51 |