locked
SQL Related Error in MS Dynamics RRS feed

  • Question

  • 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