SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 62349: %TKMI_JOB_RO etl_end_service generates 'Record : Rejected - Error on table DI_DM.RPP_PLAN_PROD_METRICS_PART.'

DetailsHotfixAboutRate It

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

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.49.4 TS1M4
Linux for x645.49.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.