E2E optimization failure

Answer

This means you need to check the data.

Possible causes:
- No good records to use in Optimization/RBP (no modeled and active product/locations for optimization, no active product/locations for RBP with cost and price) for the products in the scenario product group and location in the scenario location group.
- No records in the Zone Group -- The Zone Group assigned to the product category/division is empty or there are no locations that are part of the scenario location group and at the same time are part of the Zone Group.
- No products approved and active in DTOpt.Product table -- only approved and active products (IsApproved=1 and isActive=1) are considered for a pricing action. This is done to prevent seeing dropped products in price scenarios.

You will need to run some DB2 queries to discover the real cause of the problem. Query to find out Product Category ID, Division ID, Scenario Product Group ID, Scenario Location Group ID, Zone Group ID:

SELECT s.ScenarioID, s.CategoryID, s.DivisionID, s.ProductGroupID, s.LocationGroupID, sr.ScenarioRunID, sr.ZoneGroupID FROM DTOpt.ScenarioRun sr INNER JOIN DTOpt.Scenario s ON s.ScenarioID = sr.ScenarioID WHERE sr.ScenarioRunID = your_run_id_from_appserver_log WITH UR

?(created by DT Support last modified by DT Support on 2010-02-12T13:19:25.000Z)