59926 - Building base data completes with an error

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

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Promotion Optimization	Linux for x64	5.2_M4	5.4	9.3 TS1M2	9.4 TS1M4
SAS System	SAS Promotion Optimization	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
SAS System	SAS Regular Price Optimization	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
SAS System	SAS Markdown Optimization	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

Support

Problem Note 59926: Building base data completes with an error

Operating System and Release Information