Hi,
One of my users got this error in AX this morning.
Event Type: Error
Event Source: Dynamics Server 06
Event Category: None
Event ID: 117
Date: 10/11/2014
Time: 10:47:33
User: N/A
Computer: ACHAOS05
Description:
Object Server 06: The database reported (session 94 (brian)): [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.. The SQL statement was: "INSERT INTO INVENTTRANS (ITEMID,STATUSISSUE,INTERCOMPANYINVENTDIMTRANSFER3,DATEPHYSICAL,QTY,COSTAMOUNTPOSTED,CURRENCYCODE,TRANSTYPE,TRANSREFID,INVOICEID,VOUCHER,DATEEXPECTED,DATEFINANCIAL,COSTAMOUNTPHYSICAL,INVENTTRANSID,STATUSRECEIPT,PACKINGSLIPRETURNED,INVOICERETURNED,PACKINGSLIPID,VOUCHERPHYSICAL,COSTAMOUNTADJUSTMENT,SHIPPINGDATEREQUESTED,SHIPPINGDATECONFIRMED,QTYSETTLED,COSTAMOUNTSETTLED,VALUEOPEN,DIRECTION,DATESTATUS,COSTAMOUNTSTD,DATECLOSED,INVENTTRANSIDFATHER,COSTAMOUNTOPERATIONS,ITEMROUTEID,ITEMBOMID,INVENTTRANSIDRETURN,PROJID,PROJCATEGORYID,INVENTDIMID,INVENTDIMFIXED,DATEINVENT,CUSTVENDAC,TRANSCHILDREFID,TRANSCHILDTYPE,TIMEEXPECTED,REVENUEAMOUNTPHYSICAL,ASSETID,PROJADJUSTREFID,TAXAMOUNTPHYSICAL,ASSETBOOKID,INVENTREFTRANSID,PROBABILITYID,CREATEDDATE,CREATEDBY,DATAAREAID,RECVERSION,RECID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
I took a look at the logs but couldn't find anything useful. Am I correct in thinking that this may be something like a field may have a certain length but the user is trying to enter a longer value?
Cheers
Paul