Stored procedure error codes
The following table describes the error codes that are returned by specific WebSphere Commerce stored procedures. You should receive these error messages only when a problem with the data requires further investigation by a technical person. If you receive one of these 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 |
| 37 | There is no record on receipt table to update. | GetItems |
| 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 |
| 122 | There are no fulfillment centers in the list. | AvailRADate |
| 123 | Unable to retrieve data from RADETAIL table. | AvailRADate |
| 125 | Error parsing fulfillment center list. | AvailRADate, BackorderItem |
| 126 | Error parsing fulfillment center list. | AvailRADate, BackorderItem |
| 128 | Unable to insert into tmpffclist and error parsing. | AvailRADate, BackorderItem |
| 153 | Unable to determine available inventory from RECEIPT table. | GetItems, BackorderItem |
| 159 | Unable to retrieve available inventory from tmprctlist. | GetItems |
| 156 | Only in getitems | GetItems, BackorderItem |
| 188 | There is no baseitem or itemspc info for the orderitem | BackorderItem |
| 190 | Unable to retrieve informagtion a bout the baseitem, itemspc for the orderitem. | 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 retrieve status info from tmpbolist | 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 | No data to update into ITEMFFMCTR. | BackorderItem |
| 266 | Unable to update ITEMFFMCTR. | BackorderItem |
| 270 | There is no date to update into bkorditem | BackorderItem |
| 272 | Unable to insert row into BKORDITEM. | BackorderItem |
| 276 | There is no data to insert into itemffmctr | BackorderItem |
| 277 | Unable to insert row into ITEMFFMCTR. | BackorderItem |
| 301 | Only in current version. | AvailInvStore, GetItems, BackorderItem |
| 303 | Only in current version. | 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 radetail and itemffmctr | 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 |
| 424 | The order item has already been allocated. | GetItems |
| 451 | No date to update into tmpcmplist and no data in oicomplist, availinvstore, availradate, backorderitem, getitems | GetItems |
| 452 | Unable to retrieve information from the OICOMPLIST table. | GetItems |
| 453 | No date to insert into tmpcmplist. | GetItems |
| 444 | Unable to insert data into ORDPICKHST table. | GetItems |
| 547 | Unable to update tmpcmplist. | GetItems |
| 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 | No date to update into invadjust | AdjustInventory |
| 597 | Unable to insert data into INVADJUST table. | AdjustInventory |
| 598 | No date to retrieve from receipt. | AdjustInventory |
| 600 | Unable to retrieve inventory information from RECEIPT table. | AdjustInventory |
| 601 | No date to retrieve from itemffmctr versionspc | 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 | Unable to update receipt | AdjustInventory |
| 609 | No date to insert into invadjust | AdjustInventory |
| 611 | Unable to insert data into INVADJUST table. | AdjustInventory |
| 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 |
| 772 | Cannot perform this action on an orderitem that has fulfillmentstatus as CAN | 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 |
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 in 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 to 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.