Problem Note 62349: %TKMI_JOB_RO etl_end_service generates 'Record : Rejected - Error on table DI_DM.RPP_PLAN_PROD_METRICS_PART.'
 |  |  |  |  |
The SAS® Promotion Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridSvr.log file.
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG com.sas.solutions.di.tkmiserver.utils.TkMiServerUtils - STDOUT: Record <n>: Rejected - Error on table DI_DM.RPP_PLAN_PROD_METRICS_PART.
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG com.sas.solutions.di.tkmiserver.utils.TkMiServerUtils - STDOUT: ORA-00001: unique constraint (DI_DM.SYS_C<constraint_nbr>) violated
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n>] DEBUG com.sas.solutions.di.tkmiserver.utils.TkMiServerUtils - STDOUT: ORA-00001: unique constraint (DI_DM.SYS_C<constraint_nbr>) violated
This issue occurs when one or more of the results files is not correctly copied to the upload directory.
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M4 | ||
| Linux for x64 | 5.4 | 9.4 TS1M4 | ||||
A fix for this issue for SAS Revenue Optimization 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3R.html#62349A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#62349| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-05-23 09:21:55 |
| Date Created: | 2018-05-22 09:08:59 |