Usage Note 37470: Publishing a campaign fails with an "Update/Delete failed" error when the common data model is hosted on an Oracle database
When you publish a SAS® Marketing Automation campaign, data is usually written to the common data model. When the common data model is hosted on an Oracle database, the publish process might fail. This failure is accompanied by the following error in the SAS® Stored Process Server Log:
ERROR: Update/delete failed. The observation may have been changed or deleted
since the time it was read. ORACLE execute error:
ORA-08177: can't serialize access for this transaction
The error occurs when the publish process attempts to update a common data model table at the same time that another process attempts to update the same table.
To avoid this problem, set the option UPDATE_LOCK_TYPE=row when you define the common data model library name as shown below:
LIBNAME myoralib oracle user=testuser password=testpass path= 'myoraserver' update_lock_type=row;
Operating System and Release Information
SAS System | SAS Marketing Automation | Microsoft Windows Server 2003 Datacenter Edition | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Professional | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Advanced Server | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows XP 64-bit Edition | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise Edition | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Standard Edition | 5.1 | | 9.1 TS1M3 SP4 | |
Microsoft Windows XP Professional | 5.1 | | 9.1 TS1M3 SP4 | |
Windows Vista | 5.1 | | 9.1 TS1M3 SP4 | |
Windows Vista for x64 | 5.1 | | 9.1 TS1M3 SP4 | |
64-bit Enabled AIX | 5.1 | | 9.1 TS1M3 SP4 | |
64-bit Enabled HP-UX | 5.1 | | 9.1 TS1M3 SP4 | |
64-bit Enabled Solaris | 5.1 | | 9.1 TS1M3 SP4 | |
HP-UX IPF | 5.1 | | 9.1 TS1M3 SP4 | |
Linux | 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.
Date Modified: | 2012-02-06 10:25:47 |
Date Created: | 2009-10-14 15:35:23 |