The SAS^® Revenue Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridSvr.log file:

<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <HH:MM:SS> prep_<prod_hier_sk>pga: 
ERROR: (table=<table_name>, column=<column_name>, row=<row_nbr>) detected a double value 
greater than (2^34)-1 or less than -(2^34) (<data_value>)

This error occurs when a calculated value for <table_name>.<column_name> is larger than 17,179,869,183 or less than -17,179,869,184. The calculated data value is provided in the error message.

If the calculated value is a result of incorrect data, the workaround for this issue is to correct any underlying data. If the calculated value is correct, there is no workaround for this issue.

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 Revenue Optimization 5.2_M4 is available at: