Problem Note 47249: The %TKMI_JOB_RO waitfor_est_service task generates the error "Error in TKMIWorker..."
The SAS® Revenue Optimization Suite %TKMI_JOB_RO waitfor_est_service task might generate the following error in the MerchIntelGridSvr.log file:
yyyy-mm-dd hh:mm:ss,mmm [pool-n-thread-n] ERROR - Error in TKMIWorker
java.lang.RuntimeException: error (RC=1) on host 'grid_captain' while executing remote shell command 'set -o pipefail
(
umask 000
export 'TKPATH=SASHOME/SASFoundation/9.3/sasexe=SASHOME/SASFoundation/9.3/utilities/bin'
export ORACLE_HOME ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME:$LD_LIBRARY_PATH
export LANG=en_US
unset LC_ALL
unset NLS_LANG
=SASHOME/SASFoundation/9.3/utilities/bin/mi <<END
run=batch_est;hostname_ovrd=grid_captain;debug=1;2;data=di_dm;status_log_file=grid_captain.status.log;rdbms_vendor=oracle;rdbms_database=oracle_server:port;rdbms_schema=DI_DM;rdbms_user=di_dm;rdbms_password=****;debug=0;trace=;
END
) | tee grid_captain.batch_est.log':
at com.sas.solutions.di.tkmiserver.shell.RemoteShell.exec(RemoteShell.java:128)
at com.sas.solutions.di.tkmiserver.dispatcher.RshDispatcher.run(RshDispatcher.java:34)
at com.sas.solutions.di.tkmiserver.CommandHelper.runRshCmd(CommandHelper.java:848)
at com.sas.solutions.di.tkmiserver.data.DataServiceImpl$TKMIWorker.run(DataServiceImpl.java:1505)
at com.sas.solutions.di.tkmiserver.data.DataServiceImpl$EstimationWorker.run(DataServiceImpl.java:1917)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
yyyy-mm-dd hh:mm:ss,mmm [pool-n-thread-n] INFO - Retrieved n lines from status log for captain: grid_captain
yyyy-mm-dd hh:mm:ss,mmm [pool-n-thread-n] INFO - grid_captain: batch_est (partition_id=0)
Model_Group_Ids: list_of_model_groups_that_succeeded
ERROR: Model_Group_Id=list_of_model_groups_that_failed (DQ=n,RT=1)
This error does not occur consistently. A model group that fails during one run might succeed in a subsequent run.
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
| SAS System | SAS Markdown Optimization | Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M1 | 9.3 TS1M2 |
| SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M1 | 9.3 TS1M2 |
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M1 | 9.3 TS1M2 |
| SAS System | SAS Retail Forecasting | Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M1 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2012-08-24 12:56:30 |
| Date Created: | 2012-08-17 10:56:59 |