Problem Note 54422: The SAS® Customer Experience Analytics LOAD_SESSION_ATTRIBUTION and LOAD_FORM_DETAIL jobs fail
The two jobs LOAD_SESSION_ATTRIBUTION and LOAD_FORM_DETAIL assume that the sequence numbers are less than 999 in the following columns:
BUSINESS_PROCESS_X_EXCEPTION.UNSUCCESSFUL_ATTEMPT_INDEX_NO
FORM_DETAIL.CHANGE_INDEX_NO
SESSION_ATTRIBUTION.SEQUENCE_NO
This assumption is generally valid because larger sequence numbers are generally the result of automated clicks rather than the human-driven data that we intend to gather. If the sequence numbers exceed 999, these two jobs fail.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After the hot fix is applied, rows in which these sequence values exceed 999 are discarded when you run LOAD_SESSION_ATTRIBUTION or LOAD_FORM_DETAIL.
Operating System and Release Information
SAS System | SAS Customer Experience Analytics | Microsoft® Windows® for x64 | 6.1 | 6.3 | | 9.4 TS1M0 |
64-bit Enabled AIX | 6.1 | 6.3 | | 9.4 TS1M0 |
64-bit Enabled Solaris | 6.1 | 6.3 | | 9.4 TS1M0 |
Linux for x64 | 6.1 | 6.3 | | 9.4 TS1M0 |
Solaris for x64 | 6.1 | 6.3 | | 9.4 TS1M0 |
*
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.
The SAS Customer Experience Analytics LOAD_SESSION_ATTRIBUTION job and LOAD_FORM_DETAIL job fail if sequence values exceed 999.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2014-10-24 10:19:14 |
Date Created: | 2014-10-22 14:35:17 |