[jira] [Commented] (OFBIZ-9212) Picklist passing incorrect datatype
[ https://issues.apache.org/jira/browse/OFBIZ-9212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Updated] (OFBIZ-9227) Violation of foreign key constraint
[ https://issues.apache.org/jira/browse/OFBIZ-9227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Clifton updated OFBIZ-9227: --- Description: Trying to add a task to a project phase, I receive the below error. 2017-02-21 09:23:54,189 |http-nio-8443-exec-1 |ServiceDispatcher |E| Error in Service [createProjectTask]: Exception thrown while creating the "newEntity" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffort][createdByUserLogin,admin(java.lang.String)][createdDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][currentStatusId,PTS_CREATED(java.lang.String)][description,Test(java.lang.String)][estimatedCompletionDate,2017-02-24 00:00:00.0(java.sql.Timestamp)][estimatedStartDate,2017-02-21 00:00:00.0(java.sql.Timestamp)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastStatusUpdate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][priority,1(java.lang.Long)][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][sequenceNum,1(java.lang.Long)][workEffortId,10090(java.lang.String)][workEffortName,Test(java.lang.String)][workEffortParentId,10048(java.lang.String)][workEffortTypeId,Task(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT (WORK_EFFORT_ID, WORK_EFFORT_TYPE_ID, CURRENT_STATUS_ID, LAST_STATUS_UPDATE, WORK_EFFORT_PURPOSE_TYPE_ID, WORK_EFFORT_PARENT_ID, SCOPE_ENUM_ID, PRIORITY, PERCENT_COMPLETE, WORK_EFFORT_NAME, SHOW_AS_ENUM_ID, SEND_NOTIFICATION_EMAIL, DESCRIPTION, LOCATION_DESC, ESTIMATED_START_DATE, ESTIMATED_COMPLETION_DATE, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE, ESTIMATED_MILLI_SECONDS, ESTIMATED_SETUP_MILLIS, ESTIMATE_CALC_METHOD, ACTUAL_MILLI_SECONDS, ACTUAL_SETUP_MILLIS, TOTAL_MILLI_SECONDS_ALLOWED, TOTAL_MONEY_ALLOWED, MONEY_UOM_ID, SPECIAL_TERMS, TIME_TRANSPARENCY, UNIVERSAL_ID, SOURCE_REFERENCE_ID, FIXED_ASSET_ID, FACILITY_ID, INFO_URL, RECURRENCE_INFO_ID, TEMP_EXPR_ID, RUNTIME_DATA_ID, NOTE_ID, SERVICE_LOADER_NAME, QUANTITY_TO_PRODUCE, QUANTITY_PRODUCED, QUANTITY_REJECTED, RESERV_PERSONS, RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC, ACCOMMODATION_MAP_ID, ACCOMMODATION_SPOT_ID, REVISION_NUMBER, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, SEQUENCE_NUM) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WORK_EFFORT' caused a violation of foreign key constraint 'WK_EFFRT_TYPE' for key (Task). The statement has been rolled back.)) was: Trying to add a task to a project phase, I receive the below error. 2017-02-21 09:23:54,189 |http-nio-8443-exec-1 |ServiceDispatcher |E| Error in Service [createProjectTask]: Exception thrown while creating the "newEntity" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffort][createdByUserLogin,admin(java.lang.String)][createdDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][currentStatusId,PTS_CREATED(java.lang.String)][description,Test(java.lang.String)][estimatedCompletionDate,2017-02-24 00:00:00.0(java.sql.Timestamp)][estimatedStartDate,2017-02-21 00:00:00.0(java.sql.Timestamp)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastStatusUpdate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][priority,1(java.lang.Long)][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][sequenceNum,1(java.lang.Long)][workEffortId,10090(java.lang.String)][workEffortName,Test(java.lang.String)][workEffortParentId,10048(java.lang.String)][workEffortTypeId,Task(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT (WORK_EFFORT_ID, WORK_EFFORT_TYPE_ID, CURRENT_STATUS_ID, LAST_STATUS_UPDATE, WORK_EFFORT_PURPOSE_TYPE_ID, WORK_EFFORT_PARENT_ID, SCOPE_ENUM_ID, PRIORITY, PERCENT_COMPLETE, WORK_EFFORT_NAME, SHOW_AS_ENUM_ID, SEND_NOTIFICATION_EMAIL, DESCRIPTION, LOCATION_DESC, ESTIMATED_START_DATE, ESTIMATED_COMPLETION_DATE, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE, ESTIMATED_MILLI_SECONDS, ESTIMATED_SETUP_MILLIS, ESTIMATE_CALC_METHOD,
[jira] [Commented] (OFBIZ-9212) Picklist passing incorrect datatype
[ https://issues.apache.org/jira/browse/OFBIZ-9212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Created] (OFBIZ-9227) Violation of foreign key constraint
Michael Clifton created OFBIZ-9227: -- Summary: Violation of foreign key constraint Key: OFBIZ-9227 URL: https://issues.apache.org/jira/browse/OFBIZ-9227 Project: OFBiz Issue Type: Bug Components: workeffort Affects Versions: Release Branch 16.11 Environment: Win 7 Reporter: Michael Clifton Priority: Minor Trying to add a task to a project phase, I receive the below error. 2017-02-21 09:23:54,189 |http-nio-8443-exec-1 |ServiceDispatcher |E| Error in Service [createProjectTask]: Exception thrown while creating the "newEntity" GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WorkEffort][createdByUserLogin,admin(java.lang.String)][createdDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][currentStatusId,PTS_CREATED(java.lang.String)][description,Test(java.lang.String)][estimatedCompletionDate,2017-02-24 00:00:00.0(java.sql.Timestamp)][estimatedStartDate,2017-02-21 00:00:00.0(java.sql.Timestamp)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastStatusUpdate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][priority,1(java.lang.Long)][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][sequenceNum,1(java.lang.Long)][workEffortId,10090(java.lang.String)][workEffortName,Test(java.lang.String)][workEffortParentId,10048(java.lang.String)][workEffortTypeId,Task(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT (WORK_EFFORT_ID, WORK_EFFORT_TYPE_ID, CURRENT_STATUS_ID, LAST_STATUS_UPDATE, WORK_EFFORT_PURPOSE_TYPE_ID, WORK_EFFORT_PARENT_ID, SCOPE_ENUM_ID, PRIORITY, PERCENT_COMPLETE, WORK_EFFORT_NAME, SHOW_AS_ENUM_ID, SEND_NOTIFICATION_EMAIL, DESCRIPTION, LOCATION_DESC, ESTIMATED_START_DATE, ESTIMATED_COMPLETION_DATE, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE, ESTIMATED_MILLI_SECONDS, ESTIMATED_SETUP_MILLIS, ESTIMATE_CALC_METHOD, ACTUAL_MILLI_SECONDS, ACTUAL_SETUP_MILLIS, TOTAL_MILLI_SECONDS_ALLOWED, TOTAL_MONEY_ALLOWED, MONEY_UOM_ID, SPECIAL_TERMS, TIME_TRANSPARENCY, UNIVERSAL_ID, SOURCE_REFERENCE_ID, FIXED_ASSET_ID, FACILITY_ID, INFO_URL, RECURRENCE_INFO_ID, TEMP_EXPR_ID, RUNTIME_DATA_ID, NOTE_ID, SERVICE_LOADER_NAME, QUANTITY_TO_PRODUCE, QUANTITY_PRODUCED, QUANTITY_REJECTED, RESERV_PERSONS, RESERV2ND_P_P_PERC, RESERV_NTH_P_P_PERC, ACCOMMODATION_MAP_ID, ACCOMMODATION_SPOT_ID, REVISION_NUMBER, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, SEQUENCE_NUM) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WORK_EFFORT' caused a violation of foreign key constraint 'WK_EFFRT_TYPE' for key (Task). The statement has been rolled back.)) (Error while inserting: [GenericEntity:WorkEffort][createdByUserLogin,admin(java.lang.String)][createdDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][createdTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][currentStatusId,PTS_CREATED(java.lang.String)][description,Test(java.lang.String)][estimatedCompletionDate,2017-02-24 00:00:00.0(java.sql.Timestamp)][estimatedStartDate,2017-02-21 00:00:00.0(java.sql.Timestamp)][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastStatusUpdate,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedStamp,2017-02-21 09:23:52.876(java.sql.Timestamp)][lastUpdatedTxStamp,2017-02-21 09:23:51.627(java.sql.Timestamp)][priority,1(java.lang.Long)][revisionNumber,1(java.lang.Long)][scopeEnumId,WES_PRIVATE(java.lang.String)][sequenceNum,1(java.lang.Long)][workEffortId,10090(java.lang.String)][workEffortName,Test(java.lang.String)][workEffortParentId,10048(java.lang.String)][workEffortTypeId,Task(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WORK_EFFORT (WORK_EFFORT_ID, WORK_EFFORT_TYPE_ID, CURRENT_STATUS_ID, LAST_STATUS_UPDATE, WORK_EFFORT_PURPOSE_TYPE_ID, WORK_EFFORT_PARENT_ID, SCOPE_ENUM_ID, PRIORITY, PERCENT_COMPLETE, WORK_EFFORT_NAME, SHOW_AS_ENUM_ID, SEND_NOTIFICATION_EMAIL, DESCRIPTION, LOCATION_DESC, ESTIMATED_START_DATE, ESTIMATED_COMPLETION_DATE, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE, ESTIMATED_MILLI_SECONDS, ESTIMATED_SETUP_MILLIS, ESTIMATE_CALC_METHOD, ACTUAL_MILLI_SECONDS, ACTUAL_SETUP_MILLIS, TOTAL_MILLI_SECONDS_ALLOWED,
[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)
[jira] [Created] (OFBIZ-9212) Picklist passing incorrect datatype
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)
[jira] [Created] (OFBIZ-9210) Truncation error when adding Work Effort note
Michael Clifton created OFBIZ-9210: -- Summary: 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 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)