SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 47249: The %TKMI_JOB_RO waitfor_est_service task generates the error "Error in TKMIWorker..."

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationLinux for x645.25.2_M19.3 TS1M19.3 TS1M2
SAS SystemSAS Regular Price OptimizationLinux for x645.25.2_M19.3 TS1M19.3 TS1M2
SAS SystemSAS Promotion OptimizationLinux for x645.25.2_M19.3 TS1M19.3 TS1M2
SAS SystemSAS Retail ForecastingLinux for x645.25.2_M19.3 TS1M19.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.