In SAS^® Marketing Automation, the following error occurs and the process fails when you execute a multi-threaded diagram interactively in Campaign Studio or by running a scheduled campaign.

   :16,507 [DEBUG]  SAS Demo User 
   analytics.crm.flow.ejb.FlowPostProcessor - Unlocking node 
   Remainder/BOXFKFJZKCPFSABC 
   2007-02-06 11:04:17,492 [ERROR]  SAS Demo User 
   ute.ejb.ExecutionManagerBean_uzvd12_Impl - Problem executing: 
   diagram, id=BOXFKFJUWQVAQAAA for user SAS Demo User: immediate cause: 
   The following error(s) occurred:,In MAIQService:executeCount:Error 
   gene rating physical query.,In MAIQService:executeCount:Error 
   generating physical query.,Error executing query.  The or - Group 0 
   node, or another node upstream from it, has failed to execute 
   successfully.,Error executing query.  The or - Group 4 node, or 
   another node upstream from it, has failed to execute successfully. 
   com.sas.analytics.crm.error.client.UserException 

This problem is caused by a concurrency issue. You can only resolve this process by setting the "Maximum number of concurrent processes per diagram" field to 1 on the Environment tab of the SAS Marketing Automation Administration plug-in in SAS^® Management Console.

Note: this solution can create performance overhead because individual campaign diagrams will not multi-thread even though separate campaigns will execute. Because the individual diagrams will not multi-thread, it takes longer to run them.

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

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 4.4 is available at: