Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you add items to a Purchase Order, Transfer In, or Transfer Out: "Error # - 2147217833 The statement has been terminated. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 3621)


Symptoms

When you add items to a Purchase Order, Transfer In, or Transfer Out in Microsoft Dynamics RMS Feature Pack 1 (FP1), you receive the following error: 

Error # - 2147217833 The statement has been terminated. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 3621)

↑ Back to the top


Cause

This problem can be caused by item having an overly large positive or negative inventory quantity and the new Details view in the Transfer and Purchase Order with FP1 when you try to query the details for the items linked to a supplier, but cannot because while processing the query the quantity is greater than the field size. The overly large quantity can normally be caused by scanning the barcode into the item's quantity field.

↑ Back to the top


Resolution

To resolve this issue, use the script below as a starting point to find the trouble item. Then update the quantity of the trouble item to a smaller inventory quantity. 

SELECT * FROM Item WHERE Quantity > 10000 OR WHERE Quantity < -10000

↑ Back to the top


Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2447570
Revision : 1
Created on : 1/7/2017
Published on : 1/9/2012
Exists online : False
Views : 133