Problem Note 62391: A Write-access error occurs (for the mometa.uid.data table) when you execute a campaign group in SAS® Customer Intelligence Studio
 |  |  |  |  |
In SAS Customer Intelligence Studio, you might see the following error in the SASMarketingOptimization.log file when you execute a campaign group:
ERROR: You cannot open MOMETA.UID.DATA for input access with record-level
control because MOMETA.UID.DATA is locked for exclusive
access by user sassched.
ERROR:(mo_gen_uid) 12:49:12 Error occurred while generating unique id (sqlrc=8).
ERROR:(mo_gen_uid) 12:49:12 Maxkey contains no value.
ERROR:(mo_edit_input_data) 12:49:12 Could not generate a unique
customer_column_id.
control because MOMETA.UID.DATA is locked for exclusive
access by user sassched.
ERROR:(mo_gen_uid) 12:49:12 Error occurred while generating unique id (sqlrc=8).
ERROR:(mo_gen_uid) 12:49:12 Maxkey contains no value.
ERROR:(mo_edit_input_data) 12:49:12 Could not generate a unique
customer_column_id.
As a possible workaround, minimize concurrent generation of input data for campaign groups.
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.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 |
| 64-bit Enabled AIX | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| HP-UX IPF | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| Linux for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
| Solaris for x64 | 6.4 | 6.6 | 9.4 TS1M2 | 9.4 TS1M6 | ||
A fix for this issue for SAS Marketing Optimization 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z82.html#62391A fix for this issue for SAS Marketing Optimization 6.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U54.html#62391| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-12-07 14:53:41 |
| Date Created: | 2018-05-31 10:54:21 |