SUPPORT / SAMPLES & SAS NOTES
Problem Note 61833: The cxt_2000_load_user_agent_dim job fails when LIBNAME statement options for CXTCOMM do not propagate to the SAS® 360 Discover CXT ETL script
 |  |  |  |  |
The LIBNAME statement options from SAS® Management Console for the CXTCOMM library do not propagate to the SAS 360 Discover Customer Experience Targeting (CXT) extract, transform, load (ETL) script.
When this problem occurs, the cxt_2000_load_user_agent_dim job can fail with an error that is similar to the following:
MPRINT(CXT_JOB_CHECKS): appnd="CXTSTAGE.USER_AGENT_DIM";
MPRINT(CXT_JOB_CHECKS): cnfg_md5="CXTCNFG.USER_AGENT_MD5";
MPRINT(CXT_JOB_CHECKS): work_md5="CXTWORK.USER_AGENT_MD5_NEW_KEYS";
MPRINT(CXT_JOB_CHECKS): cnfg_max_sk_value="CXTCNFG.USER_AGENT_MAX_SK_VALUES";
MPRINT(CXT_JOB_CHECKS): work_max_sk_value="CXTWORK.User_Agent_Max_SK_Value";
MPRINT(CXT_JOB_CHECKS): status="SUCCESSFUL";
MPRINT(CXT_JOB_CHECKS): run;
MPRINT(CXT_JOB_CHECKS): cnfg_md5="CXTCNFG.USER_AGENT_MD5";
MPRINT(CXT_JOB_CHECKS): work_md5="CXTWORK.USER_AGENT_MD5_NEW_KEYS";
MPRINT(CXT_JOB_CHECKS): cnfg_max_sk_value="CXTCNFG.USER_AGENT_MAX_SK_VALUES";
MPRINT(CXT_JOB_CHECKS): work_max_sk_value="CXTWORK.User_Agent_Max_SK_Value";
MPRINT(CXT_JOB_CHECKS): status="SUCCESSFUL";
MPRINT(CXT_JOB_CHECKS): run;
NOTE: There were 1 observations read from the data set CXTCOMM.USER_AGENT_DIM_CK.
NOTE: The data set CXTCOMM.USER_AGENT_DIM_CK has 1 observations and 10 variables.
ERROR: Rename of temporary member for CXTCOMM.USER_AGENT_DIM_CK.DATA failed.
File can be found in F:\SASData\CXT\AppData\SASCustomerExperienceTargeting\cxt_etl\cxtcomm.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
NOTE: The data set CXTCOMM.USER_AGENT_DIM_CK has 1 observations and 10 variables.
ERROR: Rename of temporary member for CXTCOMM.USER_AGENT_DIM_CK.DATA failed.
File can be found in F:\SASData\CXT\AppData\SASCustomerExperienceTargeting\cxt_etl\cxtcomm.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
To work around this issue, download the attached macros and add them to the ucmacros location.
Use the following commands in SAS® Customer Experience Targeting 6.3:
- Windows: -insert sasautos "!SASROOT\cxasvr\ucmacros"
- UNIX: -insert SASAUTOS "!SASROOT/ucmacros/cxasvr"
For SAS Customer Experience Targeting 6.4 and SAS 360 Discover, store the macros in the following location:
- SAS-configuration-directory\LevN\SASAppCXA\SASE
In this path:
- SAS-configuration-directory specifies the path to your SAS configuration directory.
- LevN specifies the configuration level.
- SASAppCXA specifies the application name.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Customer Intelligence 360 | N/A | ||