SUPPORT / SAMPLES & SAS NOTES
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)
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||