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
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 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2013-01-29 09:37:25 |
Date Created: | 2013-01-09 08:08:15 |