ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Clifton (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OFBIZ-9212) Picklist passing incorrect datatype
Date Fri, 10 Feb 2017 20:31:41 GMT
Michael Clifton created OFBIZ-9212:
--------------------------------------

             Summary: 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
            Priority: Minor


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)

Mime
View raw message