Dynamics SL Shipper Doesn’t Close – It’s Stuck
Posted by Gary Korby on September 20, 2016
Occasionally, our Crestwood Support Team receives a call that the Microsoft Dynamics SL Order Management shipper is “stuck” in the Update Shipper step of the process. In other words, it is stuck open and won’t move to a closed status on the Other Information tab in the Shippers window.
Here are the steps to close the Shipper in Dynamics SL when it’s stuck:
- Stop the Process Manager (40.400.00)
Using SQL Query Analyzer, access the appropriate application database and execute the following SQL script.
SET QUOTED_IDENTIFIER OFF SELECT "exec ADG_Release_For_Update '" + rtrim(CpnyID) + "', '', '" + rtrim(ShipperID) + "'" from SOSHIPHEADER where NextFunctionID = "4043000" and NextFunctionClass = "0200" and ShipperID = (‘<ShipperID>’
Paste the results of the above query (minus the first column header line and the last row count line; i.e., only the lines that start with "exec") into another query window and execute. This should re-queue the affected Shippers for updating.
Start Process Manager (40.400.00) to update the Shippers to a Closed Status.
This is just one fix that our team of Dynamics SL experts can help with. Send us an email if you have questions or need some assistance. Support@Crestwood.com