Problem Note 59926: Building base data completes with an error
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
SAS System | SAS Promotion Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
SAS System | SAS Markdown Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2017-02-28 09:19:41 |
Date Created: | 2017-02-08 11:21:43 |