Problem Note 67222: Errors occur when you delete contact history data in SAS® Customer Intelligence
 |  |  |  |  |
The following error occurs when you delete contact-history data for a communication and multiple cells are attached to the communication:
ORA-12838: cannot read/modify an object after modifying it in parallel
In addition, the SAS Customer Intelligence core log contains these errors:
MPRINT(MACHDEL): proc sql noerrorstop;
MPRINT(MACHDEL): connect to ORACLE( PATH=sasprd USER=SASCI PASSWORD=******** );
MPRINT(MACHDEL): ;
NOTE: %INCLUDE (level 3) file CHDEL is file WORK.TEMP.CHDEL.SOURCE.
119 +
120 + execute(delete from &targettbl. where
121 + CELL_PACKAGE_SK=32981599 ) by &dbengine. ;
MPRINT(MACHDEL): execute(delete from CDM.CI_SUBS_CONTACT_HISTORY where
CELL_PACKAGE_SK=32981599 ) by ORACLE ;
MPRINT(MACHDEL): connect to ORACLE( PATH=sasprd USER=SASCI PASSWORD=******** );
MPRINT(MACHDEL): ;
NOTE: %INCLUDE (level 3) file CHDEL is file WORK.TEMP.CHDEL.SOURCE.
119 +
120 + execute(delete from &targettbl. where
121 + CELL_PACKAGE_SK=32981599 ) by &dbengine. ;
MPRINT(MACHDEL): execute(delete from CDM.CI_SUBS_CONTACT_HISTORY where
CELL_PACKAGE_SK=32981599 ) by ORACLE ;
ORACLE_105995: Executed: on connection 3
delete from CDM.CI_SUBS_CONTACT_HISTORY where CELL_PACKAGE_SK=32981599
ORACLE: 999 rows inserted/updated/deleted.
delete from CDM.CI_SUBS_CONTACT_HISTORY where CELL_PACKAGE_SK=32981599
ORACLE: 999 rows inserted/updated/deleted.
Summary Statistics for ORACLE are:
Total SQL execution seconds were: 0.264718
Total seconds used by the ORACLE ACCESS engine were 0.264864
Total SQL execution seconds were: 0.264718
Total seconds used by the ORACLE ACCESS engine were 0.264864
122 +
123 +
124 + execute(delete from &targettbl. where
125 + CELL_PACKAGE_SK=32981600 ) by &dbengine. ;
MPRINT(MACHDEL): execute(delete from CDM.CI_SUBS_CONTACT_HISTORY where
CELL_PACKAGE_SK=32981600 ) by ORACLE ;
ORACLE_105996: Executed: on connection 3
delete from CDM.CI_SUBS_CONTACT_HISTORY where CELL_PACKAGE_SK=32981600
123 +
124 + execute(delete from &targettbl. where
125 + CELL_PACKAGE_SK=32981600 ) by &dbengine. ;
MPRINT(MACHDEL): execute(delete from CDM.CI_SUBS_CONTACT_HISTORY where
CELL_PACKAGE_SK=32981600 ) by ORACLE ;
ORACLE_105996: Executed: on connection 3
delete from CDM.CI_SUBS_CONTACT_HISTORY where CELL_PACKAGE_SK=32981600
Summary Statistics for ORACLE are:
Total SQL execution seconds were: 0.271304
Total seconds used by the ORACLE ACCESS engine were 0.271485
Total SQL execution seconds were: 0.271304
Total seconds used by the ORACLE ACCESS engine were 0.271485
ERROR: ORACLE execute error: ORA-12838: cannot read/modify an object after
modifying it in parallel.
130 +
NOTE: %INCLUDE (level 3) ending.
NOTE: %INCLUDE (level 2) resuming.
MPRINT(CDICHSRC): ;
modifying it in parallel.
130 +
NOTE: %INCLUDE (level 3) ending.
NOTE: %INCLUDE (level 2) resuming.
MPRINT(CDICHSRC): ;
The error can occur as a result of the following criteria:
- Oracle is configured to modify tables in parallel without an automatic commit step.
- Publish macros contain areas where rows are deleted in multiple commands without calling the commit step after each command.
To work around this problem, enable automatic execution of the commit step in Oracle and disable the parallel degree settings in Common Data Model tables.
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 Automation | Linux for x64 | 6.6 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.6 | 9.4 TS1M6 | ||||
| 64-bit Enabled AIX | 6.6 | 9.4 TS1M6 | ||||
| Microsoft® Windows® for x64 | 6.6 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Marketing Automation 6.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H8P.html#67222| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-05-26 16:17:22 |
| Date Created: | 2021-01-13 16:55:57 |