Problem Note 48872: SAS® Real-Time Decision Manager campaigns and SAS® Digital Marketing campaigns might not consistently update the contact history
 |  |  |  |  |
SAS Real-Time Decision Manager and SAS Digital Marketing use SAS® Stored Processes to update the contact history. However, those stored processes sometimes fail. In the SAS® Marketing Automation core log, you might see error messages similar to the following when the problem occurs:
ERROR 2012-09-07 07:06:03,907 CIStoredProcessTask Sent an error message to error
cache with key = CHTUPOP1346930843095 &&& dataMap = {Error_Details=Execution
failed.CCS Return Code: [001]
CCS Return Message: [Error processing History tables. Check log and
MAMISC.CI_HISTORY_ERROR_REPORT for details]
SAS Return Code: [100]
Node name: []
Table name: []
Column name: [], Error_Code=StpResultsError,
EXECUTION_TICKET=CHTUPOP1346930843095}
ERROR 2012-09-07 07:06:03,907 CIStoredProcessTask Stp error for
executionTicket=(CHTUPOP1346930843095) is as follows
Execution failed.CCS Return Code: [001]
CCS Return Message: [Error processing History tables. Check log and
MAMISC.CI_HISTORY_ERROR_REPORT for details]
SAS Return Code: [100]
Node name: []
Table name: []
Column name: []In the reporting log, you might also see messages similar to the following when this problem occurs:
11172732 [ queue-reader5] DEBUG ks.TricklingInsertTimeWaitTask - About to call SP For :- CHTUPOP1347957051886(3 Records) :: T::RECORD_WAIT @ 07:37:01 11172732 [ queue-reader5] DEBUG ks.TricklingInsertTimeWaitTask - Submitting CH Stored process 11172732 [ queue-reader5] DEBUG ks.TricklingInsertTimeWaitTask - Time taken for trickling task: 0:00:00.000 11173025 [ ch_stp1] DEBUG rvice.sp.AbstractStoredProcess - Inside fillStream :- Stream name=CHStream
These messages are followed by the XML data that is sent to the stored process. However, there are no messages in the logs showing that the stored process finishes.
There is no workaround for this problem.
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 Real-Time Decision Manager | Microsoft® Windows® for x64 | 5.41 | 6.1 | 9.3 TS1M2 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 5.41 | 6.1 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 5.41 | 6.1 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| HP-UX IPF | 5.41 | 6.1 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 5.41 | 6.1 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Solaris for x64 | 5.41 | 6.1 | 9.3 TS1M2 | 9.3 TS1M2 | ||
A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#48872| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-01-29 09:37:25 |
| Date Created: | 2013-01-09 08:08:15 |