Steps:


1. Login via ssh to the optimalOne server (10.20.0.46).

2. psql jboss-cima

3. Run the following SQL update statements:


start transaction;    <-- MANDATORY SAFETY STEP

UPDATE deliveryorderitems SET productbrand=productbrands.id FROM deliveryorders,products,productbrands WHERE deliveryorders.id=deliveryorderitems.parentdeliveryorder AND deliveryorderitems.product=products.id AND products.productbrandid=productbrands.id AND productbrands.id <> deliveryorderitems.productbrand AND deliveryorders.deliveryordernumber IN (LIST_OF_DO_NUMBERS);
UPDATE dowarehouse SET productbrand=productbrands.productbrandname FROM deliveryorders,deliveryorderitems,productbrands WHERE deliveryorders.id=deliveryorderitems.parentdeliveryorder AND deliveryorders.id=dowarehouse.deliveryorderid AND deliveryorderitems.productbrand=productbrands.id AND productbrands.id=deliveryorderitems.productbrand AND dowarehouse.productbrand <> productbrands.productbrandname AND deliveryorders.deliveryordernumber IN (LIST_OF_DO_NUMBERS);
UPDATE salesorderallocations SET productbrand=deliveryorderitems.productbrand FROM deliveryorders,deliveryorderitems WHERE deliveryorders.id=deliveryorderitems.parentdeliveryorder AND deliveryorders.salesorderallocation=salesorderallocations.id AND salesorderallocations.productbrand <> deliveryorderitems.productbrand AND deliveryorders.deliveryordernumber IN (LIST_OF_DO_NUMBERS);
commit;    <-- MUST RUN THIS TO COMMIT THE TRANSACTION

Replace LIST_OF_DO_NUMBERS with the comma delimited list of the affected delivery order numbers e.g. 'BK:1140221','BK:1140753','BK:1137856','BK:1137855'