[
https://issues.apache.org/jira/browse/OFBIZ-9212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16238066#comment-16238066 ]
Dennis Balkir commented on OFBIZ-9212:
--------------------------------------
Hi [~Gryphoenix],
while trying to fix this error I retook the steps you made to produce it (with all the demo data loaded).
I opened up all 3 demo projects available and navigated to the notes tab, and in all three projects I tried to create a random note with the parameter "yes" for internal note.
Unfortunately I was not able to reproduce this error, for me they all got created just fine.
Can you check if the problem is already solved for you too?
Do you have the latest updates for the plugin files and can you recreate this error again?
Thanks in advance for your help,
Dennis
> 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.4.14#64029)
Locked
