Problem Note 48368: The error "Statement is not valid or it is used out of proper order" might be generated when you run the %TKMI_JOB_RO fcst_export task
 |  |  |  |  |
The %TKMI_JOB_RO fcst_export task might generate the following error in the ddmmmyyy_hh_mm_ss_fcst_export.log file when you export sales forecast data:
ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: File WORK._.DATA does not exist. ERROR: File WORK.PROC.DATA does not exist. ERROR: File WORK.SQL.DATA does not exist. ERROR 180-322: Statement is not valid or it is used out of proper order.
The error is generated because one of the internal macro variables exceeds its defined limit.
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 Retail Forecasting | Linux for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| SAS System | SAS Markdown Optimization | Linux for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 | ||
A fix for this issue for SAS SizeOptimization 3.2_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J06.html#48368A fix for this issue for SAS Revenue Optimization 5.2_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J17.html#48368| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-01-29 09:18:45 |
| Date Created: | 2012-11-01 14:45:49 |