Problem Note 56347: The error "Unable to save treatment" occurs when you use the SAS® Customer Intelligence Integration Utilities to load treatments
 |  |  |  |  |
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence Utilities | Microsoft® Windows® for x64 | 6.4 | 6.5 | 9.4 TS1M3 | |
| 64-bit Enabled AIX | 6.4 | 6.5 | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 6.4 | 6.5 | 9.4 TS1M3 | |||
| HP-UX IPF | 6.4 | 6.5 | 9.4 TS1M3 | |||
| Linux for x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
| Solaris for x64 | 6.4 | 6.5 | 9.4 TS1M3 | |||
A fix for this issue for SAS Marketing Automation 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U53.html#56347A fix for this issue for SAS Marketing Automation 6.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R60.html#56347| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-08-11 15:41:07 |
| Date Created: | 2015-08-04 15:46:02 |