[ https://issues.apache.org/jira/browse/OFBIZ-9212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876780#comment-15876780 ]
Michael Clifton commented on OFBIZ-9212: ---------------------------------------- [~mbrohl] I agree :) > Picklist passing incorrect datatype > ----------------------------------- > > Key: OFBIZ-9212 > URL: https://issues.apache.org/jira/browse/OFBIZ-9212 > Project: OFBiz > Issue Type: Bug > Components: workeffort > Affects Versions: 16.11.01 > Environment: Win 7, 64 bit > Reporter: Michael Clifton > Assignee: Michael Brohl > Priority: Minor > Labels: Picklist, SQL > > 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.))) -- This message was sent by Atlassian JIRA (v6.3.15#6346)