SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59926: Building base data completes with an error

DetailsHotfixAboutRate It

In SAS® Merchandise Solutions Configuration Workbench, building base data might complete with an error as indicated by a Completed with error status in the Grid Execution Results dialog box. When this issue occurs, the following warning message is generated in the MerchIntelGridsvr.log file.  The warning might be generated more than once.

<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: running command: run='ma_base_data'
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Warning: no model group data available
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>:: Model_Group_Ids: xxx

Even though a success status is printed in the log, the run results in an rc value of 0 and the following error is generated:

<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Status Stats:
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: -------------
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Success with DQ: 1
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT:     xxx
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Min/Avg/Max Units Processed: 132/132/132
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Min/Avg/Max Elapse Time(s) : 0/0/0
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Total Units Processed: 132
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>: Total Elapse Time(s) : 10
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: <YYYYMMDD:HH.MM.SS.MM>:
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - STDOUT: rc=0
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - RC: 0
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG - Finished running '! [ -f 'ma_base_data.7.log' ] || (echo; echo; echo TKMI LOG: <captain>: ma_base_data.7.log; echo && cat 'ma_base_data.7.log' && rm -rf 'ma_base_data.7.log')' on captain <captain> with result 0
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] DEBUG -   tkmi rc = 1
<YYYY-MM-DD HH:MM:SS,MMM> [pool-<n>-thread-<n>] INFO  - Skip copying results from <captain> for failed request run=ma_base_data;fa_output_path=<output_path>;user_nm=<user_id>;
<YYYY-MM-DD HH:MM:SS,MMM> [http-<n>-Processor2-<n>] ERROR - Failed to run on <captain> with command run=ma_base_data;fa_output_path=<output_path>;user_nm=<user_id>;
java.lang.RuntimeException: error (RC=1) executing TKMI command on captain <captain>: run=ma_base_data;fa_output_path=<output_path>;user_nm=<user_id>;context_sk=0;scope_sk=null;scope_assoc_cd=null;process_sk=0;partition_id=<partition_id>;
      at com.sas.solutions.di.tkmiserver.dispatcher.TKMI.invoke(TKMI.java:91)
      at com.sas.solutions.di.tkmiserver.dispatcher.TkDispatcher.run(TkDispatcher.java:73)
      at com.sas.solutions.di.tkmiserver.dispatcher.RequestDispatcher.run(RequestDispatcher.java:80)
      at com.sas.solutions.di.tkmiserver.requestexecutor.RequestExecutorImpl$RunRequestTask.ca(RequestExecutorImpl.java:142)
      at com.sas.solutions.di.tkmiserver.requestexecutor.RequestExecutorImpl$RunRequestTask.call(RequestExecutorImpl.java:117)
      at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      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)

This error occurs when you build base data for a model group that belongs to a captain that has a partition with no model groups defined.

The workaround for this issue is to ensure that there is at least one model group defined for the product-locations in every partition.

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 Promotion OptimizationLinux for x645.2_M45.49.3 TS1M29.4 TS1M4
Microsoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Regular Price OptimizationLinux for x645.2_M45.49.3 TS1M29.4 TS1M4
Microsoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
SAS SystemSAS Markdown OptimizationLinux for x645.2_M45.49.3 TS1M29.4 TS1M4
Microsoft® Windows® for x645.2_M45.49.3 TS1M29.4 TS1M4
* 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.