WARNING NULL PROPORTION DETECTED FOR PROP xx AT NODE xx,yy (Doc ID 1917031.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Customer is on 12.2.3

12.2.3 5 0 4/5/2014 12:37:50 AM
12.2.3 1 12230019 5/6/2014 10:04:12 AM

When they run the batch or simulation engine they get the following error:

12:38:56:999 http://EngLogger.cpp,220 Logger General Level: message, UserLevel: message
12:38:57:001 Working with Oracle RDBMS
12:38:57:005 Database connection string: Provider=MSDAORA;Data Source=devdsc_r12 User: LFDEM
12:38:58:420 12:38:58:421 Oracle Demantra Windows Forecast Engine Version 12.2.3 ( 12.2.3.0 (12230019) (2644) )
12:38:58:421 Engine Start Time 12:38:58 - 08/05/2014
12:38:58:421 Running in Batch mode for profile ID: 1
12:38:58:421 12:38:58:425 Loading parameters from INIT_PARAMS_0 table.
12:38:58:432 Loading parameters from INIT_PARAMS_1 table.
12:38:58:552 Engine is using table SALES_DATA as fact table
12:38:58:552 Engine is using table MDP_MATRIX as combination table
12:38:58:552 Engine is using table INPUTS as inputs table
12:38:58:552 Engine is using table PARAMETERS as parameters table
12:38:58:754 Engine is using @ITEM_ID, @LOCATION_ID as lowest data key
12:38:58:823 Calculated last date: 2014-03-01 (41699)
12:38:58:824 Calculated start date: 1995-01-01 (34700)
12:38:58:884 Calculated first forecast date: 2014-04-01 (41730)
12:38:58:898 Calculated last forecast date: 2016-03-01 (42430)
12:39:01:213 CHECK_FORE_SERIES finished
12:39:01:213 Executing the shell...
12:39:01:232 Writing output to forecast column:FORE_2
12:39:01:361 Resest of Matrix will be executed in engine tasks
12:39:01:361 Resetting previous forecast for inactive combinations
12:39:01:451 Start Analyzing Table : mdp_temp_99
12:39:01:715 Finished Analyzing Table : mdp_temp_99
12:39:01:736 Finished resetting SALES_DATA previous forecast
12:39:01:825 Truncating node_forecast and interm_results tables
12:39:02:037 INSERT_UNITS Procedure Started
12:39:03:312 INSERT_UNITS Procedure Finished
12:39:03:399 Deleting rows from ENGINE_CACHES table with current profile_id ...
12:39:03:412 Generating the branch IDs...
12:39:03:413 Using Fast divider...(V1.1)
12:39:04:427 Divider preferred size: 100, Factor: 4
12:39:05:675 Start Analyzing Table : ENGINE_BRANCH_LIST
12:39:05:878 Finished Analyzing Table : ENGINE_BRANCH_LIST
12:39:05:878 Start Analyzing Table : MDP_MATRIX
12:39:11:255 Finished Analyzing Table : MDP_MATRIX
12:39:11:258 1 branches were created.
12:39:23:604 Creating engines...
12:39:25:238 Engine (ID: 0) on machine localhost was successfully created and initialized
12:39:25:238 1 engines were created.
12:39:26:123 Computer localhost speed = 2.61
12:39:29:431 Machine localhost (ID: 0) receiving Branch: 1
12:39:43:746 12:39:43:745 WARNING NULL proportion detected for prop #1 at node: 1, 12
12:39:43:845 12:39:43:845 WARNING NULL proportion detected for prop #2 at node: 1, 12
12:39:43:945 12:39:43:945 WARNING NULL proportion detected for prop #3 at node: 1, 12
12:39:44:045 12:39:44:045 WARNING NULL proportion detected for prop #4 at node: 1, 12
12:39:44:145 12:39:44:145 WARNING NULL proportion detected for prop #5 at node: 1, 12
12:39:44:245 12:39:44:245 WARNING NULL proportion detected for prop #6 at node: 1, 12
12:39:44:345 12:39:44:345 WARNING NULL proportion detected for prop #7 at node: 1, 12
12:39:44:445 12:39:44:445 WARNING NULL proportion detected for prop #8 at node: 1, 12
12:39:44:545 12:39:44:545 WARNING NULL proportion detected for prop #9 at node: 1, 12
12:39:44:645 12:39:44:645 WARNING NULL proportion detected for prop #10 at node: 1, 12
12:39:44:745 12:39:44:745 WARNING NULL proportion detected for prop #11 at node: 1, 12
12:39:44:845 12:39:44:845 WARNING NULL proportion detected for prop #12 at node: 1, 12
12:40:14:192 Engine (ID: 0) on machine localhost successfully completed Branch: 1
12:40:25:324 Engines have finished executing.
12:40:25:340

They have changed the hist_glob_prop and have the following values

dying_time is 24
hist_glob_prop is 28

But if they query mdp_matrix, all combinations shows
dying_time is null
hist_glob_prop is 6

The same also shows p1 through 12 as null even though the prediction status is 1 (active combination)

Customer executed proport after setting the prop_changes to 1. But that did not help either

update mdp_matrix set prediction_status = 99, prop_changes=1;
commit;
exec proport;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms