Problem Note 61596: The refine-output functionality fails when you use it with a numeric field that is defined as "Nominal"
When you use the the refine-output functionality (on the Refine Output tab) in a SAS® Marketing Automation Export node that references an upstream Select node in the diagram, the diagram fails and generates the following error:
2017-11-30 09:36:41,840 ERROR [CIAsyncExec-9] [8ec1f05501a09d7f:390e3cb0:160085cff2b:2235] [sasdemo]vcom.sas.analytics.crm.util.SystemCheck - Error executing campaign.
com.sas.analytics.crm.error.client.ApplicationException
at
com.sas.analytics.crm.flow.ForkCampCommExecution.run(ForkCampCommExecution.java:100)
at
com.sas.analytics.crm.security.SecurityExecutorServiceImpl$WrappedRunnable.run(SecurityExecutorServiceImpl.java:61)
at
com.sas.analytics.crm.task.ejb.ClearedThreadLocalRunnable.run(ClearedThreadLocalRunnable.java:17)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.String
at
com.sas.analytics.crm.sql.client.FilterNodeDO$ValueCombinator.createTreeSet(FilterNodeDO.java:923)
at
com.sas.analytics.crm.sql.client.FilterNodeDO.combineWith(FilterNodeDO.java:519)
The diagram fails because the Select node uses a numeric field that is defined as Level=Nominal in the SAS Marketing Automation information map. This problem also occurs if a date field is defined as Level=Nominal.
To work around this issue, define the numeric or date field as Level=Internal in the SAS Marketing Automation information map.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Linux for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-02-21 16:45:34 |
Date Created: | 2017-12-18 10:31:44 |