Buy Ship > Bulk Planning always failing

[nbbhatia]

Despite the correct setups, Bulk Planning is always failing. Last few lines of error log are as under:


2009-12-26 22:42:12.0 685139 Debug Planning Begin location capacity optimization... [batch - 1]
Begin location capacity optimization... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning End location capacity optimization... [batch - 1]
End location capacity optimization... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning Begin Post processing and Saving Shipments to Database ... [batch - 1]
Begin Post processing and Saving Shipments to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning # of shipment graphs created from this bulk plan run: 0 [batch - 1]
# of shipment graphs created from this bulk plan run: 0 [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning Complete Saving Shipments to Database ... [batch - 1]
Complete Saving Shipments to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning Begin Saving Trailler build Shipment Groups to Database ... [batch - 1]
Begin Saving Trailler build Shipment Groups to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning End Saving Shipment Groups to Database ... [batch - 1]
End Saving Shipment Groups to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning End Saving Trailler build Shipment Groups to Database ... [batch - 1]
End Saving Trailler build Shipment Groups to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning Begin Saving Continuous Move refnums to Database ... [batch - 1]
Begin Saving Continuous Move refnums to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning End Saving Continuous Move refnums to Database ... [batch - 1]
End Saving Continuous Move refnums to Database ... [batch - 1]

2009-12-26 22:42:12.0 685139 Debug Planning End Bulk plan run #1 [batch - 1]
End Bulk plan run #1 [batch - 1]

2009-12-26 22:42:12.015 685139 Debug Planning Attempting to set Status of OrderRelease: GUEST.MULTISTOP1-001 to PLANNED - FAILED [batch - 1]
Attempting to set Status of OrderRelease: GUEST.MULTISTOP1-001 to PLANNED - FAILED [batch - 1]

2009-12-26 22:42:12.015 685139 Debug Planning Successfully set Status of OrderRelease: GUEST.MULTISTOP1-001 to PLANNED - FAILED. [batch - 1]
Successfully set Status of OrderRelease: GUEST.MULTISTOP1-001 to PLANNED - FAILED. [batch - 1]

2009-12-26 22:42:12.015 685139 Debug Planning Find Substitute Locations SQL:SELECT LOCATION_GID, SUBSTITUTE_LOCATION_GID FROM LOCATION_SUBSTITUTE WHERE LOCATION_GID = ? OR LOCATION_GID = ? src:GUEST.PHOENIX DC/changed:false dest:GUEST.SAN DIAGO STORE/changed:false [batch - 1]
Find Substitute Locations SQL:SELECT LOCATION_GID, SUBSTITUTE_LOCATION_GID FROM LOCATION_SUBSTITUTE WHERE LOCATION_GID = ? OR LOCATION_GID = ? src:GUEST.PHOENIX DC/changed:false dest:GUEST.SAN DIAGO STORE/changed:false [batch - 1]

2009-12-26 22:42:12.031 685139 Debug Planning CriteriaToBeIgnoredHelper.clearCriteriaToBeIgnored (): Clearing thread local stored criteria to be ignored-- [batch - 1]
CriteriaToBeIgnoredHelper.clearCriteriaToBeIgnored (): Clearing thread local stored criteria to be ignored-- [batch - 1]

