Problem Note 50222: The SAS® Customer Experience Analytics Server 6.1 cxa_stage_profile job fails during processing and an error message is generated
 |  |  |  |  |
When you run the job cxa_stage_profile as part of a scheduled flow, the job fails with the following error message:
ERROR: Counts of stage_profile_x_session and stage_profile_dim do not match OR they are not equal to the last session_sk.
In SAS Customer Experience Analytics Server 6.1, the cxa_state_profile job executes as part of a scheduled flow. The flow is scheduled per user requirements. Once the flow is triggered, all of the jobs are executed in the pre-defined sequence. If any of the jobs fail, the flow is terminated.
The problem occurs when the counts for the two data sets (stage_profile_x_session and stage_profile_dim) do not match. However, the job still should not fail when the counts do not match.
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 Customer Experience Analytics | Solaris for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 |
| Linux for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
A fix for this issue for SAS Customer Experience Analytics Server 6.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K54.html#50222| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-09-19 10:13:49 |
| Date Created: | 2013-06-18 14:12:24 |