Problem Note 62146: %TKMI_JOB_RO fcst_export generates "ERROR: Update/delete failed. The observation may have been changed or deleted since the time it was read"
 |  |  |  |  |
The SAS® Revenue Optimization %TKMI_JOB_RO fcst_export task might generate the following error in the <DDMONYYYY_HH_MM_SS>_fcst_export.log file.
ERROR: Update/delete failed. The observation may have been changed or deleted since the time it was read. ORACLE execute error:
ORA-08177: can't serialize access for this transaction.
ERROR: ROLLBACK issued due to errors for data set DI_TRANS.FCST_EXPORT_INPUT.DATA.
NOTE: Deletes were rolled back by the DBMS software.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Statement not executed due to NOEXEC option.
NOTE: The SAS System stopped processing this step because of errors.
ORA-08177: can't serialize access for this transaction.
ERROR: ROLLBACK issued due to errors for data set DI_TRANS.FCST_EXPORT_INPUT.DATA.
NOTE: Deletes were rolled back by the DBMS software.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Statement not executed due to NOEXEC option.
NOTE: The SAS System stopped processing this step because of errors.
The workaround for this issue is to truncate the DI_TRANS.FCST_EXPORT_INPUT table before starting the %TKMI_JOB_RO fcst_export task.
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 Retail Forecasting | 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 | ||||
| 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 | ||||
A fix for this issue for SAS Revenue Optimization 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3R.html#62146A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#62146A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#62146| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-06-22 10:50:12 |
| Date Created: | 2018-04-17 09:17:33 |