[ https://issues.apache.org/jira/browse/OFBIZ-7519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amardeep Singh Jhajj updated OFBIZ-7519: ---------------------------------------- Attachment: OFBIZ-7519-Screen-Shot.png > Some entity-auto services fields doesn't have optional false in case of > multiple PK's. > -------------------------------------------------------------------------------------- > > Key: OFBIZ-7519 > URL: https://issues.apache.org/jira/browse/OFBIZ-7519 > Project: OFBiz > Issue Type: Improvement > Components: accounting, content, marketing > Affects Versions: Trunk > Reporter: Amardeep Singh Jhajj > Assignee: Amardeep Singh Jhajj > Attachments: OFBIZ-7519-Screen-Shot.png > > > Some services with entity-auto doesn't have optional false in case of > multiple PK's. In this cases if any of the PK is missing then sql error > returns. > Please find attached screenshot of error. > According to my analysis of entity auto engine, Here are some cases: > 1. One primary key: Takes new sequence if PK not passed. > 2. Two primary key: Both PK should be mandatory except the case of secondary > primary key (like agreementItemSeqId) where next subsequence is generated. > 3. More than two PK's, all PK's should be mandatory except the fromDate. > Here is the list of services which need to be fixed according to above points. > 1. createAgreementItem > 2. updateAgreementItem > 3. deleteAgreementItem > 4. updateAgreementTerm > 5. deleteAgreementTerm > 6. createContentMetaData > 7. createContentPurpose > 8. createContentPurposeOperation > 9. createContentAttribute > 10. createContentRevisionItem > 11. createContentTypeAttr > 12. createDataResourceMetaData > 13. createDataResourcePurpose > 14. createSurveyTrigger > 15. createDataResourceAttribute > 16. createSalesOpportunityRole > I am working on it and will add patch soon. -- This message was sent by Atlassian JIRA (v6.3.4#6332)