In SAS^® Customer Experience Analytics, you can process data tables into Oracle tables. When you process a table that has a column with values that exceed the predefined length, an error occurs. For example, you receive an error if you have a column that is predefined with the NUMERIC(9) function, but the values in the column contain ten digits.

When this problem happens, an error message similar to the following is generated:

NOTE: There were 100 observations read from the data set CXASTAGE.STAGING_TABLE.
NOTE: 99 observations added.
NOTE: The data set CXASTAGE.STAGING_TABLE has . observations and 1 variables.
ERROR: ERROR: ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed for this column.

With this error, the error limit (1) that is set by the ERRLIMIT= option has been reached. When this happens, any rows that are processed after the last COMMIT are lost.

You can prevent this problem by using cleansing code, as follows:

1. Open the cxa_clean_session_fact.sas file, which resides in the following locations:
   
   • Microsoft Windows operating environments: !SASROOT\cxasvr\ucmacros
   • UNIX operating environments: !SASROOT/ucmacros/cxasvr
2. Add the following code to cxa_clean_session_fact.sas:
   
   if CCXASTAGE.STAGING_TABLE > 999999999 then CXASTAGE.STAGING_TABLE=999999999
3. Run the ETL_Reset job.
4. Rerun the ETL 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.3 is available at: