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

Picklist passing incorrect datatype

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 16.11.01
    • Fix Version/s: None
    • Component/s: workeffort
    • Labels:
    • Environment:

      Win 7, 64 bit

      Description

      It appears that the picklist used on Work Effort Notes to designate 'internal' is passing 'Yes' to the WorkEffortNote table rather than 'Y' or 'N' causing a truncation error.

      The Following Errors Occurred:
      Exception thrown while creating the "newWorkEffortNote" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortNote][createdStamp,2017-02-10 14:30:52.4(java.sql.Timestamp)][createdTxStamp,2017-02-10 14:30:51.962(java.sql.Timestamp)][internalNote,Yes(java.lang.String)][lastUpdatedStamp,2017-02-10 14:30:52.4(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-10 14:30:51.962(java.sql.Timestamp)][noteId,10060(java.lang.String)][workEffortId,10079(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-10 14:30:52.4(java.sql.Timestamp)][createdTxStamp,2017-02-10 14:30:51.962(java.sql.Timestamp)][internalNote,Yes(java.lang.String)][lastUpdatedStamp,2017-02-10 14:30:52.4(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-10 14:30:51.962(java.sql.Timestamp)][noteId,10060(java.lang.String)][workEffortId,10079(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:
              mbrohl Michael Brohl
              Reporter:
              Gryphoenix Michael Clifton
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: