Problem Note 55667: Intermittent failures occur when you try to create scenarios in SAS® Marketing Optimization
 |  |  |  |  |
In SAS Marketing Optimization, you might see intermittent failures when you attempt to create scenarios. These failures manifest as an orphaned data-store entry for the scenario in the scenarios table, and there is no corresponding public object for the entry.
When this failure occurs, the SASMarketingOptimization6.x.log, MarketingOptimizationddmmmyy_1.log, and ShareServer_xxx.log files show that the failure to create a scenario is related to the following error:
This problem might happen when you execute multiple scenario actions at the same time. This error results in concurrent SAS® Stored Process Server calls that need access to update the scenarios table.
The failures are intermittent because the problem is a timing issue. That is, if the problem occurs during scenario creation, the middle tier aborts the scenario-creation process, and there is no attempt to create the corresponding public object.
In this situation, the PUBLIC_OBJECT_METADATA_ID column for the scenario is blank in the scenarios table. When there is no public object for a scenario in the data store, that scenario cannot be surfaced in SAS Marketing Optimization.
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 Optimization | Microsoft® Windows® for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8 Pro x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Enterprise x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows 8.1 Pro 32-bit | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 R2 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2008 for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Datacenter | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 R2 Std | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Microsoft Windows Server 2012 Std | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Windows 7 Enterprise x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Windows 7 Professional x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| 64-bit Enabled AIX | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| 64-bit Enabled HP-UX | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| 64-bit Enabled Solaris | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| HP-UX IPF | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Linux for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
| Solaris for x64 | 6.1_M1 | 6.4 | 9.4 TS1M0 | |||
A fix for this issue for SAS Marketing Optimization 6.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R88.html#55667| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-04-28 11:02:06 |
| Date Created: | 2015-04-28 09:00:07 |