You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Michael Clifton (JIRA)" <ji...@apache.org> on 2017/02/10 20:33:41 UTC
[jira] [Closed] (OFBIZ-9210) Truncation error when adding Work
Effort note
[ https://issues.apache.org/jira/browse/OFBIZ-9210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Clifton closed OFBIZ-9210.
----------------------------------
Resolution: Duplicate
> Truncation error when adding Work Effort note
> ---------------------------------------------
>
> Key: OFBIZ-9210
> URL: https://issues.apache.org/jira/browse/OFBIZ-9210
> Project: OFBiz
> Issue Type: Bug
> Components: workeffort
> Affects Versions: Release Branch 16.11
> Environment: Win 7, X64
> Reporter: Michael Clifton
> Priority: Minor
> Labels: truncated
>
> Hi all. New to this; hope what I can submit is helpful. When trying to add a note to a Work Effort item, the following error occurs and I am unable to save the note:
> The Following Errors Occurred:
> Exception thrown while creating the "newWorkEffortNote" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffortNote][createdStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][createdTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][internalNote,Yes(java.lang.String)][lastUpdatedStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][noteId,10032(java.lang.String)][workEffortId,10027(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-09 11:13:25.69(java.sql.Timestamp)][createdTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][internalNote,Yes(java.lang.String)][lastUpdatedStamp,2017-02-09 11:13:25.69(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-09 11:13:25.043(java.sql.Timestamp)][noteId,10032(java.lang.String)][workEffortId,10027(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)