2009-12-26 22:42:12.031 685139 Debug Planning Updating bulk plan result:<BulkPlanResult bulk Plan Gid = GUEST.20091226-0007 <-- Order Release Statistics --> Num Of Order Releases Selected = 1 Num Of Order Releases Unassigned = 0 Num Of Order Releases Planned = 0 Num Of Order Releases Failed To Plan = 1 <-- Order Movement Statistics --> Num Of Order Movements Selected = 0 Num Of Order Movements Unassigned = 0 Num Of Order Movements Planned = 0 Num Of Order Movements Failed To Plan = 0 <-- Shipment Statistics --> Num Of Shipments Built = 0 Start Time = 2009-12-27 06:42:11 UTC End Time = 2009-12-27 06:42:12 UTC > ... [batch - 1]
Updating bulk plan result:<BulkPlanResult bulk Plan Gid = GUEST.20091226-0007
<-- Order Release Statistics -->
Num Of Order Releases Selected = 1
Num Of Order Releases Unassigned = 0
Num Of Order Releases Planned = 0
Num Of Order Releases Failed To Plan = 1
<-- Order Movement Statistics -->
Num Of Order Movements Selected = 0
Num Of Order Movements Unassigned = 0
Num Of Order Movements Planned = 0
Num Of Order Movements Failed To Plan = 0
<-- Shipment Statistics -->
Num Of Shipments Built = 0
Start Time = 2009-12-27 06:42:11 UTC
End Time = 2009-12-27 06:42:12 UTC > ... [batch - 1]

2009-12-26 22:42:12.046 685139 Debug Planning Updated bulk plan result:<BulkPlanResult bulk Plan Gid = GUEST.20091226-0007 <-- Order Release Statistics --> Num Of Order Releases Selected = 1 Num Of Order Releases Unassigned = 0 Num Of Order Releases Planned = 0 Num Of Order Releases Failed To Plan = 1 <-- Order Movement Statistics --> Num Of Order Movements Selected = 0 Num Of Order Movements Unassigned = 0 Num Of Order Movements Planned = 0 Num Of Order Movements Failed To Plan = 0 <-- Shipment Statistics --> Num Of Shipments Built = 0 Start Time = 2009-12-27 06:42:11 UTC End Time = 2009-12-27 06:42:12 UTC > has been committed. [batch - 1]
Updated bulk plan result:<BulkPlanResult bulk Plan Gid = GUEST.20091226-0007
<-- Order Release Statistics -->
Num Of Order Releases Selected = 1
Num Of Order Releases Unassigned = 0
Num Of Order Releases Planned = 0
Num Of Order Releases Failed To Plan = 1
<-- Order Movement Statistics -->
Num Of Order Movements Selected = 0
Num Of Order Movements Unassigned = 0
Num Of Order Movements Planned = 0
Num Of Order Movements Failed To Plan = 0
<-- Shipment Statistics -->
Num Of Shipments Built = 0
Start Time = 2009-12-27 06:42:11 UTC
End Time = 2009-12-27 06:42:12 UTC > has been committed. [batch - 1]

2009-12-26 22:42:12.046 685139 Debug Planning CriteriaToBeIgnoredHelper.clearCriteriaToBeIgnored (): Clearing thread local stored criteria to be ignored-- [batch - 1]
CriteriaToBeIgnoredHelper.clearCriteriaToBeIgnored (): Clearing thread local stored criteria to be ignored-- [batch - 1]

2009-12-26 22:42:12.046 685139 Debug Workflow Completing workflow Simple Workflow (5093943) [batch - 1]
Completing workflow Simple Workflow (5093943) [batch - 1]

Can someone suggest?

Thanks in advance...

[LourensGlog]

Re: Buy Ship &gt; Bulk Planning always failing

You need to give us a little more logfile: this part doesn't tell why it could not create a shipment.

Also, I noticed that your system date is more than a month in the future!

[blumhe]

Re: Buy Ship &gt; Bulk Planning always failing

As indicated above, a portion of log alone is hard to tell why it fails to plan.
I would suggest you run the logging with agent, planning, planning details, rating, multistop, multistopdetails, exception, and sql logging turned on. Search for the word exception and error. Download it to text file so it is easier to naviagate.

Advice if you use dates for planning.
Also check equipment group profiles in your itinerary. ensure that is checked for multistop and that you have rates into and out of the pool. pool location needds to be set to deconsolidation or consolidation depending on how use it. check multistop flag and de/consolidation flag- one one can be set.
Ensure that your transport mode is included in this part.
Ensure that your domain grants are setup correctly.

This will give you a start.