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
| 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 |
*
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 |
| Topic: | System Administration ==> Servers
|
| Date Modified: | 2007-05-21 15:57:31 |
| Date Created: | 2007-03-21 15:27:57 |
