Stored procedure error codes

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.