SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 56347: The error "Unable to save treatment" occurs when you use the SAS® Customer Intelligence Integration Utilities to load treatments

DetailsHotfixAboutRate It

When you use the SAS® Customer Intelligence Integration Utilities to load treatments, the loading might fail with an error similar to the following:

sh sasciutils -loadtreatments -userid [user] -password [password] -bcname [business-context] -libname [treatment-libref] -treatmenttablename ch_treatment -customdetailtablename ch_treatment_custdetail
2015-07-31 13:59:55: Connecting to the Mid-tier...
2015-07-31 14:00:12: Mid-tier connection established.
2015-07-31 14:00:13: Using business context [Business Context].
2015-07-31 14:00:14: Successfully loaded treatment table ch_treatment.
2015-07-31 14:00:14: Successfully loaded custom detail table ch_treatment_custdetail.
2015-07-31 14:00:17: Successfully created treatment Treatments\Load\[Treatment Name].
2015-07-31 14:00:18: Missing value for required custom detail [Detail]e in treatment Treatments\Load\[Treatment Name].
2015-07-31 14:00:19: Unable to save treatment Treatments\Load\UTILLT13.
com.sas.analytics.crm.error.client.ApplicationException: Error saving treatment for session: b4a05f9021910030:-5a3bed03:14ee51e010d:-1a3e
        at com.sas.analytics.crm.util.SystemCheck.createMAException(SystemCheck.java:106)
        at com.sas.analytics.crm.util.SystemCheck.handleExceptionForEJB(SystemCheck.java:83)
        at com.sas.analytics.crm.cm.ejb.TreatmentBean.saveTreatment(TreatmentBean.java:129)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        ...more error lines...

This error is generated after a middle-tier restart if no clients are logged on to SAS® Customer Intelligence Studio before you execute the load treatments utility.

To work around this issue, log on to SAS Customer Intelligence Studio and then log off before you execute the load treatments utility.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Customer Intelligence UtilitiesMicrosoft® Windows® for x646.46.59.4 TS1M3
64-bit Enabled AIX6.46.59.4 TS1M3
64-bit Enabled Solaris6.46.59.4 TS1M3
HP-UX IPF6.46.59.4 TS1M3
Linux for x646.46.59.4 TS1M3
Solaris for x646.46.59.4 TS1M3
* 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.