Problem Note 57081: The %TKMI_JOB_RO etl_end_service task generates "ERROR: (table=,column=,row=) detected a double value greater than (2^34)-1..."
 |  |  |  |  |
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#57081| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-02-09 09:42:52 |
| Date Created: | 2015-11-13 11:08:15 |