When you run the Extended Customer View extract, transform, and load (ETL) job in SAS Customer Experience Analytics, the ETL job can fail. The job fails when a numeric value exceeds eight digits and is incorrectly converted to a character value and when the job tries to update the ECVrunfile.sas file. When the failure occurs, the following error appears in the log.

As a workaround for this problem, follow the steps below.

1. Click here to access a corrected version of the CXT_ECVCHKINTEGRITY macro. Save the corrected macro to the default sasautos directory: SAS-configuration-directory/Lev1/.../sasautos/.
2. Execute the failed job (cxt_3400_ecv_CEAUPDATES) and run the ECV flow.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Customer Experience Targeting Server 6.4 is available at: