SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57539: A user exception error occurs when you update counts on diagram nodes using Link and Cell nodes in SAS® Customer Intelligence Studio

DetailsHotfixAboutRate It

When you update counts on a Cell node or on all nodes in a diagram using Link and Cell nodes, the updates might fail and the following error message occurs in the SASCustomerIntelligenceCore6.3.log file:

com.sas.analytics.crm.util.SystemCheck   - Error executing campaign.
com.sas.analytics.crm.error.client.UserException
	at com.sas.analytics.crm.flow.MANode.updateAfterAsynchExecution(MANode.java:643)
	at com.sas.analytics.crm.flow.MASQLNode.updateAfterAsynchExecution(MASQLNode.java:657)
	at com.sas.analytics.crm.flow.MABaseSelectNode.updateAfterAsynchExecution(MABaseSelectNode.java:401)
	at com.sas.analytics.crm.flow.FlowPostProcessor.doProcess(FlowPostProcessor.java:334)
	at com.sas.analytics.crm.task.ejb.TaskSequence.handleCompletedSequence(TaskSequence.java:726)
	at com.sas.analytics.crm.task.ejb.TaskSequence.completeJob(TaskSequence.java:1130)
	at com.sas.analytics.crm.task.queue.JobCleanupRunner.run(JobCleanupRunner.java:23)
	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:744)

In SAS Customer Intelligence Studio, the following message is displayed:

Error executing query. The Status node, or other node upstream from it, has failed to execute successfully

When this problem happens, the campaign becomes unresponsive and you need to close SAS Customer Intelligence Studio.

As a workaround, remove the Cell node between the Link and Limit nodes. The example below shows Link and Limit nodes where the Cell node has been removed.

Remove the Cell node

Then, you can make the Link node behave like a Cell node by selecting the Act as a marketing cell option in the Link node.

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 Marketing AutomationSolaris for x646.36.59.4 TS1M29.4 TS1M3
Linux for x646.36.59.4 TS1M29.4 TS1M3
HP-UX IPF6.36.59.4 TS1M29.4 TS1M3
64-bit Enabled Solaris6.36.59.4 TS1M29.4 TS1M3
64-bit Enabled AIX6.36.59.4 TS1M29.4 TS1M3
Microsoft® Windows® for x646.36.59.4 TS1M29.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.