The following table describes the error codes returned from specific WebSphere Commerce stored procedures. You should only receive the following error message in the event of a problem with the data that requires further investigation by a technical person. If you receive any of the following errors (other than error code 0) and you cannot determine the cause of the error, contact IBM WebSphere Commerce support for assistance.
Error Code | Description | Stored Procedure |
---|---|---|
0 | No error has occurred | all |
39 | Unable to update RECEIPT table. | GetItems |
40 | No data in the TMPRCTLIST table. | GetItems |
42 | Unable to update ALLOCATED or ORDERABLE in TMPRCTLIST table. | GetItems |
43 | Error in inventory allocation - over allocation. | GetItems |
45 | Error in inventory allocation - under allocation. | GetItems |
94 | Unable to retrieve inventory information from RECEIPT table. | AvailInvStore |
97 | Unable to retrieve inventory information from ITEMFFMCTR table. | AvailInvStore |
98 | There are no fulfillment centers in the list. | AvailInvStore |
100 | Error parsing fulfillment center list. | AvailInvStore |
102 | Error parsing fulfillment center list. | AvailInvStore |
122 | There are no fulfillment centers in the list. | AvailRADate |
123 | Unable to retrieve data from RADETAIL table. | AvailRADate |
126 | Error parsing fulfillment center list. | AvailRADate, BackorderItem |
128 | Error parsing fulfillment center list. | AvailRADate, BackorderItem |
153 | Unable to determine available inventory from RECEIPT table. | GetItems, BackorderItem |
159 | Unable to determine reserved or backorder amounts in ITEMFFMCTR table. | GetItems |
156 | Unable to determine reserved or backorder amounts in ITEMFFMCTR table. | GetItems, BackorderItem |
188 | Unable to retrieve information about the item or the order. | BackorderItem |
190 | Unable to retrieve information about the item or the order. | BackorderItem |
191 | The ORDERITEM.INVENTORYSTATUS is invalid. | BackorderItem |
209 | Data missing from TMPRADTL table. | BackorderItem |
211 | Unable to update the TMPRADTL table. | BackorderItem |
212 | Data missing from RADETAIL table. | BackorderItem |
214 | Unable to update RADETAIL table. | BackorderItem |
215 | Data missing from TMPRADTL table. | BackorderItem |
217 | Unable to update the TMPRADTL table. | BackorderItem |
218 | Data missing from RADETAIL table. | BackorderItem |
220 | Unable to update RADETAIL table. | BackorderItem |
221 | Data missing from TMPBOLIST table. | BackorderItem |
223 | Unable to update TMPBOLIST table. | BackorderItem |
224 | Data missing from TMPBOLIST table. | BackorderItem |
226 | Unable to update TMPBOLIST table. | BackorderItem |
227 | Data missing from TMPBOLIST table. | BackorderItem |
229 | Unable to update TMPBOLIST table. | BackorderItem |
230 | Data missing from TMPBOLIST table. | BackorderItem |
232 | Unable to update TMPBOLIST table. | BackorderItem |
233 | Data missing from TMPBOLIST table. | BackorderItem |
235 | Unable to determine expected date. | BackorderItem |
236 | Data missing from TMPBOLIST table. | BackorderItem |
238 | Unable to determine status. | BackorderItem |
239 | Data missing from TMPFFCLIST table. | BackorderItem |
241 | Unable to update TMPFFCLIST table. | BackorderItem |
240 | Unable to update TMPFFCLIST table. | BackorderItem |
242 | Data missing from TMPFFCLIST table. | BackorderItem |
244 | Unable to select a fulfillment center. | BackorderItem |
248 | Data missing from RADETAIL table. | BackorderItem |
250 | Unable to update RADETAIL table. | BackorderItem |
254 | No data inserted into RABACKALLO. | BackorderItem |
256 | No data inserted into RABACKALLO. | BackorderItem |
257 | No data inserted into BKORDALLOC. | BackorderItem |
259 | No data inserted into BKORDALLOC. | BackorderItem |
264 | Unable to update ITEMFFMCTR. | BackorderItem |
266 | Unable to update ITEMFFMCTR. | BackorderItem |
267 | Unable to update ORDERITEMS. | BackorderItem |
269 | Unable to update ORDERITEMS. | BackorderItem |
270 | Unable to insert row into BKORDITEM. | BackorderItem |
272 | Unable to insert row into BKORDITEM. | BackorderItem |
275 | Unable to update ITEMFFMCTR. | BackorderItem |
276 | Unable to insert row into ITEMFFMCTR. | BackorderItem |
277 | Unable to insert row into ITEMFFMCTR. | BackorderItem |
301 | There is no current version of the item. | AvailInvStore, GetItems,BackorderItem |
303 | Unknown error while determining current version of the item. | AvailInvStore, GetItems, BackorderItem |
331 | No data found in ORDERITEMS row in DELETEBACKORDER procedure. | GetItems, ReverseInventory |
332 | Unable to retrieve ORDERITEMS row in DELETEBACKORDER procedure. | GetItems, ReverseInventory |
335 | Unable to update ITEMFFMCTR table in DELETEBACKORDER procedure. | GetItems, ReverseInventory |
339 | Unable to delete from BKORDALLOC table. | GetItems, BackorderItem, ReverseInventory |
340 | Unable to delete from BKORDITEM table. | GetItems, ReverseInventory |
341 | Unable to delete from BKORDITEM table. | GetItems |
341 | Unable to delete from RABACKALLO table. | ReverseInventory |
421 | Unable to retrieve information about the item or the order. | GetItems |
423 | Unable to retrieve information about the item or the order. | GetItems |
424 | The order item has already been allocated. | GetItems |
451 | There are no components in the OICOMPLIST table. | GetItems |
452 | Unable to retrieve information from the OICOMPLIST table. | GetItems |
453 | Unable to retrieve backorder allocation information. | GetItems |
438 | Unable to update ORDERITEMS table. | GetItems |
444 | Unable to insert data into ORDPICKHST table. | GetItems |
547 | Unable to determine if inventory should be tracked. | GetItems |
548 | Unable to update QTYAVAILABLE in TMPCMPLIST for a tracked item. | GetItems |
549 | Unable to update QTYAVAILABLE in TMPCMPLIST for a non-tracked item. | GetItems |
643 | Unable to delete rows in RABACKALLO table. | RAallocation |
646 | Unable to update RADETAIL table. | RAallocation |
647 | Data missing from the STORE table. | RAallocation |
649 | Unable to determine backorder offsets for this store. | RAallocation |
658 | Unable to update RADETAIL table. | RAallocation |
661 | Unable to insert rows into RABACKALLO table. | RAallocation |
664 | Unable to update BKORDITEM table. | RAallocation |
665 | Unable to update ORDERITEMS table. | RAallocation |
743 | No row found in the ORDERITEMS table. | ReverseInventory |
745 | Unknown error while trying to retrieve information from the ORDERITEMS table. | ReverseInventory |
751 | Unable to update the RECEIPT table. | ReverseInventory |
754 | Unable to delete rows from ORDPICKHST table. | ReverseInventory |
757 | Cannot perform this action on an order that has been released to fulfillment. | ReverseInventory |
770 | Inventory cannot be reversed because the ORDERITEM row was not allocated. | ReverseInventory |
771 | Cannot perform this action on an order that has been released to fulfillment. | ReverseInventory |
775 | Unable to update ORDERITEMS table. | ReverseInventory |
843 | Unable to insert rows into ORDSHIPHST table. | ShipItems |
852 | Unable to update RECEIPT table. | ShipItems |
858 | Unable to determine next release number. | ShipItems |
865 | No data in the ORDRELEASE table. | ShipItems |
867 | Unable to insert row into the ORDRELEASE table. | ShipItems |
868 | Unable to update ORDERITEMS table. | ShipItems |
870 | Unable to update ORDERITEMS table. | ShipItems |
871 | Unable to update ORDERITEMS table. | ShipItems |
872 | Unable to update ORDERITEMS table. | ShipItems |
880 | No data in the ORDRELEASE table. | ShipItems |
882 | Unable to insert row into the ORDRELEASE table. | ShipItems |
883 | Unable to update ORDERITEMS table. | ShipItems |
885 | Unable to update ORDERITEMS table. | ShipItems |
583 | VERSIONSPC_ID not supplied. | AdjustInventory |
584 | STORE_ID not supplied. | AdjustInventory |
585 | FFMCENTER_ID not supplied. | AdjustInventory |
586 | INVADJCODE_ID not supplied. | AdjustInventory |
587 | Quantity to be adjusted was not supplied. | AdjustInventory |
581 | There is no existing inventory for this item. | AdjustInventory |
589 | Data missing from RECEIPT table. | AdjustInventory |
591 | Unable to update RECEIPT table. | AdjustInventory |
595 | Unable to insert data into INVADJUST table. | AdjustInventory |
597 | Unable to insert data into INVADJUST table. | AdjustInventory |
598 | Unable to retrieve inventory information from RECEIPT table. | AdjustInventory |
600 | Unable to retrieve inventory information from RECEIPT table. | AdjustInventory |
601 | Unable to retrieve inventory information from ITEMFFMCTR table. | AdjustInventory |
603 | Unable to retrieve inventory information from ITEMFFMCTR table. | AdjustInventory |
604 | Requested amount of adjustment is greater than what is currently available. | AdjustInventory |
606 | Data missing from RECEIPT table. | AdjustInventory |
608 | Data missing from RECEIPT table. | AdjustInventory |
609 | Unable to insert data into INVADJUST table. | AdjustInventory |
611 | Unable to insert data into INVADJUST table. | AdjustInventory |
Description of Stored Procedures
- AdjustInventory
- Makes adjustments to existing inventory. An adjustment is made by either marking down quantities in one or more RECEIPT rows when the adjustment is negative, or adding inventory to an existing RECEIPT row when the adjustment is positive.
- AvailInvStore
- Indicates whether inventory is currently available for an item within the context of the current order. This process does not reserve inventory for the order, nor is this a guarantee that the inventory will still be available when the order item is processed.
- AvailRADate
- Indicates when the next expected inventory record for an item will be available. This is not a guarantee that an actual backorder created for this item will have the same expected ship date.
- BackOrderItem
- Creates a backorder for an item, possibly allocating against expected inventory, and provides an estimated ship date.
- GetItems
- Allocates available inventory to an order item. The order item may have been previously unallocated, or it may be a backorder.
- RAallocation
- Reallocates existing backorders against expected inventory.
- ReverseInventory
- Returns the allocated inventory back into the RECEIPT table from a previously allocated order item, or deletes backorder information for a backordered line item.
- Shipitems
- Releases allocated items on an order to fulfillment.