[
https://issues.apache.org/jira/browse/OFBIZ-9212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876146#comment-15876146 ]
Michael Clifton commented on OFBIZ-9212:
----------------------------------------
[~mbrohl] no problem!
I believe that the value stored for the pick list is 'Yes' rather than 'Y' which is what the database is expecting. Below are my steps to reproduce:
> Enter 'Project Manager' module
> Open 'ABC' project
> Navigate to 'Notes' tab
> Try to create a note
> Receive the error reported above
I think that if I can determine where the data is stored for the 'Internal Note' pick list, I can remedy the issue but I am not sure where to find it.
> 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)
Locked
