Develop > Controller layer > Application developer

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 baesitem, 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 itmeffmctr	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.

Related concepts

WebSphere Commerce database schema

+

Search Tips   |   Advanced Search