Problem Note 62156: The %TKMI_JOB_RO fcst_export task runs slowly
 |  |  |  |  |
The SAS® Revenue Optimization %TKMI_JOB_RO fcst_export task might run slowly. There are no errors or warnings in the log file, but there is a significant amount of time spent reading in the forecast export results generated by the MerchIntelGridSvr. To diagnose this issue, the SAS option FULLSTIMER must be enabled in the SAS session where %TKMI_JOB_RO fcst_export is executed. This issue can be observed in the <DDMMMYYYY_HH_MM_SS>_fcst_export.log file by looking at the time between the end of the PROCEDURE HTTP call and when PROCEDURE EXPORT is called.
NOTE: PROCEDURE HTTP used (Total process time):
real time 43:45.00
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 76.40k
OS Memory 14640.00k
Timestamp 11/04/2018 09:10:32 o'clock PM
real time 43:45.00
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 76.40k
OS Memory 14640.00k
Timestamp 11/04/2018 09:10:32 o'clock PM
....
NOTE: DATA statement used (Total process time):
real time 8:33.62
user cpu time 8:06.81
system cpu time 12.54 seconds
memory 8435.17k
OS Memory 21072.00k
Timestamp 11/04/2018 10:31:32 o'clock PM
real time 8:33.62
user cpu time 8:06.81
system cpu time 12.54 seconds
memory 8435.17k
OS Memory 21072.00k
Timestamp 11/04/2018 10:31:32 o'clock PM
...
NOTE: "<sales_forecast_export.csv>" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
NOTE: "<sales_forecast_export.csv>" file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
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 | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
| SAS System | SAS Retail Forecasting | Microsoft® Windows® for x64 | 5.2_M4 | 9.3 TS1M2 | ||
| Linux for x64 | 5.2_M4 | 9.3 TS1M2 | ||||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#62156| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-06-22 10:51:34 |
| Date Created: | 2018-04-18 11:29:22 |