Problem Note 19808: An error occurs and the process fails when you execute a multi-threaded diagram interactively or by running a scheduled campaign
 |  |  |  |  |
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation-Server | Microsoft Windows XP Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| Solaris | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| AIX | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||
| HP-UX IPF | 4.4 | 5.1 | 9.1 TS1M3 SP4 | |||