Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Related Error in MS Dynamics RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Monday, November 10, 2014 1:03 PM