[jira] [Created] (OFBIZ-4409) Agreement issues

[Nicolas Malin (Jira)]

Agreement issues
----------------

                 Key: OFBIZ-4409
                 URL: https://issues.apache.org/jira/browse/OFBIZ-4409
             Project: OFBiz
          Issue Type: Bug
          Components: accounting
    Affects Versions: SVN trunk
            Reporter: Carlos Guzman


1.- I can't add or edit Agreement Item. The error is:
The Following Errors Occurred:
ERROR: Could not complete the Create an AgreementItem [file:/develop/ofbiz/applications/accounting/script/org/ofbiz/accounting/agreement/AgreementServices.xml#createAgreementItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:AgreementItem][agreementImage,null()][agreementItemSeqId,00001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,null()][createdStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][createdTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)][currencyUomId,MXN(java.lang.String)][lastUpdatedStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][lastUpdatedTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO AGREEMENT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'AGREEMENT_ID' cannot be null))]

2.- Search Result table has table headers missing.
3.- Edit header agreement has missing some fields values like Agreement Id, Party Id From, Party Id To and Agreement Type Id
4.- Agreement terms list has missed the column value AGREEMENT ITEM SEQ ID
https://demo-trunk.ofbiz.apache.org:8443/accounting/control/EditAgreement?agreementId=9000

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carlos Guzman closed OFBIZ-4409.
--------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk

with last modifications on trunk the problem gone.

> Agreement issues
> ----------------
>
>                 Key: OFBIZ-4409
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4409
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Carlos Guzman
>             Fix For: SVN trunk
>
>
> 1.- I can't add or edit Agreement Item. The error is:
> The Following Errors Occurred:
> ERROR: Could not complete the Create an AgreementItem [file:/develop/ofbiz/applications/accounting/script/org/ofbiz/accounting/agreement/AgreementServices.xml#createAgreementItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:AgreementItem][agreementImage,null()][agreementItemSeqId,00001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,null()][createdStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][createdTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)][currencyUomId,MXN(java.lang.String)][lastUpdatedStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][lastUpdatedTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO AGREEMENT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'AGREEMENT_ID' cannot be null))]
> 2.- Search Result table has table headers missing.
> 3.- Edit header agreement has missing some fields values like Agreement Id, Party Id From, Party Id To and Agreement Type Id
> 4.- Agreement terms list has missed the column value AGREEMENT ITEM SEQ ID
> https://demo-trunk.ofbiz.apache.org:8443/accounting/control/EditAgreement?agreementId=9000

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13103694#comment-13103694 ]

Carlos Guzman edited comment on OFBIZ-4409 at 9/13/11 3:33 PM:
---------------------------------------------------------------

with last modifications on trunk the problem gone.

I had to reload the seed data again in a clean database.

      was (Author: cguzzman):
    with last modifications on trunk the problem gone.
 

> Agreement issues
> ----------------
>
>                 Key: OFBIZ-4409
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-4409
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Carlos Guzman
>             Fix For: SVN trunk
>
>
> 1.- I can't add or edit Agreement Item. The error is:
> The Following Errors Occurred:
> ERROR: Could not complete the Create an AgreementItem [file:/develop/ofbiz/applications/accounting/script/org/ofbiz/accounting/agreement/AgreementServices.xml#createAgreementItem] process [problem creating the newEntity value: Error while inserting: [GenericEntity:AgreementItem][agreementImage,null()][agreementItemSeqId,00001(java.lang.String)][agreementItemTypeId,AGREEMENT_COMMISSION(java.lang.String)][agreementText,null()][createdStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][createdTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)][currencyUomId,MXN(java.lang.String)][lastUpdatedStamp,2011-09-12 18:22:39.787(java.sql.Timestamp)][lastUpdatedTxStamp,2011-09-12 18:22:39.765(java.sql.Timestamp)] (SQL Exception while executing the following:INSERT INTO AGREEMENT_ITEM (AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID, AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'AGREEMENT_ID' cannot be null))]
> 2.- Search Result table has table headers missing.
> 3.- Edit header agreement has missing some fields values like Agreement Id, Party Id From, Party Id To and Agreement Type Id
> 4.- Agreement terms list has missed the column value AGREEMENT ITEM SEQ ID
> https://demo-trunk.ofbiz.apache.org:8443/accounting/control/EditAgreement?agreementId=9000

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira