Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-9210

Truncation error when adding Work Effort note

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: Release Branch 16.11
    • Fix Version/s: None
    • Component/s: workeffort
    • Labels:
    • Environment:

      Win 7, X64

      Description

      Hi all. New to this; hope what I can submit is helpful. When trying to add a note to a Work Effort item, the following error occurs and I am unable to save the note:

      The Following Errors Occurred:
      Exception thrown while creating the "newWorkEffortNote" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortNote][createdStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][createdTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][internalNote,Yes(java.lang.String)][lastUpdatedStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][noteId,10032(java.lang.String)][workEffortId,10027(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_NOTE (WORK_EFFORT_ID, NOTE_ID, INTERNAL_NOTE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink CHAR 'Yes' to length 1.)) (Error while inserting: [GenericEntity:WorkEffortNote][createdStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][createdTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][internalNote,Yes(java.lang.String)][lastUpdatedStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][noteId,10032(java.lang.String)][workEffortId,10027(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT_NOTE (WORK_EFFORT_ID, NOTE_ID, INTERNAL_NOTE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink CHAR 'Yes' to length 1.)))

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Gryphoenix Michael Clifton
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: