[OFBIZ-9212] Picklist passing incorrect datatype

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 16.11.01
• Component/s: workeffort
• Labels: Picklist SQL

Environment

Win 7, 64 bit

• Assignee: Michael Brohl
• Reporter: Michael Clifton
• Created: 10/Feb/17 20:31
• Updated: 19/Dec/17 19:28
• Resolved: 19/Dec/17 19:28

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.)))